Hello,
Is it possible to update more than one RSVP status at a time in Elevated Events, after the Event Invitations have been created? To clarify, we are looking to updated around 150 RSVP responses from Invited to Accepted. I've been doing some research and I'm only able to find instructions for manual updates.
Or, has someone written code for doing so?
Thanks!
Sarah Benjamin
Patron Data Assistant
San Francisco Opera
Hi Sarah,
There is no utility to bulk update elevated events, only special activities. If you have an IT Team or have access to SSMS and SQL Knowledge, you can gather the ID's of folks you want to update and update the tables TX_EVENT_EXTRACT and TX_EVENT_GUEST and set a new value for T_NEXT_ID after you finish with TX_EVENT_EXTRACT. It would be helpful for a utility to be created for this!
Thanks for your help Brian! Yes, a utility similar to Manage Special Activity would be super helpful for Elevated events.