• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 7 views
  • Users 0 members are here
Related

Swapping N1 and N2 names and field formatting

Former Member
Former Member $organization

Hi:

I have a large number of corporate contacts currently listed in the N1 fields, and the company name in the N2 field (one long field).  I want to swap the names, where the person is listed in several fields in N2 and the company name is listed in one field in N1 (opposite of what it is now).  I can  easily swap the names with SQL, but how to do I change the format of N1 and N2?

 

James

  • $organization

    TR_CUST_TYPE contains the n1n2 formattings for various cust types. Having said that, it might not be worth the effort to flip them around. I'm pretty sure this will be a moot point come v11.

  • Former Member
    Former Member $organization
    I agree with Amanda about probably not being worth the effort, given v11 changes, but if you do want to change them, you should just convert them from Corporate Contact type to Organisation type constituenti.
    That will have consequences for how they convert to the New Model, of course, so you need to think that through
    Ken
    Ken McSwain :: sent from the Blackberry
     
    From: Amanda Freeman [mailto:bounce-amandafreeman5080@tessituranetwork.com]
    Sent: Wednesday, October 26, 2011 07:29 AM
    To: Ken McSwain
    Subject: Re: [Tessitura Technical Forum] Swapping N1 and N2 names and field formatting
     

    TR_CUST_TYPE contains the n1n2 formattings for various cust types. Having said that, it might not be worth the effort to flip them around. I'm pretty sure this will be a moot point come v11.

    From: James Fairfield <bounce-jamesfairfiled8203@tessituranetwork.com>
    Sent: 10/25/2011 3:13:45 PM

    Hi:

    I have a large number of corporate contacts currently listed in the N1 fields, and the company name in the N2 field (one long field).  I want to swap the names, where the person is listed in several fields in N2 and the company name is listed in one field in N1 (opposite of what it is now).  I can  easily swap the names with SQL, but how to do I change the format of N1 and N2?

     

    James




    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!
    Explore the 2012 season at aco.com.au/season2012

    This email is confidential. If you are not the intended recipient you must not disclose or use the information contained in it. If you have received this email in error please notify us immediately by return email and delete the document. The ACO is not responsible for any changes made to a document other than those made by the ACO or for the effect of the changes on the document's meaning. The ACO accepts no liability for any damage caused by this email or its attachments due to viruses interference, interception, corruption or unauthorised access.