Skip to main content
Participant
January 27, 2019
Question

Importing Acrobat XML Data into Excel XML Map (XML,XSD)

  • January 27, 2019
  • 0 replies
  • 2140 views

Hello,

I'm running into an issue exporting XML output from Acrobat Pro DC (Version 2019.010.20069) and importing it into an Excel (Version 2013) XML map.

Here's my process:

Using Acrobat Pro DC, I have a form with form field data in the document. This data is exporting into an XML format using the following command:

Edit->Form Options->Export Data and saved as an *.xml file.

The exported XML document is verified within Visual Studio 2017 (Version 15.9.6) as such:

<?xml version="1.0" encoding="UTF-8"?>

<fields xmlns:xfdf="http://ns.adobe.com/xfdf-transition/">

...

... (XML Data Here) ...

...

</fields>

Using Visual Studio 2017, an XSD file is generated from the XML file using the following command:

XML->Create Schema and saved as an *.xsd file.

The generated XSD document is verified within Visual Studio 2017 as such:

<?xml version="1.0" encoding="utf-8"?>

<xs:schema xmlns:xfdf="http://ns.adobe.com/xfdf-transition/" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

  <xs:import namespace="http://ns.adobe.com/xfdf-transition/" />

  <xs:element name="fields">

    <xs:complexType>

      <xs:sequence>

...

... (XSD Data Here) ...

...

      <xs:sequence>

   </xs:complexType>

  </xs:element>

</xs:schema>

Finally, Excel 2013 is open and the following commands are used to bind the generated XSD file:

Developer->Source->XML Maps...->Add...->(XSD File Selected) and an Error Message pops up.

Undeclared XSD attribute: '{http://ns.adobe.com/xfdf-transition/}original'.

The error indicates that 'original' attribute from the namespace is missing or unable to be referenced. This speaks to the elements within the XML/XSD files:

(delphi - Validate a XML against a XSD: Undeclared XSD element - Stack Overflow )

(Correct me if I'm wrong)

... (XSD Data Here) ...

<xs:attribute ref="xfdf:original" use="required" />

... (XSD Data Here) ...

... (XML Data Here) ...

<First6Digits xfdf:original="First 6 Digits">333333</First6Digits>

... (XML Data Here) ...

I am needing the XSD schema for the xfdf namespace (http://ns.adobe.com/xfdf-transition/) to help Excel reference the undeclared XSD attributes.

This would be done by adding the *.xsd file and a corresponding schemaLocation within the generated XSD file from Visual Studio.

Questions:

1) Is my understanding of the issue wrong/incorrect in any way?

2) Where might I find the Adobe XSD schema file for helping Excel reference the xfdf-transition namespace?

3) Are there any XML Export Data options which remove the xfdf namespace inclusion in the XML output?

3) Is there a method for retaining back-compatibility with older XML Export Data options which did not use the xfdf namespace? (i.e. export xml data without namespace data).

This topic has been closed for replies.