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.
Hello Sr., how are you ? Jorge is my name and I have wide experience doing scrapes using different tools. I'm placing my proposal right now but I'm going to sleep because is really late here in Argentina. How ev Plus
19 freelance font une offre moyenne de $569 pour ce travail
Hi, my name is Sevinc. I read your "Web Scraping jQuery/AJAX, Excel Output" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon Plus
Hi Sir! I'm the expert developer. you can check my profile here https://www.freelancer.com/u/FASTGuru.html .with 5 years of experience I assure you the highest quality of the work. Once you have awarded me your project Plus
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. You can also c Plus
Hi i am highly experienced in web scraping and data search.i am a programmer and scraped more then 300 websites.i can scrap any website and output will be in excel, csv or [url removed, login to view] for your quick response please. Plus
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Plus
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scri Plus
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 friend, Freelancer recruiter team sent me the link to check out your project. I am one of the top Freelancers in this category. Feel free to check my reviews for reference of the similar work. Please contact Plus
Hi, I have more than 14 years of Web scarping and Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 p Plus
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in .Net development. I have developed many web scrapers which scrape sites with AJAX calls and I will be happy to work on Plus
Hello, I would like to work on your interesting project. I am ready to talk about details in chat.
Dear sir, Greeting, Give me 1 chance send good work. Old account has been closed new account start work. I've extensive experience doing the work very [url removed, login to view] work will be absolutely perfect and sound which can ab Plus
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
Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements Plus