Scrape the address information from this site:
and append results to an existing sql table ( I will deliver an export of the current sql file)
For each adress there is a link to "Detailansicht" this gives more information to be saved: "Beschreibung/Bemerkungen:"
All addresses with Homepage links, scan the url and scrape the email adresses found. these email adresses are to be saved to a seperate sql table with reference field to the customer number in the first table.
This second table will also be used to try and determine the size of the company. TO acheive this i would like a list with company nr, company name and number of email adresses found at the homepage url.