Hello,
I'm working on converting how we track the tenures of our board members from an excel file into Tessitura. When have members who have rotated on and off our board since 1963. My organization is looking to track the years each member was on the board, and it was suggested that Memberships would be the best place to record this data. Has anyone else had experience with importing this kind of historical data? Does it make sense to build Campaigns/Memberships dating back to the 60's, or is there a better place to record this data in Tessitura?
Hi Scott,
We use Affiliations for this - for our purposes, Memberships seemed overly complicated. We have 3 boards here at NIDA - each has it's own constituent record. We use two Affiliation types:
There's not easy, elegant way of doing this via the application but it's pretty simple SQL-wise. Happy to share my scripting if you're interested - just email me at martin.keen@nida.edu.au
Martin