Knowledgebase

Making changes to an existing CSV import ODBC Data Source? (v3)

Last Updated:2011-08-18

As of version 4.x the use of ODBC for importing source CSV data is obsolete. Refer to Importing Directly from a Source CSV article for more information on this option.

If you add or remove columns from a source csv file, you will have to update the ODBC Data Source to reflect those changes. Then you must modify your custom map file to include mappings for the new columns (or remove mappings for columns that no longer exist).

If the source csv file format hasn't changed, you simply want to start mapping columns that were not mapped previously, skip to #2.

1) To change an ODBC Data Source:

Open Administrator Tools and run "Data Sources (ODBC)".
Select the System DSN you want to change and click Configure.
Click Options.
Click Define Format.
Select the csv file name from the Tables list.
Click Guess.
Click OK on each tab to save changes as you exit.

** Note: If you do not have Column Name Headers in your csv source file, the Guess function applies unique column names F1 through Fn. The insertion of new columns in this case will change existing column names. This will require you to modify existing mappings to ensure the new Fn column names are accurate.

2) To change Custom Mapping for an ODBC (csv) Data Source

In the SimpleSync admin tool, highlight your connection and go to the Custom Attribute Mapping tab.
Click Edit to open the Custom Mapping file.
Add or removing mappings for each value you want to sync.
Standard format for mapping is as follows:

Destination_Attribute_Name=^CSV_Column_Header^

For more help on map file syntax, click the Help button on the Custom Attribute Mapping tab. That help topic includes a link to see Attribute Mapping Examples.

Directory Wizards Inc.

Solutions For Your Directory Needs

Categories

Knowledgebase

Making changes to an existing CSV import ODBC Data Source? (v3)