• Replies 8 replies
  • Subscribers 415 subscribers
  • Views 123 views
  • Users 0 members are here
Related

Populating Season Manager

Dan Grossman
$organization

State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg

Parents
  • Former Member
    Former Member $organization

    Dan,

     

    Do you have the “Select Date View” radio buttons set properly at the bottom?  (I have to ask – this gets people confused here).

     

     -steve carlock

    Information Technology Manager

    The Granada

    jsc@granadasb.org

    (805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

    (805) 899-3002 (fax)

    (562) 239-7075 (cell)

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Dan Grossman
    Sent: Wednesday, January 06, 2010 12:31 PM
    To: Steve Carlock
    Subject: [Tessitura Ticketing Forum] Populating Season Manager

     

    State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 Former Member

    Select access order is by event

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Steve Carlock
    Sent: Wednesday, January 06, 2010 3:46 PM
    To: dgrossman@statetheatrenj.org
    Subject: RE: [Tessitura Ticketing Forum] Populating Season Manager

     

    Dan,

     

    Do you have the “Select Date View” radio buttons set properly at the bottom?  (I have to ask – this gets people confused here).

     

     -steve carlock

    Information Technology Manager

    The Granada

    jsc@granadasb.org

    (805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

    (805) 899-3002 (fax)

    (562) 239-7075 (cell)

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Dan Grossman
    Sent: Wednesday, January 06, 2010 12:31 PM
    To: Steve Carlock
    Subject: [Tessitura Ticketing Forum] Populating Season Manager

     

    State Theatre in New Brunswick here...We are having an issue with getting our newly formed 2011 season to populate in the season manager. The season is set up and we are selling tickets successfully, but no data for the fiscal year or the season is populating in the season manager. Any thoughts on how to remedy this? Please advise and thanks, dg




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 Dan Grossman

    Turns out, the SQL job updating every night was using a flavor of trying to update without having to specify a string of seasons, but there was some faulty logic that was causing it not to get this latest season.  Since State Theatre is on RAMP I went ahead and put in the code below that the RAMP team uses, and it did the trick:

    /* EIS Update Script - Copy from here to End of Script line */
    --runs in "Full" scope

    declare @id as int
    declare @season as varchar(300)

    set @season = ''

    declare ACTIVE_SEASONS INSENSITIVE cursor for
                select id from [dbo].[tr_season] (NOLOCK)
                where inactive = 'N'
    FOR READ ONLY

    open ACTIVE_SEASONS
    fetch next from ACTIVE_SEASONS into @id

    while @@fetch_status = 0
                begin
                set @season = @season + convert(varchar(5),@id) + ','
                fetch next from ACTIVE_SEASONS into @id         
                end

    close ACTIVE_SEASONS
    deallocate ACTIVE_SEASONS

    --trim trailing comma off
    set @season = substring(@season,1,len(@season)-1)

    exec EIS_IMP_CHANGED_LOAD_NEW @scope = 'F', @season_str = @season, @include_resold = 'Y'
    /* End of Script line */

Reply
  • $organization in reply to Dan Grossman

    Turns out, the SQL job updating every night was using a flavor of trying to update without having to specify a string of seasons, but there was some faulty logic that was causing it not to get this latest season.  Since State Theatre is on RAMP I went ahead and put in the code below that the RAMP team uses, and it did the trick:

    /* EIS Update Script - Copy from here to End of Script line */
    --runs in "Full" scope

    declare @id as int
    declare @season as varchar(300)

    set @season = ''

    declare ACTIVE_SEASONS INSENSITIVE cursor for
                select id from [dbo].[tr_season] (NOLOCK)
                where inactive = 'N'
    FOR READ ONLY

    open ACTIVE_SEASONS
    fetch next from ACTIVE_SEASONS into @id

    while @@fetch_status = 0
                begin
                set @season = @season + convert(varchar(5),@id) + ','
                fetch next from ACTIVE_SEASONS into @id         
                end

    close ACTIVE_SEASONS
    deallocate ACTIVE_SEASONS

    --trim trailing comma off
    set @season = substring(@season,1,len(@season)-1)

    exec EIS_IMP_CHANGED_LOAD_NEW @scope = 'F', @season_str = @season, @include_resold = 'Y'
    /* End of Script line */

Children
No Data