• Replies 10 replies
  • Subscribers 415 subscribers
  • Views 69 views
  • Users 0 members are here
Related

Constituent DELETED?!

Paul White
$organization

Hello there,

I've raised two tickets today so I thought that I'd throw issue number three out to everyone else instead!

A colleague was updating address details on a Constituent and got an error. They clicked 'okay' or whatever was on the window that popped up and now when we try to find the Constituent we get 'There were no records matching the given criteria'.

We've tried searching for account number, address etc but cannot access the account on Tess. Yet in SQL we can see it if we run a script on either of the below:

SELECT

 

* FROM T_ADDRESS where customer_no = 99217
SELECT * FROM T_CUSTOMER where customer_no = 99217

A bit odd isn't it?

Paul.

 

 

  • $organization


    It is worth checking to see if the customer has a default Salutation (TX_CUST_SAL).  If the customer doesn’t have one then they won’t appear in the search results.

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Paul White
    Sent: 05 September 2011 15:07
    To: Nick Insell
    Subject: [Tessitura Ticketing Forum] Constituent DELETED?!

     

    Hello there,

    I've raised two tickets today so I thought that I'd throw issue number three out to everyone else instead!

    A colleague was updating address details on a Constituent and got an error. They clicked 'okay' or whatever was on the window that popped up and now when we try to find the Constituent we get 'There were no records matching the given criteria'.

    We've tried searching for account number, address etc but cannot access the account on Tess. Yet in SQL we can see it if we run a script on either of the below:

    SELECT

     

    * FROM T_ADDRESS where customer_no = 99217
    SELECT * FROM T_CUSTOMER where customer_no = 99217

    A bit odd isn't it?

    Paul.

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
  • $organization in reply to Nick Insell

    I've just looked and they are showing up twice on TX_CUST_SAL. Would that be the issue?

  • $organization in reply to Paul White

    Do either of the salutations in tx_cust_sal have default_ind=Y? If neither do, then that's probably the issue.

  • $organization in reply to A. Freeman

    One of them does (the older one) and the other one doesn't.

  • $organization

    I’ve also had it happen once or twice that the t_customer value for primary_address_no wasn’t referring to an active, existing value in t_address. The Tess client doesn’t like that.

     

    Lucie

     

    ________________

    Lucie Spieler

    IT Development and Training Manager

    Florida Grand Opera

    8390 NW 25th Street

    Miami, FL 33122

    305-854-1643 ext 1521

    www.FGO.org

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nick Insell
    Sent: Monday, September 05, 2011 10:42 AM
    To: Lucie Spieler
    Subject: RE: [Tessitura Ticketing Forum] Constituent DELETED?!

     

     

    It is worth checking to see if the customer has a default Salutation (TX_CUST_SAL).  If the customer doesn’t have one then they won’t appear in the search results.

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Paul White
    Sent: 05 September 2011 15:07
    To: Nick Insell
    Subject: [Tessitura Ticketing Forum] Constituent DELETED?!

     

    Hello there,

    I've raised two tickets today so I thought that I'd throw issue number three out to everyone else instead!

    A colleague was updating address details on a Constituent and got an error. They clicked 'okay' or whatever was on the window that popped up and now when we try to find the Constituent we get 'There were no records matching the given criteria'.

    We've tried searching for account number, address etc but cannot access the account on Tess. Yet in SQL we can see it if we run a script on either of the below:

    SELECT

     

    * FROM T_ADDRESS where customer_no = 99217
    SELECT * FROM T_CUSTOMER where customer_no = 99217

    A bit odd isn't it?

    Paul.

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • Former Member
    Former Member $organization in reply to Paul White

    Hi Paul

    Check the teh INACTIVE flag for that customer,

     Select Customer_No, fname, lname, Inactive from T_Customer where Custoemr_no = 99217

    If Inactive = 5 then that means it is Merged with other id. If you still want to keep that ID then update the Inactive flag to 1. Merged accounts don't appear in the selection!!

    cheers, Varsha

  • $organization in reply to Former Member

    Hi Varsha,

    Usually if an account is merged there's a pop-up giving details of the account it was merged into. I'm just getting 'There were no accounts matching the given criteria.'. It's like Tessitura has forgotten it. I'm sure it's fine - we'll just create a new account for her, it's just weird that I can see it in SQL but not on Tessitura.

  • $organization in reply to Paul White

    It sounds basic but did you check to make sure that you have all 3 Types (individual, Organization, Contacts) checked on your search screen?  Also check to make sure you don't have a filter in effect on your search screen.

    Dale

  • $organization in reply to Dale Aucoin

    Hi everyone,

    Ben sent me some SQL code to run which updated the primary address and it has sorted it. Thanks Ben! And thanks to everyone here for suggestions etc.

    Paul.

  • $organization

    When checking in SQL, make sure you are also looking at the primary_address_no,

     

    SELECT

        *

    FROM

        dbo.T_CUSTOMER AS c

        JOIN dbo.T_ADDRESS AS a ON c.customer_no = a.customer_no AND

                                   c.primary_address_no = a.address_no

    WHERE

        a.customer_no = ####

     

     

    I believe Lucie was also pointing you in this direction.

     

     

    Marty Jones

    Director of Information Services

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469

    Marty.Jones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Paul White
    Sent: Tuesday, September 06, 2011 3:57 AM
    To: Martin A. Jones
    Subject: RE: [Tessitura Ticketing Forum] Constituent DELETED?!

     

    Hi Varsha,

    Usually if an account is merged there's a pop-up giving details of the account it was merged into. I'm just getting 'There were no accounts matching the given criteria.'. It's like Tessitura has forgotten it. I'm sure it's fine - we'll just create a new account for her, it's just weird that I can see it in SQL but not on Tessitura.

    From: Varsha Karnik <bounce-varshakarnik2805@tessituranetwork.com>
    Sent: 9/5/2011 11:12:34 PM

    Hi Paul

    Check the teh INACTIVE flag for that customer,

     Select Customer_No, fname, lname, Inactive from T_Customer where Custoemr_no = 99217

    If Inactive = 5 then that means it is Merged with other id. If you still want to keep that ID then update the Inactive flag to 1. Merged accounts don't appear in the selection!!

    cheers, Varsha




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!