Can't export a relational table using XML Mapping

Occasional Visitor

I created the following XML format to be able to map to an excel spreadsheet and export to XML when datasets are updated. 

 

When I import the XML into excel, it is recognized as the intended format of the spreadsheet. However, when mapping using the same XML format, I receive the following errors.

taloohi_0-1634918392686.png

Is there any way to map with a schema/xml that does not have the maxoccurs = 1 restriction? 

I used the resource below and am not able to replicate:

 

https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa203737(v=office.11...

 

Snippet below:

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<part_list>
    <part id="Map">
            <Option_Code id="FDU1">
                <Part_Numbers>
                    <app>H4B1F1</app>
                    <boot>H4B100</boot>
                    <cal>H4B1F1</cal>
                    <assmb>006351</assmb>
                </Part_Numbers>
            </Option_Code>
            
                <Option_Code id="FDU2">
                <Part_Numbers>
                    <app>H4B1F2</app>
                    <boot>H4B100</boot>
                    <cal>H4B1F2</cal>
                    <assmb>00488</assmb>
                </Part_Numbers>
            </Option_Code>


            <Option_Code id="FDU3">
                <Part_Numbers>
                    <app>H4B1F3</app>
                    <boot>H4B100</boot>
                    <cal>H4B1F3</cal>
                    <assmb>009545</assmb>
                </Part_Numbers>
            </Option_Code>
        </part>
    <part id="Bag">
            <Option_Code id="RDU1">
                <Part_Numbers>
                    <app>H4B2R1</app>
                    <boot>H4B200</boot>
                    <cal>H4B2R1</cal>
                    <assmb>004929</assmb>
                </Part_Numbers>
            </Option_Code>
        
            <Option_Code id="RDU2">
                <Part_Numbers>
                    <app>H4B2R2</app>
                    <boot>H4B200</boot>
                    <cal>H4B2R2</cal>
                    <assmb>006220</assmb>
                </Part_Numbers>
            </Option_Code>
        </part>
    <part id="Van">
            <Option_Code id="FDU1-RDU1">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                    <cal>K7AEF1R1</cal>
                </Part_Numbers>
            </Option_Code>
        
            <Option_Code id="FDU1-RDU2">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                    <cal>K7AEF1R2</cal>
                </Part_Numbers>
            </Option_Code>
        
            <Option_Code id="FDU2-RDU1">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                    <cal>K7ADF2R1</cal>
                </Part_Numbers>
            </Option_Code>

            <Option_Code id="FDU2-RDU2">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                    <cal>K7AEF2R2</cal>
                </Part_Numbers>
            </Option_Code>

            <Option_Code id="FDU3-RDU1">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                </Part_Numbers>
            </Option_Code>
        
            <Option_Code id="FDU3-RDU2">
                <Part_Numbers>
                    <app>K71000</app>
                    <boot>K71000</boot>
                    <cal>K7AEF3R2</cal>
                </Part_Numbers>
            </Option_Code>
        </part>
    <part id="Hat">
            <Option_Code>
                <Part_Numbers>
                    <app>G3D000-</app>
                    <boot>G3D0000</boot>
                    <cal>G3D000</cal>
                    <hardware>G3D000</hardware>
                </Part_Numbers>
            </Option_Code>
        </part>
</part_list>
0 Replies