[vBtise] MailChimp vBulletin Integration

[vbtise]

https://vborg.vbsupport.ru/external/2014/03/28.png (http://www.vbtise.com)


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

Download the latest version of the addon
Upload content from "UPLOAD" directory to your forum root
Go to AdminCP -> Plugin & Products -> Manage Products -> Add/Import Product
Import product-kws_mailchimp.xml
Go to AdminCP -> Settings -> Options -> vBtise Mail Chimp
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 (http://www.vbtise.com)

[pete_brady]

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

[pete_brady]

oh and 'view cron log' throws this error:

SELECT *,date(log_date) as log_date_display,case
when status = 'C' then 'Complete'
when status = 'E' then 'Error'
end as status_display
FROM kws_mailchimp_log;

MySQL Error : Table 'thumped_vb.kws_mailchimp_log' doesn't exist

[billrini]

oh and 'view cron log' throws this error:

Just to confirm, I get the same error.

[billrini]

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

[vbtise]

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

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

[vbtise]

Just to confirm, I get the same error.

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

[billrini]

How do you add additional merge fields?

[vbtise]

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/getting-started-with-merge-tags

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

[pete_brady]

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

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.

[billrini]

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

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

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?

[billrini]

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.

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

[vbtise]

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.

[mirko185]

For vB 3.8?

[pete_brady]

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.

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

edit:

vBulletin Message

You don't have any Custom Profile fields defined.

You can add profile fields here.

But i do!

[coolankur49]

installled on helpline3d.com.

[fovvbuser]

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

edit:

vBulletin Message

You don't have any Custom Profile fields defined.

You can add profile fields here.



But i do!


I'm having the same issues...

[MegaManSec]

SQL Injection found in this mod, please read PM.

[vbtise]

vBulletin Message

You don't have any Custom Profile fields defined.

You can add profile fields here.!

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

[pete_brady]

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.

3
2012-09-22
Error
Could not read response (timed out)
4
2012-09-22
Error
Could not read response (timed out)

[vbtise]

SQL Injection found in this mod, please read PM.

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

[fovvbuser]

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

Thanks! Everything looks like it's working!

[iadventure]

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

[TheSupportForum]

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

[Skivey]

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

[vbtise]

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
Make sure you are using latest version, and let us know if you are still facing any issue . thanks

[vbtise]

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
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)

[DoDe]

Hi,

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

[DrPrepper]

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!

[Meestor_X]

Is this mod any better/different than this one (http://www.bestrecipes.com.au/site/mailchimp.html)?

[mediax]

will this work on VB5?

[Meestor_X]

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 (http://www.bestrecipes.com.au/site/mailchimp.html)?
Is this mod unsupported now?

[DrPrepper]

Is this mod any better/different than this one (http://www.bestrecipes.com.au/site/mailchimp.html)?

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

Is this mod unsupported now?

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

[Meestor_X]

I did come across that one too, but since it didn't mention anything on vB4.x I guessed it only supported vB3.I think it works on vb4 as well.Have that same feeling, unfortunately. Especially since it seems pretty buggy to me.
A reaction by @vBtise would be highly appreciated.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.

[vbtise]

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.

[DoDe]

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:

[cloferba]

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.

Please let us know when it will be available.

thank you

[1320Nation]

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.

[cavyspirit]

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.

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

[Toorak Times]

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

[chrisu]

So what's happening with this? I installed and confugures, but still it sent an emai eo all my members regardless of settings.

Nice work guys, delete these mods if you are not working on them as promised.

/chris

[K4GAP]

So what's happening with this? I installed and confugures, but still it sent an emai eo all my members regardless of settings.

Nice work guys, delete these mods if you are not working on them as promised.

/chris

I don't recall seeing any promises. A good (free) add on is worth waiting on.

[khronos_group]

Curious if this add-on works anymore with VB 4.2.2. We can't get it working at all.

We simply want the option for "Receive emails from Administrator" to push the email subscription to mailchimp, and have mailchimp send out the verification email. We don't need or want sync, or merge fields or anything else.

Many thanks,

[DownNout87]

Thinking about working with vBtise? Check out my thread: www.vbulletin.org/forum/showthread.php?p=2487653

If you enjoy going several weeks without a response, this is the company for you.

[BirdOPrey5]

Thinking about working with vBtise? Check out my thread: www.vbulletin.org/forum/showthread.php?p=2487653

If you enjoy going several weeks without a response, this is the company for you.

Please keep this thread specific to this modification.

[DownNout87]

I am trying to get in touch with vbtise in regards to the mailchimp add-on but not getting any luck. Is anyone else able to get a hold of him?

[DownNout87]

Anyone? I can't seem to get a hold of this developer via PM or via his website (www.vbtise.com).

It's odd because he was online yesterday...hmm....

[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!

[Alfa1]

You can find the developer here:
https://www.freelancer.com/u/vbtise.html
https://xenforo.com/community/members/forumcube.61433/

[Scimia]

Hi,

I have problems with this plugin: every time i try to do the scheduled task of this plugin i get this database error.

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vbforum_kws_mailchimp_log values(NULL,now(),'C',NULL,'a:36:{i:0;a:3:{s:4:"code";i:212;s:7:"message";s:158:"email@hotmail.it has unsubscribed, and cannot be resubscribed by you. To prevent false spam complaints, they'll need to resubscribe of their own free will.";s:5:"email";s:19:"email@hotmail.it";}i:1;a:3:{s:4:"code";i:212;s:7:"message";s:159:"email@yahoo.it has unsubscribed, and cannot be resubscribed by you. To prevent false spam complaints, they'll need to resubscribe of their own free will.";s:5:"email";s:20:"email@yahoo.it";}s:11:"total_added";i:20;s:13:"total_updated";i:117;s:11:"total_error";i:33;}');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'll need to resubscribe of their own free will.";s:5:"email";s:19:"blabla@hotma' at line 1
Error Number : 1064
Request Date : Monday, January 26th 2015 @ 02:02:34 PM
Error Date : Monday, January 26th 2015 @ 02:02:45 PM
Script : http://www.mywebsite.it/forum/admincp/cronadmin.php?do=runcron&cronid=37
Referrer : http://www.mywebsite.it/forum/admincp/cronadmin.php?do=modify
Classname : vB_Database
MySQL Version : 5.5.40-36.1-log

[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]

@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! :D

[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]

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]

@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]

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]

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.

[Scalemotorcars]

Anyone using this still? Any other mailchimp or 3rd party VB newsletter options? Thanks.

[Scalemotorcars]

Guess thats a no.