- 3 Minutes to read
- Print
- DarkLight
Add New Data (window)
- 3 Minutes to read
- Print
- DarkLight
Navigation Path
In the Main Navigation, click Administration > Attributes.
Click Related Data.
In the Actions column, click > Add New Data.
Add New Data window
In the Add New Data window, it is possible to import data into the Related Data Set. Before data can be imported from a CSV file, a structure must be created for the related data set. With an XML file, both the structure (i.e. the columns of the table) and the data can be added during import. For more information, see Structure of XML and CSV files (see Structure of XML and CSV Files (Related Data)).
Information | Description |
---|---|
File | This input field identifies the local path where the file is stored. |
File Type | These options identify the import file format:
|
Separator Character | This input field defines which character is used to separate entries in the CSV file. This character separates the data fields (columns) in the data records. Normally, a comma is used. However, depending on the software and user settings, other characters such as a semicolon, colon or tab can be used. |
Import Mode | This drop-down list defines how records are imported from the source file. The following options are available:
|
Synchronization Mode | These options define how the import mode functions when one of the two update options are selected. The following options are available:
|
Error Mode | This drop-down list defines how errors in the import file are handled.
|
Encoding | This drop-down list identifies the character encoding of the source file. The character encoding ensures that the imported text is displayed correctly. The symbol opens a pop-up window. In the window, it is possible to search all encoding options in the system. |
Cancel | This button closes the Add New Data window without importing any data. |
Import | This button starts the import of the selected file and opens the Related Data Overview window. A status message displays information about the import. When the import is finished, a confirmation email is sent. |
Hint:
The update modes Update and Update and Add replace all existing records in the related data set with records in the import file that contain matching key column values. In non-unique data sets, this means that the data set can actually contain fewer records for a specific key value after import.
For example, a data set called Purchase has five purchase records for a key-value Customer_ID. The import file only contains three records for the same key value. The update modes Update and Update and Add delete the original five records and leave only the three new records from the import file in the data set.