Excel Import of Dictionary Elements (Version 2.1)

Data type

Description

Example

Integer

whole number (positve and negative)

-10, 20

Real

Rational numbers (positive and negative)
Exponential notation is allowed

10, 10.5, -12,44
2.1E10

String

Sequence of characters (excluding inverted comma)
Can be further constrained by a grammar

AbC

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

M

IN

String

In imports, if no value is specified, the system will try an update of element if exists, else will consider it as new element.

Import actions in case of development releases:

• NEW       Create Dictionary- Element

• EDIT        Change Textual Information of Dictionary- Element

N

Class Discriminator

Z52

M

IN/OUT

Char(1)

Because worksheet "Classes" handles all class types, user needs a means to transmit to the system which Class should be created by import as an Application Class, which as an Classification Class, etc. This means is the "Class Discriminator" by which user can specify the type of class. Possible values:

• A - Classification Class

• C - Application Class

• F - Block Class

• P - Aspect

N

Application Class Type

Z19

C

IN/OUT

String

Specifies type of application class.

Allowed values:

• ADVANCED

• ASSET

• BASIC

• DOCUMENT

• MATERIAL

• PROD_STRUCTURE

N

Hierarchical Position

Z28

C

IN/OUT

String

For classification classes it contains Hierarchical Position. Value and syntax of this field depends on dictionary settings where classification class belongs.

In general hierarchical position may serve also to identify the super class of current class (except dictionaries where hierarchical position is defined as free text in dictionary).

Example of hierarchical position values (17010101, PB101)

N

Identifier

C04

C:

• mandatory in case of edit

• empty in case of new

IN/OUT

String

Contains Identifier of dictionary-element which will be imported. If dictionary-element is already present in the system an update will take place (directly or through change request depending on dictionary change management type)

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Internal ID

Z04

O

IN

String

Contains an identifier valid inside import file. This identifier is used to reference this line in other work sheets (e.g. import a new property without identifier and assign it to a class).

N

Preset SCV

Z66

O

IN

String

Contains a fixed eptos ID for the newly imported structure element. It is used to maintain the same IDs in different systems.

If an element of the same type with this code already exists in the system a validation error will be included in the report.

N

Super Class ID

Z44

O, C

IN/OUT

String

Contains Identifier of an existing class.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

It is used to identify the super class to be imported.

If no value is entered in this column, system automatically sets the root class as super class.

Note: The root class is the uppermost class in the hierarchical structure and it is created/defined at create Dictionary.

Note: If another class is identified as super class (different than the root class), the result is that the system will create a hierarchical (parent class-specialized class) relation between the two classes. The specialized classes inherit the properties from the parent class. On import, this inheritance can be controlled via the GUI Option "Inherit properties from superclass".

N

Super Class Internal ID

Z46

O

IN

String

Contains Identifier of a new Application Class, Block or Aspect described in the same file.

It is used to identify the super class of current Application Class, Block or Aspect.

N

Preferred Name

A01 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Preferred Name 2

Z34

(LC_CC)

O

String

Y

Preferred Name Short

Z35

(LC_CC)

O

String

Y

Short Name

A08 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Definition

A04 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Source of Definition

A05 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Note

A06 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Remark

A07 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the application class.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Synonymous Name

Z48 

(LC_CC)

O

String

Y

Restricted

Z36

O

String

Adds Access Control restriction for visibility. Possible values: ALLOW or DENY.

N

Extended Attribute

{EA CODE}

O

IN/OUT

String

Code of extended attribute for dictionary-element identification. When column is present, "EA Code" is used to identify the extended attribute template. This code must not overlap with one of the existing codes of the other dictionary-element attributes.

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

O

IN

String

In imports, if no value is specified, the system will try an update of element if exists, else will consider it as new element.

Import actions in case of development releases:

• NEW    Create Dictionary- Element

• EDIT    Change Textual Information of Dictionary- Element

N

Identifier

C04

O

IN/OUT

String

Contains Identifier of dictionary-element which will be imported. If dictionary-element is already present in the system an update will take place (directly or through change request depending on dictionary change management type)

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Change Request ID

Z03

O

IN/OUT

Integer

Specifies if an existing Change Request will be updated (only textual attributes or status can be changed).

When a value is specified in this column the other values for identification of structure element are ignored.

N

Internal ID

Z04

O

IN

String

Contains an identifier valid inside import file. This identifier is used to reference this line in other work sheets (e.g. import a new property without identifier and assign it to a class).

N

Extended Attribute

{EA CODE}

O

IN/OUT

String

Code of extended attribute for dictionary-element identification. When column is present, "EA Code" is used to identify the extended attribute template. This code must not overlap with one of the existing codes of the other dictionary-element attributes.

N

Preferred Name

A01 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Short Name

A08 (CL_CC)

C, O

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Definition

A04 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Note

A06 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Remark

A07 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Source of Definition

A05 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the property.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Definition Class ID

