Adding Dynamic Images to Header

I'm trying to tackle constituent header customizations and have finally figured out how to add a static image tied to a note type.  I'm now trying the dynamic image functionality and the InfoMaker part seemed pretty easy......the SQL stored procedure part, not so much.  I'm still learning how to write SQL code and edit stored procedures and can't quite figure out how to add this to my stored procedure.  Any help from someone who has done this would be so greatly appreciated!!!

Teresa

Parents
  • Jon,

     

    Thanks for this link……I’ve already looked at and used the document.  My issue is that I’m not sure of how to edit the stored procedure to factor in the graphic.  I’ve followed the directions for adding the dynamic graphic in InfoMaker and think that it’s all correct.  I just need a bit of direction in how to edit the stored procedure.

     

    Teresa  

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, March 23, 2010 9:37 AM
    To: Teresa Dean
    Subject: Re: [Tessitura Technical Forum] Adding Dynamic Images to Header

     

    Check out the tessitura document located here:

    http://www.tessituranetwork.com/network/Learning/Documentation/Customization/Custom%20Constituent%20Headers.aspx

     

    From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com>
    Sent: 3/23/2010 8:18:15 AM

    I'm trying to tackle constituent header customizations and have finally figured out how to add a static image tied to a note type.  I'm now trying the dynamic image functionality and the InfoMaker part seemed pretty easy......the SQL stored procedure part, not so much.  I'm still learning how to write SQL code and edit stored procedures and can't quite figure out how to add this to my stored procedure.  Any help from someone who has done this would be so greatly appreciated!!!

    Teresa




    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
  • Jon,

     

    Thanks for this link……I’ve already looked at and used the document.  My issue is that I’m not sure of how to edit the stored procedure to factor in the graphic.  I’ve followed the directions for adding the dynamic graphic in InfoMaker and think that it’s all correct.  I just need a bit of direction in how to edit the stored procedure.

     

    Teresa  

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, March 23, 2010 9:37 AM
    To: Teresa Dean
    Subject: Re: [Tessitura Technical Forum] Adding Dynamic Images to Header

     

    Check out the tessitura document located here:

    http://www.tessituranetwork.com/network/Learning/Documentation/Customization/Custom%20Constituent%20Headers.aspx

     

    From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com>
    Sent: 3/23/2010 8:18:15 AM

    I'm trying to tackle constituent header customizations and have finally figured out how to add a static image tied to a note type.  I'm now trying the dynamic image functionality and the InfoMaker part seemed pretty easy......the SQL stored procedure part, not so much.  I'm still learning how to write SQL code and edit stored procedures and can't quite figure out how to add this to my stored procedure.  Any help from someone who has done this would be so greatly appreciated!!!

    Teresa




    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
  • Are you storing the image or the path to the image in the database?  If not what then is making your images dynamic?



    [edited by: Jon Ballinger at 9:55 AM (GMT -6) on 23 Mar 2010]
  • Jon,

     

    I just figured it out.  When I was copying my computed field expression into an reply, I noticed a missing \ ….. once added, my graphic is showing up in the header.

     

    Thanks for helping!!!

     

    Teresa  

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, March 23, 2010 9:57 AM
    To: Teresa Dean
    Subject: Re: [Tessitura Technical Forum] RE: Adding Dynamic Images to Header

     

    Are you storing the image or the path to the image in the database? 

    From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com>
    Sent: 3/23/2010 9:50:59 AM

    Jon,

     

    Thanks for this link……I’ve already looked at and used the document.  My issue is that I’m not sure of how to edit the stored procedure to factor in the graphic.  I’ve followed the directions for adding the dynamic graphic in InfoMaker and think that it’s all correct.  I just need a bit of direction in how to edit the stored procedure.

     

    Teresa  

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, March 23, 2010 9:37 AM
    To: Teresa Dean
    Subject: Re: [Tessitura Technical Forum] Adding Dynamic Images to Header

     

    Check out the tessitura document located here:

    http://www.tessituranetwork.com/network/Learning/Documentation/Customization/Custom%20Constituent%20Headers.aspx

     

    From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com>
    Sent: 3/23/2010 8:18:15 AM

    I'm trying to tackle constituent header customizations and have finally figured out how to add a static image tied to a note type.  I'm now trying the dynamic image functionality and the InfoMaker part seemed pretty easy......the SQL stored procedure part, not so much.  I'm still learning how to write SQL code and edit stored procedures and can't quite figure out how to add this to my stored procedure.  Any help from someone who has done this would be so greatly appreciated!!!

    Teresa




    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!