/
CSV Directory

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:

  1. Download the connector server jar file and store it in the connector server directory (any directory).

  2. Download the CSV directory connector jar file and store it in the bundles subdirectory.

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

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.