Deleting promotion and source that has been used

Hi John,

Thanks for the suggestion but unfortunately I had already tried removing the source from the order and ran the Delete Promotions and Sources utility in our test environment, and it failed and returned a database error because I was trying to delete both the promotions and source.  But your suggestion did give me the idea to try deleting just the promotions and not worry about the source and that works fine.  I can live with just making the source itself inactive and not deleting it.

Cheers

Sarah

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Moskal II
Sent: Friday, 4 December 2015 2:59 AM
To: scoffey@sydneytheatre.com.au
Subject: Re: [Tessitura Technical Forum] Deleting promotion and source that has been used

I have never tried to delete promotions, but you can always change the source number on the offending order by going through the constituent.  Possibly once the source number from that order has been changed you could delete the promotion.

Good luck!

We have a source that has been incorrectly created and promoted (from WordFly).  Unfortunately before this was realised it was selected as the source for an order, which means that I am unable to use the Delete Promotions and Sources utility to remove the promotions and the source.

Has anyone successfully deleted promotions & source once they have already been used and have any tips on the best way to go about it/ gotchas to look out for?

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!

Hi John,

Thanks for the suggestion but unfortunately I had already tried removing the source from the order and ran the Delete Promotions and Sources utility in our test environment, and it failed and returned a database error because I was trying to delete both the promotions and source.  But your suggestion did give me the idea to try deleting just the promotions and not worry about the source and that works fine.  I can live with just making the source itself inactive and not deleting it.

Cheers

Sarah

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Moskal II
Sent: Friday, 4 December 2015 2:59 AM
To: scoffey@sydneytheatre.com.au
Subject: Re: [Tessitura Technical Forum] Deleting promotion and source that has been used

I have never tried to delete promotions, but you can always change the source number on the offending order by going through the constituent.  Possibly once the source number from that order has been changed you could delete the promotion.

Good luck!

We have a source that has been incorrectly created and promoted (from WordFly).  Unfortunately before this was realised it was selected as the source for an order, which means that I am unable to use the Delete Promotions and Sources utility to remove the promotions and the source.

Has anyone successfully deleted promotions & source once they have already been used and have any tips on the best way to go about it/ gotchas to look out for?

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!