[vBtise] MailChimp vBulletin Integration
 

Background
This mod is developed to integrate vBulletin with Mailchimp. Mailchimp is one of the popular email marketing platform. Which is also free for upto 2000 subscribers. For more information please visit their website (http://mailchimp.com/).

Installation

1. Download the latest version of the addon
2. Upload content from "UPLOAD" directory to your forum root
3. Go to AdminCP -> Plugin & Products -> Manage Products -> Add/Import Product
4. Import product-kws_mailchimp.xml
5. Go to AdminCP -> Settings -> Options -> vBtise Mail Chimp
6. Change settings to connect with your Mailchimp account

Configure Admin Options
Configure admin options in admin end => settings => options => vBtise Mail Chimp

• Option 1 => Turn mail chimp integration on/off
• Option 2 => If this option is selected as YES, user will be subscribe to Mail chimp without his permission, otherwise in case of NO user will be send to mail chimp only when he will checked the Receive Email from Administrators option on registration page.
• Option 3 => Enter Mailchimp API Key.
• Option 4 => Enter Mail chimp Unique list id in which you want to subscribe

Configure Admin Options

• After admin options configuration, go to admin end => User Profile Fields => User profile fields manager. here you can manage already created fields or create new one to configure with mail chimp. NOTE: To display fields in Manage Mailchimp Fields Page select ( Yes, at registration and profile updating) or ( No, but display at registration) in add/edit filed form => Field Required
• After creating fields move on to admin end => Vbtise Mail Chimp => Manage Mailchimp Fields page
• Enable fields with the same Merge tag in Mailchimp administration end

How to View Logs

• admin end => vBtise Mail chimp => View Cron logs ( here you can see logs like total new added / updated records in Mail chimp List)
• admin end => vBtise Mail chimp => Registraion Subscription error log ( list of users which are not successfully subscribed in mailchimp while registion )

Features
Admin options

• Enable or disable mail chimp integration
• Subscribe user to forcefully or with permission
• Option to target a particular mail chimp list
• Configure Vbulletin and Mailchimp Fields (Merge tags )

Mailchimp Subscription
There are two ways to add a user into mail chimp list.

• When new user register?s in forum
• Run cron job to sync Vbulletin users into mail chimp. ( this will pass all users to mail chimp api , with options to add new subscribers and update which already exists )
• Two types of logs admin can view
• Cron logs with summary of ( Total accounts added/updated or number of accounts having error while sync.)

Changelog
Version 1.0.2

• Security Fixes

Version 1.0.1

• Cron job missing file added

Version 1.0

• Cron job issue fixed
• Improved loggin

Installed & configured, but I don't see any option to "Run cron job to sync Vbulletin users into mail chimp."

oh and 'view cron log' throws this error:

Just to confirm, I get the same error.

Looks pretty cool if we can figure out the missing db table and maybe get some more info on the filed mapping.

We have fixed the issue and updated the version of plugin. Please let us know if you still have any issue there.:)

Error is fixed now. Please remove the previous version and install this new one. It will fix the error for you.

How do you add additional merge fields?

If you are asking for Mailchimp, please read about it on following link:
http://kb.mailchimp.com/article/gett...ith-merge-tags

In vBulletin you have to add custom profile fields and map it with merge tags.

edit: nevermind, seems to be ok now!

edit2: ok the view cron log error is gone, and i can see there's a cron job set to run at 12:01 on the 1st of each month. However, when i force it to run now nothing happens. I'm not seeing anything happening in the API logs on the Mailchimp end either.

Sorry, I should have been more clear.

What I mean is I have the following default merge tags in MailChimp:

EMAIL
FNAME
LNAME

But when I go to Manage MailChimp Fields in your product I only see one user profile field:

Newsletter

There is no option to assign FNAME and LNAME values. I also do not see any of the other user profile fields.

So, what I was asking was how do you get more of the userfields to show up? Do I have to create the merge tags in MailChimp first?

How does MailChimp map those fields to the userfields? In other words, why does Newsletter show up but not Real Name? Why is Newsletter the only one that does show up since it has nothing to do with any of my merge fields in MailChimp?

Same here. It runs but nothing ends up in the logs.

We have fixed the cron issue. Now cronjob will work fine on manual run. Please let us know if you have any other question for us.

For vB 3.8?

latest version installed, but not seeing the Merge Tag option in 'User Profile Fields in Area'

edit:

But i do!

installled on helpline3d.com.

I'm having the same issues...

SQL Injection found in this mod, please read PM.

Please activate profile fields to display on registration. This condition will allow fields to visible on plugin's setting page.

OK! Now we're getting somewhere.

I've run the cron job manually a couple of times & it times out (there are just under 11,000 accounts on my forum) so i never get any feedback in the Cron Log for Total Added, Total Updated or Total Error.

