We're using a SP that I downloaded long ago from shared reports which was provided by the Flynn Center, but I believe there are many organizations using a similar logic to generate temporary web logins in T_CUST_LOGIN. The script finds new cust records and adds a username and temp password where one doesn't exist, using the primary email as a login if there is one.
I have questions and concerns for how this script should be modified with regard to Households, and for Individuals created as a result of converting to households. Should we let the script include the household cust type, and the individual type? Is there any harm in doing so?
Has anyone out there modified their temp web login script for version 11, and if so what were the changes and the reasons for changing them?
Thanks!
Michael
Chiming in here…
The script has the following variables. Since it is pulling from the customer type…this might not be an issue. Am I missing something?
select left(replace( lower( left(a.fname, 1) +
a.lname), ' ', '' ), 7 ),
a.customer_no, b.eaddress_no from T_CUSTOMER as a,
T_EADDRESS as b
WHERE b.customer_no = a.customer_no --AND b.primary_ind = 'Y' (9/23/08 removed primary indicator variable. Logins will now be created for all email addresses.)
AND a.inactive = 1 --AND b.inactive = 'N' (9/23/08 Removed inactive emails. Now the system will assign logins to all emails - both active and inactive)
AND b.address <> ''
AND IsNull (b.mail_purposes, '7') not like '1%' --added by GJO on 12/3/04, excludes auto-email
AND IsNull(mail_purposes,'') not like '%7%' --added by GJO on 02/26/09, excludes hard bounces
and cust_type = 1 -- allow individuals
AND a.customer_no <> 289383 --mail2 account 3/14/12
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nicholas Hudson-Ellis Sent: Monday, September 24, 2012 7:54 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] "Create Temp Logins" scripts and v11
Hi Michael,
Did you have any luck with this? My organisation is looking into implementing one of the shared stored procedures for creating temp logins, and we are also in the middle of our v11 migration.
Best,
Nicholas
From: Michael Reisman <bounce-michaelreisman4888@tessituranetwork.com> Sent: 3/27/2012 10:09:34 AM
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!