Knowledgebase
Importing directly from a CSV data file
Category:ODBC
Last Updated:2011-08-18
Download PDF version
CSV Data File Requirements:
- The CSV data file must be located in the connection directory and be named import.txt (i.e. c:\UnitySync\connections\YourConnectionName\import.txt).
- Your CSV data file must include an unique ID for each record.
- Your Source CSV data file must include a column containing an smtp email address for each record. (In the absence of another unique ID field, the email address field may be used as the unique ID.)
Process to set up connection using a CSV data file Source
- Click Connection > New and provide a connection name.
- Set the Source Map Template and Sync Engine to "CSV"
- Set the Destination Map Template and Sync Engine as appropriate for your destination directory.
- Copy your CSV data file to the connection directory as ’import.txt’
(i.e. c:\UnitySync\connections\YourConnectionName\import.txt)
- Go to the Source tab and verify the Sample Data appears correctly. All columns should be displayed and four rows of data. If the sample data does not appear correct, modify the CSV parsing parameters appropriately.
- Identify each column specified by the Field Definition parameters (note, if a source column name has a space in it, you will see it is replaced with an underscore in the Sample Data. You must use an underscore in place of a space when specifying the Field Definition parameters.
- Go to the Destination tab and identify the destination server as usual.
- Complete other tabs as usual.
- Create a Custom Map file to define appropriate mapping from your CSV columns to destination attributes. Note: Use underscores in place of spaces when identifying source columns in the map file.
Please refer to the product help file (Configuring a Connection> Source Tab> CSV Data File) for more information on creating a connection using a source CSV data file and customizing attribute mapping.