Hi -
I've started the tool and love what I'm seeing so far!
I'd appreciate a few pointers on my first bot.
So far, I can successfully:
- navigate to the site ( http://www.myorangeclerk.com/myclerkapps/ForeClosureSales.aspx?SessionID=bbd957e7-aa60-446a-93ab-269a76a981b1 )
- prompt for the upcoming day range (e.g. "0 to 5 days" initially, ultimately I'll probably choose the "0 to 90 days" after my full automation is working)
What I need to do is:
For each row on the returned table:
- capture the case number (col 1)
- capture the sales date (col 2)
- capture the description (col 3)
- click on the 'Details' link
and from the resulting details page capture the first two columns of the "Party Details" table ("Full Name" and "Party Type")
Thanks in advance for any/all assistance. I'll update the post if/as I make any progress on my own.
- Ray
Update #1:
Making some progress...
For the initially selected table, I've:
- Created variables for each column (Case, SalesDate, Description, Details)
- used the "Transformation" option "Transform to absolute links" on the "Details" column
- saved the table contents to a XML file
Next up (I think), is to create a bot to use the xml file as input to loop through each of the "Details" absolute links
Update #2:
After reviewing the XML output and doing a little testing, I've found I should be able to us the XML data as input to an existing excel/webquery macro tool to pull the Detail data. Not elegant, but I'm pretty sure I can make it work
Any tips on how to do it completely with iRobot are still welcome