I want to crawl and store all 567 Organic locations in mysql or CSV or excel format. From: [login to view URL] (click search with default options to see all locations).
I need the following fields stored:
Name
Address
City
Province
Postal Code
Phone
Fax
Email
Description
Certification
Contact Person (this is found after clicking a location)
In addition each location needs to have a "category" field with one or more categories (separated by commas), for each category that it is displayed in. This may be trickier and will probably require searching by category and matching the results then updating the category field.
The possible categories are:
Producer
Processor
Retailer
Distributor
Association
Certification Body
Consultant
Restaurant
Thanks kindly.