Extracting Data from All documents of same type

Help Studio
#1

I am trying to extract data from all documents of same type Can anyone please tell me how can i achieve this?

Forum Engagement Daily Reports
#2

Hi @Seema_Jethe

Please specify the document file type. Thank you.

#3

@Jobin_Joy Document type is cancelled cheque

#4

Hi @Seema_Jethe

I want to know the type of the file.

For example: In which format you are receiving the cancelled cheque (PDF or Image or Excel etc.)
Kindly specify the file type to discuss more on the solution.

Thank you.

#5

@Jobin_Joy i am receiving the cheque in jpg image format. Can u please let me know which would be be the best way to extract proper data from all cheques in image format

#6

Hi @Seema_Jethe ,

Here is solution for your requirement.

Step 1: Keep all the cheque image files in a folder and loop through to open images one by one.
Step 2: Follow the below OCR based activity to get the specific value from the image file.

c1

c2

Hope this will help you. Thank you.

#7

Hi!

you can try with Document Understanding. for that you need to install the 2 packages

1.UiPath.IntelligentOCR.Activities from All Packages
2.UiPath.DocumentUnderstanding.ML.Activities from official

Regards,
NaNi

#8

@Jobin_Joy I tried your solution but it works for only the document which i have used for extraction and not for any other document.

#9

@Seema_Jethe

Please follow the step 1 which I mentioned in my previous post. (Looping)

Thank you.

#10

@Jobin_Joy I have tried looping also as u mentioned but it works for only the cheque which i have used for extracting data and not for any other cheque of same type
Below are the screenshots
image
image

#11

Kindly share the selector for ‘Get OCR Text’ activity. Please open it on UiExplorer and share a full screenshot here.

Thank you.

#12

@Jobin_Joy below is the screenshot of selector

image
image1366×768 57 KB

#13

Looks like your selector is good.
Anyway can you please check whether the app id in the selector is same when we open different images.

If you can able to share 2 or 3 sample images and your code means, I can check.

Thank you.

#14

@Jobin_Joy I have checked the appid is same for all documents Below is my flow and few documents
Main.xaml (87.6 KB)

Pan Card
Pan Card2339×1653 464 KB

Pan Card
Pan Card1920×1358 318 KB

Pan Card

#15

Looks like PAN card with different layout here, old card and new card.

It might be bit difficult to exact since PAN card with different layout present.

Another workaround will be exact whole text from each image and apply a regular expression to
find the specific data.

Ex: PAN: Alphanumeric of length 10.

Thank you.

#16

@Jobin_Joy Could u please tell me what would be the regular expression to extract data?

#17

Here it is

pan
pan1181×312 9.29 KB

Thank you.

#18

@Jobin_Joy So this would work for PAN card of any layout?

#19

@Jobin_Joy How can i store the regex result in variable? can u please help me with this?