 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums iWay Software Product Forum on Focal Point [SOLVED] Can i read an email attachment in PDF
Focal Point Forums iWay Software Product Forum on Focal Point [SOLVED] Can i read an email attachment in PDF Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Can i read an email attachment in PDF | Login/Join |
| Platinum Member |
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, WF8206,Windows 7,8,10 HTM,PDF,EXCEL | ||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
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? WF8206,Windows 7,8,10 HTM,PDF,EXCEL | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
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 | |||
|
| Platinum Member |
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? WF8206,Windows 7,8,10 HTM,PDF,EXCEL | |||
|
| Gold member |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums iWay Software Product Forum on Focal Point [SOLVED] Can i read an email attachment in PDF
Focal Point Forums iWay Software Product Forum on Focal Point [SOLVED] Can i read an email attachment in PDFCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |