Donor Program Name listing and online acknowledgement

Thanks Ken, that would be great!

Cheers,

Ben

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Tuesday, 20 May 2014 8:41 PM
To: Benjamin Lee
Subject: Re: [Tessitura Development Forum] Donor Program Name listing and online acknowledgement

Hi Ben

We generate the online donor ack lists directly from the prognames data. But it needed a little bit of custom work in Tess, apart from the web dev work to actually display it - two local tables, set up as system tables, and a local proc, registered in the TR_LOCAL_PROCEDURE  table, so it's accessible through the API.

[LTR_ACO_web_program], one row for each program,  holds a flag to say whether it displays on the web, and a couple of text fields, so that we can give them a friendly name

[LTR_ACO_web_donation_level], holds the same three fields for donation levels, plus a display order.

[dbo].[LWP_ACO_GET_DONOR_LIST](@program_name varchar(50)) takes a program name as input (or null to return all of them), and returns a list of the donor names for that Program..

Happy to share the scripts, if you're interested..

Ken

Hi All,

Just wondering if anyone out there automatically updates their online donor acknowledgement page from the Names tab (Program Names radial button) in Tessitura and if it is indeed possible? 

We find it a really time consuming thing to do on a weekly basis to update names and trying to work smarter, not harder! 

Thanks in advance for any advice. 

Cheers,

Ben Lee

Philanthropy Executive

Melbourne Symphony Orchestra

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!