Scraping of School Contact Data

We need a list of all schools in Austria, including the name and the email address of their director (if supplied). Each state within Austria (8 relevant states) supplies a separate web site, containing these required data. So you may see this project as approx. 8 data scraping projects, because the 8 web sites all have a different structure. It will result in approx. total of 4800 data sets. You need to collect the data according to the attached sample XLS file; each state has a separate sheet in the XLS file. This is your work: For SALZBURG (398 entries): 1) Visit [login to view URL] 2) Select Schultyp = Volksschulen, Politischer Bezirk = Alle 3) Click SUCHEN 4) For each entry of the result list, click on the school name (open in new tab) 5) Scrap the relevant data. For column Schultyp, copy the information from (2)!! 6) Continue with (4) until end. 7) Continue with (2) with Schultyp = Hauptschulen until you selected all school types. For NIEDERÖSTERREICH (1396 entries): 1) Visit [login to view URL] 2) Hover above the search field Schulart and then hover above „Alle Schulen“. 3) Click on SUCHEN 4) Click on each SKZ 5) Scrap the relevant data. Use the „<“ symbol in the first column header to return to the result set. 6) Continue with (4) with the next SKZ, until the end. For STEIERMARK (798 entries) 1) Visit [login to view URL] 2) Select Schultyp = AHS 3) Click on SUCHE STARTEN, 50 result rows 4) For each entry, scrap the relevant data, until end. 5) Continue with (2) with the Schultyp Berufsschule (21 rows) Hauptschule (173 rows) Polytechnische Schule (30 rows) Sonderschule (28 rows) Volksschule (496 rows) For KÄRNTEN (340 entries) 1) Visit [login to view URL] 2) proceed as with KÄRNTEN 3) AHS 22 rows Berufsschule 10 rows Hauptschule 10 rows Neue Mittelschule 48 rows Polytechnische Schule 6 rows Sonderschule 18 rows Volksschule 226 rows For TIROL (unknown number of entries) 1) Visit [login to view URL] 2) For Schultyp, select Volksschulen and Click SUCHEN 3) For each result row, click on the school name and scrap the relevant data 4) Continue with next school until end. 5) Contine with (2) with next school types Hauptschulen/Neue Mittelschulen Sonderschulen Polytechnische Schulen Allgemeinbildende höhere Schulen For VORARLBERG (249 entries) 1) Visit [login to view URL] and click on SUCHEN 2) For each entry, click on DETAILS ans scrap the relevant data For WIEN (699 entries) 1) Visit [login to view URL] 2) Select „SCHULTYP“ Allgemeinbildende Pflichtschulen and click ERWEITERTE SUCHE STARTEN 3) Result set shows 447 entries on several pages. For each entry, click on details. A pop up opens. Scrap the required data. The School ID is only shown in the URL of the pop up by the parameter id. Example „&id=918032&“ → school ID = 918032 4) Continue with (2) with Allgemeinbildende höhere Schulen (97 rows) Sonstige allgemeinbildende Schulen (Statut) (22 rows) Berufsbildende Pflichtschulen (26 rows) Berufsbildende mittlere Schulen (42 rows) Berufsbildende höhere Schulen (41 rows) sonstige Berufsbildende Schulen (Statut) (24 rows) For BURGENLAND (273 rows) 1) Visit [login to view URL] 2) Underneath „2 SCHULTYP“, click on Allgemeinbildende höhere Schule (11 rows) 3) The result set shows at the bottom of the page 4) The school ID is displayed on this page only. 5) Click on the RIGHT ARROW for more information. A new page is opened. Scrap the additional required information (all but the school ID). 6) Continue with (2) with the next links Berufsbildende Schule (18 rows) Berufsschule (4 rows) Neue Mittelschule (41 rows) Polytechnische Schule (8 rows) Sonderschule SPZ (8 rows) Volksschule (180 rows) Weitere Schulen / … (3 rows)