Hi,
I'm in a pickle...
Every year, when we send out our sub renewal forms, we include a 'suggested donation amount' that is automatically calculated depending on several factors. Basically, everyone gets a different suggested donation amount calculated on their previous donation history, performance attendance, etc...
In order to stay consistent with our donation asks, we want to start keeping these suggested amounts in Tessitura as attribute values. As of now, they are kept on an excel spreadsheet.
I'm looking for the easiest way to import these values and the attribute (which I've created in T_KEYWORD as id = 475). In addition to this, the account data to be imported should not create new duplicate accounts. I'm attempting to MATCH the records from the spreadsheet to the existing records. I vaguely remember the Contribution Import Utility being more flexible and is able to match up constituent IDs, but I hate the idea of creating a batch and what seems like a lot of work JUST to import an attribute and their values! It seems like it should be pretty simple... right?
Has anyone else tried something similar to this before and had success? I'd love to hear that the solution has been staring me in the face this whole time. :)
Any help would be great.
Thanks!
We got a custom script from David as well and also use it on our sub renewals. We run it every year, but export the results into an excel sheet and then merge it into various things.
Our goal is to have this data accessible and visible to our Box Office staff within Tessitura so they can mirror the ask the patron has already received. My personal goal is to add this as an attribute and make it visible as a header. J
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom Sent: Wednesday, February 26, 2014 11:46 AM To: Tiffany Evans Subject: RE: [Tessitura Technical Forum] Attribute value import
I’ve done something similar, with rules in system tables for the contribution asks.
BWG
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Wednesday, February 26, 2014 11:37 AM To: Brian W. Grundstrom Subject: Re: [Tessitura Technical Forum] Attribute value import
Hi Tiffany,
Just wanted to throw this out there as some food for thought if the attribute thing doesn't work out for you. :)
We also wanted custom ask amounts for our subscription renewals. David Woodall created an awesome stored procedure for us that calculates the ask amount and then populates it directly into the customer's subscription summary. This has made our lives a lot easier here at the ESO!
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 2/25/2014 1:05:45 PM
Oh, this is very helpful. :)
I think for now, we wanted to try it out for now as an attribute and see if we are still happy with it there for now. But yes, it's a good idea to add an indicator for the FY we are loading.
Seems simple! I'll give it a shot! :) Thanks so much for your help.
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!