Looping through IE table

[timz]

I am presently evaluating AA and have a couple questions regarding looping through IE tables.

The web site from which I am attempting to extract data makes extensive use of java servlets. It has an initial page with multiple rows of data several columns across. At the end of each row of data is a button/hotspot to click amd get the details for the item in that row of data. The AA Web recorder handles this beautifully when I record the session.

What I would like to do is loop through the rows in the table on the first page to get the details which are displayed on the next page. I'm sure this is a typical task for AA, but the first issue I have is that when I write the data from the first table to an Excel file the column which would identify the link to the next page is empty. The address does show in the Web Recorder dialogue under the "Tasks Actions List" under "Control Details". My question is how do I capture this value to automatically proceed to get the details for each row?

The second question I have is regarding looping in general. On page 62 of the documentation it provides an example of how to extract data from an IE table, but I'm wondering if I need a nested loop for what I am describing. That is do I need to loop through both tables or can I loop through the first, go to the details page, and then simply extract the detail on the second page to an Excel file.

Do you have a sample atmn file which would detail looping in this fashion?

Thanks in advance.

[forumsupport]

Hello,

Using Automation Anywhere 4.5, you can extract data from details page as well. If the web control that takes you to details page is a link then using 'Loop for each row in IE table command' you can click on that link and can extract data from details page using 'Extract Data' command.

For your reference, we have attached sample task (ExtractDetailsSample.atmn) in attached zip file. Copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy 2.xls under c:\.
This task will extract list of sample tasks from Tethys website and will extract description of each task in a loop into 2.xls.

If the web control is not a link then you can use other loop options for e.g. Loop 20 times or Loop While web Control 'Next' Exist (if first table is in multiple pages). Inside loop you can use Keystrokes command to click on button that takes you to details page and and can extract data using 'Extract Data' command. Use Keystrokes command to come back from details page, move the cursor to next row so that in next iteration task will process for next row.

You can use nested loops but you cannot use nested 'Loop for each row in IE table' command.

We would like to create task for you. If you could tell us more about your case, we would be able to help you more with specific task.

Hope that helps.