Chat now with support
Chat with Support

Identity Manager 9.2 - Operational Guide

About this guide Simulating data changes in the Manager Scheduling operations activation times Re-applying templates Exporting data with the Manager Analyzing data and data changes Analyzing process monitoring in the Manager Schedules in One Identity Manager Mail templates in One Identity Manager Password policies in One Identity Manager Working with change labels Checking data consistency Compiling a One Identity Manager database Transporting custom changes Importing data with the Data Import Importing and exporting individual files for the software update Creating a One Identity Manager database for test or development from a database backup Initializing DBQueue Processor the after extending the server hardware Command line programs

Structure of the CSV file

On the File structure page in the Data Import, specify how the file is structured.

Table 42: File structure

Property

Description

Number of lines in header

Enter the number of head lines in the .csv file. The header is not imported.

Columns identified by

Indicator for column limits.

  • Select the Delimiter option if the data is separated by a semi-colon, comma, space, tab, pipe, or other character. Specify the line structure.

  • Select the Fixed width option if all the data in the columns has the same length. Specify the line structure.

Detailed information about this topic

Specifying the line structure for data with delimiters

In Data Import on the Defining the line structure page, describe how the line structure is configured. If you have selected the Columns identified by delimiters option for the file structure, specify the following settings.

NOTE: The Line break preview pane displays the line structure according to the selected settings.

Table 43: Line structure

Property

Description

Delimiter

Delimiter used to separate the data in the file. You have the following options: Semicolon, Comma, Space, Tab, and Pipe.

If the data is separated by a different character, select Other: and enter the delimiter in the input field next to the menu.

Text qualifier

Character enclosing the column text. This text is treated as one value on import, even is the text contains the delimiter given as above.

NOTE: The delimiters are masked by doubling them up.

Example:

Delimiter: Comma (,)
Text qualifier: Quotation mark (")
Value in file: "User,BS"
Value after import: User,BS
   
Delimiter: Comma (,)
Text qualifier: Not given or other character:
Value in file: "User,BS"
1st value after import: "User
2nd value after import: BS"

Mask delimiter by doubling

Specifies whether the data is separated by several of the same delimiters. Data that contains a new line must be marked with a text qualifier.

Example:

Delimiter: Comma (,)
Mask delimiter by doubling: Enabled
Value in file: User,,BS
Value after import User,BS
   
Delimiter: Comma (,)
Mask delimiter by doubling: Not set
Value in file: User,,BS
1st value after import: User
2nd value after import:  
3rd value after import: BS

Multiple values in / delimited by

Specifies whether the import contains a multivalued property column (MVP) and the column should not be imported directly. Individual values are entries in another table and should be linked through a many-to-many table.

  • Using the menu, specify Multiple values in the column in question.

  • In Delimited by: enter the values' delimiter.

The column values are split up. A new line is generated for each value although the rest of the columns remain the same.

Example:

The line

Chris;User2;Org1|Org2|Org3

is converted by suitable settings to the import source

Chris;User2;Org1

Chris;User2;Org2

Chris;User2;Org3

Related topics

Specifying the line structure for data with a fixed width

In Data Import on the Defining the line structure page, describe how the line structure is configured. If you have selected the Columns identified by fixed width option for the file structure, specify the width of the columns.

  • Click on the ruler in the Data Import preview to set a separation point. A separation mark is inserted.

  • When you click again on a fixed separation point, the separation mark is deleted.

Related topics

Defining a condition for the import

To exclude individual data records from the import, you can specify a condition for the lines to be imported on the Line condition page in the Data Import.

Format the condition in VB.Net syntax. The columns are accessed with dollar notation. For more information about scripts in One Identity Manager, see the One Identity Manager Configuration Guide.

You can access the columns using the column index (0...n).

Example:

Do not import the data record if the first column contains the OLD value.

Value = $0$<>"OLD"

If a header is defined, you can use the column identifier for access.

Example:

Import the data record if the column with the name NewData contains the True value.

Value = $NewData:Bool$

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating