Merge Data Files Into Spreadsheet - Failing to extract some data

[0Experience3305703339qu]

Hello Everyone,

I have over 300 fillable PDF forms that are all the same version, though the content and answers differ. These forms contain various types of fields, such as textboxes, checkboxes, and dropdowns.

I’ve encountered an issue where some checkboxes are selected (X), but after extracting the data using the "Merge Data Files Into Spreadsheet" option, the value for these fields appears as (0) instead of (1). Given that there are over 200 fields per form, many of which are checkboxes, it’s not feasible for me to verify each field manually. However, I have found that over 90% of the data extraction is accurate, though in some cases, selected fields are still showing as (0) in the output. When I inspect the form in "Designer," it indicates that the selected value should be (1).

Could anyone provide insight into why this might be happening? I would upload the form for further examination if privacy considerations allowed, but unfortunately, that's not possible. Any advice or suggestions would be greatly appreciated.

Thank you!

[PDF Automation Station]

By "selected value", do you mean the export value of the check box that is selected?  Try running the following script for one of these check boxes in the console:

this.getField("Check Box1").value;

What does it return?

[0Experience3305703339qu]

@PDF Automation Station thanks for your suggestions. I don't know how to run in the console but the screenshot of the scheckbox value from the Designer is attached (if it helps)

[PDF Automation Station]

This forum is for Acrobat.  I don't know what that screen shot is.  If you have Acrobat, press Ctrl + Shift + 7 to enter form editing mode, then double-click one of the check box fields to see the properties. Then look at the export value.

Here's an article about how to use the JavaScript console.

[0Experience3305703339qu]

Thank you, but it shows I can not open XFA form in Acrobat

[PDF Automation Station]

I didn't know it was an XFA form created with LiveCycle Designer.  Sorry, I can't help.

[try67]

It's from LiveCycle Designer (known as Adobe Experience Manager now, or AEM, now), which creates a special kind of PDF files, which are technically known as XFA forms.

Questions about this application and the type of forms it creates should be asked here:

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/ct-p/adobe-experience-mana...

[0Experience3305703339qu]

Thanks @try67 

As I was getting wrong data extraction from Adobe so thought might be this would be the best platform for asking the question. My Bad.

[Tariq Ahmad]

Hi @0Experience3305703339qu, 

Technically it is almost impossible to provide suggestions in such scenarios regarding XFA forms. For example, you need to check if all the fields have unique names and are mapped correctly. Also, need to check what default value is set, etc. It is impossible to provide suggestions without looking into the file.

You can contact the dedicated support channel or try the forum @try67 suggested if you have support available. 
If you can't find help there as well, you can try https://developer.adobe.com/developer-support/ 

~Tariq

[Bernd Alheit]

What do you mean with "Designer," ?

[0Experience3305703339qu]

Adobe Designer (Adobe Experience Manager) for building dynamic form