Writing Queue data into Excel

Help Activities
, , ,
1

Good Day.

I am trying to write in excel the queues from Orchestrator and here are the activities and steps that I do:

  1. Get Queue Items activity
  2. Build Data Table
  3. For Each where the output variable from Get Queue Items activity are being iterated.
  4. Assign activity inside For Each (ColumnVar = QueueItem.SpecificContent().ToString)
  5. Also inside For Each, Add Data Row:
    Array Row = {Column1Var, Column2Var, Column3Var}
    DataTable = output variable from Build Data Table
  6. Outside For Each activity, write range workbook

I tried to do the steps from above but there are rows that are being repeated and missing. How can I solve this one?

Best regards,
Robert

2

@Llessur

  1. repeated ideally should not be there unless they are retreid items
  2. Possible that you have missing items because it retrieves only 100 items…to get all use the logic explained here

Cheers

3

May I know what is the purpose of these? Why is the condition quIsItems = 100? Thank you

4

Easiest option would be to automate the steps via Front End. Once the zipped folder is downloaded - unzip and utilize the excel file which will give complete details in few clicks. During export - there is no 100 records limits. You can get all the transactions

image
image1918×298 63.3 KB

Are you looking for any specific status like New, In Progress etc or you need full queue item details ?

Before adding - It is good to check whether the unique item is already present in the data table as a work around to avoid duplicates.

5

I am aiming to process the queues with New statues

The image shows an UiPath automation workflow involving steps to get queue items from an orchestrator folder, including filters for queue item states. (Captioned by AI)
The image shows an UiPath automation workflow involving steps to get queue items from an orchestrator folder, including filters for queue item states. (Captioned by AI)1170×310 18 KB

6

@Llessur

As 100 is the limit for one get queue items if the count is not 100 then we can stop the loop that means there are no more items

Cheers

7

If it is specific to New Items - Ideally duplicate rows shouldn’t be there unless you are writing in the same excel while running the process multiple times

100 is the cap set by UiPath to avoid memory exception as a Queue could contain huge number of records

You could build a logic using SKIP and TOP properties of get queue items activity to fetch all the new items. Skip 100 will skip the first 100 items and start from 101 item. Based on the loop count - you could build a logic to extract all the records

image
image1245×581 82.3 KB

8

@Llessur,

Follow this video on how to get all the queue items from the queue.

9

What if there are 1000 items in the queue then it won’t work?

10

@Llessur

the limit is for 1 get of queue items…in one get you would get max 100…so the loop of while which is having condition of 100 will run 10 times to get all 1000 items…and will end loop after that…

if you see the screenshots there are two loops one while which runs till get queue items does not retrieve all items

cheers