Newsletter Builder not sending mails

5 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: April 5, 2013   (RSS)

By ht1080z - March 31, 2013

Hello,

We trying to use the Newsletter Builder plugin and with defaults try to send for subscribers newsletter but the plugin not working.

For test users the mails are sent and received but for Subscribers not at all.

In the Messages i can see Sending (0 of 2) and nothing after.

We purchased the plugin month ago but never tried to use in action.

This is a very urgent request. please reply ASAP.

The plugin updated to 2.03, CMSB is version 2.51

I sent to support@interactivetools.com details about the server.

Please advise,

Karls

By ht1080z - April 1, 2013

Hello Dave,

Thank you for your quick reply and your instructions. The plugin working fine.

We managed to modify the plugin sending to subscriber groups (with added fields on the table _nlb_subscribers and _nlb_messages and creating a new table 'groups' also modifying the newsletterBuilder.php)

The modification working fine with counted sent records per groups and validation with error messages on the 'messages' section as well.

The last thing we want to create now is the subscriber import. We have the purchased CSV import plugin but this tools cannot see the 'system' _nlb_subscribers table.

Can we just modify the csv import plugin to work with the _nlb_subscribers table or rename the subscriber table and change all the affected lines in the newsletterBuilder.php and background-mailer.php? What you suggest?

Also the 'authkey' (that the embedded import utility fills during import with generated keys) is important why? It is required for unsubscribing?

Please advise,
Karls

By Dave - April 2, 2013

Hi Karls, 

So it sounds like you've got the first issue resolved and some additional questions and custom modifications to the plugin.

We can't promise to always been able to provide support or feedback on custom modifications, but here's some info:

We have the purchased CSV import plugin but this tools cannot see the 'system' _nlb_subscribers table.

Try commenting out this line in csvImport.php to show "system" tables that start with an underscore:

if ($tablename[0] == '_') { continue; }

Can we just modify the csv import plugin to work with the _nlb_subscribers table or rename the subscriber table and change all the affected lines in the newsletterBuilder.php and background-mailer.php? What you suggest?

It's going to be a bit tricky and require some debugging.  Ideally the less changes the less likely of breaking something else and less testing required.  If you can use the existing "_nlb_subscribers" table I'd try that first as it might be easiest.  Just make the the subscriber "num" doesn't change each time you re-import.

Also the 'authkey' (that the embedded import utility fills during import with generated keys) is important why? It is required for unsubscribing?

The confirm subscription, unsubscribe, and link tracking all use URLs with the users subscriber "num" in the url to identify them.  To prevent someone from faking a request from a different user "num" we require them to also submit the value in "authkey" with is a randomly generated string.  It's basically like a secret password to prevent people from hacking together fake links to pretend to take actions on the behalf of other users.

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com

By ht1080z - April 5, 2013

Hi Dave,

Thank you for your advise!

Karls