search

veda-consulting-company / uk.co.vedaconsulting.mailchimp

Other
22 stars 43 forks source link

Middle name & last name mixup #133

Closed magnolia61 closed 7 years ago

magnolia61 commented 9 years ago

In the Netherlands we tend to use the Middle Name field for cases like: Joe van Vliet (van would be middle name). This is how we set up mailchimp.

Now when syncing from mailchimp to civicrm, the last name field was filled with the middle name. In Mailchimp they are named FNAME, MNAME, LNAME.

Is there a possibility the wrong fields got synced? Our civicrm database is a mess now, since people now have their Middle Name duplicated in the Last Name field.

veda-consulting commented 9 years ago

@magnolia61 sorry to hear that but its not something thats been reported previously. Can you clarify which name fields got pulled from where to where? We'll take a look to see if there is a bug that could have caused this but as mentioned its not been reported to date.

magnolia61 commented 9 years ago

Happy to help debugging and testing if your want. In mailchimp I set up:

  1. First Name [FNAME]
  2. Middle Name [MNAME]
  3. Last Name [LNAME] In CiviCRM what happend after a pull from mailchimp was that the CiviCRM Last Name field was filled with the Middle Name field from Mailchimp. Since I set the merge tag in mailchimp manually to MNAME, what I suspect is that for the last name it just selects the field after the firstname.

Result in CiviCRM: Joe van van (lastname field is overwritten by the sync by the mailchimp middle name field)

magnolia61 commented 9 years ago

Also (but maybe that is by design of this extension) the pull from mailchimp did not follow the civicrm build-in unsupervised dedupe rule which I set for First Name -Last Name - Email

veda-consulting commented 9 years ago

@magnolia61 pull will only use the email address for the matching, won't use any other rule. Thanks for the feedback, if you're able to debug you could try and find the issue. I didn't think we ever touched the middle name but you may find some code thats doing it?

veda-consulting commented 9 years ago

@magnolia61 at present the integration does not deal with anything but the first and last name, we could look at this as an enhancement.

deepak-srivastava commented 7 years ago

We no longer able to reproduce this with latest v2.x release. Closing it. Please re-open if the issue still exist. Thanks.