Orchestrator Queue and studio data dispatcher and performer

[avinash.wankhede]

1. I want to download the excel attachment from email.
2. copy the data from particular row
3. and add those data as Queue.
4. then copy/use those Queue items and paste them into search box of website.

Please help me on this step by step, as I am beginner.

Thanks in advance!

[Usha_Jyothi]

create queue in orchestrator
take one Sequence in studio

• Get IMAP Mail Messages
• For Each item In mailMessages
  • If item.Subject = “Your Email Subject” And item.Attachments.Count > 0
    • Save Attachment
• Excel Application Scope
  • Read Range to get data from the desired row
  • Add Queue Item to add data to the Queue
• Open Browser
  • Type Into to paste Queue data into the search box
  • Other web automation activities as needed

Hope this helps
Usha

[Praveen_Mudhiraj]

1.Use “Open Browser” activity to navigate to the website.
2.Use the “Get Outlook Mail Messages” activity to retrieve the email containing the Excel attachment. and Specify the filter criteria to get the email with the Excel attachment.
3. Download Attachment:
Use the “Save Attachments” activity to save the Excel attachment to a local directory.
4. Read Excel Data:
Use the “Read Range” activity to read the data from the Excel sheet into a DataTable.
5. Pass the data table in loop and copy the data from the desired row.
6. Use the “Add Queue Item” activity to add the data from the selected row as a Queue item.
Configure the Queue item with the necessary parameters, such as the data to be passed to the website.
7. Use the “Get Queue Item” activity to retrieve Queue items one by one.
8. Use Type into activity to paste the data from the Queue item into the search box on the website.

@avinash.wankhede

[Nitya1 (Nitya Tomar)]

Hi @avinash.wankhede

Certainly! I’ll provide you with a step-by-step guide on how to achieve your automation task using UiPath. This involves downloading an Excel attachment from an email, extracting data from a particular row, adding that data as Queue items, and then using those Queue items to populate a search box on a website.

Step 1: Read Email and Download Attachment

1. Use the “Get IMAP Mail Messages” or “Get POP3 Mail Messages” activity to retrieve emails from your email server.
2. Configure the activity with your email credentials, server details, and filter criteria to identify the email with the Excel attachment.
3. Use a “For Each” loop to iterate through the list of emails obtained.
4. Inside the loop, use an “If” condition to check if the current email contains the desired Excel attachment. You can use the .Attachments property to access email attachments.
5. If the condition is met, use the “Save Attachment” activity to download the Excel file to a specified location.

Step 2: Read Excel Data and Add to Queue

1. Use the “Excel Application Scope” activity to open the downloaded Excel file.
2. Within the scope, use the “Read Range” activity to read the data from the Excel sheet into a DataTable variable.
3. Use a “For Each Row” activity to iterate through the DataTable and extract the data from the specific row you want to add to the Queue.
4. Inside the loop, add the extracted data as Queue items using the “Add Queue Item” activity. You can create a Queue in Orchestrator to store these items.

Step 3: Use Queue Items to Populate Website Search Box

1. Use the “Get Queue Items” activity to retrieve the Queue items you added in the previous step.
2. Iterate through the Queue items using a “For Each” loop.
3. Inside the loop, use activities to navigate to the website and populate the search box with the data from the current Queue item.
4. You may need to use web automation activities such as “Type Into” or “Set Text” to enter the data into the search box.
5. After entering the data, you can trigger a search or perform any other required actions on the website.
6. Continue the loop to process all Queue items.

Step 4: Error Handling and Cleanup

1. Implement error handling to capture any exceptions that may occur during the process, such as email retrieval failures, Excel file reading errors, or website interactions.
2. Consider adding logging and notifications to keep track of the automation’s progress and any issues that may arise.
3. Close the Excel application and release any resources once you’ve finished using it.
4. Ensure that the workflow handles the cleanup of temporary files or folders, such as downloaded attachments.

Remember to customize the activities, selectors, and data according to your specific email client, Excel file structure, Queue configuration, and website you’re working with. Additionally, UiPath provides extensive documentation and tutorials that can help you learn and understand each activity and concept in detail.

Thanks!!

[vinitha_yachamaneni]

@avinash.wankhede

• I want to download the excel attachment from email.
• copy the data from particular row
• and add those data as Queue.
• then copy/use those Queue items and paste them into search box of website.

Hello @avinash.wankhede

1. Use the “Get Outlook Mail Messages” activity to retrieve emails from your Outlook mailbox.
2. Use the “Save Attachments” activity to save the Excel attachment to a local folder.
3. Use the “Read Range” activity to read the data from the Excel file
4. Iterate through the DataTable to extract the specific row(s) you need.
5. Create Queue Items with the extracted data using the “Add Queue Item” activity
6. Use the “Open Browser” activity to navigate to the website
7. Use a “Get Queue Items” activity to retrieve the items from the Queue.
8. Use a loop (e.g., For Each) to iterate through the Queue Items.
9. For each item, use UiPath activities to paste the data into the search box on the website.
10. You may need to use activities like “Type Into” or “Set Text” to input the data into the search box.