These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Dynamically fill out PDF from database

n8felton
Registered: Jun 13 2011
Posts: 1

Hello,
 
I'm looking for someone to point me towards a resource that will help me out, be it a book or a website or maybe even some training courses.
 
What I have is about 6 PDFs that all have fields for things like First and Last name. What I would like to do is pre-populate all of these fields in the PDFs with values from a database and have the PDF dynamically created/printed.
 
The idea is to have a web form and I can submit the data to and then have the proper fields already populated after the web form is submitted o the server.

thomp
Expert
Registered: Feb 15 2006
Posts: 4411
You'll find a complete set of videos and sample files that cover techniques for connecting a LiveCycle form into a DB, including pre-populating form data, at the membership site pdfscripting.com:
LiveCycle Scripting

This is a listing of the videos.


Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

NK-INC.COM
Registered: Apr 17 2010
Posts: 93
Q?: The idea is to have a web form and I can submit the data to and then have the proper fields already populated after the web form is submitted o the server.

A!: Yes, you will need to use 3rd party software for the populate a PDF or merge form data with a PDF on a web server.

What type of web server OS are you using? Windows?

Good news! There are free methods available for both.
iText for JAVA/LINUX
iTextSharp for Microsoft .net

iText is great, you may want to buy the e-book "iText in Action!". iText is open-source, which means you can modify the code, and use it without buying a license. iText provides mailing list support.



FDFToolkit.net is another great tool, which utilizes iTextSharp technologies, and provides examples online (see links) and within the software installation. FDFToolkit.net is not free, but offers 1 year of free technical support and updates. FDFToolkit.net works on Microsoft .net web servers.


Useful links:
http://www.fdftoolkit.net/examples/
http://www.fdftoolkit.net/
http://www.itextpdf.com/book/
http://www.itextpdf.com/
http://sourceforge.net/projects/itextsharp/
mkhennafi
Registered: Jul 2 2009
Posts: 15
Hi there

we have created a dynamic form and this form is populated with data extracted from an access database...

In this project, we ask our vendors to provide us with updated data and we have one form per vendor, the form has 1 to many items and the number of rows in the body part of the dynamic form is variable per vendor.

We use Formrouter, XML and Live Designer... Form is generated, automatically emailed to the vendors, the vendors do their update on the form and press the submit button, the form is send to FormRouter and redirected back to the database for update...