Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Multiple Bots can access same excel file as database using OLEDB

ArnabPani
Level 2

‎25-09-23 07:18 AM

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
------------------------------
0 Likes
5 REPLIES 5

Athiban_Mahamathi
MVP

‎25-09-23 07:47 AM

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.

16857.png



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

ArnabPani
Level 2
In response to Athiban_Mahamathi

‎25-09-23 07:58 AM

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
------------------------------
0 Likes

Babjee24
Level 7

‎25-09-23 01:14 PM

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
------------------------------
Babjee Vangipurapu
Senior RPA Developer
India
0 Likes

LeonardoSQueiroz
MVP

‎25-09-23 10:13 PM

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
------------------------------
Leonardo Soares RPA Developer América/Brazil
0 Likes

Athiban_Mahamathi
MVP
In response to ArnabPani

‎26-09-23 07:37 AM

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
------------------------------
0 Likes