Donor Program Name listing and online acknowledgement

The Output Set Builder Cookbook (on tessituranetwork.com) has an element you can set up to do this – on page 32 called Program Name Listing. It output the program name and sort order for a specific program selected.

The cookbook for v11 is the one you should be using it will work for v12 too.

Cheers

Sandra

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ros Keeley
Sent: Tuesday, 20 May 2014 9:20 PM
To: Sandra Ashby
Subject: Re: [Tessitura Development Forum] Donor Program Name listing and online acknowledgement

Hi

I know it's slightly off topic but does anyone have a way of pulling the programme name as a merge field? It would be really useful to put in thank you letters to confirm a donors listing.

I feel we should know this but can't seem to find how it's done.

Thanks

Ros

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

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!

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!