directory of .html files

[buddyjackson]

Hello, and thanks for any response.

On my XP box, I have a directory of html files where I want to copy/extract one table of user information and add into a csv file.

I was able to perform and record once with no confusion. I stopped the recording and wanted to replicate the action or maybe loop the action on the entire directory contents of approx 200 html files.

Can someone help me better understand the best method of approach.

[forumstaff]

Hi Buddy,

If we have understood your requirement in the right manner, you can create a script in the task editor as the one mentioned below -

1 Start Loop " Each File in C:\TestAA"
2 If $Extension$ Equal To "html" Then
3 Open "$FileName$.$Extension$ "
4 Extract table from 'http://www.test.com/individuals.htm' website's '13' table
5 End If
6 End Loop

At Step 1, you select the directory under which your .html files are saved.

Then you insert an 'IF' condition to open the .html files and extract the table from the webpage by capturing it through the 'Extract Table' command of the Web Recorder.

Hope this helps. Do let us know if you need any further assistance.

Regards.

[buddyjackson]

Thanks for your help!

I managed to fumble my way around the Editor. The F2 Tip helped, after I'd ignored it a few times...

Following your instruction to Extract my Table data, I arrived at line #4, but its having me go to a URL... Do I need to push these 200 html files onto a webserver to perform the Automation, because the action is called Web Recorder?

Is there a way to just work offline on my XP box?

Thank you, again!

[forumstaff]

Hi Buddy,

Can you send us a couple of html files that you have stored in your directory. Also do let us know the table which you want to extract from these files. This will help us in understanding the requirement in a better way.

Regards.

[buddyjackson]

I Teleported htm pages onto my XP box into a directory and removed all css formatting.

Logically, going back to your original approach line by line, I question why line 4 gets involved? (go to the URL, if line 1,2 & 3 says "look in this folder and get these files).

Helpfully, the URL: Link
Grateful for your instruction

[forumstaff]

Hi Buddy,

Please find attached the sample task that we have created at our end. Download and Save the task under 'My Tasks' folder. To locate the path of the 'My Tasks' folder, right click on any of the existing tasks under Automation Anywhere and select the 'Locate on Disk' option.

There are a couple of changes you need to make in order to run the task successfully -

1. Edit Statement 2 and select the folder which contains your '.htm' files.
2. Edit Statement 4 and change the path to include your folder.
For ex - Navigate URL "C:\agents\$Prompt-Assignment$.htm" should be changed to Navigate URL "<folder containing '.htm' files>\$Prompt-Assignment$.htm"

Hope this helps. Do let us know how it works out at your end.

Regards.