40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

CSV Data Upload – Zip Field

This topic contains 9 replies, has 4 voices, and was last updated by  Paolo 6 years, 8 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • August 12, 2017 at 2:29 pm #390869

    Jonathan
    Full Member
    Post count: 7

    Having issues when uploading data via csv file. The leading 0’s in the zip field are not sticking. Question: is the zip field a number or text field. If number, is there a way to change it to a text field to see if that will result in the 0’s carrying over after uploading?

    August 12, 2017 at 6:01 pm #390892

    Paolo
    Site Admin
    Post count: 31206

    Hi Jonathan,

    are you using excel to edit the file? If you are, you should only use open office or libre office.

    CSV files don’t have cell formatting at all. Everything you write in it should stick all the time.

    I’ve only see things like that happening with excel.

    Let us know,

    Thanks

    August 13, 2017 at 3:04 pm #390968

    Jonathan
    Full Member
    Post count: 7

    Nah, leading 0’s still won’t carry over in Open Office.

    August 14, 2017 at 12:34 am #390986

    Guust
    Moderator
    Post count: 29970

    I can confirm this.
    Even when first creating a listing with ZIP code 04032 for example, the export drops the leading zero.
    If trying to add the zero and re-importing, it drops it again.
    The only way to add a leading zero is to add it in the backend or frontend.

    I’ll get a developer to have a closer look.

    Thanks

    August 14, 2017 at 12:38 am #390989

    Jonathan
    Full Member
    Post count: 7

    Great, thank you. Hate to have to do it manually, as I have thousands to upload.

    August 14, 2017 at 5:30 am #391019

    Kiran
    Moderator
    Post count: 7069

    Hi Jonathan,

    During open CSV file in OpenOffice/LibreOffice choose column type “Text”, this will keep leading zeros for values. By default it column type is Standard and it trims the leading zero.

    Check following links to know more:
    https://forum.openoffice.org/en/forum/viewtopic.php?t=24940
    https://stackoverflow.com/questions/13835264/how-to-prevent-openoffice-libreoffice-calc-from-changing-what-you-input-data-n
    https://ubuntuforums.org/showthread.php?t=1584141

    I have tested with csv import and it keeps leading zero in zip value.

    Kiran

    August 14, 2017 at 1:20 pm #391077

    Jonathan
    Full Member
    Post count: 7

    Tried. Doesn’t work.

    August 14, 2017 at 1:41 pm #391084

    Kiran
    Moderator
    Post count: 7069

    Let us provide admin credential, so we can test on your site.

    Kiran

    August 14, 2017 at 2:48 pm #391107

    Jonathan
    Full Member
    Post count: 7

    Where should I send that?

    August 14, 2017 at 7:21 pm #391182

    Paolo
    Site Admin
    Post count: 31206

    right here, simply tick the “Set as private reply” option below the “Notify me of follow-up replies via email”

    Thanks

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

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket