Page MenuHomePhabricator

RML Country information not making it into Civi from Acoustic
Closed, ResolvedPublic

Description

Country information is not carrying over with RML sign ups from Acoustic to Civi. This information is essential for DR to be able to accurately respond to donor inquiries without unnecessary back and forths, from accepted payment methods to tax deductibility information.

Example: CID 67389567, 68084633, and 68063824. They signed up and received an RML emails last week.

We're unsure why their country field isn't populated. In Acoustic it's set as country=XX .

Their respective RML fields are correctly populated in Acoustic as:
rml_country=US
rml_language=en

@SHust notes that it’s likely that the form or process that collects RML signups is populating only the rml_country field, and not the standard country field.

Something has clearly changed with this flow. Can we please look into this and prioritise fixing @Eileenmcnaughton ? Thank you!

Details

Related Changes in Gerrit:

Event Timeline

One thing to note, I just came across this while investigating today: when I expand the address field in Civi, the country is there, but it doesn’t appear on the summary page the way it does for non-RML entries.

Screenshot 2025-07-30 at 9.58.11 AM.png (230×968 px, 28 KB)

Screenshot 2025-07-30 at 9.58.24 AM.png (452×1 px, 60 KB)

Change #1175616 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix bad array join

https://gerrit.wikimedia.org/r/1175616

Change #1175616 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix bad array join

https://gerrit.wikimedia.org/r/1175616

@Eileenmcnaughton, it looks like the patch that was deployed isn’t correcting the country field for contacts who had previously signed up and received today’s email — for example: CID 68138127, 68123782, and 68083847. Given the volume of incoming replies, not being able to see the country at a glance just isn’t scalable. Can a fix for both, please, be worked on? Thank you

@SHust so it's working when newly collected but not backfilling the old ones?

@Eileenmcnaughton I signed up with a test email today, after the RML went live, and noticed the country field in Acoustic wasn’t populated with “XX. We won’t see the newly signed CIDs until they sync with Civi or receive the email 48 hours later. The backfill, I'm certain, isn’t fixed.

@Eileenmcnaughton turns out this is still broken!
Example: Ticket #1710951 / CID 68135552, where the country doesn’t show up on the Civi summary page for the RML recipient. Please let me know if you need other recent examples. Thank you!

@SHust that contact was RMLd on July 30 - do you have any that were added to the RML group after 6 Aug with no country?
https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=68135552

Sorry for the delay, and you are right, @Eileenmcnaughton, the CID I shared predates Aug 6th. The recent ones appear to have the country listed in the summary page: CID 59969864 (signed up 8/15); CID 62069226 (signed up 8/7); and 68240534 (Signed up 8/16). Ty!

Yes, it is, thanks for checking!

XenoRyet set Final Story Points to 2.