topic RE: @CaryH, Denis is right on… in Digital Exchange

SharePoint VBO?

AjishChandrabab — Fri, 29 Sep 2017 08:23:00 GMT

All, Is there a SharePoint VBO available with Blue Prism? if so, where can I download it from ? Thanks Ajish

anyone please?

AjishChandrabab — Tue, 03 Oct 2017 18:38:00 GMT

anyone please?

what u need to do in

RaahulC1 — Thu, 05 Oct 2017 11:58:00 GMT

what u need to do in sharepoint ?

There is no ""official

OlaNykvist — Tue, 10 Oct 2017 12:05:00 GMT

There is no ""official"" SharePoint VBO that I'm aware of, but SharePoint has a well documented REST API that exposes most functionality. See MSDN or ask a more specific question and I'm sure someone here can point you in the right direction.

Can you map the Sharepoint

Denis__Dennehy — Tue, 10 Oct 2017 16:12:00 GMT

Can you map the Sharepoint folder to be a network drive on your computer and then just use the standard Utility - File Management VBO? I have done that previously and it worked well.

Denis, have you come across…

CaryHenderson — Tue, 11 Dec 2018 20:53:00 GMT

Denis, have you come across a situation where you've needed to update/manage SharePoint file/directory permissions in Blue Prism? We're currently trying to find the best way to go about accomplishing this and would appreciate any guidance.

@CaryH, Denis is right on…

AmiBarrett — Tue, 11 Dec 2018 21:07:00 GMT

@CaryH, Denis is right on the money -- you can browse to any SharePoint directory via file explorer, which means you can also map it to a network drive. Just ensure that the WebClient service is running in order for this to work. The only caveat to this, is that I had to write a batch file script to run on login which would open the network path in a file explorer window, then close said window. If you don't do anything to refresh this connection on login (note: locking the screen does not affect this), then Blue Prism will fail to navigate to the directory.

RE: @CaryH, Denis is right on…

DiannaBartlett — Tue, 16 Jul 2019 10:55:00 GMT

Hi @AmiBarrett, can you provide the script file you used to open and close the windows? Or specifically, what you used to close them? I have a process that requires files to be moved to several different sharepoint locations, and I am experiencing the issue you describe where it can't navigate to it. I have worked out how to get them to open, but not close, and with a potential 50 different file paths I can't leave them sitting open once they've been connected to.

------------------------------
Dianna Bartlett
Robotics Developer
LBG
Europe/London
------------------------------

RE: @CaryH, Denis is right on…

AmiBarrett — Tue, 16 Jul 2019 15:07:00 GMT

You'll need to change a couple spots on this batch file. The first line dictates the path of the folder, which in my case is the sharepoint set up as a network drive of W:\ . The end of this where it says "RPA*" is just the start of the Window title. The timeout may vary based on system and/or startup times, but without it the script will execute too fast for it to close anything.

start w:\
timeout 2
taskkill /FI "IMAGENAME eq explorer.exe" /FI "WINDOWTITLE eq RPA*"

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------

RE: @CaryH, Denis is right on…

HarishM2 — Thu, 26 Sep 2019 18:00:00 GMT

Hi,

The above solution will help us to get the files from share point location through file explorer but If I have 100 paths I cannot map 100 drivers in to Network .What would be the best approach for this scenario?

------------------------------
Harish
RPA Developer
------------------------------

RE: @CaryH, Denis is right on…

AmiBarrett — Thu, 26 Sep 2019 19:54:00 GMT

Is this all on the same sharepoint? If so, just make a drive mapping to the highest-level directory and go from there. Treat it like you would any other drive or directory.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
Richardson, TX
------------------------------

RE: @CaryH, Denis is right on…

HarishM2 — Thu, 26 Sep 2019 20:23:00 GMT

Hi Ami ,

Thanks for the response. No, its not the same share point location. I was aware we can navigate from the highest level directory to different sub directory or sub folders bu I was not sure how we can do if we have some thing like 90 or 100 totally different or unrelated URL's. because I think there is some limit like 24 or 25 drivers only we were able to create in one machine.

------------------------------
Harish
RPA Developer
------------------------------

RE: @CaryH, Denis is right on…

AmiBarrett — Thu, 26 Sep 2019 20:28:00 GMT

If you really have that many different locations, that's an unusually obscene number. You may just have to teach the bot to use the web interface at that point.

Alternatively, rather than setting up shared drives, you could probably pass the path to a modified version of the script above to make it connect, then use BP's file actions to reach the path.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
Richardson, TX
------------------------------

RE: Can you map the Sharepoint

Nannevan_der_Wa — Mon, 30 Sep 2019 15:51:00 GMT

I know this has been some time but I am trying to upload a folder from a local machine to a sharepoint folder. When I navigate to the folder in my file explorer it works, but if I give that sharepoint filepath to blueprism for standard file management utility, it doesn't seem to find it.

What do you mean by 'mapping' a sharepoint folder to be a network drive? Do I need to do something specific for that? Hope you can help.

------------------------------
Nanne van der Wal
Advisor
EY
Europe/Amsterdam
------------------------------

RE: @CaryH, Denis is right on…

SandeepNalla — Fri, 25 Oct 2019 20:54:00 GMT

You could use Symbolic links to map network drives. This could be useful if you have used all the 26 mapped drives.

https://superuser.com/questions/210824/creating-a-symbolic-link-to-mapped-network-drive-in-windows

------------------------------
Sandeep Nalla
Senior Consultant
Lateetud Inc
America/New_York
------------------------------

RE: @CaryH, Denis is right on…

sourabh.das — Tue, 11 Feb 2020 08:46:00 GMT

@AmiBarrett Can you please share the entire batch script to make this work, the challenge i am facing is when ever i restart my citrix vda's I am loosing connection to that mapped shared drive.

------------------------------
Sourabh Das
Tech Arch/Tech Lead
Wipro Limited
Asia/Kolkata
------------------------------

RE: @CaryH, Denis is right on…

AmiBarrett — Tue, 11 Feb 2020 21:08:00 GMT

The code I previously shared is the entire batch file. Is there something not working on it for you?

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: @CaryH, Denis is right on…

Faraz_Ahmed_Hus — Wed, 26 Feb 2020 00:47:00 GMT

Do you have a solution for retrieving SharePoint List Items?

------------------------------
Faraz Ahmed Hussain Mohammed
------------------------------

RE: @CaryH, Denis is right on…

vivek.kumar.goel — Wed, 26 Feb 2020 03:52:00 GMT

Hi, You can download the sharepoint VBO from DX and try it out.

------------------------------
Vivek Goel
"If you like this post, please press the "Recommend" Button.
------------------------------

RE: @CaryH, Denis is right on…

BillyMarsh — Wed, 26 Feb 2020 15:34:00 GMT

To Accomplish this on one of our projects, we used Utility - HTTP > HTTP Request. Then convert JSON to Collection with Utility - JSON. This has been very reliable.

------------------------------
Billy Marsh
Delivery Lead
Computershare
America/Denver
------------------------------