Thanks for informing us. We have fixed the issue in new release.

Thanks! Everything looks like it's working!

what am I doing wrong?? When I try to run in scheduled tasks.

VBulletinMailchimp

Warning: include_once([path]/./includes/cron/mailchimp_subs_all.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/mailchimp_subs_all.php' for inclusion (include_path='.:/usr/local/php52/pear') in [path]/admincp/cronadmin.php on line 113

why are you running a scheduled task, once you have all settings done it auto send out the mail lists

Thanks for this it will help me a lot once ive properly got it configured.

I installed it fine, set it up in the options.

I then set up the merge tags fine, all ok so far.

Now, I already have 400 of the 700 members subscribed and I 'presume' that if i set this up properly itll somehow automatically add the additional 300 members....

So I set it up to run a scheduled task (it was already set up to run 1st of the month) by changing it to the next few minutes... it runs and 'seems' to have a back log.

The problem I have now is, its sending ALL my members insane amounts of emails from mailchimp. One members reports to have over 40, a couple of others are saying 15... why is this?

I have now deleted the lists and renewed it to with a new csv so that itll have ALL the members... if a new member signs up now do they automatically get added to the list I have put in the settings?

I signed up with a fake user and the user wasnt added to this list.... but members are still being added from the scheduled task even though I stopped it, seems to be a backlog........

Im stuck and confused and members are getting very annoyed :(

Matt

Make sure you are using latest version, and let us know if you are still facing any issue . thanks

you are testing it with fake user, but keep it in mind that user will not be added in your mailchimp list untill he/she will accept subscription using link given in email ( email which is sent by mailchimp itself)

Hi,

the Subscribe Forcefully option does not work. It always works as No.
Any suggestions?

Please help, it is pretty confusing to me how it works.
I integrated it as described above, forcefully=off.
Have radio buttons (yes and no) on profile and registration page.

OK, but what happend is this: When everything was setup right (I guessed) I ran the Scheduled task for vBulletinMailChimp. Took quite some time (1000 members) and ended in an MySQL error. But guessed that most of the mails we're sent. Pretty soon I got some MailChimp-Yippeee mails for new signups.

But I wondered what would happen when the scheduled task would run the next time. So half an hour later, I manually ran it again. And OOPS, I noticed that it starting to send out all (??) mails again. That's ofcourse not what I want, and especially not what my forummembers want :(
The sched.task is turned off now.

What can I expect that this plugin does?
And what happens with new forum registrations when the sched.task is turned off?

Hope for some extra info on this promising plugin ...
Thanks in advance!

Is this mod any better/different than this one?

will this work on VB5?

Is this mod unsupported now?

I did come across that one too, but since it didn't mention anything on vB4.x I guessed it only supported vB3.

Have that same feeling, unfortunately. Especially since it seems pretty buggy to me.
A reaction by @vBtise would be highly appreciated.

I think it works on vb4 as well.I don't find it buggy, but there is one very important piece missing for me.
I need to have a radio button or checkbox that asks if the person would like to sign up to the newsletter or not. Right now this is done by checking "receive e-mails from admin". I need there to be a line in the forum signup that asks specifically:
"Do you want to receive our newsletter?" and then act accordingly.

I'm going to try the other plugin as it seems like it might be able to do that.

Hello everyone,

We are in process of launching new version of this mod very soon. Which will address all the issues reported to us so far.

A documentation link on how to use it will be added with it soon.

That is very nice :up:

Please let us know when it will be available.

thank you

Will this plugin, or the new plugin integrate with the forums and blog to pull info from posted threads and blog's?

If it doesn't do this now or in the upcoming upgrade will be a main reason this will ever be successful with many vbulletin admin's. I noticed it currently shows only 24 downloads on the most popular vbulletin mod website.

I had installed this mod on my board only because of a promotion by MailChimp that gave 12,000 credits and then if you did something else you got another $3,000 credits and if it was all before a certain time you got another 5,000 credits.

After installing this plugin as the best I can remember to me it looked like it mainly allowed you to import your subscribers. There didn't appear to be much more about it. I went on MailChimp and registered an account and spent time trying to get use to it. I'll admit they have an extremely nice setup on MailChimp, it's just that it needs to work more with the our boards database with pulling down info from threads and such. Btw, that actually happens to be what landed me here again. I wanted to back track and see if MailChimp was working with our boards as I have mentioned. It doesn't seem that it does, and I'll apologize now if I'm wrong with anything I have posted here.

I've seen some vbulletin boards that have newsletter plugins that pull the data and images from their board. All they do is check off what they want sent to their subscribers, check off what sponsor banners and links are added. Very basic.

It's been a month. I need this integration. Is it about done or still waiting to be addressed? Thanks.

I love MailChimp emails from promoters, I just cut and paste them straight in to a gig guide page and ...perfect, looks the same.