In this article
In addition to node label and node id, when running a “hierarchy only” import you can upload additional information about the hierarchy nodes by adding additional columns to the hierarchy file. Place these after the level columns (for a full path import) or parent id (for a parent/child import). Note that it is not possible to add additional columns for node attributes if the file includes contacts data.
These node attributes can be retrieved through scripting in surveys, data processing rules, and reporting. The attributes provide capabilities for, for example, presenting additional data points related to a hierarchy.
Note: Node attributes are imported alphabetically. If the attributes must be in a specific order, then they must be named or numbered such that they fall in the desired order when displayed in the Edit Node window.
The system will automatically add additional variables for each of the additional columns included in the upload file, and will upload the data from the file. Data will be treated as open text. The maximum number of additional columns that can be uploaded is 100. When viewing/editing details of a node in the hierarchy, these fields will be available to the user alongside node id and node label (go to About Editing Nodes for more information).
Note: Once created, node attributes are permanent and cannot be renamed or deleted from within Hierarchy Management. If you need to delete node attributes then you must contact Forsta Support at support@confirmit.com and ask them to delete the attributes directly in the database.