We created a form to capture addresses for a giveaway we're doing. However, when I exported the entries so that they could go to the shipping house, we found that some of the zip codes were truncated to four digits. Upon investigation, we found that the ones that were truncated were ones that started with a zero. Is there any way to keep this from happening?
PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.
Zip Code zeroes stripped on export
-
I can not replicate this on my dev site. If you are using excel, the csv should have the leading zero, i think you may need to set your column up correctly. It's most likely how you are trying to view the data that is the issue.
Excel does have this lame thing where it sets the data type for the column based on the first row of data, which screws numbers up all the time.
Posted 11 years ago on Wednesday June 26, 2013 | Permalink -
I exported a fresh CSV and opened it this time in Google Docs instead of Excel, and it had the same problem. Here's a copy of the file (without addresses and names) if that helps: https://dl.dropboxusercontent.com/u/11138065/pillow-engagement-2013-06-26%20%281%29.csv
Posted 11 years ago on Wednesday June 26, 2013 | Permalink -
It's showing correct for me: screenshot
Posted 11 years ago on Wednesday June 26, 2013 | Permalink
This topic has been resolved and has been closed to new replies.