Topic overview

This article describes the procedures for importing item characteristic classifications with the Import data application. These procedures contain general instructions, such as the sequence that must be followed for the import. Furthermore, they will inform about the expected preconditions, effects, and restrictions.
A classification represents the superordinate and subordinate relationship between objects. It determines the ranking order in the system and can consist of several levels. Classifications consist of interdependent  nodes. The higher, parent node in each case is called folder. The node underneath the last folder is called leaf.

General

There are two standard types of import:

• exchange of data between existing CEE systems
• import of data from a predecessor system to a newly configured CEE system

This article describes only the import of data from the predecessor systems.

Procedures

Below described are the procedures for importing item characteristic classifications.

select distinct h:guid, h:path from com.cisag.app.general.obj.ItemPropertyHierarchy h

order by h:path

Import data

1. Open the Import data application
2. Select the business entity com.cisag.app.general.obj.ItemPropertyHierarchy in the Filter field using the [Value assistant] button
3. The filter for the data import is displayed.
4. Select the necessary filter attributes. If required, you can still adapt the attributes as described in section Necessary attributes for the import.
5. Select the [Import data] button in the standard toolbar.
6. The Import data dialog window opens.
7. You can enter the settings for the import file in this dialog window. For a detailed description of the fields, see the section of the same name in the article Import data.
8. To start the import, click the [Batch] button.

Sequence for classifications

Permissible:
path description
A …
A-1 …
Not permissible:
path description
A-1 …
A …

select distinct h:guid, h:path from com.cisag.app.general.obj.ItemPropertyHierarchy h

order by h:path

Sequence of the dependent business objects

The following sequence must be followed for the data import without exception:
1. Import all data types (com.cisag.app.general.extension.obj.Datatype) used in item or configuration characteristics.
2. Import the item characteristic definitions  (com.cisag.app.general.extension.obj.EntityExtensionSet)
3. Import the user-defined classifications (com.cisag.app.general.extension.obj.EntityExtensionHierarchy). Only necessary if these are used in the item characteristics.
4. Import the item characteristic classification (com.cisag.app.general.obj.ItemPropertyHierarchy).
5. Following successful import, perform the [Generate table schema] action in the Item characteristic classifications application.

Necessary attributes for the import

Specify at least the following attributes for each business entity:

• Identification attributes – they are used to identify a business object, an attribute is required in order to save a business object
• Required fields

The business entity cannot be assigned without the identification attributes. Furthermore, if a required field is missing, the postprocessing step starts up in each case. The required fields and identification attributes of the item characteristic classifications are presented in the next chapter.

The following chapter Identification fields and required fields describes all identification fields and required fields for  importing metadata of item characteristics and configuration characteristics, together with the assignment to classification nodes. The actual identifiers of the item characteristics (useful data) must be imported following the import of the item characteristic classification. For more information, refer to the article Import item characteristics.

Identification fields and required fields

Item characteristic definitions

Filter in Import data application for business object: com.cisag.app.general.extension.obj.EntityExtensionSet

Item characteristic classifications

Filter in Import data application for business object: com.cisag.app.general.obj.ItemPropertyHierarchy