Wednesday, February 08, 2012     | Register
Welcome to the Support Forums

In order to post to the support forums, you must be logged in as a registered user.


These forums are not moderated and may not be checked for a few days, so any important support issues should be emailed directly to support at orizonti.com for the fastest response.

Orizonti Forums
Subject: I aenhanced Newsletter

You are not authorized to post a reply.   
Author Messages
vb4hire2
Posts:2

3/09/2007 8:33 AM Alert 
Love the module and the price... just what I was looking for last year to send out announcements.

In the fall I updated the module for better unsubscribe.

Basically the problem with the original module is the record gets deleted and you cant see who requested to unsubscribe. There was also an active column that appeared unused.

I dug in and changed the sprocs so that they use the Active column.

The big win is that the data of those who unsubscribed can be queried.

1) when a person is added, Active = true.
2) SEND function now only sends to ACTIVE.
3) User clicking UNSUBSCRIBE, changes active flag to false, dropping them out of future sends.

This requires host access, as it is SQL Scripts. I basically scripted all the procs, and it can be run in the SQL window to update.

also.. to then see who unsubscribed, you can run a query like this...

select * from orizonti_newsletter_user
where active = 0
and moduleid = 704

to see who has unsubscribed.

As i said.. requires HOST access as I dont think the regular admin window has SQL access.

This is completely unsupported... Rstieb... what do you think about this? Interested in seeing my scripts to see if they can be incorporated into the core product? (puttin ya on the spot, aren't I!?)


This has been running since october of last year for me.. and so far no problems!

(Another item... I also loaded in bulk data by generating insert statements in Excel and running them in the SQL window also... again.. completely unsupported and risky.. but it does work. I loaded up 600 names from a club list in a matter of minutes)

the bulk sign-up, and unsubscribe report would be nice to have with an interface!
rstieb
Posts:738

3/13/2007 9:14 AM Alert 
Nice work...

This is something I've been looking at and just haven't had the time... I've got several "enhancements" I'd like to get to with the module, just not enough hours in the day...

I'd love to take a look at what you've done and possibly include it into the module... You can email me directly at rstieb at orizonti.com...

Thanks,
Russel
You are not authorized to post a reply.
Forums > Orizonti DNN Module Support > Newsletter > I aenhanced Newsletter



ActiveForums 3.6
Copyright (c) 2012 Orizonti Group Inc.   |  Privacy Statement  |  Terms Of Use