Create a dictionary from PDF File

Help
,
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

1 Like
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

1 Like
5

Hi @CamiCat,

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

Regards
Balamurugan.S

1 Like
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

1 Like
8

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

image
image1600×900 69.3 KB

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

9

Hi @CamiCat,
The below i have Marked.

image
image1087×642 31.8 KB

Regards
Balamurugan

1 Like
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

1 Like