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

    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
Reply
  • $organization

    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
Children
No Data