Flow system that will Extract data from multiple scanned pdfs to multiple text files then extract specific data from each text file to excel

Help Studio
, ,
1

Help me create a flow system that will Extract data from multiple scanned pdfs to multiple text files then extract specific data from each text file to excel

2

Hi @PHETHO_SILAS

I had one query here

Why are u are saving the data into text file can we Make it simpler by adding the data to excel ?

3

Hi @NIVED_NAMBIAR.

I am new to Uipath hence i thought converting from pdf to text file then to excel would give me the results i want.
kind share the code or steps i can take to make it simpler

Thank you

4

Hi @PHETHO_SILAS

Since it is a scanned PDF, u can try to use document understanding feature in Uipath which helps to extract the data from scanned PDF etc which u can store in datatable in final

5

@NIVED_NAMBIAR i got stuck sir.I have tried everything.
This problem is unique because of the structure of the documents.I even tried to group them according to their formats or structure,tried to change selectors.Used Uipath ML models but nothing is working.

The following is what we need to extract and import the data on an 1 excel
1.Company Name
2. Registration number
3. Supplier classification (EME, QSE or Generic)
4. BEE Level (Level 1-8)
5. Black ownership percentage
6. Female ownership percentage
7. Designated group supplier
8. Expiry date

please help.See attached
Scanned Pdfs.zip (7.3 MB)

6

@NIVED_NAMBIAR The system must then be able to extract even 100 pdf or more of this type of documents