Facebook pages database
This project received 2 bids from talented freelancers with an average bid price of $500 USD.Get free quotes for a project like this
Browse Related Skills
Other things people do on Freelancer
Project Budget$250 - $750 USD
I need someone to create a database of Facebook pages with: their ID number, page name, type, and number of likes. Here's my suggested approach, which requires 2 scripts to complete. If you have a better method, by all means go ahead.
First, create a script (in the language of your own preference) that will scrape data from this page [url removed, login to view] and gather Page_ids for every Facebook page.
The script needs to:
1) eliminate duplicates (each page id is duplicated several times in the source)
2) load successive pages ad infinitum
3) insert data into a database (mySQL)
Next, we will need another automated script to run this query in FQL (Facebook Query Language) for every page_id returned from the previous script. We will be querying for page name, type, and number of likes, to fill the other columns of the Lexicon
[url removed, login to view] page_id, name, type, fan_count FROM page WHERE page_id = ?
This data should be automatically used to update the mySQL database and fill in the remaining columns.
Please don't hesitate to ask questions or make suggestions. I am very open to new approaches to solving this problem.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online