Moving Source Codes to a different Appeal

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
    The source code selected when an order or contribution is created determines the appeal that will be associated with the order or gift; and the source code selected when a payment is entered determines the appeal that is associated with the transaction.  If you move a source code that has been used in ticket orders or contributions to another appeal "in the backend" then the new source/appeal association will not match what has been written to the database for the already processed transactions.
     
    Bob


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kim Lee
    Sent: Sunday, January 17, 2010 8:17 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

    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

     




    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
    The source code selected when an order or contribution is created determines the appeal that will be associated with the order or gift; and the source code selected when a payment is entered determines the appeal that is associated with the transaction.  If you move a source code that has been used in ticket orders or contributions to another appeal "in the backend" then the new source/appeal association will not match what has been written to the database for the already processed transactions.
     
    Bob


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kim Lee
    Sent: Sunday, January 17, 2010 8:17 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] Moving Source Codes to a different Appeal

    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

     




    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