Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
[vBtise] MailChimp vBulletin Integration Details »
[vBtise] MailChimp vBulletin Integration
Mod Version: 1.0.2, by vbtise (Coder/Designer) vbtise is offline
Developer Last Online: Mar 2019 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (0 vote - 0 average) Installs: 45
Released: 05 Sep 2012 Last Update: 22 Sep 2012 Downloads: 286
Not Supported Uses Plugins Additional Files Re-usable Code Translations  



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

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	admin_config_options.PNG
Views:	596
Size:	40.4 KB
ID:	141028   Click image for larger version

Name:	Configure_merge_fields.PNG
Views:	712
Size:	33.1 KB
ID:	141029   Click image for larger version

Name:	Subscription_error_log.PNG
Views:	675
Size:	14.7 KB
ID:	141030  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Jpilot / Vbulletin Integration for Vbulletin 3 d3nnis vBulletin 3.0 Full Releases 36 13 Dec 2005 23:25

Comments
  #2  
Old 05 Sep 2012, 20:24
pete_brady pete_brady is offline
 
Join Date: Mar 2002
Installed & configured, but I don't see any option to "Run cron job to sync Vbulletin users into mail chimp."
__________________
thumped.com
Reply With Quote
  #3  
Old 05 Sep 2012, 20:32
pete_brady pete_brady is offline
 
Join Date: Mar 2002
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
__________________
thumped.com
Reply With Quote
  #4  
Old 05 Sep 2012, 21:55
billrini billrini is offline
 
Join Date: Aug 2009
Originally Posted by pete_brady View Post
oh and 'view cron log' throws this error:
Just to confirm, I get the same error.
Reply With Quote
  #5  
Old 06 Sep 2012, 20:14
billrini billrini is offline
 
Join Date: Aug 2009
Looks pretty cool if we can figure out the missing db table and maybe get some more info on the filed mapping.
Reply With Quote
  #6  
Old 07 Sep 2012, 08:01
vbtise's Avatar
vbtise vbtise is offline
 
Join Date: May 2012
Thumbs up

Originally Posted by pete_brady View Post
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.
Reply With Quote
  #7  
Old 07 Sep 2012, 08:02
vbtise's Avatar
vbtise vbtise is offline
 
Join Date: May 2012
Thumbs up

Originally Posted by billrini View Post
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.
Reply With Quote
  #8  
Old 07 Sep 2012, 17:25
billrini billrini is offline
 
Join Date: Aug 2009
How do you add additional merge fields?
Reply With Quote
  #9  
Old 07 Sep 2012, 18:31
vbtise's Avatar
vbtise vbtise is offline
 
Join Date: May 2012
Thumbs up

Originally Posted by billrini View Post
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.
Reply With Quote
  #10  
Old 07 Sep 2012, 22:45
pete_brady pete_brady is offline
 
Join Date: Mar 2002
Originally Posted by vbtise View Post
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.
__________________
thumped.com

Last edited by pete_brady; 07 Sep 2012 at 22:58.
Reply With Quote
  #11  
Old 07 Sep 2012, 23:08
billrini billrini is offline
 
Join Date: Aug 2009
Originally Posted by vbtise View Post
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.
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?
Reply With Quote
  #12  
Old 07 Sep 2012, 23:09
billrini billrini is offline
 
Join Date: Aug 2009
Originally Posted by pete_brady View Post
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.
Reply With Quote
  #13  
Old 11 Sep 2012, 14:34
vbtise's Avatar
vbtise vbtise is offline
 
Join Date: May 2012
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.
__________________
vBtise - Premium vBulletin services
vBulletin Upgrade | Custom Template Design | Custom Mod development | Troubleshoot | Monthly support
Reply With Quote
  #14  
Old 11 Sep 2012, 16:49
mirko185 mirko185 is offline
 
Join Date: Apr 2012
For vB 3.8?
Reply With Quote
  #15  
Old 11 Sep 2012, 18:14
pete_brady pete_brady is offline
 
Join Date: Mar 2002
Originally Posted by vbtise View Post
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!
__________________
thumped.com
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:13.

Layout Options | Width: Wide Color: