Importing Logical Data from an Excel File
HOPEX Data Governance and HOPEX Information Architecture provide an Excel file template so that you can import a set of existing logical information into the HOPEX repository. You can also use this template to export data from the repository.
Downloading the Excel File Template
To download the Excel template associated with the logical data:
1. On the HOPEX Information Architecture desktop, click Main menu > Export > Excel.
2. In the wizard that appears, check the option "From a template".
3. Click Next.
4. In the Predefined Template File field, select "Data Excel Template".
5. Click twice on Next and save the created file. It contains the structure provided by the model.
Content of the Excel Template
The template contains the following sheets:
Data Dictionary sheet
The Data Dictionary sheet allows you to import a set of data dictionaries with their name and owner.
Data Dictionary Short Name
Name of the data dictionary. This property is mandatory.
Data Dictionary ID
The ID is used to identify the business dictionary, in the event that several dictionaries have the same name. This property is optional.
Data Dictionary Owner Name
Name of the holding data dictionary. This property is optional.
Data Dictionary Owner ID
The ID is used to identify the holding business dictionary, in the event that several have the same name. This property is optional.
Comment
Comment of the data dictionary. This property is optional.
Data Type sheet
The Data Type sheet defines the data types to be imported.
Data Type Short Name
Name of the data dictionary. This property is mandatory.
Data Type ID
The ID is used to identify the data type, in the event that several have the same name. This property is optional.
Data Type Package Name
Name of the package that holds the data type. This property is optional.
In the case of a hierarchy in detention, the syntax of the name is as follows: <Name of the holding package 1>::<Name of the holding package 2>
Example:
Standard::Types::Data Types Reference
Data Type Package ID
The ID is used to identify the data type package, in the event that several have the same name.
Length
Decimal
Data Type Type
You can associate a standard type with the type of data to be imported, for example "P-Character".
Comment
Comment of the data type.
Data Type Component sheet
The Data Type Component sheet defines the attributes of the data types defined in the Data Type sheet.
Attribute Short Name
Name of the data type attribute. This property is mandatory.
Example: “Number”.
Owner Data Type Name
Name of the holding data type. This property is mandatory if the ID of the holding data type is not specified.
Example: "Address".
Owner Data Type ID
ID of the holding data type. This property is mandatory if the ID of the data type is not specified.
Data Type Name
Name of the attribute data type.
Example: “Number”.
Data Type ID
ID of the attribute data type.
Length
Length of the attribute data type.
Decimal
Comment
Comment of the data type attribute.
Class sheet
The Class sheet enables to define classes to be imported. Enter the name of the class. Enter the class ID when different classes have the same name.
Class Short Name
Name of the class. This property is mandatory.
Class ID
The ID is used to identify the class, in the event that several have the same name. This property is optional.
Data Dictionary Name
Name of the data dictionary that holds the class. This property is optional.
Data Category
You can give the class a classification, e.g. "sensitive data", "reference data", and so on.
Comment
Attribute sheet
The Attribute sheet defines the attributes of the classes defined in the Class sheet.
Leave the first column blank if you want to create new occurrences, or fill it in with the Absolute Hopex ID if you want to update existing data.
Short Name
Class Name
Name of the holding class. The name or the ID of the class is mandatory.
Class ID
ID of the holding class. The name or the ID of the class is mandatory.
Length
Decimal
Comment
Comment of the attribute.
Relationship sheet
Part Name
Owner Class Name
Name of the holding class. The name or the ID of the class is mandatory.
Owner Class ID
ID of the holding class. The name or the ID of the class is mandatory.
Referenced Class Name
Name of the referenced class. The name or the ID of the referenced class is mandatory.
Referenced Class ID
ID of the referenced class. The name or the ID of the class is mandatory.
Multiplicity
Multiplicity of the part.
Generalization sheet
Generalization Name
Super Class Name
Name of the general class. The name or the ID of the class is mandatory.
Super Class ID
ID of the general class. The name or the ID of the class is mandatory.
Sub Class Name
Name of the sub- class. The name or the ID of the class is mandatory.
Sub Class ID
ID of the sub- class. The name or the ID of the class is mandatory.