Manual data extraction of Ecuadorian goverment website, 10 000 Observations (Companies)
Budget: $30 – $250 USD
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 https://www.supercias.gob.ec/portalscvs/index.htm
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.
After collect the CEO name:
1.- Go to https://www.senescyt.gob.ec/web/guest/consultas
2.- Insert CEO id (the first column name "Identificación") in “Identificación(Cédula/Pasaporte)” box and type in the characters on the Black box below with the tittle “*Ingrese los caracteres” . Then copy all the data in other sheet of EXCEL. The you have to move on with the next observation… and repeat the process. Type in “Identificación(Cédula/Pasaporte)” the id (the first column name "Identificación")...
3.- ALL THESE STEPS YOU HAVE TO COMPLETE FOR EACH OBSERVATION THAT YOU COLLECTED BEFORE HAND.
We will provide you a tutorial with all the steps and how to put in the sheet of EXCEL.
Steps:
1.- Go to SUPERCIAS https://www.supercias.gob.ec/portalscvs/index.htm
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.
After collect the CEO name:
1.- Go to https://www.senescyt.gob.ec/web/guest/consultas
2.- Insert CEO id (the first column name "Identificación") in “Identificación(Cédula/Pasaporte)” box and type in the characters on the Black box below with the tittle “*Ingrese los caracteres” . Then copy all the data in other sheet of EXCEL. The you have to move on with the next observation… and repeat the process. Type in “Identificación(Cédula/Pasaporte)” the id (the first column name "Identificación")...
3.- ALL THESE STEPS YOU HAVE TO COMPLETE FOR EACH OBSERVATION THAT YOU COLLECTED BEFORE HAND.
We will provide you a tutorial with all the steps and how to put in the sheet of EXCEL.