Computer vision to loop in a Excel Sheet URL Address

Help Studio
, , , , , , , ,
1

Hi All,
i am creating a Bot automate to read from an Excel Sheet then enter a URL to download a Report. but i have different URL’s for different sites for instance http://192.168.xxx.100/reports/ Here xxx is the dynamic digit that will point to the relavant server.

i am using a Computer vision activity it works fine but it won’t iterate to the next address in my excel file. Please if some one could help me on this .

Here is how the work flow look like in my BOT.

image
image989×372 19.1 KB

image

2

Hello @Kamal_Bernard_De_Senevira!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

Hi @Kamal_Bernard_De_Senevira,
Could you show example of how your excel file looks like and settings for “For Each” loop?

4

Hi Pawel
Here is my Excel File that i need to read each report link and enter it in a Web browser but this one is in a remote System so i need to use Computer vision to identify the elements on the screen
image
image
image

Appreciate if you can help me to solve this.

Thank you
Kamal Bernard

5

Overall process looks good but I’m wondering why are you using CV scope?
I’m not 100% sure but it might be that your selector becomes not compatible with browser after first iteration. I would start from normal browser activities and checking if selector is dynamic so it will handle another step.

6

Dear Pawel

Thank you for your Reply.

i am useing a CV scope because this is a Remote PC running on Remote desktop application such as a Team viewer or Virtual PC.

Yes the selector becoms invalid after the 1st loop. then it cant find the refrehed page so the loop stoped can you kindly help me to create a workflow for looping after the screen refresh.

Thanks and regards
Kamal

7

I guess in that way you could try to work with send shortcut to open new tab before going to next iteration.

8

Hmmm… but if i want to do it in the same Window like refresh page an I pass it with a Hot Key?

9

Are you able to send me your part of the project with this loop? (just remove your CV url and token) I’m pretty sure it’s possible but you need to make anchor or selector more dynamic. I could check it.

10

After careful review and working through managed to get this one solved.

I shall publish my solution so that it will help others also.

  1. I have used CV scope activity and indicated the screen that i need to work on and all the elements have been identified.

2.Used a Read Range Excel to read the sites that is input in the Excel file for instance site1 , site2 , site3, site4, and created a Data table Variable.

3.Add a For Each Row loop to iterate through the excel file

  1. Used a Get Row item Activity to to read the column name of each row.

  2. Add a CV type in activity and indicated on-screen and input the sites by passing the name of the site row(“sitename”).ToString

Here is a screenshot of the solution. — Cheers.

image

1 Like
11

Nicely done! :slight_smile:
Thank you for sharing the solution.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.