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

Can Some body help me with this ?? Serious Help Directly Exporting / Inserting the Complete Data from responses.pdf to Local DB

Forum Index > PDF Portfolios > Can Some body help me with this ?? Serious Help Directly Exporting / Inserting the Complete Data from responses.pdf to Local DB
2011-07-25 02:23:13
arana
Registered: Jul 4 2011
Posts: 8

Hi there,

This is my first Experience with Acrobat Forms and I want to directly insert / export the FORM data from " _responses.pdf" OR "_distributed.pdf" PDF to a database(primarily MS Access OR MYSQL)

Here is the complete Scenario :-

I have a Acrobat form and this form is suppose to be distributed to end users for getting responses and I am using "Automatically download and organize responses with Acrobat.com" option for distributing the forms to end users (to get the response)

Every thing is working excellent for me but what i want is ,in "_responses.pdf" form (which adobe created for managing the data ) i want to put a button or any other approach with distributed or responses pdf form which could export the complete data from all the responses PDF's to a local database(Access or My SQL) in one GO.

In simple words I do not want the data manually exported to first (.csv or .xml file) (which i could do by clicking the Export -> Export all... link in responses pdf)

I am using Adobe X Pro.
 
Can Somebody tell me Is this possible (or something nearest to this) using Adobe Portfolio ???

Any help would be highly appreciated .

Thanks in Advance

My Product Information:
Acrobat Pro 10.0, Windows
Top
2011-07-25 10:30:29
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Any thing is possible, if you've got the chops (or the funds).

I don't know of any existing tools that perform this process, but you could create an automation script that would do this with a single click. Collecting the data from the attached forms is the simple bit. Look in the Acrobat JavaScript reference at the Doc.submitForm() function. Example #5 shows the code for extracting the data from LiveCycle forms in a Portfolio, combining the data, and then submitting it. LiveCycle forms are easy because the data is already stored in an XML structure. Collecting the data from an AcroForm is a bit more difficult, but it follows the same process. The Doc.exportAsXFDFStr() function will help with the process.

Writing all the data out to an existing DB is more difficult. Where is the DB? local or on a server? For this part of the process you'll need external tools. The easiest solution is to submit the data to a server script, which then writes the data in to the DB. This particular path is well tread so you'll find lots of info on it.

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

Top