Match the data from excel file row and orchestrator Queue item

Help Orchestrator
1

Hello,
I am using RE Framework in my project. I have excel file input. In my process I will get the Status for each input. For example, If there is ID field in my Excel file then I will get the Access No. as my output to that particular ID. I want to write that in my excel file.

In case of system exception, the failed item will processed again after all items being worked from queue. Then that failure will write after all items status in my excel file. How to do that? Where to write these things in RE framework ? Plz guide me as I am very new to this UiPath

2

@Omkar_Shete1

Please use set transaction xaml for these updates…

So that is where queue items are updated…at the same time You can update the excel rows as well…to find the required row…use find/replace which gives required cell value

Cheers

3

Hi Anil,
i am updating the excel file inside the Process itself where I get the output. For happy path it works fine. Only issue is when the Queue retries…

4

@Omkar_Shete1

You can check the reqtry count in the exception block and if the retry number is greater than maximum
Only then update the status else do not update status.

Transactionitem.retryno will give the retry number

Store the max retry count in asset or as it would be constant can give the value directly

Compare them in if condition and then proceed accordingly

Hope this helps

Cheers

5

I gave 2 retry for queue. When for the first time item got fail then it write FAIL in front of the ID in excel file. but after all items processed from Queue that item will get retried, Then the status FAIL is below all items in excel file…

I want that status to get overwrite on previous

6

Thanks for this.

Should I use this inside the SET Transaction >> System Exception

7

@Omkar_Shete1

You can use it either in set transaction status or in the exception block of process xaml…both ahould work

Cheers

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.