This month, I wrote a custom module for a client, that import newsletters (or "campaigns", as MailChimp calls them) from a given MailChimp account into a Drupal site as nodes. (As many of you know, MailChimp is a rather nice third-party newsletter service.)
How it works:
- Depends on mailchimp.module, using the same account configured in mailchimp.module settings.
- Uses a custom table to store ID's of imported messages.
- Checks MailChimp account for new messages on every cron run, or when an admin pushes the big shiny "Import campaigns" button.
- Uses the MailChimp API to connect to your MailChimp account and import your messages
- Provides config page where admin can specify: which list(s) to import from; what kinds of messages to import (sent or not sent); what publishing options to apply to the nodes that will be created (published/unpublished, etc); and taxo terms to apply to the nodes that will be created.
It works for my client. Now I'm wondering if it would be useful to others. Members of this group who use a 3rd-party newsletter system such as MailChimp, what say you to importing newsletters as nodes?
Comments
I am looking for similar solution
Does it work with emf module?
http://drupal.org/project/emf
can you post the module, so i can test it out. Thanks,
Looking for this functionality
can you share the module?
Even just as a starting point
Even just as a starting point (should be possible to add support for E-mail Marketing Framework later) it would be perfect. We all want it!
-Stefan
I obey!
I posted the first beta of MailChimp Import module over at my company blog.
Download! Test! Bring on the comments!
(Incidentally, this is tested with the current recommended 6.x release of Mailchimp module, which is 6.x-2.0-rc4. It won't work with earlier 6.x versions.)
Zoë Neill-St. Clair
Drupalshank @ Affinity Bridge
http://www.AffinityBridge.com
Most definitely
We would most definitely use this module.
As far as I can see it would save us the process of copying the newsletter to our site manually, which we do as part of providing an archive for this type of thing.
Let me know how it works!
Let me know how it works!
Zoë Neill-St. Clair
Drupalshank @ Affinity Bridge
http://www.AffinityBridge.com
I'd like to check it out..
Please send me a note on the contact tab!
Latest version
Thank you for writing this module. I have a client interested in this exact functionality. I'm trying to find the latest version of your module, and it looks like it is actually here: http://drupal.org/node/736394#comment-3221586
Could you please confirm that is the best place to go... at least until you get a cvs account?
'Tis, but it is a little
'Tis, but it is a little neglected and quite probably needs work. Let me know if it doesn't work for you.
Zoë Neill-St. Clair
Drupalshank @ Affinity Bridge
http://www.AffinityBridge.com
Thanks again. The module
Thanks again. The module works great is is exactly what I was looking for. If I have feedback as I continue to use it, I'll let you know.
Drupal 7 Release?
Just wondering if there are any plans to update this to include a Drupal 7 version?
campaign monitor
Dear All,
Could you please tell me step for campaign monitor module.
Drupal 7 version available
Hi,
I created a sandbox Drupal 7 version of this module here. I added a feature to import from the newsletters only a selected portion identified with given id, and/or extract from the newsletter the title identified with the given id. I removed the CSS file from the module because I think it is the job of the person creating the theme to hide elements using CSS files.
The module seems to work as I want but I haven't done real large scale testing. I will take the module into production on my site in September so I will hopefully iron out most of the bugs by then.
Please submit bug reports, feature requests etc.
A big thanks to ZoeN for her work!
Looking for similar functionality.
Hi,
I am searching for similar functionality to bring mailchimp archive into a website
and display the latest newsletter as a full node while the rest as a list of titles.
Since mailchimp provides campaign archive folder code, which is in Java script. Can we use feeds module to import campaigns using that code? (My knowledge is limited.)
I want to try your Drupal7 version of module but not familiar with sandbox of jit what could be method to install it on my website?
Thanks in advance.
This is a good place to start
This is a good place to start with git: http://drupal.org/documentation/git
As heads-up, sandbox projects are "experimental code for developer use only." So there's a good chance that it's not quite ready for production sites.
It's probably not quite what you're looking for, but you could also embed email archives on your website using a "Campaign Archive Folder," as described here: http://blog.mailchimp.com/embed-email-archives-on-your-website
Will hopefully get a beta version out after September
Hi,
I don't really know how the campaign archive works but the Mailchimp Import module allows you to strip CSS stuff from the campaign and/or import only a specific section of the campaign to Drupal - something I'm guessing isn't as easy with the feeds module.
The import module now works in my test site, but I don't think I will have time to do any real testing outside my limited use cases. My site will be in production in the beginning of September, so before that I don't want to release anything more serious. After I verify that everything works for me, I will hopefully have time to get a beta version released and then also people with no git experience can start testing.
Thanks for the effort so far!
I also have a client, that is interested in this functionality. I have installed the module, and it seems to work. Only thing is, that when I import the campaigns, I only get the titles, but the body/content sections are empty.
I am happy to test different settings, if you can suggest any. I am hoping soon to this module in beta, and follow the development.
Might have something to do with PHP version
I now tried to debug that, because I'm having the same problem with my website service provider. The problem is that I can not reproduce the problem on my own machine - the same campaign is imported just fine to my development environment.
The PHP version in my development environment is 5.4.9 where it works, and 5.3.18 in the service provider, which doesn't work. So my best guess at the moment is that it works with PHP 5.4 but doesn't work for PHP 5.3.
What version of PHP do you have?
You're right
Thanks for your testing. You're right that currently, for some reason, only the headings are imported. Don't quite know what happened, maybe Mailchimp changed something. I'll try to find time to debug the problem.