topic RE: Unable to convert PDF To Txt file in Product Forum

Unable to convert PDF To Txt file

sjimoh — Tue, 26 Oct 2021 10:25:00 GMT

I have a PDF File that needs to be converted to a Text file. In order to use the File Management VBO Action Read all text from file. Please how do I go about this in blueprism.

I have tried opening the file using Microsft Word VBO, However, the files contains tables, hence when I copy and paste these records on excel, it doesn't paste the records in the right format as it is expected to be if I copy directly from the PDF or text file.

------------------------------
Shakirat Jimoh
RPA Developer
Waje Smart solutions
Africa/Lagos
------------------------------

RE: Unable to convert PDF To Txt file

shashank.kumar280 — Tue, 26 Oct 2021 11:48:00 GMT

Hi Shakirat,

There is an asset available on DX that can read text from PDF files. Here is the link to it https://digitalexchange.blueprism.com/dx/entry/117528/solution/sabancidx---daily-pdf-actions

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Unable to convert PDF To Txt file

sjimoh — Wed, 27 Oct 2021 11:21:00 GMT

Hi Shashank, Many thanks for the feedback. I tried downlaoding the VBO from the link you shared and also imported it to Blueprism. However, I am getting the following error "Could not load file or assembly 'itextsharp, Version=5.5.13.2, Culture=neutral, PublicKeyToken=8354ae6d2174ddca' or one of its dependencies. The system cannot find the file specified.".

Can you help me with this, I don't know what I am doing wrong to trigger this error.

Thank you.

------------------------------
Shakirat Jimoh
RPA Developer
Waje Smart solutions
Africa/Lagos
------------------------------

RE: Unable to convert PDF To Txt file

ritansh.jatwani — Wed, 27 Oct 2021 11:35:00 GMT

Hi @Shakirat Jimoh,

Did you try placing the file in the Blueprism folder rather than placing the file in the Downloads folder?

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Unable to convert PDF To Txt file

sjimoh — Wed, 27 Oct 2021 11:52:00 GMT

Hi @ritansh.jatwani,

I actually just tried placing the file in the Blueprism Folder and i am getting the same error.

------------------------------
Shakirat Jimoh
RPA Developer
Waje Smart solutions
Africa/Lagos
------------------------------

RE: Unable to convert PDF To Txt file

harish.mogulluri — Wed, 27 Oct 2021 13:29:00 GMT

Hi Shakira,

You can easily convert pdf to text file. If the tables are missing in your text file while saving pdf to text file . Use Adobe acrobat dc and convert the file into OCR and save as text file.

Thanks

------------------------------
Harish Mogulluri
developer
TCS
America/New_York
------------------------------

RE: Unable to convert PDF To Txt file

harish.mogulluri — Wed, 27 Oct 2021 13:35:00 GMT

Hi Shakira,

I would restart my PC and try again, if it is showing error even placing those

------------------------------
Harish Mogulluri
developer
TCS
America/New_York
------------------------------

RE: Unable to convert PDF To Txt file

ritansh.jatwani — Wed, 27 Oct 2021 14:13:00 GMT

Hi @Shakirat Jimoh,

Post placing the files in the Blueprism folder, i would recommend to remove this row line item from Code options tab and again browse to the blueprism location (where the files are placed) so that the backend code gets refreshed automatically. Ideally, post performing browse option, it should not throw any error.

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Unable to convert PDF To Txt file

sjimoh — Wed, 27 Oct 2021 14:27:00 GMT

Hi Ritansh,

I carried out the action of browsing to the path as advised and the error still persists.

------------------------------
Shakirat Jimoh
RPA Developer
Waje Smart solutions
Africa/Lagos
------------------------------

RE: Unable to convert PDF To Txt file

sjimoh — Thu, 28 Oct 2021 08:48:00 GMT

Hi Harish,

The restarting did it for me. I restarted my system and it started working. Thank you.

However, I am experiencing some other issues. I will attach screenshot to give a better understanding.
I noticed that the copied records obtained from the VBO when pasted into the excel workbook (It includes Macro) includes extra lines in the records, it also breaks a line of record into two rows instead of one row. Thus this affects the number of rows i expect to have and also when i apply the Macro in the Excel file, i do not get the right set of records required.

------------------------------
Shakirat Jimoh
RPA Developer
Waje Smart solutions
Africa/Lagos
------------------------------

RE: Unable to convert PDF To Txt file

michaeloneil — Thu, 04 Nov 2021 16:43:00 GMT

Hi Shakirat

If you are wanting to get the info from the pdf to be used in an excel file then there is a pdf to excel converter in the DX community. Link below.

https://digitalexchange.blueprism.com/dx/entry/122031/solution/pdf-to-excel-converter

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------