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. |