I'm exporting our subscribers and the resulting CSV is displaying the State values as the 2 character version. I tried editing the State values table adding a third character to the State Code 2 field but it is still exporting only 2 characters.
Is there a way to select the Sate Code 3 value as the value used in the export?
Unfortunately, it's not possible. If it's really needed, we can modify the code to query database to have data exported in state 3 code. However, I am afraid of i will slow down the process and you would get timeout issue during export process
The reason I asked is due to Australia having some 2 character state codes and some 3 character state codes.
As I mentioned I've edited the State Code 2 values to put 3 characters in there but unfortunately the 3 character state codes seem to be truncated by the export process.
This results in QL instead of QLD, NS instead of NSW etc. When I then use this exported data for a mailing label mailmerge, the State is incorrect and may result in the member not receiving their mail.
Can you at least configure the export process to not truncate the State value to 2 characters long so that if the State Code 2 value is modified with a third character added it is not truncated?
I've gone through the few subscribers that required a correction for their 3 character state code and re-selected their state (updating them with a 3 character code) and now the export has 3 character state codes for those subscribers.