• Replies 5 replies
  • Subscribers 413 subscribers
  • Views 40 views
  • Users 0 members are here
Related

Hotlists

Former Member
Former Member $organization
Does anyone know whether there's a way to set up the hotlist function in multiple sources or an entire appeal? Our sources by default are set to "none" but barring a few, I would like most of them set for "Cont" only.
  • $organization
    There is no way to update multiple sources at once on the front end, but your DBA should be able to help you make that update on the back end. It's a pretty straight forward thing to do in SQL Server.

    One related thing I wanted to point out is that if you are looking to limit sources to contributions only, you want to set Usage to Cont, not Hotlist. Hotlist is used to make sources float to the top of the list. If you set Hotlist to Cont it will make those sources appear at the top of the list of sources when in contributions, but they will still be on the list in their normal positions for ticket orders. That might actually be what you want to do, but I've seen some confusion in this area before, so I wanted to point out the difference in case it isn't what you want to do.

    Kevin Sheehan
    Documentation & Learning Resources Specialist
    Tessitura Network
    1 888 643 5778 ext 329 Office
    ksheehan@tessituranetwork.com
  • $organization in reply to Kevin Sheehan
    is there a way to mass populate the use in contributions?
    or back end only?

    :)
    just checking ....

    Monika Jouvert
    Brooklyn Academy of Music
    Development Business Process Director
    718.623.7810 x6 / internally x4253
    mjouvert@bam.org
    http://www.bam.org
    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Kevin Sheehan [bounce-kevinsheehan4372@tessituranetwork.com]
    Sent: Thursday, September 03, 2009 8:31 PM
    To: Monika Jouvert
    Subject: RE: [Tessitura Development Forum] Hotlists

    There is no way to update multiple sources at once on the front end, but your DBA should be able to help you make that update on the back end. It's a pretty straight forward thing to do in SQL Server.

    One related thing I wanted to point out is that if you are looking to limit sources to contributions only, you want to set Usage to Cont, not Hotlist. Hotlist is used to make sources float to the top of the list. If you set Hotlist to Cont it will make those sources appear at the top of the list of sources when in contributions, but they will still be on the list in their normal positions for ticket orders. That might actually be what you want to do, but I've seen some confusion in this area before, so I wanted to point out the difference in case it isn't what you want to do.

    Kevin Sheehan
    Documentation & Learning Resources Specialist
    Tessitura Network
    1 888 643 5778 ext 329 Office
    ksheehan@tessituranetwork.com


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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
    Back end only as well.

    By the way, the trick for updating the Usage or Hotlist fields from the back end is you need to find an easy way for your DBA to group or exclude sources for update. Like all sources in these ten appeals. Or these fifteen source numbers. In the end it might be just as fast to manually update them.

    Kevin Sheehan
    Documentation & Learning Resources Specialist
    Tessitura Network
    1 888 643 5778 ext 329 Office
    ksheehan@tessituranetwork.com
  • $organization in reply to Kevin Sheehan

    Following up on this from what I've read - i was thinking about writing something that would update ticketing appeal source numbers to be on the hotlist if they've been promoted in teh last 30 days and then taking them off the hotlist once 30 days has passed.  While all our sources are (sadly) built to last the entire fiscal year, perhaps this might funnel more sales into current source numbers.  Is this feasible?  it seems pretty easy to do in sql, but not sure if it's SMART to do.

  • $organization in reply to Richard Jackson (Past Member)

    I don't think there would be a problem doing that technically, but the default sort order for sources is creation date starting with the most recently created, so I'm not sure putting sources promoted in the last 30 days on the hot list will result in a sort that's much different than the default.

    -Kevin