I am working on a project that has proven to be extremely time consuming and I wanted to know if there were any ideas for a web query that could automate my efforts of searching a website's database and going through entries and placing each entry in a row in excel or access.
for example here is the database I'm searching - [login to view URL]
from that list I have to manually select each of the neighborhoods (one after another). Once the search returns there are thousands of records of which I have to click into each and extract;
Address | Neighborhood | Use Code | Land Area | Owner Name | Mailing Address | Sale Price | Recordation Date | URL
then I go back to the search results and do the same thing over and over for the next listings. This has proven to be extremely time consuming and I was just wondering if there were a way to automate this. Also, it would need to be flexible enough that my spreadsheet updates with the results once news ones are added.
If you are able to do this I would offer up to 10 additional projects, same task but different websites that need to be able to be imported into the same or another worbook, we could also negotiate a rate increase.
Hi there,
I've done similar data collection jobs for a few realtors in the recent past. I'm a MS Office developer with over 5 years of experience. For more details on my proposed solution, please refer to the private message.
Thanks!
Hi Astradford,
I have done several projects like this.
I had a check at website taxpayerservicecenter regarding your requirement. Its easy and I can complete it in one day.
Waiting for your reply to star working on this.
Best Regards,
Naveen
I have sent you sample Deliverable of "TRINIDAD" Neighborhood. Also sent you the logic to find the unique records in Excel. My team is experienced in Similar projects. I have also sent you Variable payment rate in PM
Hello!
I know the solution for your problem:)
I see there are average 1000 entry for each neighborhood and it will take extremely long time to complete manually.
I can automate the process and it will be done within a few days.:)
Contact me if you're insterested in my services, and please check my profile at fist:)
Regards,
Esther
Hi,
I can assist with this Please contact me to discuss further details. I need to know if you're able to get a CSV file or a straight dump into Excel
Thanks,