A14

C

IN/OUT

String

Contains the identifier of an existing Class which will be set as definition Class for the Property to be imported. This means the Property can be used in this Class. If the Property is existing, the value of this field will be ignored because changing the Definition Class of the Property is out of scope of this import.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Type

A13

O

IN/OUT

String

Specifies type of property.

Allowed values are:

• NON_DEPENDENT_PDET_STRING

• DEPENDENT_PDET_STRING

• CONDITION_DET_STRING

If value is not specified for a new property, "non dependent" is considered by default.

N

Data Type

A15

C

IN/OUT

String

Value is mandatory for new properties. For textual changes of property it will be ignored, modification of property data type is not supported.

Specifies the data type of the property. Allowed values are:

• Axis 1D

• Axis 2D

• Axis 3D

• Boolean (Yes/No)

• Date

• Integer (count)

• Integer (currency)

• Integer (measure)

• Rational

• Rational (count)

• Rational (measure)

• Real (count)

• Real (currency)

• Real (measure)

• Reference

• String

• String (translatable)

• Time

• Timestamp

• URL

N

Digits before comma

Z05

O

IN/OUT

Integer

Specifies number of integer digits for numeric properties

N

Digits after comma

Z06

O

IN/OUT

Integer

Specifies number of fraction digits for numeric properties

N

Number of characters

Z07

O

IN/OUT

Integer

Specifies maximum number of characters for String properties

N

Unit ID

E24

O

IN/OUT

String

For measure properties, contains the identifier of the default unit.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Unit Name

Z08

O

IN/OUT

String

For measure properties, it contains one of the following attributes of the default unit:

• ECE Code

• DIN Notation

• SI Notation

N

Alternate Units ID

Z09

O

IN/OUT

String

For measure properties, contains a list of identifiers for alternate units.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

List of identifiers may be separated by comma or semicolon.

N

Quantity ID

Q01

O

IN/OUT

String

For measure properties, contains the identifier of the quantity.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Class Type

B07

O

IN/OUT

String

Specifies the 3 character IEC code for class type of property (e.g. R91, Q52)

N

Reference Class ID

Z10

O

IN/OUT

String

Contains Identifier of an existing class.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

It is used to identify the referenced block in the case of reference properties.

N

Valency

Z13

O

IN/OUT

String

Specifies valency of property.

Allowed values are:

• UNIVALENT

• MULTIVALENT

N

Value List ID

A17

O

IN/OUT

String

Contains Identifier of an existing value list.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the value list of the property.

N

Value List Internal ID

Z15

O

IN

String

Contains Identifier of a new value list described in the same file.

It is used to identify the value list of the property.

N

Preferred Symbol

B01

O

IN/OUT

String

Contains the Preferred Symbol of the property

N

Substitute Symbol

B02

O

IN/OUT

String

Contains the Substitute Symbol of the property

N

Preset SCV

Z66

O

IN

String

Contains a fixed eptos ID for the newly imported structure element. It is used to maintain the same IDs in different systems.

If an element of the same type with this code already exists in the system a validation error will be included in the report.

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

O

IN/OUT

String

In imports, if no value is specified, the system will try an update of element if exists, else will consider it as new element.

Import actions in case of development releases:

• NEW    Create Dictionary- Element

• EDIT    Change Textual Information of Dictionary- Element

N

Identifier

C04

O

IN/OUT

String

Contains Identifier of dictionary-element which will be imported. If dictionary-element is already present in the system an update will take place (directly or through change request depending on dictionary change management type)

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Internal ID

Z04

O

IN

String

Contains an identifier valid inside import file. This identifier is used to reference this line in other work sheets (e.g. import a new property without identifier and assign it to a class).

N

Extended Attribute

{EA CODE}

O

IN/OUT

String

Code of extended attribute for dictionary-element identification. When column is present, "EA Code" is used to identify the extended attribute template. This code must not overlap with one of the existing codes of the other dictionary-element attributes.

N

Value

A18

O

IN/OUT

<anyType>

Value according to Data Type.

N

Preferred Name

A01 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Short Name

A08 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Definition

A04 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Note

A06 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Remark

A07 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Source of Definition

A05 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Value Specification Type

A16

O

IN/OUT

String

Indicate value specification for value.

Allowed Values:

• CODED (default)

• EXPLICIT

N

Data Type

A15

C

IN/OUT

String

Specifies the data type of the value. Allowed values are:

• BOOLEAN

• INT_COUNT

• INT_MEASURE

• RATIONAL

• RATIONAL_MEASURE

• REAL_COUNT

• REAL_MEASURE

• REFERENCE

• STRING

• URL

Note: Field is mandatory on create but optional on edit.

N

Unit Name

Z39

O

IN/OUT

String

For value(s) with measure datatype, contains the name of the unit.

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

O

IN/OUT

String

In imports, if no value is specified, the system will try an update of element if exists, else will consider it as new element.

Import actions in case of development releases:

• NEW    Create Dictionary- Element

• EDIT    Change Textual Information of Dictionary- Element

N

Identifier

C04

O

IN/OUT

String

Contains Identifier of dictionary-element which will be imported. If dictionary-element is already present in the system an update will take place (directly or through change request depending on dictionary change management type)

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

N

Internal ID

Z04

O

IN

String

Contains an identifier valid inside import file. This identifier is used to reference this line in other work sheets (e.g. import a new property without identifier and assign it to a class).

N

Preferred Name

A01 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Short Name

A08 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Definition

A04 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Note

A06 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Remark

A07 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Value Specification

Z53

O

IN/OUT

String

Indicate value specification for value list.

Allowed Values:

• CODED (default)

• EXPLICIT

N

Source of Definition

A05 (LC_CC)

C

IN/OUT

String

Field may appear multiple times and it specifies the value of textual attribute of the value list.

Each apparition contains language information for text attribute (e.g. en_US, de_DE, zh_CN, zh_TW)

Y

Data Type

A15

O

IN/OUT

String

Specifies the data type of the property. Allowed values are:

• Axis 1D

• Axis 2D

• Axis 3D

• Boolean (Yes/No)

• Date

• Integer (count)

• Integer (currency)

• Integer (measure)

• Rational

• Rational (count)

• Rational (measure)

• Real (count)

• Real (currency)

• Real (measure)

• Reference

• String

• String (translatable)

• Time

• Timestamp

• URL

N

Unit ID

E24

O

IN/OUT

String

For measure properties, contains the identifier of the default unit.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

N

Unit Name

Z08

O, C

IN/OUT

String

For measure properties, contains the name of the default unit.

N

Domain Type

Z55

M

IN/OUT

String

Specifies the type of value list.

Possible values:

• GLOBAL

• LOCAL

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

O

IN/OUT

String

Possible values are:

• ASSIGN    Assign source application class to target classification class.

N

Source ID

Z41

C

IN/OUT

String

Contains Identifier of an existing class.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the source class in relation class - class.

N

Source Internal ID

Z43

C

IN

String

Contains Identifier of a new class described in the same file.

It is used to identify the source class in relation class - class.

N

Target ID

Z49

C

IN/OUT

String

Contains Identifier of an existing class.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the target class in relation class - class.

N

Target Internal ID

Z51

C

IN

String

Contains Identifier of a new class described in the same file.

It is used to identify the target class in relation class - class.

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

M

IN/OUT

String

Possible values are:

• ASSIGN - Assign property to class.

N

Source ID

Z41

C

IN/OUT

String

Contains Identifier of an existing class (application, aspect, block).

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the class in relation class - property.

N

Source Internal ID

Z43

C

IN/OUT

String

Contains Identifier of a new class (application, aspect, block) described in the same file.

It is used to identify the class in relation class - property.

N

Target ID

Z49

C

IN/OUT

String

Contains Identifier of an existing property.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the property in relation class - property.

N

Target CR ID

Z50

C

IN/OUT

String

Contains Identifier of a change request of type new property.

It is used to identify the property in relation class - property.

N

Target Internal ID

Z51

C

IN/OUT

String

Contains Identifier of a new property described in the same file.

It is used to identify the property in relation class - property.

N

Column Name

Column Code

Obligation

IN/OUT

Data type

Description

Translatable

Import Action

Z01

M

IN/OUT

String

Possible values are:

• ASSIGN        Assign value to value list

• UNASSIGN   Unassign value from value list

N

Value List ID

A17

C

IN/OUT

String

Contains Identifier of an existing value list.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the value list in relation value list - value.

N

Value List Internal ID

Z15

C

IN

String

Contains Identifier of a new value list described in the same file.

It is used to identify the value list in relation value list - value.

N

Value ID

Z61

C

IN/OUT

String

Contains Identifier of an existing value.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001) 

It is used to identify the value in relation value list - value.

N

Value Internal ID

Z62

C

IN/OUT

String

Contains Identifier of a new value described in the same file.

It is used to identify the value in relation value list - value.

N

Order Index

Z33

O

IN/OUT

Integer

Contains a number indicating the position of the value within the value list.

N

Parent Value ID

Z57

O

IN/OUT

String

Contains Identifier of an existing value.

The following types of identifiers are allowed:

• IRDI (0175-1#00-AAA123#001)

It is used to identify the parent value in relation value list - value.

It is used for hierarchical presentation of values. The parent is specified at level of association between value and value list. It is not structural parent of value

N

Parent Value Internal ID

Z58

String

Contains Identifier of a new value described in the same file.

It is used to identify the parent value in relation value list - value.

It is used for hierarchical presentation of values. The parent is specified at level of association between value and value list. It is not structural parent of value

Order Index Under Parent

Z60

C

IN/OUT

Integer

Contains a number indicating the position of the value under parent values within the value list.

N