How to load the Excel data to queue?

Help Activities
,
1

Hi all,

What is the easiest approach to load the Excel data which contains 60,000+ of records to load UiPath queue??
Please give me some suggestions

2

HIE @lucky7 are you referring to upload the Excel Data into Queues if yes you can use Add Bulk Queue item activity.

cheers

3

@lucky7
use bulk queue item activity

cheers!!

4

Hi @lucky7

Try below:

5

@lucky7,

If it’s onetime thing, follow these steps:

  1. Prepare the CSV File: Convert your Excel data into a CSV file. Ensure it adheres to predefined column headers or custom headers for the corresponding fields in the queue.
  2. Upload File to Orchestrator:
  • In Orchestrator, go to the Queues page and select the desired queue.
  • Click on the corresponding More Actions button and then select Upload Items.
  • Browse and select the CSV file you prepared.
  • Ensure that the file meets the required formatting rules.
  1. Choose Upload Strategy:
  • Process All Independently: Each item is processed individually and added to the queue if successful. You can download a list of items that failed processing.
  • All or Nothing: Items are only added if all of them are successfully processed.
  1. Enable Dynamic Typing (if needed): This allows Orchestrator to interpret string values as integers or booleans to match the schema definition.
  2. Complete the Upload: After selecting the strategy, click Upload to add the items to the queue.

If you have to code it in dispatcher, follow these steps:

Follow this logic to split datatable in 15000 rows per iteration and add. 15000 rows is the limitation of Add Bulk Queue Item Activity.

How to load the input excel into UiPath queue??
6

@lucky7

Use Add bulk queue item activity,
when you use this it wont add reference, to add reference in excel add one more column, column name should be Reference. and copy paste the data that you want set as the reference.

7

Hi all,

I need to load the Excel data to queue which from Excel contains 60000+ records , what is better approach to do this??

8

@lucky7,

Avoid creating duplicate threads.

Check the answers provided on older thread and discuss your doubts.

9

Hey @lucky7
I think the best approach is batch processing rather than adding each item one by one. You can split the data into smaller batches, for example, 500–1000 records at a time, and use Bulk Add Queue Items

10

@lucky7

Use bulk add queue items

  1. use Read range to read the excel
  2. add bulk add queue item activity
  3. pass read range output to bulk add queue item activity
  4. run execution.

Note: if excel having column as Reference as fine if not add one column and set column name Reference and copy the values which you want to see in queue before starting the executions