Bulk Upload Option to load the Queue

i_declined
orchestrator
queue

#1

Hi,

I wanted to share that while uploading the data in to queues, we have only option available to populate the queue would be a different process to do that. Since the record populated in the queue is stored in a single column in SQL DB as JSON data. So it will be good idea to have a same logic if we provide the file upload option which reads each row and populate the queue and fill the column with JSON data.


#2

This requires some control. Exception handling. Logging. (if not all items are uploaded). Too complex.


#3

How to use Datatable (or any other object) in Queue (Orchestrator):

Add to queue:

  1. In Studio, import Newtonsoft.Json namespace
  2. Serialize datatable using the following command (output string): JSONConvert.SerializeObject(dt)
  3. Send the string to queue

Consume queue:

  1. Get the string from queue
  2. Use Deserialize json activity (from Uipath.Web.Activities package) using TypeArgument DataTable property
  3. Use the outputed datatable for your workflow.

How to upload data of excel in orchestrator queue?
Orchestrator training - Data table to queue
Orchestrator - ItemInformation
Queue - Upload in Bulk / Create new at the runtime
#4

Thanks Andrei - will try this and keep you posted…

Also, how can we populate the queue rather than constructing this work as a seperate process…

Assume, before my BOT start processing it, i would keep it simple if there is an option to upload the excel file as bulk upload in the queue through screen itself.


#5

As a product, you have everything exception handling, logging…so only thing which needs to work on is to get the input as Excel or file path and read the data and populate the queue as bulk upload…

If the screen provides an option to choose the file and upload…internally we can do the same thing what currently the Add Queue item activity does…


#6

Getting below error while converting Mail message object using JSONConvert object.

Error
Assign : Error getting value from ‘ReadTimeout’ on ‘System.IO.MemoryStream’.
Kindly help to resolve this.


Upload 165 columns into queue
#7

Hi Andrei,
i am able to upload datatable to queue. Now the point is i want to fetch records row by row from the queue? Is there any way to do this ?