Zip Code won't map to Postal Code

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , ,

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • 02/13/2017 at 2:16 pm #411241
    ramarachamber
    Participant

    Hi,
    My file has Postal Code field.
    I import the .csv and map Postal Code to the Zip Code choice.
    The Postal Code does not show up.

    I have not changed anything in the customizer under Address Format.

    thanks for your help,
    Sabine

    02/13/2017 at 3:31 pm #411261
    Steven Zahm
    Keymaster

    @ Sabine

    When you edit an entry in the admin, does the imported zip code show?

    02/13/2017 at 4:52 pm #411268
    ramarachamber
    Participant

    No it does not show in the admin area, but I can add it manually and then it shows.

    Sabine

    02/13/2017 at 5:00 pm #411269
    ramarachamber
    Participant

    I see looking at the details in the Admin, that it is in under ‘Other’.

    02/14/2017 at 10:01 am #411409
    Steven Zahm
    Keymaster

    @ Sabine

    Can you please give me a temp WP admin login so I can take a closer look?

    Can you also please attach a copy of the CSV file you imported? Before you attach it please rename it from .csv to .txt so the support forum does not reject the file.

    02/14/2017 at 4:35 pm #411436
    ramarachamber
    Participant
    This reply has been marked as private.
    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!

    02/15/2017 at 4:17 pm #411545
    ramarachamber
    Participant

    Thank you so much! I had to do it a few times. I put them in the other | zipcode column but finally realized that it mapped to the work address |zipcode column. Of course each try I uploaded to google sheets to get a fresh copy.
    Thank you again!
    Sabine

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

You cannot reply to this support topic. Please open your own support topic.