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!
Am I right in thinking that if they are already "invited" then you might only have to update TX_EVENT_EXTRACT and they'd have an evex_no so T_NEXT_ID might be ok. Inserting new folks is a bigger job