TB.One > Import & Export > Master Data Import via TB.Cat/XML > Importing Internal Categories via XML

Importing Internal Categories via XML

Using the STRUCTURE node ("TBCATALOG / CLASSIFICATION / STRUCTURE"), you may import internal categories hierarchically or in a flat structure.

3016_structure

 

NODE

REQUIRED

DATA TYPE

DESCRIPTION

CLASSIFICATION

N

XML

Main node

STRUCTURE

N

XML

Structure node

STRUCTURE[id]

N

INT

Currently not used

STRUCTURE_ITEM

N

XML

Category node

ID

Y

INT

Unique ID of the category node

NAME

Y

CHAR(100)

Designation of the category node

PARENT_ID

Y

INT

Reference to the ID of the parent node (if main category, then value = 0)

SORT

Y

INT

Sorting of the category within the parent node

 

EXAMPLE:
Tree Structure

<STRUCTURE>

 <STRUCTURE_ITEM>

         <ID>641</ID>

         <NAME>Pflanzen</NAME>

         <PARENT_ID>0</PARENT_ID>

         <SORT>0</SORT>

 </STRUCTURE_ITEM>

 <STRUCTURE_ITEM>

         <ID>745</ID>

         <NAME>Obstpflanzen</NAME>

         <PARENT_ID>641</PARENT_ID>

         <SORT>0</SORT>

 </STRUCTURE_ITEM>

</STRUCTURE>

Flat Structure

<STRUCTURE>

 <STRUCTURE_ITEM>

         <ID>641</ID>

         <NAME>Pflanzen</NAME>

         <PARENT_ID>0</PARENT_ID>

         <SORT>0</SORT>

 </STRUCTURE_ITEM>

 <STRUCTURE_ITEM>

         <ID>745</ID>

         <NAME>Pflanzen|Obstpflanzen</NAME>

         <PARENT_ID>0</PARENT_ID>

         <SORT>0</SORT>

 </STRUCTURE_ITEM>

</STRUCTURE>

For further information, see also:

•Internal categories

•Importing internal categories via CSV

•Master data import via XML - overview

•XML structure overview - TB.Cat 1.2/1.3

•XML structure overview - TB.Cat 1.4

•Examples: XML for TB.Cat 1.2/1.3 or TB.Cat 1.4