In this post a method is described how you can configure your xml with repeating with Scribe Insight.
You start with your xml and create associated xsd schema (this is optional) with your xml software like Visual Studio or XML spy or other flavor :-)
|Example customer xml file|
In the following screenshots you see the steps you have to take. In short you open the connection manager, choose for XML > dynamic > Select your xml and xsd. The files should be located in your collaboration folder.
|Example customer xsd file|
After your connection has been created you can define connection to your target. In this example I used a custom table in Scribe Internal database called customers. When you define your source a window will popup where you can define your repeating node(s).
Ok, here is the flow in screenshots..... just like your TV at home :)
|Add Connection > Choose XML|
|Use as Source|
|Its dynamic :-)|
|Choose your files e.g. xml & xsd (in this case)|
At this time you did configure your connections, when you Configure Source (see screenshot below), you will go to XML and select the Customer node of your xml. A new window will popup where you can define your repeating node(s)
|Configure your source|
|Here the magic happens :)|
After your created your source, target and mappings, just hit the "Test Run" button and in my case you would loop three times through the xml file.
|Your basic mapping|
|No where to run :)|
This is in nutshell how you could loop through your source XML file with repeating nodes.
Happy happy happy repeating repeating repeating :)