An import consists of up to five sections. Each import section corresponds to a set of source data of a specific granularity. All records for an import section are expected to be the same number of columns. Import sections in source files are identified with a unique section header composed of a prefix, label, and suffix. An import file can consist of multiple sections of the same type but all sections of the same type must have the same number of columns. For database sources, each import section is mapped to a single database table.
Table 13. Import Sections
Import Section | Description |
|---|
Version | Property values of the new version This import section is only required to allow for the name or description of the new version created by the import to be different for each run or to load version property values. Required column: Version Name |
Hierarchy | Hierarchies to be created by the import process, their top nodes, and property values for each hierarchy This section is required to relate nodes to each other using hierarchy relationships. Required columns: Hierarchy Name, Top Node |
Node | Nodes to be created by the import process and global node property values for each node Nodes that are not related to hierarchies will be imported into the new version as orphans. Required column: Node Name |
Relationship | Parent-child relationships between nodes in hierarchies and global or local node property values for the child node This section is required to relate nodes using hierarchy relationships. Nodes that are directly or indirectly related to a top node of a hierarchy being imported will be inserted into the hierarchy unless the insert would result in duplicate instances of the node. Required columns: Parent Node Name, Node Name |
Hierarchy Node | Local node property values specific to a specified hierarchy The Hierarchy import section is required when this section is being used. Required columns: Hierarchy Name, Node Name |
Import File Example
[version]
My Version
[hier]Balance Sheet,BALSHEET
[node]
1000,Assets
2000,Liabilities
3000,Equity
[relation]
BALSHEET,1000
BALSHEET,2000
BALSHEET,3000