CiviCRM Community Forums (archive)

I'm trying to export records from one CiviCRM installation and import them into another.  The process works fine except the export function truncates leading zeroes in the postal code, the CSV file seems unable to retain them, and the import function does not restore them.  At what point in this export => import process can the leading zeroes be restored, or can the stored values be fixed?

Love the many CiviCRM improvements!

Thanks, Lobo.  The export is indeed complete with leading zeroes.  But the .csv files I imported into CiviCRM are not; Excel, when loading the .csv file, was truncating them.  Even correcting the format in Excel and saving the file again did not fix the problem.

The solution: convert the exported .csv file to an .xls format, then perform the format fix to zip code columns to restore the leading zeroes (format cells > special > zip code).  Then save as a .csv file, and this time the leading zeroes are intact.

I forgot to mention that I had also tried using the various formulas that people suggested to create new columns for zip code values, to no avail.

Thanks again for your help, hopefully this will help others.