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).
AdChoices