How to create an excel file as a traker as a global or centralised so that it can be accessed from multiple system

Help Studio
,
1

I am going to create an automation ( ui path ,attended )where I want to check if user is present or not help of a api and if user is not present we have to add the user in a excel sheet as a tracker . There is a chance multiple people can use this automation form separate separate system. So I want to store the excel traker some where as a centralised so that even multiple people can do the same operation and if user not present it will automatically add the user in the Excel tracker .
Also we want to read the user details from tracker in the next day and recheck again if those users are still not present in through the api or not if present we have to remove the user details.

The main problem am facing is how to make the tracker as a global or central so that all the data will be updated and correctly present .

Need your support and help.
Please let me know if any other information required from my end.

2

@Raj.1,

Storing the excel file on SharePoint will be the best approach. You can control the access as well as this provides the concurrent access to many users without blocking anyone.

3

@Raj.1

Sharepoin tor google sheet would be good…and can use sheets online activities so tat multiple can work parallely

also if needed can implement a locking mechanism with variable delay to make sure only one bot uses the file at a time and then the next bot starts once the first bot releases and so on

cheers

4

Thanks @ashokkarale ,

I think it may be helpful.
I haven’t tried this one yet .
Let me implement this thing .

If possible can you please help me how to implement or use the it in ui path .
I never done this before .

5

Hi @Anil_G ,

Thanks, it may be helpful.

Can you please help me how we can implement it in ui path. Any kind of examples will be helpful.

6

@Raj.1

this is the activity

integration services can be used to connect

cheers

7

@Raj.1,

Try it by following this documentation. If stuck anywhere specific, feel free to ask.

8

Thanks @ashokkarale ,

Let me try.

I will inform if I stock anywhere

9

Thanks @Anil_G ,

Let me try

1 Like