• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 49 views
  • Users 0 members are here
Related

Inserting Content Fields in bulk

Beau Vigushin (Past Member)
$organization

Hello,

Has anyone inserted content types and values to a group of performances using SQL? 

I'd love to insert the same content type with the same value to a group of shows (either by Season ID or Title ID) but Season Maintenance in the client doesn't cover this area, so thought maybe someone out there has used SQL to do it?

Beau.

  • $organization

    Yup. I do it all the time. Do you need an example?

  • $organization

    Ohh yes please – that would be wonderful! J

     

    From: Amanda Freeman [mailto:bounce-amandafreeman5080@tessituranetwork.com]
    Sent: Friday, 6 January 2012 09:22
    To: Beau Vigushin
    Subject: Re: [Tessitura Technical Forum] Inserting Content Fields in bulk

     

    Yup. I do it all the time. Do you need an example?

    From: Beau Vigushin <bounce-beauvigushin8188@tessituranetwork.com>
    Sent: 1/5/2012 4:19:08 PM

    Hello,

    Has anyone inserted content types and values to a group of performances using SQL? 

    I'd love to insert the same content type with the same value to a group of shows (either by Season ID or Title ID) but Season Maintenance in the client doesn't cover this area, so thought maybe someone out there has used SQL to do it?

    Beau.




    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!

  • $organization in reply to Beau Vigushin (Past Member)

    So for your example for every show in a certain season you might want to do this:

    INSERT INTO tx_inv_content( inv_no, content_type, value)

    Select p.prod_season_no, 1, 'yay content' --replace with your real content type and content value

     from t_prod_season p

    where p.season= 40--replace with whatever season

     

    or if you needed the content on the individual perfs this:

     

    INSERT INTO tx_inv_content( inv_no, content_type, value)

    Select p.perf_no, 1, 'yay content' --replace with your real content type and content value

     from t_perf p

    where p.season=40 --replace with whatever season

  • $organization in reply to A. Freeman

    Thank you Amanda!  I owe you a drink @TLCC2012 :)