Opening the Litmus Production Record Internal Event Configurator

to create an event monitoring configuration inside litmus production record database using the litmus production record internal event configurator, the user will create the event monitoring configuration inside the configurators sheets first before uploading it directly to the database as the solutions is designed to ideally publish the tag configuration directly to litmus production record database, it is recommended to make sure that access to the sql server running the le productionrecord database exists to be able to work, it is required that both the data model for which events are to be monitored as well as the tags which are to be used have both been created in litmus production record database it is recommended to do define them first, as the configurator will be able to retrieve them to assist with the configuration for cases where users may not have direct connection to the sql server, the solution also has an offline mode in the offline mode the solution will create a sql file, which can be executed later through for example sql management studio note the offline options is only recommended for experienced users why this is the case will be highlighted in the respective chapters of this guide when opening the file litmus production record internal event configurator v1 0 0 xlsm , the user is typically asked to enable vba macros some organizations do by default not trust any custom code for ms excel therefore the solution might display in this case, close the solution and navigate to the files location and open its properties window in the general tab check the unblock checkbox and apply the change now open the file again and it should allow the user to enable the use of macros the solution will start the user always in the instructions sheet in case a sql server is defined in the sheet configurations the application can show a prompt to request a sql authenticated login user and password to verify if the sql server is reachable and the database le productionrecord does exist