Reply To: Zip Code won't map to Postal Code

02/15/2017 at 10:42 am #411499
Steven Zahm
Keymaster

@ Sabine

I took a look… my best guess is during the initial import of the CSV file the postal code column was not mapped correctly or not mapped at all and not imported.

I did a test of your file, only importing the first entry (1North Group) and it did import without issue. I left this duplicate entry as “unlisted” so you can see that the postal code was imported. YOu can safely delete this duplicate.

Likely the quickest and easiest solution to resolve this is to Navigate to the Connections : Tools admin page and click the Export tab. Scroll to the bottom and use the All export tool.

Open the resulting file, add the postal codes and then reimport the file. Doing this will update the existing entries with the postal code.

Tested this process with 1North Group and it worked fine. During mapping stage, let the CSV Import do the auto-mapping of the fields, do not change them.

Hope this helps!