T65 - Extract Real Estate Property information from a Website and keep your database up-to-date
|
| Task Description |
Extract Real Estate Property information and keep your database up-to-date.
Note: This sample task uses an example of http://www.hcad.org/ just for illustrative purposes.
|
| Solution |
 |
Record a new task
- Click on Record button.
- Go to the website http://www.hcad.org
- Type in 13 digit Account number for e.g. 1186820010001 in the Account number box.
- Hit enter or click on 'Search' button
- In the search page, copy the information like property name, address, land area, building area, etc using your mouse and paste it in the Excel one by one.
- Hit the Back button on your browser window once you are done copying results for one Account number.
|
Screenshot 1
Screenshot 2
Screenshot 3 |
 |
Create the list of account numbers
- Using Variable Manager, create a variable called 'AccountNumber' of type List.
- Specify to read the values from a text file.
- Specify the path of the text file as C:\AccountNumber.txt.
- Specify the list of account numbers in the text file
|
 |
Extract information for the list of account numbers
- The recorded task will extract the information for one account number.
To make your task extract the information for the list of account numbers you will need to modify the recorded task.
- Select the task and click on 'Edit' to open it in editor.
- Insert a Loop for List around the recorded action. You have to Loop for the list of values present in the AccountNumber List variable.
- Double-click the line where you see your account number being typed (1186820010001) and replace it with the list variable $AccountNumber$.
Tip:
- You will repeat your actions in a loop. So before the loop ends, make sure that the cursor in Excel is in the appropriate cell.
Note:
- The recorded task depends on the mouse co-ordinates for copying the data. If your search results support copying using the keyboard shortcuts use that as keyboard shortcuts can work in any screen resolution.
|
|
| When you run this task, it extracts the real estate data for different properties (account numbers) into an Excel file. |
|
 |
| Wow! This program is fantastic. I was given the task to figure out how to get a list of over 1000 contacts off of a website and into Excel. I was trying to write some kind of macro for days through Excel's VB extension and was making no progress. So I went online and found Automation Anywhere, it took me only minutes to write a macro to copy the addresses. I owe Tethys Solutions hours of my life that I was prepared to spend copying and pasting. Thank you so much Tethys" |
- Ben Kinney,
Monterey media
|
| Read Customer Testimonies >> |
|
