Leading zeros are gone once csv is uploaded

  • Resolved christian72

    (@christian72)


    2 years, 3 months ago

    Hi,

    I have a problem with missing leading zeros in the zip field.

    I have my csv set up with about 1.750 rows.

    The csv shows the leading zeros.

    When I open the csv with a plain text editor the leading zeros are still there. So my file should be ok.

    As you told another user I defined the zip field as a text-line field.

    I’ve read a lot about it and tried some things, so far without success.

    Whatever I do… once uploaded the leading zeros are gone. In the backend and in the frontend.

    Thank you!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Yes, that’s correct, in order to have a field value with leading zeroes, the Participants Database field must be defined as a text-line field.

    I know you tried that, but make sure that the field is defined as a text-line type field, since that is correct. Also, of course make sure the CSV is getting exported with the leading zeroes.

    If it’s still truncating the leading zeroes on import, what you need to do is make sure that the database was updated to the correct data type. (normally, the pugin does this for you) You can do this by opening the database in phpMyAdmin (usually found in your hosting control panel) and checking the wp_participants_database table. You need to go to the structure tab and find the row that stores the leading zeroes. Make sure it is set as a “text” type in the “Type” column of the row.

    Thread Starter christian72

    (@christian72)

    Thank you but I have already deleted your plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Leading zeros are gone once csv is uploaded’ is closed to new replies.