vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Integration with vBulletin - [vBtise] MailChimp vBulletin Integration (https://vborg.vbsupport.ru/showthread.php?t=287495)

vbtise 09-04-2012 10:00 PM

[vBtise] MailChimp vBulletin Integration
 
1 Attachment(s)


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

pete_brady 09-05-2012 07:24 PM

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

pete_brady 09-05-2012 07:32 PM

oh and 'view cron log' throws this error:

Quote:

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 09-05-2012 08:55 PM

Quote:

Originally Posted by pete_brady (Post 2362978)
oh and 'view cron log' throws this error:

Just to confirm, I get the same error.

billrini 09-06-2012 07:14 PM

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

vbtise 09-07-2012 07:01 AM

Quote:

Originally Posted by pete_brady (Post 2362973)
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 09-07-2012 07:02 AM

Quote:

Originally Posted by billrini (Post 2363005)
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 09-07-2012 04:25 PM

How do you add additional merge fields?

vbtise 09-07-2012 05:31 PM

Quote:

Originally Posted by billrini (Post 2363412)
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.

pete_brady 09-07-2012 09:45 PM

Quote:

Originally Posted by vbtise (Post 2363287)
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.


All times are GMT. The time now is 10:45 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01091 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete