I need to create a tool that collects data weekly from a site specific and mount a file. Cvs with this information, and provide this downloadable file on a website of my property after password entry.
The site collection is: ([url removed, login to view])
Where we have 27 options subpages "Select State"
and 6 variations of these 27 "Select the fuel"
When you select the options the next page brings together and makes an average of the values ??we need to enter each "City" collect and extract this information.
Grouping all in one file. CSV with columns, "ESTADO/MUNICIPIO//RAZÃO SOCIAL/ENDEREÇO/BAIRRO/BANDEIRA/PREÇO VENDA/PREÇO COMPRA /MODALIDADE DE COMPRA/FORNECEDOR (B. BRANCA)/DATA COLETA"
As for the site must be set up a page where it will be simple and logged after the files have weekly individually for separate download.