1. Products
  2. MetaDirectory 6
  3. MetaDirectory
  4. Connecting to Data Sources
  5. Text File (CSV)
Back Next  PDF Download PDF

Configuring a CSV replicator for integrating a text file

This sample application shows how to use a text file with contacts in CSV (Comma Separated Values) format as a data source for estos MetaDirectory. The sample file can be found in the estos MetaDirectory installation directory in the Samples folder.

Setting up estos MetaDirectory for using a CSV File

  • Start estos MetaDirectory administration on the computer where the server is installed.
  • Authenticate yourself on the server with the user data that you specified during installation.
  • Go to the Configuration / General / Replicators view.
  • Use the context menu or Add... to start the Replicator Wizard to configure a data source.
  • Select the data type "Text/CSV File" and confirm the selection with Next.
  • In the user login, you specify how to access the data source. You can access the data source both from the context of the current user and from the system account. In this example, we will use a SYSTEM account. For more information on this topic, see Replicator Wizard.
    Confirm the selection using the Next button.
  • In the following step, the access to the file is configured.
    • Select the CSV file from the Samples folder in the estos MetaDirectory installation directory using the Browse button.
    • Select the "Windows® Text (semicolon separator)" file format. This indicates that the fields in each line of the file are separated by semicolons.
    • Set the option "First row contains field names".
    • Confirm the selection using the Next button.
  • The following field mapping wizard defines which fields of the data source are copied to which target fields. Next to the sample text file you will find a saved field mapping. Load the field mapping Demo-Namensliste-csv.fxm via the button at the bottom left of the field mapping dialog. Confirm the settings with Next.
  • Leave the settings in the country and regionlocation settings unchanged and confirm the dialog with Next.
  • In the replication schedule, you can define the intervals and times for replicating the database.
    Make changes - if desired. Then leave the settings page with Next.
  • Enter a replicator name. This name must be unique and cannot be changed afterwards.
    Configuration of the replicator will be concluded using the Done button.
Once the replication process has been concluded, you can let the replicator run from the replicators list from the context menu or by using the Start button.
You can view replication results in Database Search or Database View.

Version 6