scraping from a website

[stefanoste78]

Hello to all.

I asked in the chandoo forum: scraping website

if there was someone who wanted to try to extrapolate business contacts by scraping from this website: Registro Imprese | I dati Ufficiali della Camera di Commercio

Is there anyone who would like to try their hand at this scraping?

Thanks

 

[alansidman]

I think you will need to provide more information on what you want to obtain from the site. There are no tables to extract data from without some sort of input. Explain in detail what you wish to happen. We are not mind readers here and need you to explain your needs.

 

[Marc L]

We are not mind readers here

In fact whatever the Excel VBA forum as « Guessing can't be coding ! » …​

 

[stefanoste78]

OK I describe what I would do manually.
1) I accept the cokies
2) I enter a search key: "pharmacies"
3) I start the search
4) I click on each single page result and extrapolate the following data (I indicate the case of the first result obtained):
4.1) "Nome impresa": Farmacia Centrale Della Dr.Ssa Ciamillo Simonetta S.A.S
4.2) "Indirizzo Impresa": Napoli (NA) Piazza De Franchis 36
4.3) "PEC* ": 11809@pec.federfarma.it
4.4) "Forma giuridica (generico)": Societa' di persone
4.5) "Attività": Farmacie - tabella speciale farmacie farmacie
4.6) "ATECO primaria": 47.73.1

Keep in mind that to view the data in point 4.3), you must first click on the word "mostra".

 

[alansidman]

Does not appear that the site in question is set up to allow easy scraping using automated Excel functions. Neither VBA nor Power Query. They do not appear to use systematic tables that will allow scraping.

 

[stefanoste78]

Does not appear that the site in question is set up to allow easy scraping using automated Excel functions. Neither VBA nor Power Query. They do not appear to use systematic tables that will allow scraping.

the procedure is the same. Seems done right