Consider u have 10000 records u started working on excel sheet suddenly it got closed due to some issue network or server and if u have completed some loops its comes to upto middle around 100 and u have to start from 101 how how will u identify its sta

Help Activities
1

consider u have 10000 records u started working on excel sheet suddenly it got closed due to some issue network or server and if u have completed some loops
its comes to upto middle around 100 and u have to start from 101 how how will u identify its start

2

Hello @TUSHAR_LENDAY ,

If your the process can be connected to Orchestrator, then you should take advantages of Queues https://docs.uipath.com/orchestrator/docs/about-queues-and-transactions

If your process cannot be connected to Orchestrator, then you should build your own mechanism that keeps track of the updates. For instance, after each record that is processed, you should store somewhere (excel, sql table, list etc.) some info that that specific record has been record.

In case of restart, the processes should asses the stored data, and resume processing with the first records that hasn’t been proceed thru the previous run.

Hope it clarifies your issue.
Bes regards,
Marius

3

Hi @TUSHAR_LENDAY,
If you do not have to keep a track of rows that you have processed, you can delete each row from the Excel sheet once you have finished processing. In case the process stops midway and you have to start the process again, then the BOT will start picking up the next rows directly.

In case you do have to keep track of the rows that you have processed, then you can simply append each row in a separate sheet after the row is processed and before the row is deleted from your original sheet.

Let me know if this helps

Thanks,
Nishant

4

Hello @TUSHAR_LENDAY ,
You can use Orchestrator Queues for this. Please connect to the orchestrator , send all the items as transaction in the queue and then process it one by one . Once the bot stops, you can check all the completed, In Progress and pending transactions there.

Thanks