No Translation available yet
You have Slovak selected as language but this page has not been translated yet. Translate the page or view the content in the default space language below.
Display default
By adding custom columns can be selected, which rows will be imported.
We will use following XML structure for this example:
<employees>
<employee>
<element type="name">Jan</element>
<element type="surname">Novak</element>
<element type="birthDate">1.1.1977</element>
<element type="salary" length="10">15.000</element>
</employee>
</employees>
As row tag should be selected --employee (this tag repeats for each record).
Now, there need to be added new columns, columns are divided by its type (name, surname, birthday, salary).
- Select element [type, length] tag
- Add expression for each column
Expression | Result |
---|
[1] | Jan |
[1].text() | Jan |
[@type="name"] | Jan |
[@type="name"].text() | Jan |
[2] | Novak |
[3] | 1.1.1977 |
[@type="salary"] | 15.000 |
[@type="salary"].text() | 15.000 |
[@type="salary"]/length | 10 |
Click Continue to proceed to Import settings.
Next Steps