Specify how the file is structured. Enter the following data:
Enter the number of lines in the CSV file header. The header is not imported.
If you selected the option Columns identified by delimiter then you need to specify the following settings in this step:
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.
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" |
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 |
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
If you have selected the option Columns identified by fixed width, define the width of the columns in this step.
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.
Example:
Do not import a data record if the first column contain the values "OLD".
Value = $0$<>"OLD"
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$
© 2023 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy