Hi again,
I need to start a new proces, starting out with import a XML file to a collection (its a pretty big xml collection).
So far I have looked into XML utility - and can read the file into a dataitem, but how do I getting the data from the dataitem into a collection.
I guess its something with a loop but I am not sure, how do you guys work this out.
Here is a example of the first bit in my xml-file a item - and there are somewhere between 100-500 items in the file I guess.
<?xml version="1.0" encoding="utf-8"?>
<Data>
<Items>
<Item>
<ID>12025</ID>
<Name>SPLITTER</Name>
<Text>SPLITTER</Text>
<Unit>pc</Unit>
<SalesPrice>388.00</SalesPrice>
<CostPrice>171.50</CostPrice>
<TimeStamp>2020-05-07T18:00:58</TimeStamp>
</Item>
I need to start a new proces, starting out with import a XML file to a collection (its a pretty big xml collection).
So far I have looked into XML utility - and can read the file into a dataitem, but how do I getting the data from the dataitem into a collection.
I guess its something with a loop but I am not sure, how do you guys work this out.
Here is a example of the first bit in my xml-file a item - and there are somewhere between 100-500 items in the file I guess.
<?xml version="1.0" encoding="utf-8"?>
<Data>
<Items>
<Item>
<ID>12025</ID>
<Name>SPLITTER</Name>
<Text>SPLITTER</Text>
<Unit>pc</Unit>
<SalesPrice>388.00</SalesPrice>
<CostPrice>171.50</CostPrice>
<TimeStamp>2020-05-07T18:00:58</TimeStamp>
</Item>