Welcome, Guest. Please Login or Register.
IRobotSoft Robot
09/05/10 at 13:05:46
News: IRobotSoft is the Best Visual Web Computing Platform!
Home Help Search Login Register


Pages: 1
Send Topic Print
Questions on my first bot. (Read 88 times)
RayOTown
IRobotSoft Newbies
*


I Love IRobotSoft

Posts: 4
Questions on my first bot.
07/26/10 at 12:59:58
 
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  Smiley
 
Any tips on how to do it completely with iRobot are still welcome  Smiley
Back to top
 
« Last Edit: 07/26/10 at 16:39:26 by RayOTown »  
  IP Logged
IRobotSoft Administrator
IRobotSoft Administrator
*****


IRobotSoft, the Best
Internet Robot
System

Posts: 525
Gender: male
Re: Questions on my first bot.
Reply #1 - 07/26/10 at 21:58:58
 
What I found is that the details link is a javascript function, so saving it to xml is not useful.    
 
Actually you want to let the robot click through the detail pages and extract all your data directly.  You need to do the following changes:  
1. At the property of your Get A List of Links action, you need to change the "Field Index for Links:" to 4, which is the detail link.  
2. Add an event for the Get a List of Links action:  
     Event: After each tuple; Value: GoBack(); ValueType: Expression
3. Add a few actions to extract data in the detail page and name it.
4. Save your results at the final action.  
 
Notice that you need to set the menu: Settings -> Pop Up ->  Open In Current Browser to make it working.  See if there is any other problem.  
 
Back to top
 
 

The Administrator.
WWW   IP Logged
RayOTown
IRobotSoft Newbies
*


I Love IRobotSoft

Posts: 4
Re: Questions on my first bot.
Reply #2 - 07/26/10 at 22:54:35
 
Thanks for the suggestions!
I'll give it a try and come back with any follow on questions.
 
   - Ray
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print