Table of Contents | ||||
---|---|---|---|---|
|
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. |