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 Connector Servers.
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 | Description |
---|---|---|---|
Source Path | String | X | Absolute path of a directory where are located CSV files to be processed |
File Mask | String | X | Regular expression describing files to be processed (e.g. ->.\.csv<- to include all csv files) |
File Encoding | String | Basic encoding of the file. | |
Field Delimiter | String | X | Delimiter used to separate fields in CSV files |
Text qualifier | String | Delimiter to determine begin and end of text in value | |
Key column name | String | 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 | Specify if value quotation is required | |
Column names | String | Name of the all columns | |
Ignore header | Boolean | Specify it first line file must be ignored | |
Key separator | String | X | Character used to separate keys in a multi-key scenario |
Status Column | String | Optional name of the status column where the account's status (enabled/disabled/...) are stored. | |
Disabled Status Value | String | Optional value of 'status column' indicating disabled users. | |
Enabled Status Value | String | Optional value of 'status column' indicating enabled users. | |
Default Status Value | String | Optional default value for 'status column' in case of value not provided. |