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

Populate Form with XML or Database

superpinkster
Registered: Oct 4 2007
Posts: 2

How do I populate an Adobe Acrobat form with information from either an xml file or from sql server? I have been trying to nail this down for three days with no luck. It seems like it should be a "1, 2, 3" issue but I can't seem to find the answer. The Adobe form is already created. I just need to fill it in, save it as a pdf and display it as a pdf in Internet Explorer.

My Product Information:
Acrobat Pro 7.0.5, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
There are many different ways to go about doing this, and they all depend on you're exact workflow.

For example, you can write an Acrobat Automation script, activated from an Acrobat toolbar button, that uses the JavaScript "SOAP" object to access the DB and fill in the form.

If the form is a LiveCycle form, you can connect it to an XML schema when the form is designed, then use ordinary data loading and merging operations to fill in the form.

These are all client side operations. If you want server side data merging you'll have to get the LiveCycle Form Server. This is a non-trivial task. Don't even think about server side processing unless you've got lots of time and money.

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