Meeting Closer in iMIS EMS

Meeting Closer will continue to work with the following iMIS environments:

• EMS On-Prem
• 20/20

If you require the Meeting Closer functionality to close and re-close meetings to continuously generate CEUs, then we highly recommend keeping Meeting Closer for your organization!

Removing Meeting Closer from iMIS Environment

If upgrading to pure EMS Cloud and/or no longer have the necessity for Meeting Closer, we recommend following these steps below.

If Meeting Closer functionality is required in pure EMS Cloud, please consider using the iMIS Data Management Suite

1) Un-Hide all Meetings

This moves data from csi_Meeting_Closer and puts it back into Meet_Master.

Do this by selecting all events in the Hidden Meetings section (you can use Ctrl-A), and clicking the Show for Cloning

Screenshot...

2) Once this is done, you may safely delete the following objects using SQL

sp_csi_CloseMeeting
sp_csi_FlowdownMeetingActivity
sp_csi_GenerateCert
sp_csi_GenerateCertActivity
sp_csi_GenerateExcludeFunctionActivity
sp_csi_GenerateFunctionActivity
sp_csi_GenerateMeetingActivity
sp_csi_GenerateSpeakerActivity
sp_csi_OpenMeeting
sp_csi_PurgeDuplicateMeetings
sp_csi_PurgeMeetingDetail
sp_csi_RecloseMeeting
sp_csi_UpdateExcludeActivity
csi_Meeting_Closer 
Meet_Master_View 

Any IQA's or stored procedures that reference Meet_Master_View, they will need to be corrected BEFORE you delete the view.

You can use the Query Browser tool from ASI to identify these IQAs.