Category:Map Files
Last Updated:2011-08-18
The default attribute mapping for a CSV Export connection includes all standard mappings for the selected map templates. You may modify, remove or add columns/values to be included in your CSV Export by creating a custom map file . The map file is used to control what ATTRIBUTES get written at SYNC time... in the case of a CSV output, it controls what columns/values are written to the CSV file.
1) On the Custom map tab, type a new file name into the Object Map parameter, then click Create.
This opens a custom map file for this connection. It contains the default mappings, which include all standard mappings for the selected map templates.
The format is for a CSV Export map file is:
CSVColumnName=^sourceValue^
Assuming you have enabled 'column headers' on the Destination tab, the value to the left will be a column header. The value to the right will be the data that is written for each source object.
2) If you do not want a particular column/value set (i.e. postalcode) then delete the line, or comment it out with a preceding # character.
i.e.
#postalcode#40=^postalcode^
(The preceding comment # character should not be confused with any embedded # character which calls for a truncation of the value at the specified character number).
3) Once you have made the desired changes to the custom map file, click SAVE. Then click APPLY.
4) Run your Sync. You should see the Export.txt contains only those values that you left in the custom map file.