XML file structure as follows, record each node field has more with less, import, will go wrong. This is what
<? The XML version="1.0" encoding="utf-8 16 le" standalone="no"?>


001 & lt;/A>
Zhang SAN & lt;/B>
& lt; C> Men's & lt;/C>
Second grade & lt;/D>


002 & lt;/A>
Li si & lt;/B>
Second grade & lt;/D>

.


Above information lead to the data window:
A B C D
Two grade 001 zhang SAN men
002 li si second grade
(the second record D field information guide into a C)

CodePudding user response:

Ru if is direct import order, not according to the node, can use the XML template import can correspond

CodePudding user response:

"The data import" item selected template also not line, the template as follows, what's the problem? Use this for the first time, also is not very good
<? XML version=~ "1.0" encoding="utf-8 le ~ 16" standalone=~ "no ~"?>
A
B
B
D
CodePudding user response:

If the imported identification sequence of XML and XML template logo in a different order, what are the consequences, I tried the XML file of the first and second switch logo, after import, behind the modulated data appeared in the second line, so it is very to note that it is important to ensure that the order are the same,

Also tested if the XML file without identification of XML template, then the DW this field value is empty, do not affect other data import,

CodePudding user response:

Five time, find the problem right away, ha ha

XML template elements are case-sensitive, need is the same as in the XML file,
Tried switching element order does not affect the import and export needs, set up the detail, import does not need to set up the detail
Hereafter have time to try