• Replies 31 replies
  • Subscribers 340 subscribers
  • Views 997 views
  • Users 0 members are here
Related

Temporary Logins

Carole Lipscombe
$organization

Hi 

We want to be able to automatically generate a temporary login when a new constituent is created in the client.  I see from past discussions that people have tackled this issue, does anyone have a solution they would be prepared to share with us

Thanks

Carole

Parents
  • $organization
    Hi Sara
     
    You are most welcome to a copy.
     
    I hope this stored procedure helps…you may need to tinker with it for your particular set up.
     
    I wish I could say it stopped customers creating duplicate accounts, but they regularly seem to forget which email address they used and set up a new account. One thing we have noticed recently,  is that when customers change their contact email address this does not automatically create a new login account, so when they attempt to login with the new email address, they end up creating a new account (at least on cursory glance I believe that is what is happening).
     
    The stored procedure is set up to create a temporary login for all constituents or, for a specific constituent by passing in a customer_no.  We had originally planned to use the latter method when updating a constituent record in the Tessitura client but that resulted in all sorts of difficulties so we abandoned that idea, but I would suggest passing in a customer_no for testing purposes.
     
    When we were happy with the results in test, we ran the procedure once for all constituents. Be aware that depending on the size of your database, this might take some time.  Thereafter, we have scheduled this nightly as a scheduled job and have been running it successfully since early November creating temporary logins for any new constituents who have been added during the working day (of course, it ignores inactive constituents and those without an email address)
     
     
    In SSRS:
     
    USE [impresario]
    GO
     
    DECLARE @return_value int
     
    EXEC  @return_value = [dbo].[LP_GPO_CREATE_TEMP_LOGIN]<optional customer_no>
     
    SELECT 'Return Value' = @return_value
     
    GO
     
    By all means come back to me if you have any queries, good luck
     
    Carole
     
     
Reply
  • $organization
    Hi Sara
     
    You are most welcome to a copy.
     
    I hope this stored procedure helps…you may need to tinker with it for your particular set up.
     
    I wish I could say it stopped customers creating duplicate accounts, but they regularly seem to forget which email address they used and set up a new account. One thing we have noticed recently,  is that when customers change their contact email address this does not automatically create a new login account, so when they attempt to login with the new email address, they end up creating a new account (at least on cursory glance I believe that is what is happening).
     
    The stored procedure is set up to create a temporary login for all constituents or, for a specific constituent by passing in a customer_no.  We had originally planned to use the latter method when updating a constituent record in the Tessitura client but that resulted in all sorts of difficulties so we abandoned that idea, but I would suggest passing in a customer_no for testing purposes.
     
    When we were happy with the results in test, we ran the procedure once for all constituents. Be aware that depending on the size of your database, this might take some time.  Thereafter, we have scheduled this nightly as a scheduled job and have been running it successfully since early November creating temporary logins for any new constituents who have been added during the working day (of course, it ignores inactive constituents and those without an email address)
     
     
    In SSRS:
     
    USE [impresario]
    GO
     
    DECLARE @return_value int
     
    EXEC  @return_value = [dbo].[LP_GPO_CREATE_TEMP_LOGIN]<optional customer_no>
     
    SELECT 'Return Value' = @return_value
     
    GO
     
    By all means come back to me if you have any queries, good luck
     
    Carole
     
     
Children
No Data