Retrieving information from a directory
Context
Retrieve invoice information to rebuild a customer database
Following a computer problem, a company needs to recover the data of its customers starting from its paper invoices. They are scanned beforehand.
The objective is twofold:
- reconstitute the customer database from this information and regroup them in a CSV file.
- extract billing information on pdf and link them to the customer account.
The output file diagram is special because it must correspond to the import logic of the cash register software used.
Solution
Extraction of invoice information after OCR (text recognition)
Automated processing in our Smart My PDF solution.
Retrieval of all information sorted and stored in a CSV document.
Scenario used
1
OCR Worker
Recovers text from a scanned image
2
ETL Worker
Cleanses and formats data
3
CSV Worker
Categorizes texts
4
Database Worker
Save to database
Return on investment
Retrieval of important data, customer contact details and accounting.
Cleaning, standardization, control and consolidation of information.
The file can be directly integrated into the customer's cash register software
500 hours of data entry by operators saved for the entire project.