1350 records to parse - pdf and xls files
- or -
Post a project like this2132
$$$
- Posted:
- Proposals: 15
- Remote
- #2058100
- Awarded
Online/Offline Data Entry,Microsoft excel, internet Research/Web Research, Google docs, fillable PDF form, Data Processing and Data Mining, I Data Scraping, Data Conversion
Bhilwara
2118187213238922254312237157
Description
Experience Level: Expert
JOB DESCRIPTION
There are two jobs: Move ASL 2.0 and PON EU Citizenship – 1306 record
### Move ASL 2.0 – 27 records
Search “COD. ENTE” from source files PRG-Dec471-18_AllB_Finanziati.pdf into FORM-Enti_Gestori.xls “Cod” Column A.
Once found, please doublecheck that the “SOGGETTO PROPONENTE” and “Prov” from source files PRG-Dec471-18_AllB_Finanziati.pdf are the same as in FORM-Enti_Gestori.xls “Ente” Column B and “Prov” Column F
Identify TEL, FAX and E_MAIL of the identified record
Output file should contain: Source file name, “COD. ENTE”, “SOGGETTO PROPONENTE” , “Prov”, TITOLO, DESTINATARI, PUNTEGGIO, TEL, FAX andE_MAIL
### PON EU Citizenship – 1306 record
For each of the files in the subfolders of the folder PON EU Citizenship, select only the records whose name contain “secondo”
Filter only those whose “Stato” is “valutato”
Regione: name of subfolder
Posizione: as specified in the table
Punteggio: as specified in the table
Beneficiario: as specified in the table
Tipologia Scuola : as specified in the table
Denominazione : as specified in the table
Sottoazione : as specified in the table
Stato : as specified in the table
Importo Richiesto: as specified in the table
Phone number: search the "Beneficiario" field in the table across the file Anagrafica and copy the "telefono" field of the relevant record after checking the "Denominazione" field in the table is similar to "denominazione" field in the Anagrafica file
Email: search the "Beneficiario" field in the table across the file Anagrafica and copy the "email" field of the relevant record after checking the "Denominazione" field in the table is similar to "denominazione" field in the Anagrafica file
As an initial stage, you will be required to provide a sample of 5 records to test your understanding of the quality of information for the two jobs
Your proposal will be selected on Mon 2nd July and the results must be delivered before Fri 6th July 12.00 UK time.
There are two jobs: Move ASL 2.0 and PON EU Citizenship – 1306 record
### Move ASL 2.0 – 27 records
Search “COD. ENTE” from source files PRG-Dec471-18_AllB_Finanziati.pdf into FORM-Enti_Gestori.xls “Cod” Column A.
Once found, please doublecheck that the “SOGGETTO PROPONENTE” and “Prov” from source files PRG-Dec471-18_AllB_Finanziati.pdf are the same as in FORM-Enti_Gestori.xls “Ente” Column B and “Prov” Column F
Identify TEL, FAX and E_MAIL of the identified record
Output file should contain: Source file name, “COD. ENTE”, “SOGGETTO PROPONENTE” , “Prov”, TITOLO, DESTINATARI, PUNTEGGIO, TEL, FAX andE_MAIL
### PON EU Citizenship – 1306 record
For each of the files in the subfolders of the folder PON EU Citizenship, select only the records whose name contain “secondo”
Filter only those whose “Stato” is “valutato”
Regione: name of subfolder
Posizione: as specified in the table
Punteggio: as specified in the table
Beneficiario: as specified in the table
Tipologia Scuola : as specified in the table
Denominazione : as specified in the table
Sottoazione : as specified in the table
Stato : as specified in the table
Importo Richiesto: as specified in the table
Phone number: search the "Beneficiario" field in the table across the file Anagrafica and copy the "telefono" field of the relevant record after checking the "Denominazione" field in the table is similar to "denominazione" field in the Anagrafica file
Email: search the "Beneficiario" field in the table across the file Anagrafica and copy the "email" field of the relevant record after checking the "Denominazione" field in the table is similar to "denominazione" field in the Anagrafica file
As an initial stage, you will be required to provide a sample of 5 records to test your understanding of the quality of information for the two jobs
Your proposal will be selected on Mon 2nd July and the results must be delivered before Fri 6th July 12.00 UK time.
Francesco C.
99% (70)Projects Completed
70
Freelancers worked with
22
Projects awarded
62%
Last project
28 May 2024
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
I have one question. You mentioned to match 'prov' from source file. but where is the 'prov' in PRG-Dec471-18_AllB_Finanziati ?
666387
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies