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.
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