Create a dictionary from PDF File

pdf
activities

#1

Hello Friends,
I need to extract some informations from a PDF FIle.
Rami Polizze Rami Elementari.pdf (108.9 KB)
I should extrct the columns called “Prodotto” and “GIORNI PREAVVISO” (annuale column).
I should extract all the data in these two columns, create an Excel File and possibly create a Dictionary in UiPath.
Is it possible to create a dictionary based on the two Excel columns?
TEMPI_MORA_NOSTANDARD_ricodifica.XLSX (14.6 KB)

After creating the Dictionary I should use it to make some controls between variables.

Thank you so much friends.
Camilla :relaxed:


#2

Hi @CamiCat,

I am trying to get the extraction from the pdf. I have used the language setting as Italian. I think, the pdf is having the scanned copy. It is not well scanned. Many characters are not proper. Any way I have attached the output. Microsoft Ocr Only is recognizing the some characters.

File : output.zip (1.4 KB)

Regards
Balamurugan.S


#3

Thank you so much @balupad14 .
Since we have some problems in extracting data from the PDF FIle, maybe it is possible to create a dictionary from the two columns of the Excel?
CAn you please help me in creating the dictionary from the Excel previously attached?
Thank you so much,
Camilla :slight_smile:


#4

Hi @CamiCat,

Here I have attached the Excel to Dictionary.

File : Dictionary.zip (12.0 KB)

Regards
Balamurugan


#5

Hi @CamiCat,

I read a an article about How to get the best OCR results . Just want to share with you.

https://support.texthelp.com/help/how-to-get-the-best-ocr-results

Regards
Balamurugan.S


#6

Thank you so much @balupad14.
Thank you very much for your precious help.
I think it is very difficult to extract the structured data from the Pdf file.
I think the best way is to extract data from the Excel FIle.
If, after creating the dictionary, I should check if the “Prodotto” is a certain one corresponding to one in the Excel file, how can I pass through all the lines in the dictionary?
Thank you,
Camilla. :slight_smile:


#7

Hi @CamiCat,

I have attached the source.
Please check it.
File : pdf2.zip (22.5 KB)

Regards
Balamurugan.S


#8

Thank you so much @balupad14.
Which activity are you doing in the second part of the workflow?


Thank you so much,
Camilla :slight_smile::relaxed:


#9

Hi @CamiCat,
The below i have Marked.

Regards
Balamurugan


#10

Thank you so much @balupad14.
Which activity do you do with this instruction?
Thank you so much,
Camilla :slight_smile:


#11

HI @CamiCat,

At the Assign Activity. When you resize the Expression Editor. You can able to see …

Regards
Balamurugan.S