Page tree
Skip to end of metadata
Go to start of metadata

Status

Provisioning and synchronization works well.

Description

The connector can be used for any separated value file (e.g. CSV). The following steps describe setup for comma-separated value file.

Synchronization checks the last modification timestamp of CSV file.

Resource Configuration

Example File Definition

The CSV file with a header line needs to be created. The following example is available in samples/resources/csvfile/midpoint-flatfile.csv.

SQL Simple Table Definition

"id","firstname","lastname","disabled","password"

Sample resource can be imported from samples/resources/csvfile directory.

Recommended Connector

Framework: ICF
Bundle: org.forgerock.openicf.connectors.file.csvfile
Version: 1.1.0.0-SNAPSHOT
Connector: org.forgerock.openicf.csvfile.CSVFileConnector

Connector Configuration

See CSVFile Connector documentation. (currently, no published documentation).

Connector Configuration Example

        <connectorConfiguration>

            <!-- Configuration specific for the CSVfile connector -->
                <icfc:configurationProperties
                xmlns:icfccsvfile="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/bundle/org.forgerock.openicf.connectors.csvfile-connector/org.forgerock.openicf.csvfile.CSVFileConnector">

                                <icfccsvfile:filePath>/var/tmp/midpoint-flatfile.csv</icfccsvfile:filePath>
                                <icfccsvfile:encoding>utf-8</icfccsvfile:encoding>
                                <icfccsvfile:valueQualifier>"</icfccsvfile:valueQualifier>
                                <icfccsvfile:fieldDelimiter>,</icfccsvfile:fieldDelimiter>
                                <icfccsvfile:multivalueDelimiter>;</icfccsvfile:multivalueDelimiter>
                                <icfccsvfile:usingMultivalue>false</icfccsvfile:usingMultivalue>
                                <icfccsvfile:uniqueAttribute>id</icfccsvfile:uniqueAttribute>
        <!--                    <icfccsvfile:nameAttribute>id</icfccsvfile:nameAttribute> -->
                                <icfccsvfile:passwordAttribute>password</icfccsvfile:passwordAttribute>
                        </icfc:configurationProperties>
                        <!-- Generic ICF configuration -->
        </connectorConfiguration>

Resource Sample

See resource sample.

  • No labels