topic RE: Bot and Human working on same file in Product Forum

Bot and Human working on same file

Neel1 — Mon, 19 Sep 2022 16:51:00 GMT

Hello - What are the best practice for bot working on a file which human is also updating and of course human can open the file at any time of day.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: Bot and Human working on same file

ewilson — Mon, 19 Sep 2022 21:02:00 GMT

Hi @Neeraj Kumar,

I would say the general rule of thumb is don't do this. 🙂 However, it comes down to your use case and the software/platform that's involved. Many software packages will not allow more than one person to edit a file at one time because they're not designed for concurrency. Are you talking about something like Excel or something else?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Bot and Human working on same file

Neel1 — Tue, 20 Sep 2022 06:57:00 GMT

Hello @ewilson - Max time i tried to follow general rule of thumb to avoid chaos 🙂

Yes, i am talking about Excel File.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: Bot and Human working on same file

ManpreetKaur1 — Tue, 20 Sep 2022 19:24:00 GMT

Hi @Neeraj Kumar,

Are you talking about a shared excel file which is available on the sharepoint or a local version of it since you 2 people can't work on same file at the same time.

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

RE: Bot and Human working on same file

Neel1 — Tue, 27 Sep 2022 07:01:00 GMT

Hello @ManpreetKaur1 - Yes. i am talking about Excel file placed in a share drive where BOT and Human can update the excel.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: Bot and Human working on same file

Satish1414 — Tue, 27 Sep 2022 08:24:00 GMT

Hi Neeraj ,

You can try below scenarios .
1)Lets say the Human can update the document before the scheduler kicks in there by when the BOT starts the schedulers no issues .
2)If the Human is updating the file during the scheduler time-- try to Defer the queue item which has the dependency on the File and try after Defer time .

Hope this helps .

Best,
Satish Gunturi

------------------------------
Satish Gunturi
------------------------------

RE: Bot and Human working on same file

Neel1 — Tue, 27 Sep 2022 10:18:00 GMT

Hello Satish - thanks for your reply.

i am considering these workaround only. Once Human is done updating the file then i am running the bot again to pick the value.

My question was more around solution to problem.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------