How to read the data from an excel file and then add that data to queue using RE-Framework template

[polu_gopi]

Hi friends,

I want to implement below scenario using UiPath RE-Framework:

step1: Read data from excel file available in predefined location
step2: add the extracted excel data to queue

Once the data is added to queue, i don’t want to process those items . I will create a separate performer to process those items.
Please let me know where do i need to change/modify RE-Framework stages. if changes required, then please explain the steps.
If possible please share the screenshots so that it might be helpful for the people who are also looking for the same logic.

[Gokul001 (Gokul Balaji)]

Hi ,

1. You can Add Workflow to Read Excel Data.
2. In the Framework folder, locate the GetTransactionData.xaml or create a new workflow for reading Excel data.
3. Use Excel Application Scope or Read Range activity to Read the Excel file. Store it in DataTable
4. Data to the Queue.
5. Iterate Over Rows in DataTable: Use a For Each Row activity to loop through the rows in the DataTable.
6. Add Items to Queue: Inside the loop, use the Add Queue Item activity.

Regards
Gokul

[ashokkarale]

@polu_gopi

Modify your REFramework to linear using this thread.

Linear Usecase for REFramework

@devasaiprasad_K , It’s not about the value you are going to assign to out_TransactionItem it’s about checking the in_TransactionNumber and restrict it to 1 only. For second iteration in_TransactionNumber value will be 2 and it will assign out_TransactionItem=Nothing which will result into Linear process. You need to add one if condition in GetTransactionData workflow as below. [image] Thanks, Ashok

Then add your steps into Process.xaml

[jast1631 (Jagravi Trivedi)]

@polu_gopi
Hi

You can refer below mentioned video of Rakesh
It is having similar implementation like read data from excel upload them in queue and then read it back from queue
Only thing is this is created on older version but the functionality is same
You will be able to relate with new Version studio and orchestrator

UiPath Tutorial | Uipath ReFramework Tutorial ( COMPLETE TUTORIAL 2020 Chapter 3)

Hope this helps !

[Anil_G (Anil Gorthi)]

@polu_gopi

1. if the data is available in predefined and all data to be added then better use read range and then bulk add queue item to add all data at once instead of going with ref again
2. if you still want to use then your transaction item can change to datarow to make it add in loop or make it linear and do the same as step 1 in process xaml

cheers

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @polu_gopi,

You don’t need to add any additional states in re-framework for this functionality.

Best place to include this logic would be in "Initialization’ state.

Create a workflow in initialization stage which includes below:

1. Read data from excel using excel application scope and read range
2. Add those items to the queue using Add queue items or Bulk add queue items.

Once created, you will be able to get the queue items automatically from Get transaction state. and refer those queue items in Process state using TransactionItem object.

For better understanding on Re-framework, you can also read through below manual:
REFramework documentation.pdf (507.8 KB)

Hope this helps.

Regards
Sonali