Microsoft Excel

enaio® import-export • 11.0 »

Data in the Microsoft Excel format can be exported in a linear or hierarchical object model.

Excel – Linear Object Model

The exported file receives the extension 'xsl'. The file contains a table named 'data'.  If you export the data associated with multiple object types, multiple files are created. A counter is appended to the name.

The first row contains the column names. They are formed according to the following schema:

  • Every field name is prepended with the name of the object type.

    Non-alphanumeric characters in the name are replaced with '_'.

  • Basic parameter fields are labeled with '_sys_' and other fields with '_usr_'.

If you export documents, the '@Image file name' column will also be created. It contains the path and file name of the exported Document Files.

Example:

Film_usr_WorkingTitle

Film_sys_created

Casting_usr_Role

Agreement_Tiff_usr_Type

@Image file name

The column names for the linear formats 'TEXT/ASCII', 'Microsoft Access', and 'Microsoft Excel' are formed in a similar manner.

Excel – Hierarchical Object Model

The exported file receives the extension 'xsl'. Exactly as in the 'Access' format, the file contains multiple tables:

  • Objects

    The table contains a list of all exported objects. The data include the ID, name of object type, object type number, ID of the parent object, name of the exported document file.

  • Fields

    The table contains a list of all exported fields. The data include the object ID, field name, internal field name, database type, database size, and index data value.

  • MultiFields

    The table contains a list of all multi-fields. The data comprise multi-field ID, object ID, name of the multi-field, and internal name of the multi-field.

  • MultiFieldValues

    The table contains a list of the values of the multi-fields. The data comprise multi-field ID, page number, database type, database length, and index data value.

  • TableFields

    The table contains a list of all table fields. The data comprise table field ID, object ID, table field name, and the internal name of the table field.

  • TableFieldValues

    The table contains a list of the values of the table cells. The data comprise table field ID, row number, column name, database type, database length, and index data value.

If you set up fixed fields, these fields are allocated to every exported object.