Bulk RSVP Updates in Elevated Events

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.

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

In which case this will update the inv_status from 1 (invited) to 3 (accepted) in a particular EE and for a list of customers, if you have someone with SQL knowledge.

Run it in TEST first

1. Replace the XXXX with Campaign Number of the Elevated Event and ZZZZ with the List number (the list containing Constituent IDs of the people you want to change)
   1. The output will let you know who was changed from 1 to 3.
2. If the campaign and constituent IDs in the output table are the ones you want changed, you can run it for real by changing ROLLBACK transaction to COMMIT transaction.
3. In the TEST Tessitura Client have a check that all is aok
4. If all is well replicate steps 1-3 in LIVE 
   
   
   
   

   DECLARE @campaign_no INT = XXXX,
   	@inv_status INT = 1,
   	@NEW_inv_status INT = 3,
   	@List_no INT = ZZZZ;
   
   DECLARE @update_inv_status TABLE 
   	(customer_no INT, Campaign_no INT, OLD_inv_status INT, NEW_inv_status INT);
   
   
   BEGIN TRANSACTION
   
   UPDATE TX_EVENT_EXTRACT
   SET inv_status = @NEW_inv_status
   OUTPUT deleted.customer_no, deleted.campaign_no, deleted.inv_status, inserted.inv_status
   INTO @update_inv_status
   WHERE campaign_no = @campaign_no
       and inv_status = @inv_status
       and customer_no in (SELECT DISTINCT customer_no from T_LIST_CONTENTS WITH (NOLOCK) WHERE list_no = @List_no)
   
   SELECT * FROM @update_inv_status
   
   ROLLBACK TRANSACTION
   
   --Run in TEST first and check your Elevanted Event in client
   --IF returned table is ok change ROLLBACK to COMMIT and rerun