Manual data extraction of Ecuadorian goverment website, 10 000 Observations (Companies)
Budget: €12 – €18 EUR
Extract around 10 000 observations from "Superintendica de Compañías Valores y Seguros" SUPERCIAS. Of each observation (companies) we want to obtain all the CEOS names , and for every search there is a captcha to salve.
Steps:
1.- Go to SUPERCIAS [login to view URL]
2.- click on "Portal de Información"
3.- Then to "Sector Societario"
4.- Go to "Consulta de Compañías"
5.- Click on "RUC"
6.- Here you have to type in the "RUC". We will provide you each "RUC", and each "RUC"will be an observation.
7.- It will appear the first captcha below the box "No soy un robot".
8.- In the screen, at the left side, in the box "Menú principal", click in the second chart "Administradores actuales" and then other captcha will appear. Copy all the data in the screen and paste in a sheet of EXCEL.
9.- Repeat the same but this time the thrid box in the left side "Administradores anteriores" and copy all the data in the same EXCEL sheet.
10.- ALL THESE STEPS YOU HAVE TO COMPLETE FOR EACH OBSERVATION IN THE WEBSITE. THEN WITH THE NAMES "NOMBRES" (THE SECOND COLUMN) YOU HAVE TO GO TO OTHER SITE.
Steps:
1.- Go to SUPERCIAS [login to view URL]
2.- click on "Portal de Información"
3.- Then to "Sector Societario"
4.- Go to "Consulta de Compañías"
5.- Click on "RUC"
6.- Here you have to type in the "RUC". We will provide you each "RUC", and each "RUC"will be an observation.
7.- It will appear the first captcha below the box "No soy un robot".
8.- In the screen, at the left side, in the box "Menú principal", click in the second chart "Administradores actuales" and then other captcha will appear. Copy all the data in the screen and paste in a sheet of EXCEL.
9.- Repeat the same but this time the thrid box in the left side "Administradores anteriores" and copy all the data in the same EXCEL sheet.
10.- ALL THESE STEPS YOU HAVE TO COMPLETE FOR EACH OBSERVATION IN THE WEBSITE. THEN WITH THE NAMES "NOMBRES" (THE SECOND COLUMN) YOU HAVE TO GO TO OTHER SITE.