Exporting checkbox to csv

Question

Hello,

I've recently received a large number of completed pdf forms. I'd like to export the data from these forms into a single spreadsheet. The form was created in Livecycle Designer some time ago by a colleague, and includes freetext boxes, dropdown menus and checkboxes. Using Acrobat Pro DC > edit > form options > merge data files into spreadsheet, I can do this, but only some of the checkboxes are represented in the resulting spreadsheet.

Checking the form in Livecycle Designer, the checkboxes which exported data to the spreadsheet had data binding enabled as 'use global data' or 'use name (X)', whereas those that didn't export had no data binding enabled.

Can anyone suggest a way to export the data from the checkboxes which did not have data binding enabled? There are several thousand forms, so doing this manually, form by form, would not be feasible.

Thank you,

Jonathan

Thom Parker · Answer

If a field in a LiveCycle form does not have a binding, then it does not appear in the data model. So you are correct that setting this relationship is critical to getting the data out. You cannot do this by editing the original form, because LiveCycle Designer will destroy the data. But I believe you have a number of options for fixing this issue. For example, it may be possible to replace the XFA model in the PDF with one that has the binding. This could be done automatically with a Script. Or there may be a scripting solution that can be applied to the live form (open in Acrobat) to fix the binding. Or a script could be written to export the data differently. None of these are trivial tasks, and will take some time to experiment with different options.

You may find some help here:

http://forms.stefcameron.com/

PM me if you want to hire a consultant for this.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded