I'm looking for anyone who has implemented solution 91 in TASK: Web Login Username Assignment Report (Shared Reports) or something similar to it.
Specifically I'm wondering about the initial assignment of logins to everyone (who has an email address), and the corresponding automatically sent emails. I'm looking for tips, thoughts, advice, ways to avoid ending up flagged as a spammer because of the large number of emails associated with that process.
Amanda,
We're (finally!) close to going live with our online ticketing, and I'm in the process of writing our version of that code. What we are doing is setting up the initial logins to all of our individual constituents that we have an email address for (about 5000), then sending them an email using a E-Mailing List service (Constant Contact) as a personalized e-blast.
Once we get everything up and running I'll turn my code into a SQL job that runs a couple times a day to generate logins for any new email addresses we get from the Box Office or Development and sends them a simple text email with their userid (their email address) and a temporary password.
I'm happy to email you the code I'm using right now and I'll try to remember to post it to my files section here once I clean it up for production.
-steve
Thanks for the offer. I've actually got a procedure tested and working the way we want it to (including the email part, tested on a test db with only 4 email addresses in it). The powers that be were hoping there'd be a solution that would allow us to use the automated dbmail for the initial eblast as well, rather than using the outside service we usually use. But I had a feeling we might need to end up using the service for the big one.
I wasn’t able to (and didn’t really want to) figure out how to generate a personalized HTML email from SQL using ap_send_smtp_email. (Now, if I had easy access to Perl from a stored procedure it would be a much different story…maybe nextgen will give us access to additional tools like Perl for things like this.) That was the driving factor to use our outside service for the initial rollout. We’re going to send a simple personalized text email for the one-offs moving forward.
We also figured that using our existing outside service was quicker and easier than having to deal with our ISP and email service provider to send an email blast from our server.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Wednesday, July 08, 2009 9:37 AM To: Steve Carlock Subject: Re: [Tessitura Technical Forum] Auto-assigning usernames and auto-emailing logins
From: Steve Carlock <bounce-stevecarlock1071@tessituranetwork.com> Sent: 7/7/2009 7:23:43 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!