Spider to extract data from Yellow Pages website and place into CSV format.

1. I must be able to set the starting URL from which the spider will intitiate from on the [url removed, login to view] or [url removed, login to view] websites. The [url removed, login to view] website is powered by [url removed, login to view] and is in the same format but I find the navigation to find various categories easier with

For example I might paste the following URL into the spider utility: [url removed, login to view];C=jewelers&R=N&STYPE=S&MC=1&OO=1&F=1&CP=Clothing+%26+Accessories%5EJewelry%5EJewelers%5E

2. Once the starting URL has been entered, the spider must parse the HTML and extract the business name, city, state, zipcode, telephone number, fax number (if applicable), email address (if applicable), and website (if applicable) into a CSV formatted text file.

3. Spider must crawl through each of the pages until the final page for that category is completed. However, at the very beginning of most categories, there are businesses listed under the "Yellow Pages - Advertisers" heading. These are businesses that are not from the area that I have chosen (for example I chose Alaska and they are from California, etc.) but are advertising in that area. I do not want these entries included. I would want the ones that start under the "Yellow Pages - Listings" heading. The spider does not neccessarily need to know how my list was created, only to avoid entries under the "Advertisers" section.

4. When completed, an update function that lets me name a new file to save the data to or lets me choose an exisiting .CSV file to append the new data to.

5. Search and purge function that can be run anytime on any of the .CSV files that have been created to ensure no two entires have the same telephone number in a specific .CSV file. If duplicates telephone numbers are found, records with the least information are automatically deleted. For example, 2 records wit the same telephone numbers but one lists a fax and the other doesn't, then delete the one without the fax number.

6. Merge function that can be run any time and lets me pick 2 or more .CSV created files and merge them into one new file. If more than 2 files is a problem, I can live with 2 and merge a few times to create one file.

7. Finally, I will provide you with 2 URL's which will represent 2 different yellow page categories on the [url removed, login to view] website and you will run the completed program and email me (or make available to download), 2 .CSV files with the completed and duplicate purged files.

Note: I have included a spider program I have gotten off [url removed, login to view] that may help you. Although you are no specifically bound to use it, the basic structure of the spider will help you progress much faster if you haven't written a java spider before.

My Requirements:

1. You will be easily contacted. Either by phone, or you will be required to answer any e-mail I send to you within 10 hours time.

2. Must speak and write english well.

3. Code must be well commented in english.

4. All source code must be given to me.

5. I would prefer if this was written in a common programming language.

6. I would like this done by no later than March 10th, 2006.

7. Must be able to run on my Pentium III with Windows XP. I am in a very rural area and only have dial up.

8. Delivery of files will be via email for sure and possibly by FTP.

8. A $50 bonus (subject to any fees from [url removed, login to view]) above the agreed bid price if the entire project is completed and delivered to me by March 6th, 2006.


See more: extract info yellow pages csv, download yellow pages csv, windows phone programming language, windows 8 price, websites written in java programming, want to start new business need help, use of data structure in programming, use of data structure, the r programming language, the getafreelancer, src program, src format file, source format, set in data structure, set data structure, set data, search data structure, r programming language download, r programming download, progress programming language, programming with data, programming language r, programming language list, programming language and it, programming in data structure

About the Employer:
( 11 reviews ) Charlottetown, Canada

Project ID: #46662

1 freelancer is bidding on average $200 for this job


Give me an answer today and you’ll have your solution delivered by March 6th. Have you considered run times? Your example url returns 50k+ results, 3500+ pages, 750+MB, 24+ hours on a 56 Kb/s line My solutio More

$200 USD in 4 days
(26 Reviews)