Sign in

Template File Assumptions

1 min read

To ensure successful and accurate export of a Technical Data Package (TDP), the Excel files attached to the TDP template must adhere to specific formatting and structural guidelines.

  1. The name of the first worksheet must exactly match the name of the context ItemType. The property columns names should be exactly same as ItemType property names.

  2. The final worksheet in the Excel file must include fully qualified paths to the file locations required for the Technical Data Package (TDP). These file paths can originate from ItemType properties, Relationship properties, or File relationships. If the file location is defined through a File relationship, the “Property” column in the worksheet may be left blank. An example of how to describe file location is shown below.

  3. Intermediate worksheets can be added as needed to export data related to relationships and associated items. Each of these worksheets must be named exactly after the corresponding Relationship name to ensure proper mapping. Additionally, the column headers within each intermediate sheet must match the property names defined in the Relationship.

  4. In each worksheet, the columns should display the property labels, while the corresponding property names must be included as comments within the header cells.

  5. If the property type is item then add itemtype name in comment.

  6. The RelatedItem properties can be exported by adding the prefix “related.” to the property name.