Chat now with support
Chat with Support

Identity Manager 8.0 - Configuration Guide

One Identity Manager Software Architecture Working with the Designer Customizing the One Identity Manager Default Configuration Checking Data Consistency Compiling a One Identity Manager Database Working with Change Labels Basic System Configuration Data
One Identity Manager Authentication Module Database Connection Data Configuration Parameters for System Configuration Setting up the Mail Notification System Enabling More Languages for Displaying and Maintaining Data Displaying Country Information Setting Up and Configuring Schedules Password Policies in One Identity Manager Reloading Changes Dynamically TimeTrace Databases Machine Roles and Server Functions Files for Software Update Operating Systems in Use System Configuration Reports Using Predefined Database Queries Managing Custom Database Objects within a Database
The One Identity Manager Data Model Granting One Identity Manager Schema Permissions Working with the User Interface
Object definitions for the User Interface User Interface Navigation Forms for the User Interface Statistics in the One Identity Manager Extending the Launchpad Task Definitions for the User Interface Applications for Configuring the User Interface Icons and Images for Configuring the User Interface Language Dependent Data Representation
Process Orchestration in One Identity Manager
Declaring the Job Server One Identity Manager Service Configuration Handling Processes in the One Identity Manager
Tracking Changes with Process Monitoring Conditional Compilation using Preprocessor Conditions One Identity Manager Scripts Maintaining Mail Templates Reports in the One Identity Manager Custom schema extensions Transporting One Identity Manager Schema Customizations Importing Data Web Service Integration SOAP Web Service One Identity Manager as SPML Provisioning Service Provider Searching for Errors in the One Identity Manager Processing DBQueue Tasks One Identity Manager Configuration Files

Specifying the File Structure

Specify how the file is structured. Enter the following data:

  • Number of lines in header

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

  • Columns identified by
    • Select the option Delimiter if the data is separated by a semi-colon, comma, space, tab, pipe or other character. Specify the line structure.
    • Select the option Fixed width if all the data in the columns has the same length. Specify the line structure.
Detailed information about this topic

Specifying Line Format for Data with Delimiters

If you selected the option Columns identified by delimiter then you need to specify the following settings in this step:

  • Delimiter

    Delimiter used to separate the data in the file. You can choose between "semi-colon", "comma", "space", "tab" and "pipe".

    If the data is separated by another character select "other" and enter the delimiter in the field next to the list.

  • 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: "Smith,Bill"
    Value after import: Smith,Bill
       
    Delimiter: Comma (,)
    Text qualifier: Not given or other character:
    Value in file: "Smith,Bill"
    1st value after import: "Smith
    2nd value after import: Bill"
  • 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: Smith,,Bill
    Value after import Smith,Bill
       
    Delimiter: Comma (,)
    Mask delimiter by doubling: Not set
    Value in file: Smith,,Bill
    1st value after import: Smith
    2nd value after import:  
    3rd value after import: Bill
  • 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.

    Enter the affected column using the menu. 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

    Hans;Müller;Org1|Org2|Org3

    becomes the import source

    Hans;Müller;Org1
    Hans;Müller;Org2
    Hans;Müller;Org3
Related Topics

Specifying Line Format for Data with Fixed Width

If you have selected the option Columns identified by fixed width, define the width of the columns in this step.

  • Click on the ruler in the Data Import preview to set the separation points. A separation mark is inserted.
  • When you click again on a fixed separation point, the separation mark is deleted.
Related Topics

Specifying a Line Condition

To exclude specific data records from being imported, you can enter a condition. Format the condition in VB.Net syntax. The columns are accessed with dollar notation.

Access using Column Indexing (0...n)

Example:

Do not import a data record if the first column contain the values "OLD".

Value = $0$<>"OLD"

Access using Column Identifier

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

Example:

Import a data record if the column with the identifier "NewData" contains the value "True".

Value = $NewData:Bool$

Related Topics
Related Documents