Page MenuHomePhabricator

Belgium currency formatting issue
Closed, ResolvedPublic

Description

A donor (https://wikimedia.zendesk.com/agent/tickets/1456326) was confused by the amount in the Belgium send. The French and Dutch sends have anglo numbering: The Dutch Belgium send had €10.00 instead of €10,00 (should have used a comma instead of a period). It looks like the French copy is the same: ‍31.20 €, which should be 31,20 €.

Hi fr-tech team,

I took a deeper dive into our contacts from other countries including France, Sweden and our Latin America countries and noticed that a period is the decimal separator for the field both_funds_latest_native_amount. Based on Donor Relations' currency guidelines (see link below) it seems that only the US, Great Britain, Canada, Australia and New Zealand should have the period as the decimal separator yet it seems as though all countries currently have it in place for the both_funds_latest_native_amount. Is there anything we can do to fix this for the donation contact fields?

https://collab.wikimedia.org/wiki/Fundraising/Donor_Services_Documentation/Localization#Canada

cc: @krobinson @DBu-WMF

https://collab.wikimedia.org/wiki/Fundraising/Donor_Services_Documentation/Localization#Canada

Event Timeline

Perhaps the number formatting is better done in the Acoustic UI? Or is that very difficult?

Our acoustic export is sending both_funds_latest_native_amount as a number, currency code as a 3 letter ISO code, and then separately the currency symbol.

Since we send both_funds_latest_native_amount as a number, it's possible for the email team to use it as a segmentation option (i.e. target a group with that number > 10). If we switch to sending it as a localized string we would have to calculate the localization in SQL and it would no longer be usable on the email side for targeting.

This comment was removed by nisrael.

@Ejegg you are right. And actually now that I'm digging deeper I see that this issue is actually just specific to Belgium because we do format our code to not include the decimal points for our amounts. So we can actually close this task as we currently have a fix in place and will just need to update it for the specific email that was sent to Belgium.

Ejegg claimed this task.