• Replies 11 replies
  • Subscribers 337 subscribers
  • Views 323 views
  • Users 0 members are here
Related

Moving Source Codes to a different Appeal

Kim Lee
$organization

Hi there,

I have been asked to move some Source Codes to a different Appeal, and was wondering if this is possible, and if anyone has done something similar in the past and has any advice?

My initial investigation suggests that the appeal_no in TX_APPEAL_MEDIA_TYPE and T_PROMOTION would need to be updated for those Source Codes. 

Cheers

Kim

 

Parents
  • Former Member
    Former Member $organization

    Brian, while the SQL you point to will move the source from one appeal to another and update promotion history for the source, if the source code has been used for Ticket Orders, Contributions or payments prior to moving it from its original appeal to another one, the source_no/appeal_no association will be incorrect in the existing T_ORDER, T_CONTRIBUTION and T_TRANSACTION rows.  This points out the caveats of doing backend updates in SQL. 

     

    This code will display all of the tables where the appeal_no column is present in hopes it may be helpful to you.

     

    select o.name, c.name    --, c.column_name

    from sysobjects o join syscolumns c on o.id = c.id

    where c.name like 'appeal_no%'  order by o.name

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Kerr
    Sent: Friday, September 16, 2011 4:07 AM
    To: Robert Bell
    Subject: RE: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

     

    Many thanks Amanda.

     

    Brian

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: 15 September 2011 16:46
    To: Brian Kerr
    Subject: RE: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

     

    I've done that numerous times without ill effect.

    From: Brian Kerr <bounce-briankerr2249@tessituranetwork.com>
    Sent: 9/15/2011 5:16:48 AM

    Hello again Bob, we've taken onboard advice on the post (thanks also Kim) and checked on our Test system, it looks like we can run the following  which will move the source from one appeal to another and Update the Constituents 'communications' history
    UPDATE TX_APPEAL_MEDIA_TYPE
    SET appeal_no = 214
    WHERE appeal_no = 641
    AND source_no = 6000

    UPDATE T_PROMOTION
    SET appeal_no = 214
    WHERE appeal_no = 641
    AND source_no = 6000

    Do you know if anyone has done the two together before?

    Cheers,

    Brian

     




    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!

    This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Any views or opinions presented or expressed are those of the author(s) and do not necessarily represent those of the Royal Opera House. If you are not the intended recipient you may not use, disseminate, forward, print or copy this e-mail, but please notify the sender that you have received it in error. Royal Opera House, Covent Garden, London WC2E 9DD Tel: 0207 240 1200 Registered in England No. 480523 Charity Registered No. 211775




    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
  • Former Member
    Former Member $organization

    Brian, while the SQL you point to will move the source from one appeal to another and update promotion history for the source, if the source code has been used for Ticket Orders, Contributions or payments prior to moving it from its original appeal to another one, the source_no/appeal_no association will be incorrect in the existing T_ORDER, T_CONTRIBUTION and T_TRANSACTION rows.  This points out the caveats of doing backend updates in SQL. 

     

    This code will display all of the tables where the appeal_no column is present in hopes it may be helpful to you.

     

    select o.name, c.name    --, c.column_name

    from sysobjects o join syscolumns c on o.id = c.id

    where c.name like 'appeal_no%'  order by o.name

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Kerr
    Sent: Friday, September 16, 2011 4:07 AM
    To: Robert Bell
    Subject: RE: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

     

    Many thanks Amanda.

     

    Brian

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: 15 September 2011 16:46
    To: Brian Kerr
    Subject: RE: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

     

    I've done that numerous times without ill effect.

    From: Brian Kerr <bounce-briankerr2249@tessituranetwork.com>
    Sent: 9/15/2011 5:16:48 AM

    Hello again Bob, we've taken onboard advice on the post (thanks also Kim) and checked on our Test system, it looks like we can run the following  which will move the source from one appeal to another and Update the Constituents 'communications' history
    UPDATE TX_APPEAL_MEDIA_TYPE
    SET appeal_no = 214
    WHERE appeal_no = 641
    AND source_no = 6000

    UPDATE T_PROMOTION
    SET appeal_no = 214
    WHERE appeal_no = 641
    AND source_no = 6000

    Do you know if anyone has done the two together before?

    Cheers,

    Brian

     




    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!

    This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Any views or opinions presented or expressed are those of the author(s) and do not necessarily represent those of the Royal Opera House. If you are not the intended recipient you may not use, disseminate, forward, print or copy this e-mail, but please notify the sender that you have received it in error. Royal Opera House, Covent Garden, London WC2E 9DD Tel: 0207 240 1200 Registered in England No. 480523 Charity Registered No. 211775




    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