Accéder au contenu principal
Version: 17.7

Structure of the Excel File

An Excel file for importing repository objects is structured as follows:

Example of an Excel File with Objects and Their Attributes

  • The Excel file can contain any number of sheets

  • Each sheet contains only objects of one type (1)

  • Each row in the sheet contains one object (2)

  • Each column holds an object attribute or a relation to another object (3)

  • A unique identifier (name, ID etc.) is needed for each object

  • The following attribute types can be imported: simple, date, enum, treeenumlist, enum_list, bool, relation and file_pointer

If you are using the ArchiMate Application Library, one or more sample configurations will already be provided for you in the ADOIT Administration. For each sample configuration, a suitable Excel template file is included. The template is available for download in the Excel import dialog in the ADOIT.