Virtual Automation Bootcamp with StudioX - Forwarding Inventory Data

This Use Case was simple and included only a couple of Vendors. Imagine having to manually extract the data for 50 vendors, or 100! We’ll take a guess and say that this robot might save the Supply Planner an hour or two a month if the numbers were higher and if this task is recurrent.
How much time do you estimate you’ll save monthly if you automate some of your tasks?

For any technical question , please create a new topic in the StudioX category here .

The automation only collects vendor data for one row. I am using the For Each Row, it looks just like the solution, but it does not go past the first row. Any hints?

Found the problem, was deleting the data on the wrong tab. Doh :slight_smile:

The only issue I had was with creating a template for the inventory list. I didn’t realize I needed to use a template due to the downloaded file. Everything else was good. Good exercise.

Even in downloading the pre built ‘Solution’ I found that the ‘wait for download’ would simply wait in the ‘Save As’ screen, and would not progress further.
I could only over come this in my own build by use of ‘click’ ing on the Save button.
Seemed odd. anyone else?

I have 2 questions:

  1. Why do we need a Template file?
  2. Why create an inventory folder at Design Time and not at Run Time?

Looking forward to clarifications.



I did this exercise, but after i clicked the “Save” button, the program got stuck for over a minute before doing the Click Vendor >> Vendor Inventory step. Any idea why it gets stuck on this step? Hints on this one >> The Data Extraction exercise in a previous step showed us to get data one-by one, but if you clicked on references, you could click on the title of “Supplier code” and the tool gets the entire table.

I also had to add “clear sheet” option to the beginning of the for each row b/c the data was appending and I added a delay 5 seconds before the table extraction b/c I noticed bad data being entered into the CSV file. Appending the vendor code to the CSV was helpful in troubleshooting too.

I did this exercise relatively quick. The only thing that I struggled was the send email piece where I wanted to send all csv files from a folder with other format files. I looked the solution after several tests and noticed that there is a dedicated folder for csv so all files from that folder are attached to the e-mail.
My doubt is how i can attach only specific files from a folder. In this case all csv files

I receive this error at Select Item ‘Vendor Code’.

“Select Item ‘Vendor Code’ (N Select Item) failed:
Value does not fall within the expected range.”

Strange thing is that the automation managed to export the CSV file for all vendors, but keeps coming back to this error before it goes into the emailing stage.

Any help?

Hi, I experienced same error. Did you find out why? Thanks for your help :slight_smile:

i also have this doubt ! please forward me if you get answers

Ran into an issue with “Protected View” for an Excel file. Any suggestions how to overcome this issue?

My robot was kinda lazy, so decided to simply delete the entire VendorInventory sheet after the completion of each row (and not row by row), then reconstructing that sheet by request.

Not sure why Excel can’t open the VendorList.xlsx file…try again tomorrow…

Great exercise, I completed it without any issues. After reviewing the solution file, I realized I took a different approach to get the solution.

  1. Instead of using a template file, I used the downloaded file from the download file activity.
  2. Instead of Export to CSV, I used the Create File and added the .csv extension. (I did that because I did not realize that the Export to CSV activity existed.)
  3. Since I was not using a template file, I did not use the Delete Rows activity
  4. Within the email activity, I selected the entire Inventory folder to be emailed instead of selecting the files.

Thanks for this exercise!

This was a great exercise for testing several things we’ve learned throughout the course. I was able to get through the exercise with hardly any issues. I did get a little stuck on the template piece and why it was needed; just assumed it was to keep the original file in tact. It’s good to see that different approaches are an option. I don’t feel so crazy now when I try to solve in a different way. Also, being able to study the solution and compare against what I tried to do was very helpful.


C. Hill

A good exercise, went through my development without issue, but ran into some problems when checking out the solution, even though were almost similar.
Some observation:

  1. Some of the activity icons were different, I would suspect of the differing versions;
  2. My main issue with the “solution” was that of the export CSV, with error/complaint of the file names being too long.
    Reading through above submission, I suspect are very similar.

I met a problem when use data table extraction from the website: I always got the first header line in the scratchpad but I see the solution doesn’t have it. If there is a header line then project will stop when read first B column to download the file. Anyone knows what’s wrong? thanks.

it took me maybe 3 times the amount of time it took the robot to complete this task. the downloading of the files worked without a hitch

I have the same error… :frowning: