Adding constituent interests enmasse

Hi,

I would like to add an interest to a specific list of people. There isn't a standard report that does this and I was wondering if anyone has gone through this process in the past.

Brenda

Parents Reply Children
  • I did this when we went live with our new website and needed to move information from a custom screen to the actual Interest screen. As Jon says it was a case of getting the customers into a list or temp table and then doing an insert into tx_cust_tkw

  • Hi Jon,
     
    Thank you for the advice.
     
    Brenda


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, 23 February 2010 11:47 PM
    To: Brenda Fehlberg
    Subject: Re: [Tessitura Technical Forum] Adding constituent interests enmasse

    Hello,

    The table that holds the customer interestes is TX_CUST_TKW.  You write sql code to add or remove interestes to customers.  Thats is what we did when we wanted to add a new interest to a group of customers.

     

    Jon

    From: Brenda Fehlberg <bounce-brendafehlberg2154@tessituranetwork.com>
    Sent: 2/22/2010 10:20:16 PM

    Hi,

    I would like to add an interest to a specific list of people. There isn't a standard report that does this and I was wondering if anyone has gone through this process in the past.

    Brenda




    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!