• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 110 views
  • Users 0 members are here
Related

Stored Procedure for Infomaker

Kevin Madeira
$organization

Hi all,

I'm modifying a few reports and order acknowledgements in Infomaker but 'Data Source' in the Design menu option is disabled.  Does anyone know why this is?

Cheers,

Kevin



[edited by: Kevin Madeira at 11:38 PM (GMT -6) on 21 Nov 2013]
Parents
  • $organization

    Thanks for your response. This all started when I came across a Gregg Stickney presentation regarding using TNEW Order Confirmation emails out of Tessi client.

    After many attempts and TNEW Support ticket, I was informed that it is not something I can do myself ......


    What I think I'll do is create a new SP that calls the TP_ORDER_ACK, takes the results and  queries for the additional info of row and seat number

    and use that as a source for a new 'report' .... and with that I'll plunge into SSRS - which has to be more fun than Infomaker ...


    Thanks again

     From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: Friday, October 03, 2014 8:19 PM
    To: John Grigaitis
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker
     

    I misspoke slightly here.  You can edit the existing set of columns in column specifications.  You cannot, however, change the stored procedure used on an existing datawindow in Infomaker.  You can do this in PowerBuilder which we use for much of the client application.  Sorry for any confusion here.

     

    What you can do is:

     

    1.        Create a new datawindow using a custom stored procedure which has the same result set as the existing datawindow’s stored procedure.

    2.       As long as the columns are in the same order and use the same names, you should be able to select all objects from the existing sample acknowledgment and copy/paste into the new datawindow.

     

    You might get an error saying “One or more objects on the clipboard are not valid.”, but any that are valid will copy to the new datawindow.

    Hope this saves you a bit of time!

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Friday, October 3, 2014 5:05 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    If it’s grayed out/inactive, it means that Column Specifications is already appearing somewhere docked on your Infomaker window.  To change the layout, find the pane.  To change the stored procedure, right click anywhere on the Column Specifications panel.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Grigaitis
    Sent: Friday, October 3, 2014 3:24 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    have a 'similar' problem. I'm new to Infomaker, have an old Tessi Order acknowledgment that I modified to show seat and row numbers. I saved the existing stored procedure under a new name and am trying to find out how to change the 'source ' of the report form the original stored procedure to the modified one ....

    On the Menu bar, under View - I see Column Specifications - but it's grayed out ......

    Thanks for any info ...

    John

    Michigan Opera

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/22/2013 1:29:46 AM

    Hi, Kevin,

    This is because a SQL query is not used as the datasource for the datawindow.  If you open the Column Specifications view for the datawindow, right click and select Stored Procedure from the menu, you can view the setup for the stored procedure associated with the datawindow.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira
    Sent: Thursday, November 21, 2013 9:33 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    Hi all,

    I'm modifying a few order acknowledgements in Infomaker but 'Data Source' in the Design menu option is disabled...for every report I've looked at.  Does anyone know why this is?

    Cheers,

    Kevin




    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!




    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!




    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!




    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!
Reply
  • $organization

    Thanks for your response. This all started when I came across a Gregg Stickney presentation regarding using TNEW Order Confirmation emails out of Tessi client.

    After many attempts and TNEW Support ticket, I was informed that it is not something I can do myself ......


    What I think I'll do is create a new SP that calls the TP_ORDER_ACK, takes the results and  queries for the additional info of row and seat number

    and use that as a source for a new 'report' .... and with that I'll plunge into SSRS - which has to be more fun than Infomaker ...


    Thanks again

     From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: Friday, October 03, 2014 8:19 PM
    To: John Grigaitis
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker
     

    I misspoke slightly here.  You can edit the existing set of columns in column specifications.  You cannot, however, change the stored procedure used on an existing datawindow in Infomaker.  You can do this in PowerBuilder which we use for much of the client application.  Sorry for any confusion here.

     

    What you can do is:

     

    1.        Create a new datawindow using a custom stored procedure which has the same result set as the existing datawindow’s stored procedure.

    2.       As long as the columns are in the same order and use the same names, you should be able to select all objects from the existing sample acknowledgment and copy/paste into the new datawindow.

     

    You might get an error saying “One or more objects on the clipboard are not valid.”, but any that are valid will copy to the new datawindow.

    Hope this saves you a bit of time!

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Friday, October 3, 2014 5:05 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    If it’s grayed out/inactive, it means that Column Specifications is already appearing somewhere docked on your Infomaker window.  To change the layout, find the pane.  To change the stored procedure, right click anywhere on the Column Specifications panel.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Grigaitis
    Sent: Friday, October 3, 2014 3:24 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    have a 'similar' problem. I'm new to Infomaker, have an old Tessi Order acknowledgment that I modified to show seat and row numbers. I saved the existing stored procedure under a new name and am trying to find out how to change the 'source ' of the report form the original stored procedure to the modified one ....

    On the Menu bar, under View - I see Column Specifications - but it's grayed out ......

    Thanks for any info ...

    John

    Michigan Opera

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/22/2013 1:29:46 AM

    Hi, Kevin,

    This is because a SQL query is not used as the datasource for the datawindow.  If you open the Column Specifications view for the datawindow, right click and select Stored Procedure from the menu, you can view the setup for the stored procedure associated with the datawindow.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira
    Sent: Thursday, November 21, 2013 9:33 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Stored Procedure for Infomaker

     

    Hi all,

    I'm modifying a few order acknowledgements in Infomaker but 'Data Source' in the Design menu option is disabled...for every report I've looked at.  Does anyone know why this is?

    Cheers,

    Kevin




    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!




    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!




    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!




    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!
Children
No Data