Hello, need to upload excel file to orchestrator queue

Help Orchestrator
,
1

i am using get outlook message and after that i have used for each to save each attached excel file to a folder.
now i need to upload the excel file to the queue to download the excel file in another step at the automation. is this can be done ?

2

Hi @mohamed.saty2012

Read the downloaded excel file and store the output in DataTable say dtData.

After that use Bulk Add Queue Items and pass dtData and your exceld data will be added to the queue.

Regards

3

i need to add the excel.xlsx as one item at the queue then download it to a folder this way i will be able to complete the next process.

4

Hi @mohamed.saty2012
It’s better to save the file in a common shared drive or upload the file to the storage file and add the bucket name, file path in the storage bucket to the queue item. and you can delete the file once you processed the queue item successfully.

@vrdabberu Its good to serialize data table to queue item but the problem is Specified data limit is 1mb per queue item after that it will throw a 403 - Payload Too Large.

5 
To pass a excel file path a queue item, you need to create a queue item name as excelfile path - pass the complete excel file.
However, it is recommended to pass excel file path as Argument and use it anywhere in the whole process/RE-frame work.

Alternate way would be get the Data table name as Argument and use it in any other workflow in the process.

6

the idea of uploading the file to the queue to be able to track all files that has been uploaded as i cannot use the rows in the excel file. that is why i need to upload all files to the queue an process one by one. so please i need a clear approach of how i can achieve this

7

is what i am trying to achieve is applicable or not

8

Question: You want to upload all excel file in one queue item or as separate queue items.

9

i need to upload the excel file as one queue item and download it as excel.xlsx to use it. in another sequence. is this possible

10

Use Add queue item and pass the file Path as one of the collection value pass complete file path in queue.
For multiple file you need to use for each loop and iterate through each file name and keep add queue item inside loop to add each file Path.

11

i managed to upload the full path of the file as showen.

The image shows a UiPath automation workflow with an active debug session and a message box displaying a file path. (Captioned by AI)
The image shows a UiPath automation workflow with an active debug session and a message box displaying a file path. (Captioned by AI)1912Ă—1078 203 KB

no how to download the file from the queue to the required folder

12

i have tried to copy the queue item to a folder but it didnt work.

A screenshot of a process in an automation workflow is showing an error indicating that a specified file could not be found in the given directory path. (Captioned by AI)
A screenshot of a process in an automation workflow is showing an error indicating that a specified file could not be found in the given directory path. (Captioned by AI)1365Ă—531 37.2 KB

13

In copy file activity From should be complete file Path and To Should be Folder path in which you want to copy that file.

14

from is the queue item which hold the full path as shown in the above message box

15

Please share image of your queue item, complete from value, and complete To value.

16

This image shows a user interface with a table listing items by their status and priority, where two rows are selected, and details about a specific data object are displayed on the right side. (Captioned by AI)
This image shows a user interface with a table listing items by their status and priority, where two rows are selected, and details about a specific data object are displayed on the right side. (Captioned by AI)1657Ă—451 73 KB

17

@mohamed.saty2012,

We can’t upload file to queue but we can have filepath which we can use to open it in performer part.

Other approach would be using Storage bucket. Let me know if you are open to this approach so I can explain you more about this one.

Thanks,
Ashok :slight_smile:

1 Like
18

In copy File activity you need to pass from value as in_ transactionitem. specificcontent(“In_c”).ToString and To value should be Folder path where you need to save the file like C:\GL\Application process Reframework\GL\Dispatcher\Temp

19

Use Path Exists Activity to check if the file actually exists in the path before copying it to destination folder. if the Path exists results in False then you need to check if there is any issue with you source file location.

20

I hope this message finds you well. I wanted to take a moment to express my sincere gratitude for all the help and guidance you’ve provided as I’ve been learning UiPath. Your support has made a significant difference in my learning journey, and I truly appreciate the time and effort you’ve invested in helping me understand the concepts and techniques.

Your willingness to share your knowledge and assist with my questions has not only enhanced my skills but also boosted my confidence in working with UiPath. I feel much more capable and prepared, thanks to your encouragement and expertise.

Once again, thank you for being such a valuable mentor. I look forward to continuing to grow and apply what I’ve learned.