Moving Source Codes to a different Appeal

This is great Bob, I think we’ve got all bases covered now. There are no contributions/ticketing transactions connected to the sources we want to move on this occasion but will be useful for future reference.

Cheers,

Brian

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

Many thanks Amanda.

Brian

I've done that numerous times without ill effect.

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!

This is great Bob, I think we’ve got all bases covered now. There are no contributions/ticketing transactions connected to the sources we want to move on this occasion but will be useful for future reference.

Cheers,

Brian

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

Many thanks Amanda.

Brian

I've done that numerous times without ill effect.

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!