Not sure why I get this error and the Microsoft help on this is not clear. I'm not an XML expert nor am I an excel expert and cannot find any clear answers as to why this is occurring. Please help!
I have this xml schema:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Items YantraMessageGroupID="1" ValidateItems="N" ShipNode="346272" CompleteInventoryFlag="Y" ApplyDifferences="Y">
<Item UnitOfMeasure="EA" ProductClass="GOOD" ItemID="11551 H1L5" InventoryOrganizationCode="688262">
<Supplies>
<Supply SupplyType="ONHAND" Quantity="0"/>
</Supplies>
</Item>
<Item UnitOfMeasure="EA" ProductClass="GOOD" ItemID="9170 H1L5" InventoryOrganizationCode="688262">
<Supplies>
<Supply SupplyType="ONHAND" Quantity="0"/>
</Supplies>
</Item>
</Items>
And Im trying to map it to 11 columns in excel with the columns in the items tag to only occur once when exported and then everything else should be repeated according to the data inside the respected excel columns.
Example output I'm trying to see:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Items YantraMessageGroupID="71852420200421190001" ValidateItems="N" ShipNode="346272" CompleteInventoryFlag="Y" ApplyDifferences="Y">
<Item UnitOfMeasure="EA" ProductClass="GOOD" ItemID="0107-12-12" InventoryOrganizationCode="688262">
<Supplies>
<Supply SupplyType="ONHAND" Quantity="126"/>
</Supplies>
</Item>
<Item UnitOfMeasure="EA" ProductClass="GOOD" ItemID="0107-12-16" InventoryOrganizationCode="688262">
<Supplies>
<Supply SupplyType="ONHAND" Quantity="12"/>
</Supplies>
</Item>
<Item UnitOfMeasure="EA" ProductClass="GOOD" ItemID="0107-12-8" InventoryOrganizationCode="688262">
<Supplies>
<Supply SupplyType="ONHAND" Quantity="42"/>
</Supplies>
</Item>
