When you create or open an import, it is displayed on a named tab.
The import wizard is used to define the parameters and criteria for the import. The wizard content is organized across Source, Style, Filters, Columns, and Target tabs to guide input. Although the wizard tabs are ordered to gather input in a sequence, you can navigate between any tabs.
To create an import:
From the Data Relationship Management navigation bar, select Import.
On the Source tab, select the import source from the Device list.
If you selected Client File, click Browse and navigate to and select the import file.
If you selected Server File, select the connection and a file name.
Note:
A server file can come from a network file system or FTP directory.
Character Encoding — UTF8, ANSI, ASCII, UTF16BE, UTF16LE.
Strip Quoted Strings — Select to remove quotation marks during data import.
Note:
Single ( ' ) and double quotation marks ( “ ) are removed. If both types of quotation marks are used at the same time, only the outer set of quotations is stripped.
Fixed Width or Delimited — For Delimited, enter the delimiter character. For Fixed Width, enter fixed width column values in Columns Options of the Columns tab.
Select from the following Section Headings options:
Prefix Delimiter — A character that is displayed at the beginning of a section heading.
Suffix Delimiter — A character that is displayed at the end of a section heading. The delimiter suffix is optional.
Select section headings that are in the import source and enter text for the section heading.
Note:
All import sections are selected by default. Deselect sections that are not in the import source.
Select the Style tab and choose Relationship Sorting options:
Sort Relationships — Select to enable the import to sort the nodes based on the order in which they are displayed in the relationship section of the source file, and complete both of the following actions:
Sort Property to Populate — Select the node property in which to store the sort order.
Hierarchy to be Sorted — Select the hierarchies to which to apply the sort.
Note:
All hierarchies are sorted by default unless specified here.
Determine Leaf Nodes at the End of Import Process — Select to specify that, at the end of the import process, the import automatically sets the leaf property to True for any node that has no children.
Note:
This option requires a second pass of the imported data and may require additional time to process. If this option is not selected, all nodes will be imported as limb nodes unless the Leaf property is specified as a column in the Node or Relationship section of the imported data.
Enforce Invalid Node Name Characters — Select to validate node name based on the InvName system preference.
Select Duplicate Handling options:
Append Unique Text to the End of the Node Name — Select to append the unique portion of the name to the end of the original node name.
Note:
If you select this option, use the Unique String, Delimiter, Unique ID Seed, and Zero Pad Length parameters to create a naming convention for duplicate nodes. The unique portion of the name is added to the end of the original node name. If not selected, the unique portion of the name is prefixed to the beginning. For example, 001NodeA, 002NodeA.
Unique String — Enter a string to be used to form part of the new unique node name.
Delimiter — Enter a delimiter character to be used to separate the original node name from the unique portion of the name.
Unique ID Seed — Select a starting point for this ID.
For example, if NodeA occurs three times in a hierarchy and the unique ID seed is 1, the original node is not changed, and the other node names are replaced with NodeA1 and NodeA2. This example ignores the other Duplicate settings in order to illustrate the use of unique ID seed.
Zero-Pad Length — Enter the minimum number of digits required in the unique ID portion of the duplicate name.
For example, a value of 3 for zero-pad length creates duplicate nodes named NodeA001, NodeA002, and so on. A value of 2 creates duplicate nodes named NodeA01, NodeA02, and so on.
Associated Property — Select a property to enable duplicate nodes to be grouped so they can be easily queried after the import is complete.
If an associated property is set, the property is populated with the node name of the original node in all duplicate nodes. This option must refer to a global, associated node property.
Duplicate Error Mode — Select a mode to determine the severity with which the import processor treats a duplicate:
Generate Warning — Warning message is added to the log for each duplicate.
Generate Error — Error message is added to the log for each duplicate.
Note:
Processing stops if the number of errors exceeds the Max Errors value (on Target tab).
On the Columns tab, from the Section list, select a file section.
From the Available list on the Select Columns tab, select the columns for the import.
Note:
Use the Category list to select a property category to ease navigation.
A special column called [Ignore Column] is available as a placeholder for any column in the input source that should not be processed during the import.
Tip:
Use the arrows to position the column in the Selected list. The first item in the list is the first column, the second item in the list is the second column, and so on.
On the Column Options tab, you can map a column to hierarchies. Double-click a column name row and select from these options:
Select Apply Value to All Hiers if values in the column should be applied to all hierarchies. By default, this option is selected.
In the Hierarchy Listing field, enter the name of each hierarchy to which the column applies. The property value is set only in the hierarchies designated in the list.
Note:
The listed hierarchies must match the names of hierarchies specified in the import source.
If you selected Fixed Width on the Source tab, enter a value in the Fixed Width column.
On the Filter tab, make selections to skip blank and use defaults for certain property types.
Note:
It is recommended to skip blank and use default values to minimize the size of the imported version.
On the Target tab, enter a name and, optionally, a description for the new version that will be created by the import.
Select a value for the maximum number of errors that can occur during processing before the import stops.
Do either or both of the following:
Click
to save the import.You are prompted to define a name, description, and object access for the import:
User – Personal objects that are only available to an individual user to view and run.
Standard – Public objects that are available to all users to view and run. Only Data Manager users can create and modify standard imports.
System – Restricted objects that are only available to Application Administrator role users to view and run.
Click
to run the import.
.