Exporting .pdf Form

[InquiringMind20]

Hi Guys:

I created a form in LiveCycle designer for some of our clinical auditors to use when they went out to audit charts at sites - with the intention of being able to use Acrobat Pro to merge all the files into a single Excel spreadsheet. However, when I try to merge the files into a spreadsheet it doesn't pull out all the columns. Does anyone have any idea what might be causing it or how to remedy?

Thanks!

[George_Johnson]

You should ask in the LiveCycle Designer forum to see if anyone there can help.

[Allta_Media]

Moving this discussion to the LiveCycle Designer forum.

[TundraSteve]

I'm confused by the process you're following.  Are you trying to export the data to .xls (not supported with XFA forms).  Can you step me through the process?

[George_Johnson]

Acrobat 9: Forms > Manage Forms Data > Merge Data Files into Spreadsheet

Acrobat 10: Tools > Forms > More Forms Options > Manage Form Data > Merge Data Files into Spreadsheet

This creates a CSV data file.

[TundraSteve]

I'm surprised that you're getting any data at all if this is an XFA form.  This was designed for Acroforms as far as I know. 

[InquiringMind20]

Hi Steve:

What I did was create a form in live cycle designer that had the interactive rights extended to reader. There are about 12 columns and 15 rows. My coworkers took this form out to an audit and then saved each one separately. I intended to Tools > Forms > More Forms Options > Manage Form Data > Merge Data Files into Spreadsheet, but that doesn't appear to be working. When the data is extrated only about 8 of the 12 columns are being pulled. The forms are already filled out, so I'm hoping there is some sort of workaround for this. Honestly, I'm not computer savvy enough to know what XFA data form even is, but if there is a way to convert it into a format that I can export to Excel I'd love to hear it!

Thanks,

Dustin