Skip to content
This repository has been archived by the owner on Mar 23, 2021. It is now read-only.

Postal code field issue #7

Open
davesbot opened this issue Feb 6, 2017 · 1 comment
Open

Postal code field issue #7

davesbot opened this issue Feb 6, 2017 · 1 comment

Comments

@davesbot
Copy link

davesbot commented Feb 6, 2017

Hi Mathieu,
I'm not sure if this has been reported. We have a client exporting address data where the postal code begins with "0",

In the xlsx display the leading "0"is removed. Its not clear if this is bug or a display issue. I've attached the output file.

Thanks

vlct_postal_Export_20170206-1726.zip

@mlutfy
Copy link
Owner

mlutfy commented Feb 7, 2017

hi @davesbot. Thanks for reporting the issue. I haven't run into that bug, but Canadian postcodes start with a letter.
It should be possible to fix this by using the column headers and setting the proper format option in phpexcel. Maybe test here: https://github.com/mlutfy/ca.bidon.civiexportexcel/blob/master/CRM/CiviExportExcel/Utils/SearchExport.php#L113 ?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants