PDF Data Extraction Issue 2

Help
, ,
1

image
image793Ă—402 9.94 KB

Can you please explain what could be the reason for data extraction issue in the above sequence.

2

What is the error you are getting?

3

Hi
Welcome to uipath community
We need the pdf file to be opened and kept in foreground of the screen for that anchor base activity to work
For that before anchor base activity use a Start process activity and mention the file path of pdf as input to property Filename
Cheers @badruddin

4

Thanks for your reply, I have started the process and accessed the file as below

image
image1013Ă—430 11.1 KB

1 Like
5

Hi Vishal,

I am not getting any error thats the problem, everything is running smoothly, whatever errors i got i removed that…

1 Like
6

HI @badruddin

Are you accessing the files from a folder?
7

yes, from a folder

8

So is it working fine
@badruddin

9

No. i am not getting the desired result that means, When i am running bot scraping is not done properly and data is not exported to Excel from pdf

10

Fine
will those text appears immediately when the file is opened or we need to scroll up or down to see that text after opening the file
Cheers @badruddin

11

you mean pdf i think, PDF when i opened the values which i am exporting from pdf are at the top so it always appears at the top of pdf,

12

Fine then we need to check with the selector
Or
We can try with Screen scrapping method instead of Get Text
Cheers @badruddin

13

you mean OCR ?

1 Like
14

Yah
@badruddin

15

Hi Palaniyappan,

While using the OCR for PDF data extractions I am facing the below error?

image

Please help

16

I am using MICROSOFT OCR

17

Hi @badruddin

If you are trying to get the specific text from the PDF between two fixed keywords
(Purchase Order No. and Next)
Example:- Purchase Order No. 15 Next

Use below Steps to get the specific text from PDF

  1. Read the text from PDF with a “Read PDF” text activity and store it with a variable such as “StrTest”.

  2. strTest.Substring(strTest.IndexOf(“Purchase Order No.”)+18,strTest.IndexOf(“Next”)-strTest.IndexOf(“Purchase Order No.”)-18)