Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn IB Bloggers
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Can i read an email attachment in PDF
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Can i read an email attachment in PDF
 Login/Join
 
Member
posted
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: Chuck Wolff,


WF8105,Windows 7
 
Posts: 14 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
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.01OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code
 
Posts: 5624 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
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?


WF8105,Windows 7
 
Posts: 14 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
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.01OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code
 
Posts: 5624 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
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.1.05M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
 
Posts: 14 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016Reply With QuoteReport This Post
Member
posted Hide Post
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?


WF8105,Windows 7
 
Posts: 14 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Member
posted Hide Post
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.1.05M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
 
Posts: 14 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Can i read an email attachment in PDF

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.