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…

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

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 scre…

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 wh…

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 ?

As a subject line, how do you think if we could add a set of transaction items to Queue instead of adding each item once? Thanks. JN.

HI @tnguyen449 You have that option… Try out the link below. [image] Bulk Upload Option to load the Queue Orchestrator How to use Datatable (or any other object) in Queue (Orchestrator): Add to queue: In Studio, import Newtonsoft.Json namespace Serialize datatable usi…

If you would have to choose what would you choose? AllOrNothing - in case of error rollback StopAtFirstError - insert till an error is encountered ProcessAllIndividually - insert all that do not throw error and return a list of errors.

My first thought is that all of these three options might come useful in specific scenarios. Do we absolutely have to choose? If I had to, I would say ProcessAllIndividually as the one that seems most flexible out of the three.

Hi Rupesh , You can try using this Opition About Queues and Transactions A queue is a container that enables you to hold an unlimited number of items. Queue items can store multiple types of data, such as invoice information or customer details. This information can be processed in othe…

Bulk Upload Option to load the Queue

Feedback Orchestrator

rupeshkumar.shah (Rupesh) June 25, 2017, 10:42am 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

Topic		Replies	Views
How to upload\consume the bulk data to\from queue? Knowledge Base orchestrator	0	1035	April 15, 2021
Not able to pass DataTable into Orchestrator Queue Orchestrator datatable , orchestrator , activities , studio , question , json	1	837	July 29, 2022
Assign entire DataTable as QueueItem details Activities datatable , excel , orchestrator	7	960	June 19, 2024
Upload an entire data table through queues and return the same Help orchestrator , queue	7	2095	January 31, 2020
Whole data table as single item into an orchestrator queue Help	8	3297	March 10, 2022

Bulk Upload Option to load the Queue

Related topics