Identity Manager 8.0 - Configuration Guide

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
• Specifying Line Format for Data with Fixed Width

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 the File Structure
• Specifying Line Format for Data with Fixed Width

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 the File Structure
• Specifying Line Format for Data with Delimiters

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

• Using Dollar ($) Notation