Focal Point
[SOLVED] Can i read an email attachment in PDF

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7727097786

September 18, 2017, 01:59 PM
srajeevan
[SOLVED] Can i read an email attachment in PDF
Hi,

Can i read an email attachment in PDF and process it and insert the data into a target.?

This message has been edited. Last edited by: FP Mod Chuck,


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
September 18, 2017, 05:36 PM
Waz
Probably not.

Do you want to extract something out of the PDF ?
And what do you mean by insert the data into a target ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

September 18, 2017, 10:49 PM
srajeevan
I will be getting email with pdf attachment which has data.
yeah I need to extract data from pdf and push it to a target master file.
So the attachment pdf will be like source.

For ex: I push data from a excel file to a target table.Here instead of excel file I will have to get the pdf from email attachment?


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
September 18, 2017, 10:59 PM
Waz
As far as I know, you can't do this out of the box.

I would suggest looking into a third party PDF utility to extract the text from the PDF.

The PDF must have text in it, and be in a format the the utility can pull out.

Once its into a file, I guess it will be simple to write it into table


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

September 19, 2017, 11:29 AM
LarissaB
Just for a reference, we use Monarch for our third party PDF utility to extract text out, which then gives the option to place the data into an excel or csv format. From there you could use that output as your target master file.


Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
September 19, 2017, 11:47 AM
srajeevan
quote:
Posts: 11 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016
    Powered by Social Strata

Thanks for the replies.
My requirement is extract pdf attachment from email and then extratc the text out.
LarrissaB,can i do that using Monarch?


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
September 20, 2017, 10:24 AM
LarissaB
Hi srajeevan!
Yes, you can use a combination of different software's to do what you want. You can use PowerShell or Automate (non WebFOCUS products, but your IT department should be familiar with this process) to schedule a job to extract the PDF from the email and save it to a network location, and then use Monarch to extract the data from the PDF file itself and export it to excel or csv.
The really neat thing about monarch is that if those PDF files are always in the same format, then you can create a template in monarch and it will extract the same layout every time. Makes like a lot easier than trying to import a text file into Excel and manually inputting those separator lines to try and make a workable spreadsheet for import.


Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html