You have to login in order to post a reply to this topic.

2 replies [Last post]
Bradj2
User offline. Last seen 12 weeks 1 day ago. Offline
Joined: 01/27/2010
Posts: 18

Hi,
I am evaluating the software and would really appreciate your kind assistance in trying to automate a specific task. My objective is to upload an excel spreadsheet containing a list of urls, name and text and to click on a part of the screen, type some text and insert column C and Column D place holders in the correct place.

I have also attached a PDF and included the text below.

Excel Spreadsheet
Column A                    Column B       Column C      Column D
Http://example.com      Brad              xyz               abc
Http://abctest.com        Mike              gfdshs          htecsbsn

etc upto 100 or 300

Actions

1.) move mouse to 785 / 300
2.) left mouse click
3.) move mouse to 530 / 360
4.) type “hello”
5.) move mouse to 447 / 370
6.) type “Hi, <insert name>
7.) return
8.) type text “this is a test message <insert 1> to feature this example <insert 2> and display the result here”
9.) move mouse to 488 / 527
10.) left mouse click
11.) navigate to next url in list and repeat

AttachmentSize
Navigate a list of URLS.pdf10.48 KB
codex
codex's picture
User offline. Last seen 18 weeks 4 days ago. Offline
Joined: 11/12/2009
Posts: 161
Re: How to navigate a list of urls

I have attached a sample job. Can you please check if it is close to what you need?

CodeX

AttachmentSize
Sample Send Excel Information.waj 20 KB
__________________

Error is not blindness, error is cowardice

__________________

Error is not blindness, error is cowardice

Thomas Minitsios
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 07/16/2009
Posts: 34
Re: How to navigate a list of urls

Hello Brad,

You can find a related post in the following URLs:

http://winautomation.com/blog/using-data-excel-part-i
http://winautomation.com/blog/using-data-excel-par...

The first part of the tutorial explains how you can save the data from Excel in a variable, and the second part, how you can loop through every row that is contained in the data table.

I hope that this helps...