The Excel Import/Export Wizards
Export Wizard
The export tool produces an Excel file in which the user can work. This file can subsequently be reimported in HOPEX.
The Excel file comprises worksheets in which you can define:
• A list of objects (occurrences) of a given type.
By default, the Excel worksheet carries the name of the selected type (MetaClass), but you can change this name.• A list of objects connected by a link to occurrences of a given type.
Only those links (MetaAssociations) between two concrete MetaClasses are accepted.By default, the Excel worksheet carries the name of the MetaAssociationEnd, but you can change this name.Import Wizard
Data contained in the import file should be clearly structured so as to be correctly interpreted in HOPEX. This being so, it is recommended that a previously exported file be used as a model.
Import and export formats are compatible, but certain exportable data cannot be imported (such as calculated attributes in HOPEX, which cannot be modified by the user).
The file imported in HOPEX allows you to:
• create or modify a list of objects.
• connect objects by a given link.
The results file indicates anomalies encountered.
Creating or modifying a list of objects.
If the identifiers of MetaClasses and MetaAttributes are not supplied in the import file, the wizard executes a query by their name in the HOPEX repository.
If the identifiers of objects (occurrences) are not indicated, objects are created.
It is possible to assign an external value to attributes (tabulated value attributes).
Connecting occurrences by a given link.
If the identifiers of MetaClasses and MetaAttributes are not indicated, they are queried by name in the repository and entered in the file.
If the identifiers of objects are not indicated, the objects are queried by name in the repository; the link is only made if the objects exist and are unique.