Web Scraping jQuery/AJAX, Excel Output

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.

Compétences : AJAX, Excel, jQuery / Prototype, Visual Basic pour les apps , Web Scraping

en voir plus : ajax jquery web based applications, google rank scraping web excel, web scraping web excel, screen scraping web site excel, scraping web page excel asp coding web scrap, reading excel file javascript jquery ajax, php scraping web sites ajax, ajax php mysql excel output, using excel screen scraping web, jquery xml web service parameters json ajax, scraping web screens excel, web excel entry ajax copy paste, web excel entry ajax, scraping web excel, ajax jquery web service

Concernant l'employeur :
( 1 commentaire ) Williston Park, United States

Nº du projet : #12720809

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(129 Commentaires)

19 freelance font une offre moyenne de $569 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(393 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(251 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(53 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(13 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(185 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(154 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(127 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(25 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(57 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(111 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(87 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(71 Commentaires)

Hello, I would like to work on your interesting project. I am ready to talk about details in chat.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(25 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(58 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(58 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(72 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(12 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(5 Commentaires)