How to use Queue Upload item

Help Orchestrator
,
1

After exporting the queue data, I want to select some data and use the Queue Item upload method.

I tried uploading the downloaded Excel format, but the Jod_State and Base_Data I set cannot be used.

How should the data under Specific data be written in Excel so that it can be checked in the Queue like the first image?

And the TEXT is broken when written in Korean.
Is it only available in English?

<Image 1 - Original Queue>

image
image334×467 9.85 KB

<Image 2- Downloaded Excel>

image
image1289×157 11.4 KB

<Image 3- Newly uploaded Queue>

The image shows a flowchart with arrows connecting the text "Specific Data: Job_State" to "Base_Datas." (Captioned by AI)
The image shows a flowchart with arrows connecting the text "Specific Data: Job_State" to "Base_Datas." (Captioned by AI)274×467 7.67 KB

2

@bbbb

ideally you can upload the text data only

can you explain the issue it is not very clear

looks like you need to given them as the column names if usign excel

if using json then key value pairs

cheers

3

Hi @bbbb The Specific Data needs to be columns in your csv.
You can use power query to transform the Json in csv columns

Transform - Parse - JSON

The image shows a data transformation interface in Power Query, highlighting the process of converting a column of specific data into JSON format. (Captioned by AI)
The image shows a data transformation interface in Power Query, highlighting the process of converting a column of specific data into JSON format. (Captioned by AI)1039×250 21 KB

A dialog box titled "Specific Data" with options to select columns and a caution about the list being incomplete, highlighting the "OK" button in yellow. (Captioned by AI)
A dialog box titled "Specific Data" with options to select columns and a caution about the list being incomplete, highlighting the "OK" button in yellow. (Captioned by AI)552×412 10.6 KB

The image shows a selection interface where multiple properties can be checked or unchecked, with options to load more and use the original column name as a prefix, and buttons for "OK" and "Cancel." (Captioned by AI)
The image shows a selection interface where multiple properties can be checked or unchecked, with options to load more and use the original column name as a prefix, and buttons for "OK" and "Cancel." (Captioned by AI)529×400 11.5 KB

Close And Load

Then, save the data in a csv file

The image shows a table with columns labeled Status, Reference, Priority, additional1, additional2, and additionalProp3, containing data entries mostly marked as "string" with varying priority levels. (Captioned by AI)
The image shows a table with columns labeled Status, Reference, Priority, additional1, additional2, and additionalProp3, containing data entries mostly marked as "string" with varying priority levels. (Captioned by AI)634×181 3.49 KB

Note: Priority needs to be between (1 and 3) and Reference is required.

Then, upload the file. Orchestrator will show and describe any error with the values; if all good, then your items will be uploaded properly

A table lists five entries with references, all with a status of "New," no revisions, and varying priorities from Low to High. (Captioned by AI)
A table lists five entries with references, all with a status of "New," no revisions, and varying priorities from Low to High. (Captioned by AI)672×190 12.5 KB

4

Hello, I tried the method you mentioned, but an error occurs when I try to upload the csv file.

Which part is wrong?

image

A dialog box shows an error message stating "The input was not valid" indicating that the "bulkAddQueueItemsParameters" field is required, alongside options for processing a CSV file named "TESE2.csv" that has been parsed successfully with 3 rows found. (Captioned by AI)
A dialog box shows an error message stating "The input was not valid" indicating that the "bulkAddQueueItemsParameters" field is required, alongside options for processing a CSV file named "TESE2.csv" that has been parsed successfully with 3 rows found. (Captioned by AI)595×377 33.8 KB

5

Hi,
Not sure if Status Column is required.
Uncheck “Use original column name as prefix” in power query; if it is easy, replace “Specific Data.” for nothing, in order to keep just the property names.

What kind of data are you trying to upload?

6

Both TargetFiles and Basedata are data in json format.

7

Success!!!

However, it cannot read Korean.
Is there any way?

8

Cool!
Was the issue with the Json value formats? Excel cell limit is 32,767 characters, sometimes the json is being trimmed

I am not sure about the Korean language limitation; but, I found the following links that could be helpful

When Special Characters Present In Queue “Specific Data”, On Clone The Queue Encoding Gets Changed In UiPath Orchestrator 2019.10 and 2020.4 - News / Knowledge Base - UiPath Community Forum

[Solved] The trouble with the queues and non-ASCII characters - Help - UiPath Community Forum