Hey
I’m trying to import items and item list relations into DW, but the documentation for this I not that clear about how to do it. https://doc.dynamicweb.com/documentation-9/integration/data-integration-module/integration-providers/item-provider#5471
Currently I’m trying with current example where I have a Lot item and on that item I have a item list LotInspection. But when I’m run the data import, this error is thrown. "Job Failed with the following message: Input string was not in a correct format.Couldn't store <1,2,3,4> in LotInspection Column. Expected type is Int32.".
I’m I doing anything wrong ?
<?xml version="1.0" encoding="utf-8"?>
<tables>
<table tableName="Lot">
<item table="Lot">
<column columnName="Id"><![CDATA[1]]></column>
<column columnName="Sort"><![CDATA[1]]></column>
<column columnName="Name"><![CDATA[Lot 42]]></column>
<column columnName="LotNumber"><![CDATA[42]]></column>
<column columnName="LotInspection"><![CDATA[1,2,3,4]]></column>
</item>
</table>
<table tableName="LotInspection">
<item table="LotInspection">
<column columnName="Id"><![CDATA[1]]></column>
<column columnName="Sort"><![CDATA[1]]></column>
<column columnName="InspectionDate"><![CDATA[01-04-2020 00:00:00:000]]></column>
<column columnName="InspectionOfficer"><![CDATA[Tom]]></column>
<column columnName="LotDescription"><![CDATA[Ok]]></column>
</item>
<item table="LotInspection">
<column columnName="Id"><![CDATA[2]]></column>
<column columnName="Sort"><![CDATA[2]]></column>
<column columnName="InspectionDate"><![CDATA[01-05-2020 00:00:00:000]]></column>
<column columnName="InspectionOfficer"><![CDATA[Tot]]></column>
<column columnName="LotDescription"><![CDATA[Ok]]></column>
</item>
<item table="LotInspection">
<column columnName="Id"><![CDATA[3]]></column>
<column columnName="Sort"><![CDATA[3]]></column>
<column columnName="InspectionDate"><![CDATA[01-06-2020 00:00:00:000]]></column>
<column columnName="InspectionOfficer"><![CDATA[Bob]]></column>
<column columnName="LotDescription"><![CDATA[Ok]]></column>
</item>
<item table="LotInspection">
<column columnName="Id"><![CDATA[4]]></column>
<column columnName="Sort"><![CDATA[4]]></column>
<column columnName="InspectionDate"><![CDATA[01-07-2020 00:00:00:000]]></column>
<column columnName="InspectionOfficer"><![CDATA[Ted]]></column>
<column columnName="LotDescription"><![CDATA[Bad]]></column>
</item>
</table>
</tables>
