CSV Directory
Overview
The CSV Directory Connector supports provisioning to and from a directory of files in CSV format.
Its typical usage should be bulk-loading.
Installation
Follow these steps to run the stand-alone connector server:
Download the connector server jar file and store it in the connector server directory (any directory).
Download the CSV directory connector jar file and store it in the bundles subdirectory.
Start the connector server. For more information, see the page about this.
Supported operations
Create
Delete
Update
Search
Schema
Sync
Configuration
Configuration Properties
The following table describes all of the properties that you can specify for the configuration:
Configuration Property | Type | Required | Default Value | Description |
---|---|---|---|---|
Source Path | String | X |
| Absolute path of a directory where the CSV files to be processed are located |
File Mask | String | X |
| Regular expression describing files to be processed (e.g. ->.\.csv<- to include all csv files) |
File Encoding | String |
| Charset.defaultCharset() | Basic encoding of the file. |
Field Delimiter | String |
| , | Delimiter used to separate fields in CSV files |
Text qualifier | String |
| " | Delimiter to determine beginning and end of text in value |
Key column name | String | X |
| Name of the column used to identify user uniquely |
Password column name | String |
|
| Name of the column used to specify user password |
Delete column name | String |
|
| Name of the column used to specify users to be deleted |
Value quotation required | Boolean |
| true | Specify if value quotation is required |
Column names | String | X |
| Column names separated by comma |
Ignore header | Boolean |
| true | Specify it first line file must be ignored |
Key separator | String |
| , | Character used to separate keys in a multi-key scenario |
Status Column | String |
|
| Name of the status column where the account's status (enabled/disabled/...) are stored. |
Disabled Status Value | String |
| false | Value of 'status column' indicating disabled users. |
Enabled Status Value | String |
| true | Value of 'status column' indicating enabled users. |
Default Status Value | String |
| true | Default value for 'status column' in case of value not provided. |