Scrape three websites and nine PDF for information and print the result in SQL format.
1. [url removed, login to view]
Record stores in United States and Canada.
Name, street address, city, state or province, postal code, country, phone number, e-mail, website, and styles.
2. [url removed, login to view]
Record stores in United States.
Name, street address, city, state, zip code, phone number, and e-mail.
3. [url removed, login to view]
Record labels in United States and Canada.
United States: Name, city, state, and genres.
Canada: Name, city, and genres.
4. 9 PDF'S will be sent in an e-mail attachment. All PDF's follow the same format, an example is provided as an attachment. The relevant section is the directory portion which begins on page 2.
I will provide the exact SQL inserts needed for each case. Here's an example:
INSERT INTO listings(name, address, city, region, postal, country, phone, email, website) VALUES (" ");
SELECT @id := LAST_INSERT_ID();
INSERT INTO `table1_table2` (`table1_id`, `table2_id`) VALUES (@id, 'X');
So, the scripts should iterate through each listing on each document and return an SQL insert for each entry. Please deliver the scripts along with text files of SQL inserts when you're done, one text file for each case.