Integration with vBulletin - [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

A plugin by vBtise.com

[Dave]

@Scimia
I fixed that error for someone not too long ago.
Open the file /mailchimp/MailChimpSubs.php

Around line 127 you have:

$qry = "INSERT INTO " . TABLE_PREFIX . "kws_mailchimp_log values(NULL,now(),'C',NULL,'".serialize($this->errors_arr)."')";

Replace with:

$qry = "INSERT INTO " . TABLE_PREFIX . "kws_mailchimp_log values(NULL,now(),'C',NULL,'".$vbulletin->db->escape_string(serialize($this->errors_arr))."')";

[Scimia]

Originally Posted by Dave

@Scimia
I fixed that error for someone not too long ago.
Open the file /mailchimp/MailChimpSubs.php

Around line 127 you have:

$qry = "INSERT INTO " . TABLE_PREFIX . "kws_mailchimp_log values(NULL,now(),'C',NULL,'".serialize($this->errors_arr)."')";

Replace with:

$qry = "INSERT INTO " . TABLE_PREFIX . "kws_mailchimp_log values(NULL,now(),'C',NULL,'".$vbulletin->db->escape_string(serialize($this->errors_arr))."')";

Thank you so much, now with this fix the plugin works!

[Paddy Murphy]

Hi,

I just installed this. I'm trying to sync my forum members to mailchimp but it hasn't happened.

How do I view the logs? I don't understand where this is;

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 )

Also, I noticed the version is 1.0 - it's suppose to be 1.0.2, yeah ?

My board is v4.2.2

Thanks

[Paddy Murphy]

Originally Posted by Paddy Murphy

Hi,

I just installed this. I'm trying to sync my forum members to mailchimp but it hasn't happened.

How do I view the logs? I don't understand where this is;

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 )

Also, I noticed the version is 1.0 - it's suppose to be 1.0.2, yeah ?

My board is v4.2.2

Thanks

Anyone ?

[fmckinnon]

I'm assuming this is no longer supported - has anyone tried this plugin with vb5?

[giorgioarmani]

Nice mod!

Installation has gone smooth...

Can you confirm how often does this CRON script run?

[fmckinnon]

@giorgioarmani - did you get this to work with vB5??

[giorgioarmani]

Originally Posted by fmckinnon

@giorgioarmani - did you get this to work with vB5??

I'm on vB4.

Installation went fine but it appears to not be adding anyone to the mailchimp list.

I assume it needs to run a cron job but not sure how or where to configure that.

[joyboy2001]

Originally Posted by giorgioarmani

I'm on vB4.

Installation went fine but it appears to not be adding anyone to the mailchimp list.

I assume it needs to run a cron job but not sure how or where to configure that.

AdminCp>Scheduled Tasks>Scheduled Tasks Manager>VBulletinMailchimp

And just after installing run the task manually for the first time.

By default it's scheduled for once a month. I have changed mine to once an hour since Mailchimp doesn't seem to mind

[joyboy2001]

Originally Posted by DownNout87

Very shady...this developer has logged in to this forum numerous times and still not replies to these forum posts and emails.

Think twice about dealing with this guy. You won't get any support!

That's too bad because the mod actually works great.

If you manage to get a hold of him, please ask him to incorporate more features in the next version (if he ever makes one):

Should allow the segmentation based on usergroup. If a person is added to a specific usergroup, their account should be removed from sync.

Reverse sync: If a person unsubscribes from the mailchimp list, they should automatically be added to a specific usergroup.

These are the only things I can think of right now.