How to load the Excel data to queue?

[ashokkarale]

@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.

3. 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.

4. Enable Dynamic Typing (if needed): This allows Orchestrator to interpret string values as integers or booleans to match the schema definition.
5. 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.

Getting Limit in Add Bulk Queue Item

@Haseeb_Farrukh Use like below in a loop by splitting and add in chunks For loop with dt.AsEnumerable.Chunk(15000) Inside loop use currentitem.CopyToDatatable …this will give 15000 items for each iteration Cheers