Create Temp Logins

Katie,

 

You are my hero, I would love to see the infomaker report and xml!

 

Thank you, thank you, thank you!

 

Thank you have a good day!

Naomi Williams

 

Hi Naomi,

I created a utility to create temporary web logins for subscribers in the given year if they don't already have one. The password is set to the first 5 digits of the postal code on their primary address. The procedure also creates a blank email address for the constituent if they don't have a valid email address.

I should point out that my version assumes there's an email type that starts with "General (" in TR_EADDRESS_TYPE, but that can easily be changed.

I posted the sp to my profile, but let me know if you want to take a look at the Infomaker report and xml so that it can be run directly from Tessitura.

~Katie

Hi Naomi, you can modify and call the following script in a loop to create temporary logins for a bunch of customers.  In the example below the script creates temporary login for customer no 549704, if it does not exist already, and with a login name equal to customer no and password equal to ‘Dance’ + any random number.  You can modify the script to suit your needs and call in a loop with the customer no(s) you want to create temporary login(s) for.  Please, try it on your test database first.

 

DECLARE @login_no INT,

      @customer_no INT,

      @login VARCHAR(80),

      @password VARCHAR(32)

 

--Assumption:

--n1n2_ind: Both (3)

--login_type: Web (1)

--login: same as customer_no

--Password: 'Dance'+ a randomly generated number

--Associated email address: none (0)

 

--Call the following in a loop

SET @customer_no=549704

SET @login=CONVERT(VARCHAR,@customer_no)

SET @password='Dance'+CONVERT(VARCHAR,ROUND(RAND()*1000,0))

 

--SELECT @login_no

IF NOT EXISTS (SELECT login_no FROM t_cust_login WHERE customer_no=@customer_no AND login=@login)

      BEGIN

            EXEC @login_no=AP_GET_NEXTID_FUNCTION @type = 'LO'

            INSERT INTO t_cust_login ( login_no, customer_no, n1n2_ind, login_type, login, password, eaddress_no, inactive, primary_ind, temporary_ind )

                  VALUES ( @login_no, @customer_no, 3, 1, @login, @password, 0, 'N', 'N', 'Y' )

      END

 

 

Hope this helps,

 

Mo

 

 

Folks I need some help. I need to create a bunch of temporary logins for our new season but don't have a clue as to how to do it. I read the forums and it points to the API harness but when I went there it just seemed to do load testing. Any idea how I can create a bunch of temporary logins?

 

Naomi

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!

Catherine,

 

I cannot even view your profile for some reason, anyway you can email me the zip file, nwilliams@tpac.org?

 

Thank you have a good day!

Naomi Williams

 

Hi Naomi,

I zipped up the proc, xml, and pbl and posted it to my profile as LP_CREATE_TEMP_LOGINS.zip.

Have fun!

~Katie