I imported 18,000 users into a new Drupal site today. I plan to use MailChimp. I imported a profile field called 'donotmail' which if checked means the user doesn't want to receive email from us. I could not figure out how to get MailChimp to import the Drupal site's user list so I exported it to CVS file and imported that into MailChimp manually.

First, I tried to erase all the users with the donotemail field checked. However, once cron was run Drupal exported the entire user database and misaligned the email address with the first and last names. So I imported the list again with the all the users and a made a special column for donotmail. I figure I can just manually sort out the do not mail users to create the list. However, I think it would be better if I can just import that list into MailChimp and have all the do not mail people marked as optout and erase the field from the Drupal database. I'm not sure how.

Any ideas?

Comments

levelos’s picture

levelos commented

Did you add the donotmail field as a marge in MC and then map it to the profile field in the MC list settings? That might help achieve the desired result.

Adam S’s picture

Adam S commented

Yes, I added the field to the list in MC. Now I have four fields to map to in the Drupal Configuration admin page for MC. They are email, first name, last name, and do not email.

It works, I was just wondering if there is a way to configure MC so that the donotmail field is mapped to Optout?

Right now a user can click in the account edit field to optout or under the menu tab for donotmail. It seems redundant and I would like one way to otpout or the other.

levelos’s picture

levelos commented
Status: Active » Closed (fixed)

Not without hacking the module or using hook_form_alter to your needs.

Adam S’s picture

Adam S commented

I'm not interested in keeping the donotemail field. I only created to keep track of the users who didn't want to be emailed. My question is can I change the variable for Optout where ever the user does not want mail?

I just took a minute to try to toggle the MC subscriber buttons with an authenticated user to see how it effects the data field in the users table. It doesn't work. The whole thing seems buggy to me. I think I'll just go ahead and use the donotmail field but that requires manually setting the field in MC. I wish there was someway to integrate it better.

What would happen if I turned off Sync Required Lists During Cron and only upload the users who want mail? Will it not send all the users during cron? That would make sense, however, I didn't bother unchecking it before because the subscription method wasn't selected required.

levelos’s picture

levelos commented

Toggling a subscribe checkbox simply adds or removes a user from a given list in MC. It has nothing to do with the user table in Drupal.

Adam S’s picture

Adam S commented

Yes, I finally figured that out. However, I didn't notice that the it was working whether or not the it was checked. This patched seems to have helped with that problem. http://drupal.org/node/608964 I just selected all 3000 users who unsubscribed to the old mailing list in Excel and pasted that list in the unsubscribe form of MailChimp. Once that was squared away with the above patch everything is running just smooth now so I can delete that ugly donotmail field and leave it MailChimp to manage the subscription list from here on out.

Thanks for the lovely module.

levelos’s picture

levelos commented

Ah yes, I need to add that patch. I've made many significant changes lately, and keep letting some obvious one's slip through. Anyways, feedback always welcome and I'll role that into the next beta release.