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

Exporting PDF form data

Forum Index > Forms: Acrobat > Exporting PDF form data
2011-04-06 08:52:48
ConnieC
Registered: Feb 16 2011
Posts: 8

***I inadvertently closed the initial post***
 
I have a fillable PDF form in which I am exporting the data to an Excel file. The form is used by project managers and allows them to provide updates on their project. The form includes a page that allows the user to enter issues/problems they are having with the project, save the issue as a bookmarked page, and create a new issue. For instance, project ABC may include 5 separate entries for individual issue. If you look at the bookmarks in the navigation window, you will see each issue listed under a parent bookmark:

- Project Issues
Issue 1
Issue 2
Issue 3
Issue 4
Issue 5

When I export the form data to excel, only one issue is exported. Is there any way to export the data for each issue?

Thank you,
Connie

Thank you,
Connie

My Product Information:
Acrobat Pro 9.2, Windows
Top
2011-04-06 11:17:05
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
How exactly are you exporting to Excel? Is this a Dynamic LiveCycle form?

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

Top
2011-04-06 11:47:41
#2
ConnieC
Registered: Feb 16 2011
Posts: 8
I am utilizing the export feature from Adobe forms tracker and it is exporting to a csv file.

Thank you,
Connie

Top
2011-04-06 13:05:17
#3
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Ok, so you are using the form distribution/collection feature. When you open the form collection document, do the additional issues show up in the form data listing?

And again, is this a dynamic LiveCycle form? This is a critical piece of data.

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

Top
2011-04-06 14:09:49
#4
ConnieC
Registered: Feb 16 2011
Posts: 8
The data is not showing up in the form collection and it is not a LiveCycle form

Thank you,
Connie

Top
2011-04-06 14:36:44
#5
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
The problem, or one of the problems, is the repeated subform for the "issues". The form collection document does not handle repeated data. This limitation is not well explained by Adobe. But whole data collection process relies on the idea that the form data is flat, i.e. there are no repeated data items.

To verify that this is the only issue, try this. Open one of the returned forms and export the data to XML using the "Forms > Manage Form data > Export" menu item. Look in this XML file and see if the repeated data is being reported. If it is not reported in this file then there is an error in the document data binding. This will have to be fixed first before moving forward with a solution to exporting the data to Excel.

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

Top
2011-04-07 11:13:03
#6
ConnieC
Registered: Feb 16 2011
Posts: 8
I receive an error message when I try to export to XML: "An incorrect structure was found in the PDF file"

Thank you,
Connie

Top
2011-04-08 11:07:45
#7
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Well, this is definitely a problem. I'd suggest a couple of tests. Try exporting data from the original form, not the one used for distribution. If this has the same error then make a simple test form. One that includes a repeatable subform like the current form. Try exporting data from it. If it has the same problem then there is something wrong with the system. If not, then see if there are any obvious differences between the test form and the original.

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

Top