Solicitor in Order Import Utility

Former Member
Former Member $organization

 

Hi everyone,

 

I have been fighting all day with the Order Import Utility and need some help! I am getting an Error 0, Severity 0, State 0 error no matter what I try or do. After much searching, I have come up with an article that suggests that it has to do with the fact that I don’t have a solicitor in the import set, but when I try to add one the drop down is blank! I have solicitors and both user/solicitors set up in the system, and I can add solicitors to ticketing and contribution orders, but I can’t get anything in the import set.

 

Can anyone tell me what I’m missing? Please?

 

Thanks so  much!

 

Adrienne

 

Adrienne Steer | Patron Services Manager

Kitchener-Waterloo Symphony | kwsymphony.ca
Conrad Centre for the Performing Arts
36 King St W
 | Kitchener ON  N2G 1A3

519.745.4711 x 278  

asteer@kwsymphony.on.ca

 

 

 

Parents
  • Adrienne, the solicitor dropdown in the system table has a small defect, which is fixed in v10.1, but it can be remedied manually.  Support can help you through this if you don’t have access to do this or understand exactly what to do.

     

    The fix is to simply remove the value from the dddw_where column in T_REFERENCE_TABLES where the table_name = TR_IMPORT_ORDER_SET and the column_name = solicitor.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Adrienne Steer
    Sent: Thursday, December 08, 2011 5:37 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Solicitor in Order Import Utility

     

     

    Hi everyone,

     

    I have been fighting all day with the Order Import Utility and need some help! I am getting an Error 0, Severity 0, State 0 error no matter what I try or do. After much searching, I have come up with an article that suggests that it has to do with the fact that I don’t have a solicitor in the import set, but when I try to add one the drop down is blank! I have solicitors and both user/solicitors set up in the system, and I can add solicitors to ticketing and contribution orders, but I can’t get anything in the import set.

     

    Can anyone tell me what I’m missing? Please?

     

    Thanks so  much!

     

    Adrienne

     

    Adrienne Steer | Patron Services Manager

    Kitchener-Waterloo Symphony | kwsymphony.ca
    Conrad Centre for the Performing Arts
    36 King St W
     | Kitchener ON  N2G 1A3

    519.745.4711 x 278  

    asteer@kwsymphony.on.ca

     

     

     




    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!

Reply
  • Adrienne, the solicitor dropdown in the system table has a small defect, which is fixed in v10.1, but it can be remedied manually.  Support can help you through this if you don’t have access to do this or understand exactly what to do.

     

    The fix is to simply remove the value from the dddw_where column in T_REFERENCE_TABLES where the table_name = TR_IMPORT_ORDER_SET and the column_name = solicitor.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Adrienne Steer
    Sent: Thursday, December 08, 2011 5:37 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Solicitor in Order Import Utility

     

     

    Hi everyone,

     

    I have been fighting all day with the Order Import Utility and need some help! I am getting an Error 0, Severity 0, State 0 error no matter what I try or do. After much searching, I have come up with an article that suggests that it has to do with the fact that I don’t have a solicitor in the import set, but when I try to add one the drop down is blank! I have solicitors and both user/solicitors set up in the system, and I can add solicitors to ticketing and contribution orders, but I can’t get anything in the import set.

     

    Can anyone tell me what I’m missing? Please?

     

    Thanks so  much!

     

    Adrienne

     

    Adrienne Steer | Patron Services Manager

    Kitchener-Waterloo Symphony | kwsymphony.ca
    Conrad Centre for the Performing Arts
    36 King St W
     | Kitchener ON  N2G 1A3

    519.745.4711 x 278  

    asteer@kwsymphony.on.ca

     

     

     




    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!

Children
No Data