Hello! I'm not sure what I'm asking is possible, so I figured some great mind in the community might be able to help me figure it out.
The ballet academy branch of our company uses a different database for students, tuition, schedules, etc. We are wanting to find the parents of academy students in Tessitura and give them a constituency to signify them as academy parents. Unfortunately because they use a different database, I do not have ID numbers for each constituent, only their name, address, email, and phone number.
Is there anyway for Tessitura to find these constituents without their ID to make a list for a constituency update, or will it need to be done manually one by one by searching their info?
On the heels of Gawain's suggestion, do you currently have a "link" between the two systems? From what I read, I seems like you don't.
Just to ensure I understand what you are attempting and keeping Gawain's suggestion in mind, I'm going to restate what you're asking to clarify your question.
You have two separate databases that you use for two different functions and using Gawain's suggestion, you can ensure both have the constituents listed in each. Also, If you currently do not have link between the ID number in the "ballet academy company" database to their Tessitura database ID.one suggestion I could make is to create an attribute in Tessitura for the "ballet academy company" ID and set that attribute value to be the ID number in the "ballet academy company" database for the related constituent.
Doing this will give you a "link" between the ID in the "ballet academy company" and Tessitura. You could then use this attribute to create the constituency update list.
Might be less messy this way. Hope this helps.
Our academy is managed in Tessitura now, but the was Phillip explained things is exactly how we did it with our previous system. It took manual work periodically, but it was worth it.
We do still use one third party app for open adult students - we just need to maintain the third party app IDs in Tess and then vice versa, their Tess IDs in the app.