Replicator for Text CSV Files

Please follow the general instructions for setting up a replicator on the Replicator Wizard page.

Text or CSV (Comma-separated Values) files contain one record per line. The fields of a record are separated by a separator (such as a comma). A field can be enclosed in quotation marks. The first line usually contains the names of the fields. Supported character sets are ASCII, UTF-8 and Unicode (UTF16-LE). The character set is determined by the BOM (Byte Order Marker) of the file.

Procedure for Adding a Replicator

1. Select the type of data source
   Select the "Text/CSV File" database type.
2. Define the credentials under which the data source can be accessed
3. Settings for the data source (Choose the file that will be imported, etc.)
   File
   
   • Enter the path to the file
     Specify which text or CSV file to use.
   • Encoding
     Specify which encoding to use. Selecting Auto automatically attempts to determine the encoding based on the BOM (Byte Order Mark).
   • File format:
     Enter which field separator is used in the file.
   • First line contains field names
     This option should be on, if the first line in the file contains the names of the fields.
4. Field mapping, which source fields are copied to which LDAP fields
5. Configure links to contact URL
6. Datasource location settings
7. Schedule replication plan
8. Defining additional applications to be started
9. Assigning a name for the new replicator