First-ever forum question as a Tessiturian; here goes!
Our organization uses Elevated Events for our large annual fundraising gala. In recording patron donations for tables at the event, the donor/household/company responsible for purchasing a table receives the primary listing for the record in Tess, and the individuals sitting at the table are listed as guests under that primary entity. This past year, we even established a Level for the Elevated Event to denote individuals as a Guest, specifically for tracking purposes.
Unfortunately, while it is possible to run an Event Listing report which only pulls attendees tracked with that Guest Level (listing them out under the heading of the primary entity of their table), it is not possible to export those attendees into a List so that I can run an Output Set and pull their address and contact information (something currently being requested by our Board Members).
Put another way, we had nearly 700 individual patrons attending the event; 460 of these were tagged with a Guest Level. When I try to save the Event Listing report as a List, the count only pulls over 66 constituents (the primary entities which are tagged as having purchased tables at the event).
Is there any Tess-savvy way to handle this? Obviously the database holds the information on the constituents tagged with a Guest Level who have Constituent IDs, but I'm not finding an immediate way to transfer those mailing addresses, phone numbers, and email addresses into Excel or some other file to share outside of Tess. Failing this, I'm looking instead at the very manual labor of referencing a spreadsheet with the guest IDs and copying address information into that spreadsheet from Tess, one constituent at a time.
Thank you in advance for any assistance!
The only way I've found to do this is to save the Event Listing Report as a CSV file, which has a column for Guest ID #, and then Import that CSV into a list in List Manager. Then you can run that list against whatever report you like to get contact info (I like the User Defined Format from a List but you have lots of choices). It's still kind of roundabout and time consuming, but at least you don't have to do them all one by one!