Normal Topic Mailmerge with pdf file (Read 1696 times)
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Mailmerge with pdf file
Mar 6th, 2010 at 5:56am
Print Post Print Post  
I have to deal with  pdf forms repeatedly in Adobe Acrobat 9.0 Pro Extended with to fill them up with Sesame data.  I can either use typewriter tool and fill it out manually or make the Form fields in the pdf document and import the data from the exported tab separated file from Sesame.  Seems like too many steps to achieve the task.  Unfortunately, there is no MergeFilePrint ( )  like command (that I have been using with RTF file) in sBasic to automatize the process when dealing with pdf files. As I understand API is available for Adobe Acrobat that might help to reduce some of the steps to fill out pdf form fields with Sesame data. Any idea or solution? As always, I will appreciate your input and suggestions.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mailmerge with pdf file
Reply #1 - Mar 6th, 2010 at 3:34pm
Print Post Print Post  
It is possible to import txt files into PDF forms:  http://help.adobe.com/en_US/Acrobat/8.0/Professional/help.html?content=WS58a04a8...

Maybe you can write data to the txt file, shell to Adobe and import.  Adobe may also be a command line ability to open Adobe and do the import at the same time, have not checked that out.....

Oops, I just reread and saw that you are already manually importing.....sorry about repeating that.  

So, on to an automated process ......
--------------

The registered version of PDFill does support command lines and/or batch files.  http://www.pdfill.com/pdf_form_filler.html.  I think I paid about $20 some time ago.  Does data import AND export as well as being a PDF editor, you can make your own forms.

Example to import text file:
C:\Program Files\PlotSoft\PDFill\PDFill.exe" IMPORT TXT SesameExport.txt EmptyForm.pdf FinalForm.pdf

No need to open any outside GUI.

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Mailmerge with pdf file
Reply #2 - Mar 6th, 2010 at 4:15pm
Print Post Print Post  
Thanks Bob. It looks promising. I will look into this and report the outcome. I believe, I should be able to create Tab separated txt data file using sbasic, that would will make one button press process. Thank again.
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Mailmerge with pdf file
Reply #3 - Mar 8th, 2010 at 1:07pm
Print Post Print Post  
Hi Bob
PDFill with its command line works great. I make the appropriate data text file to merge with PDF form elements and process is seamlessly.  Initially I struggled because the text datafile to be merged is expected in different format by PDFill as opposed to Adobe Acrobat.

Adobe Acrobat expected following format:

FieldName1 <tab> FieldName2 <tab>FieldName3<tab>......
FieldValue1 <tab> FieldValue2  <tab>FieldValue3<tab>......

While PDFill expected

FieldNames  <tab>   FieldVaules
FieldName1  <tab>   FieldValue1
FieldName2  <tab>   FieldValue2
FieldName3  <tab>   FieldValue3
FieldName4  <tab>   FieldValue4

Once I figured that out, it was a piece of cake with sBasic.

The resourcefulness of this board and hidden power of Sesame never fails to amaze me!!  Whenever I was confronted with a problem, someone invariably came up with a solution. Thanks Bob.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mailmerge with pdf file
Reply #4 - Mar 9th, 2010 at 12:38am
Print Post Print Post  
Glad it worked out for you.  Good luck with your project.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Mailmerge with pdf file
Reply #5 - Mar 26th, 2010 at 5:48am
Print Post Print Post  
Hi Bob,
Automatic (One Button Press) mailmerge of pdf forms with sesame data with PDFill commandline has been implemented and works just fine. Thanks Bob
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Mailmerge with pdf file
Reply #6 - Mar 28th, 2010 at 11:08pm
Print Post Print Post  
Happy to hear that.

Feel free to post a sample of the code in case others can use it.  Wink
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged