topic RE: Multiple Bots can access same excel file as database using OLEDB in Product Forum

Multiple Bots can access same excel file as database using OLEDB

ArnabPani — Mon, 25 Sep 2023 06:18:00 GMT

Hello,

I have one excel file with holiday list. I donot want to run bot on those days mentioned in excel file. I have a process running on multi-bot arch.

Please share efficient solution for this problem statement?

Can multiple bot can access holiday list excel file as database at the same time using oledb?

------------------------------
Arnab Pani
------------------------------

RE: Multiple Bots can access same excel file as database using OLEDB

Athiban_Mahamathi — Mon, 25 Sep 2023 06:47:00 GMT

Hi Arnab,

Instead of using excel, you can create a calendar with holidays (as non-working days) and select the same calendar in the bot schedule by enabling the option "Only on days in calendar". Refer below screenshot.

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: Multiple Bots can access same excel file as database using OLEDB

ArnabPani — Mon, 25 Sep 2023 06:58:00 GMT

Thank you for your solution @Athiban Mahamathi Mathialagan. But I don't want to touch schedules for it as the number of days the process wont run will change with time and the updated changes have been captured in the excel file.

------------------------------
Arnab Pani
------------------------------

RE: Multiple Bots can access same excel file as database using OLEDB

Babjee24 — Mon, 25 Sep 2023 12:14:00 GMT

Hi Arnab,

With my knowledge I think it's possible to read the excel via OLEDB from multiple VMs all at once (but this has to be tested in real time I've not got the chance to test this in real time). If you face any issues you can then try environment locking and have a sleep until the lock is released and then retry acquiring the lock this is the ideal way of reading shared files.

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

RE: Multiple Bots can access same excel file as database using OLEDB

LeonardoSQueiroz — Mon, 25 Sep 2023 21:13:00 GMT

Hello Arnab,

See this article, you can get some ideas and adapt to the scenario you are facing: https://community.blueprism.com/communities/community-home/digestviewer/view-question?ContributedContentKey=f5603485-f4b5-4db8-99d6- f87551a0978a&CommunityKey =3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Multiple Bots can access same excel file as database using OLEDB

Athiban_Mahamathi — Tue, 26 Sep 2023 06:37:00 GMT

Hi Arnab,

As mentioned by Bajee, you can make use of the environmental lock to access the same excel by multiple bots.

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------