Zip code import missing leading zero

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 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • 06/28/2015 at 10:36 pm #338835
    RYC
    Participant

    Most of our members are in the 068XX zip code but their zip codes import as 68XX. The CSV file contains the leading 0’s. Any ideas?

    Thanks

    06/29/2015 at 8:01 am #338924
    RYC
    Participant

    Figured it out — Excel formatting problem.

    Walt

    06/30/2015 at 11:15 am #339094
    Steven Zahm
    Keymaster

    @ Walt

    Great to hear you figured it out! Excel loves being helpful which sometimes doesn’t get you the results you want. Setting the cell format to string should fix it.

    07/01/2015 at 4:12 pm #339300
    RYC
    Participant

    Setting the cell format fixes it … until you save as .csv! Then it reverts back. Seems to be a known bug.

    My workaround is to use Google Sheets instead. Sheets “tries to help” in other annoying ways ;-) but it solves this particular issue.

    Thanks,
    Walt

    07/02/2015 at 8:47 am #339335
    Steven Zahm
    Keymaster

    @ Walt

    Ah, didn’t now Excel continue to stip the leading 0 when saving as a CSV. Good to know.

    I tend to use LibreOffice… I have not tested exporting a CSV with leading 0’s from it specifically, but at the same time, I don’t remember it ever being an issue after setting the cell formatting.

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

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