[an error occurred while processing this directive]
Replicator for Text/CSV files
Please note the basic instructions for setting up a replicator on the page Replicator Wizard.
|
Text or CSV (comma-separated values) files contain one data record per line. The fields of a data record are separated by a separator (e.g., a comma). A field can be enclosed by 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 means of the BOM (byte order marker) of the file.
|
Procedure for creating a replicator
- Select data source type
Select the "Text/CSV File" database type.
- Define the login information with which it is possible to access the data source.
- Settings for the data source (selection of the file to be imported, etc.)
File
- Specify path for file
Specify which text or CSV file should be used.
- Coding
Specify which coding should be used. Select "Auto" to have the program automatically determine the coding by means of the BOM (Byte Order Mark).
- File format
Specify which separator is used in a line in the file.
- First line contains field names
Activate this option if the first line in the file contains the names of the fields.
- Field allocation, which source fields are being copied to which LDAP fields
- Defining replication schedule