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

How to direct Directly Export / Insert the Complete Data from responses.pdf or distributed.pdf to Local Database

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
 
Any help would be highly appreciated .
 
Thanks in Advance

My Product Information:
Acrobat Pro 10.1, Windows
try67
Expert
Registered: Oct 30 2008
Posts: 2398
Unfortunately, Adobe dropped the support for ADBC connections to local databases in version X.
So you can either convert all of your forms to LiveCycle forms, where this is still possible, downgrade to Acrobat 9, or make-do with exporting to CSV files and then importing them to your DB.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

arana
Registered: Jul 4 2011
Posts: 8
Thanks try67 for the quick response.

So you are trying to say that it's not possible with Acrobat X Pro 10.0.0 I am currently using Acrobat X Pro Ver.10.0.0 and I am a newbie in this.

Is it possible if i convert this to LiveCycle forms or downgrade my Acrobat ver. to Acrobat 9 or lower ?? AND the most important part do i still get the Acrobat distributed.pdf and responses.pdf form features to manage my response from end users ??

Please reply and guide me to get the solution

Thanks a lot again

-----------------------------
Best Regards
Alok



arana
Registered: Jul 4 2011
Posts: 8
Hi try67

Can you please give me an idea if i can put a button on responses.pdf format so that i can insert javascript and thereby export the data to database using it.

Thanks in Advance

-----------------------------
Best Regards
Alok
try67
Expert
Registered: Oct 30 2008
Posts: 2398
Not in Acrobat X, as I said earlier.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

arana
Registered: Jul 4 2011
Posts: 8
I understand your point that I can't do it in Acrobat X , however i am looking to get an idea how to approach this in Acrobat 9 or lower ?? Can you please help me with this ...

Thanks for due consideration

-----------------------
Regards
Alok
try67
Expert
Registered: Oct 30 2008
Posts: 2398
This is quite a complex operation that requires both SQL and JS knowledge.
If you want, you can contact me personally about it.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com