creating renewal forms without Infomaker

We do not have infomaker installed on our server, and I am just a Box Office manager. We do not have an IT staff person. I need to pull data for renewal forms from the rollovers I created. Does anyone know of a way to get all of the necessary data out in one report? Last year I pulled the order info and the constituent info separately, then did a merge in Excel. That process is very involved and it seems there should be an easier way. Any suggestions would be greatly appreciated.

Thank you.

-dennis

 

Parents
  • Dennis,

     

    Also make sure that in TR_Season, your Renewal Notice Format  has (d_report_renewal) for your current season that you are rolling over.

     

     

    Thanks,

    Bobby Moseley

    601 Preston

    Houston, TX 77002

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Dennis Keefe
    Sent: Friday, January 06, 2012 3:02 PM
    To: Moseley, Bobby
    Subject: RE: [Tessitura Ticketing Forum] creating renewal forms without Infomaker

     

    I just tried saving to excel, and all get is some seat numbers in the seat columns, but there is no other data there.

    My D_Object is: d_report_renewal.

     

    WE do not have Infomaker, so if this an infomaker report, that eplains why I can’t get the data.

     

     

     dkeefe_signature

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin Sheehan
    Sent: Friday, January 06, 2012 11:57 AM
    To: dkeefe@balletsj.org
    Subject: RE: [Tessitura Ticketing Forum] creating renewal forms without Infomaker

     

    Hi Dennis,

     

    What you want is the data behind what you see on the screen, so generally it doesn’t matter what it’s showing (but what you describe does sound a little odd).  Renewal notices always select the same set of data, but they don’t always display all that data.  When you save the output to Excel though, you will get all the data, even if some of that data isn’t displayed on the screen.  So try saving the output to Excel and see what you get.

     

    If you don’t get the data you want when you do that, look in the T_FORMAT_INFO table and tell me what is in the D_Object column for the row for the renewal notice format you are using when you run the Renewal Notices report.

     

    And here are three links to topics in the new online help system that explain renewal notices:

    Renewal Notice Formats

    Renewal Notice Data Fields

    Subs Renewal Notices Report

     

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     




    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!

Reply
  • Dennis,

     

    Also make sure that in TR_Season, your Renewal Notice Format  has (d_report_renewal) for your current season that you are rolling over.

     

     

    Thanks,

    Bobby Moseley

    601 Preston

    Houston, TX 77002

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Dennis Keefe
    Sent: Friday, January 06, 2012 3:02 PM
    To: Moseley, Bobby
    Subject: RE: [Tessitura Ticketing Forum] creating renewal forms without Infomaker

     

    I just tried saving to excel, and all get is some seat numbers in the seat columns, but there is no other data there.

    My D_Object is: d_report_renewal.

     

    WE do not have Infomaker, so if this an infomaker report, that eplains why I can’t get the data.

     

     

     dkeefe_signature

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin Sheehan
    Sent: Friday, January 06, 2012 11:57 AM
    To: dkeefe@balletsj.org
    Subject: RE: [Tessitura Ticketing Forum] creating renewal forms without Infomaker

     

    Hi Dennis,

     

    What you want is the data behind what you see on the screen, so generally it doesn’t matter what it’s showing (but what you describe does sound a little odd).  Renewal notices always select the same set of data, but they don’t always display all that data.  When you save the output to Excel though, you will get all the data, even if some of that data isn’t displayed on the screen.  So try saving the output to Excel and see what you get.

     

    If you don’t get the data you want when you do that, look in the T_FORMAT_INFO table and tell me what is in the D_Object column for the row for the renewal notice format you are using when you run the Renewal Notices report.

     

    And here are three links to topics in the new online help system that explain renewal notices:

    Renewal Notice Formats

    Renewal Notice Data Fields

    Subs Renewal Notices Report

     

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     




    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!

Children
No Data