Looking to extract specific data and download photos locally from a land assessor's website given a list of parcel ID numbers. Output must be in Excel format. Preference towards code written in VBA.
2017 Nassau County Parcel Information [url removed, login to view] - A small sample of both the input and output needed. Column A is the list of parcel ID numbers provided. Column B replaces single spaces with "++". Column C creates the hyperlink required to query each parcel ID number. All other remaining columns contain information taken from the website. Column AH is a link created to the locally saved copy of the photo for each parcel ID number. The filename for the local copy of the photo will be the same as Column B. If multiple photos exist, all must be saved and filenames appended with -1, -2, -3, etc. for each photo. Column AM is the link to the first photo on the website after parsing for "img=" in the html source code. Doesn't look like a uniform naming system. Parsing may be the only reliable method to get photo link. The first row has been completed as an example of what is required. The following 17 rows is partial completed for your reference purposes. The remaining 7 rows represents the information that would be provided.
Towards the bottom of the file, a few examples of parcel IDs that differ from the majority and must be accounted.
Attached screenshots provide a visual representation of where the required information (denoted by red outline) can be found on the land assessor's website.
This year, the land assessor's website added the JQuery/AJAX protocal to the website and my previously functioning web query VBA code no longer functions as expected.
A typical list needing research contains 17,000 parcel ID numbers. Code must be written to allow for "resuming" should the server stop responding mid-query. Previous VBA code included a delay to allow time for the server to respond to requests. The list can be input via Excel or text file, the output must be either Excel or comma separated text. The locally saved photo file naming convention is referenced above.
Additional information available upon request.
19 freelance ont fait une offre moyenne de 569 $ pour ce travail
I am really interested to do this job and get started right away. Can we discuss the project details. Payment after you're completely satisfied nothing advance.
Hi, I have great experience in website data extraction. i have done the extraction of many sites like [url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view] and many more i have read th Plus