Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

7
Replies
340
Views
 Rajkumar Ramaswamy (RajkumarR3680) Cognizant Technology Solutions India PVT Ltd
Cognizant Technology Solutions India PVT Ltd
IN
RajkumarR3680 Member since 2019 5 posts
Cognizant Technology Solutions India PVT Ltd
Posted: Jan 16, 2020
Last activity: Jan 22, 2020
Posted: 16 Jan 2020 7:47 EST
Last activity: 22 Jan 2020 8:08 EST
Closed

Read values in PDF and extract the same to excel

Report

Hello All,

Could you please help me with reading values in PDF and extracting the same to excel.

Also share the configuration setup required to complete this activity.

Robotic Process Automation
Posted: 3 years ago
Posted: 16 Jan 2020 10:44 EST
Bhabani Shankar Jena (Bhabani_Jena) Boubyan Bank Sr. RPA Consultant
Boubyan Bank
KW
Report
Pega Robotics has inbuilt pdf connector, refer https://academy.pega.com/library/72/robotic-webinar-using-pdf-connectors
 This will help you for standard formats, and it is rich with features such as search by text / word / segment / position,... If you need further complicated automations, then any. DotNet library from external space can be used ( ex. Itextsharp, this is a powerful library for individual usey, and licensed for enterprise usage) For excel, you can use the inbuilt excel connector. Refer https://community.pega.com/video-library/use-excel-file-connector-read-spreadsheet-data-pega-robotics
 Again, pega robotics has rich features, just you have to explore the methods and properties of all these tooolbox components and utilize then as per your automation need
Santanu Mandal
Posted: 3 years ago
Posted: 20 Jan 2020 5:28 EST
Rajkumar Ramaswamy (RajkumarR3680) Cognizant Technology Solutions India PVT Ltd
Cognizant Technology Solutions India PVT Ltd
IN
Report

Thanks Bhabanishankarj for your valuable response.

And is GetRelativeWord(int relativeWordOffset, out PdfWord resultWord) available in version PEGA 8.01?

Since i am not able to extract required information from PDF.

 

 

 

 
Posted: 3 years ago
Posted: 20 Jan 2020 8:15 EST
Bhabani Shankar Jena (Bhabani_Jena) Boubyan Bank Sr. RPA Consultant
Boubyan Bank
KW
Report

yes ,

the method is available ,

the functionality is to get a word relative to this(supplied) word.

 

if you are getting false , just check if you are passing correct parameters,

 

Also, it is better to try on a standard pdf , then calibrate your practice.
Posted: 3 years ago
Posted: 21 Jan 2020 2:46 EST
Rajkumar Ramaswamy (RajkumarR3680) Cognizant Technology Solutions India PVT Ltd
Cognizant Technology Solutions India PVT Ltd
IN
Report

I don't find the option under methods (PDF Connector).

Attached the screen prints for your reference.

Version: Pega Robotics Automation Runtime Agent 8.0.1081

 
Posted: 3 years ago
Posted: 22 Jan 2020 5:16 EST
Rajkumar Ramaswamy (RajkumarR3680) Cognizant Technology Solutions India PVT Ltd
Cognizant Technology Solutions India PVT Ltd
IN
Report

I found the method under PDFwordproxy. Thanks for your help.
Posted: 3 years ago
Posted: 22 Jan 2020 6:28 EST
Bhabani Shankar Jena (Bhabani_Jena) Boubyan Bank Sr. RPA Consultant
Boubyan Bank
KW
Report

you extracted the proxy ,

the method was under the proxy ?
Posted: 3 years ago
Posted: 22 Jan 2020 8:08 EST
Rajkumar Ramaswamy (RajkumarR3680) Cognizant Technology Solutions India PVT Ltd
Cognizant Technology Solutions India PVT Ltd
IN
Report

Yes.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice