Hi fellow acrobat users/developers,
Does anyone have a link to a good tutorial how to populate a MySQL database from a Acrobat X/10 Pro (important) form/portfolio?
In my Acrobat 9 Pro solution I used ADBC with a ODBC connection, which worked perfectly, but that's dropped in the latest Acrobat X/10 version. This was mentioned to me in a other post of mine and that I have to use XFA or SOAP in Acrobat X/10. But how does this work?
A big thanks in advance
Populating a local MySQL database from a Adobe Acrobat X/10 Pro form/portfolio
2011-02-11 07:02:30
My Product Information:
Acrobat Pro 10.0, Windows
Acrobat Pro 10.0, Windows
2011-02-15 01:44:17
#2
@UVSAR: I'm reading and testing with the information you pointed out but is this kind of functionality not working in Acrobat X itself anymore? With Acrobat 9 Pro and ADBC I got it perfectly working with javascripting in Acrobat itself without any use of LiveCycle.
If this isn't possible without LiveCycle anymore than that's what I have to work with. Just curious.
If this isn't possible without LiveCycle anymore than that's what I have to work with. Just curious.
2011-02-15 02:01:06
#3
As you said in your first post, ADBC support has been removed from the Acrobat X Family. XFA and SOAP/LC are now your only options.
2011-02-15 03:24:59
#4
Unfortunately database scripting in a portfolio PDF file is also a ‘No-Go’ in Acrobat X/10 then I’m afraid? This because of a pdf portfolio workflow we developed for a client of ours.
This workflow uses two pdf files:
- a portfolio template pdf for creating a new project portfolio (creates a database on the background based on the pdf properties user input and saves a new unique portfolio pdf in a specific project folder on the desktop),
- a pdf form which submits text field data in the specific database (created with the portfolio template).
The newly created project portfolio uses the ‘Based on an image’ layout. The user selects a background image and creates several positioned folders. In each folder the user inserts a Photo + the (second) pdf form. The user fills out the specific folder data and submits this data to a locally MySQL database (runs locally Wamp Server 2).
I’m afraid this workflow isn’t possible anymore in Acrobat X/10? From the information you pointed out, the pdf form will not be the biggest problem but the portfolio template will(?).
If this workflow (especially the portfolio template part) is possible with Acrobat X/10, could you point me in the right direction to solve this problem?
This workflow uses two pdf files:
- a portfolio template pdf for creating a new project portfolio (creates a database on the background based on the pdf properties user input and saves a new unique portfolio pdf in a specific project folder on the desktop),
- a pdf form which submits text field data in the specific database (created with the portfolio template).
The newly created project portfolio uses the ‘Based on an image’ layout. The user selects a background image and creates several positioned folders. In each folder the user inserts a Photo + the (second) pdf form. The user fills out the specific folder data and submits this data to a locally MySQL database (runs locally Wamp Server 2).
I’m afraid this workflow isn’t possible anymore in Acrobat X/10? From the information you pointed out, the pdf form will not be the biggest problem but the portfolio template will(?).
If this workflow (especially the portfolio template part) is possible with Acrobat X/10, could you point me in the right direction to solve this problem?
SOAP is supported in XFA, but also via a JavaScript object collection within Acrobat which can be used when creating Acrobat-based forms (Acroforms). SOAP works fine when the form is opened in Acrobat, but to get a SOAP-based Acroform to work in Adobe Reader requires that the form be enabled by LiveCycle Reader Extensions - i.e. the very expensive server product, NOT the "extend features" menu options in Acrobat.