All data not exporting to csv from response file?

[Don_Enderud]

I exported the response data from a distributed PDF to a csv file.  Within my distributed PDF there are a couple of address fields.  Even though the full addresses are in the response PDF, only the first lines of the addresses were included in the csv file.

Can anyone help me determine how to get all the data from all the fields when I export to a csv file?

I'm using Adobe Acrobat XI Pro, version 11.0.14.

[YatharthS]

Hi https://forums.adobe.com/people/Don%20Enderud ,

Please provide the exact dot version of the software & OS installed at your system .Also check whether is there any update available for the software after going through "help > check for updates "

Follow this thread to reset the preferences for the Acrobat software:- How to reset Preference settings in Acrobat.

Is this happening with the single document or with others as well.

Also refer to this KB article :- https://helpx.adobe.com/acrobat/using/collecting-pdf-form-data.html

Regards,

Yatharth

[Don_Enderud]

Win 7 Home Premium SP1 64-bit, 1.6GHz, 6Gig RAM, i7 CPU (all Windows updates applied).

Adobe Acrobat Pro XI, version 11.0.15.

With the latest update of Acrobat (from 11.0.14 to 11.0.15, see my first note above), I extracted the response again and the addresses still were not complete.  This is the only response record I have to date, so I cannot tell if it will happen with others.

It seems that the extraction of the field is being terminated when the software encounters the first carriage return within the field (That's just a guess, based on observed extract data).

There are no indications that my Preference folder is corrupted (my Stamps, for example, work perfectly).

The KB article you referred me to is the one I read originally, when learning how to extract just the data.

Thank you,

Don

[gkaiseril]

Can you share a link to a sample form?

Special characters or spaces in field names can cause issues when processing fields internally within a PDF or Excel.

Can you post a link to a sample form that exhibits this problem.

[Don_Enderud]

I prefer not to post a link.  However, if you will provide an email address, I will send you samples.

Most of the field names in the form have spaces.  It never occurred to me that the naming of a field could affect the value of the extracted contents of that field.

There are dozens of fields in this form; removing the spaces or replacing them with an underscore is a non-trivial effort.  I hope not to have to do that.

[gkaiseril]

Do not assume this is an issue with Acrobat. MS Excel may also have issues with non-standard characters being used as column headings (the form field names).

Also once the response file has been started one cannot add new fields to the form or add different forms to the response file.

Foreign characters might also cause issues.

Column Name Limitations per Microsoft.

[Don_Enderud]

I still haven't resolved this issue.  I made a new PDF (a shortened version of the one that I originally used), replaced all spaces in field names with underscores, redistributed the form and created a new response PDF.  There are no special or foreign characters in the field names. The field values are complete in the response PDF, but when I extract a response to a CSV file, all fields with multi-word contents are being truncated, usually but not always at the first carriage return.  Some of the form fields are addresses which I could break down into separate fields - street, city, state and zip, but other fields are free-form, i.e., for comments, that cannot be separated.

Since I haven't seen anyone else mentioning that they have or have had a similar issue, I'm assuming that I'm doing something incorrect.

Does anyone have any other suggestions or, preferably, a solution?

Thanks in advance for any help!

[George_Johnson]

I don't think you're doing anything wrong. It seems to be related to carriage returns being present, and may have to do with what type are present (carriage return vs carriage return plus linefeed). I seem to recall having to deal with this a while ago, and my solution was to develop my own export routine that exported to tab delimited form. You have a lot more flexibility this way, but it does involve some programming. CSV has always been troublesome to work with and tab delimited not nearly so much, in my experience anyway. Tab delimited is particularly convenient for PDF forms since fields values don't normally contain tab characters. It's a simple matter to remove them should the user manage to enter any.

[JR Boulay]

Special characters or spaces in field names can cause issues

This is why Acrobat should not allow them.

It's a real issue because when you are exporting response data it's too late for editing field names in the original form.