Documentation Center

Viz Mosart Administrator Guide

Version 3.9 | Published November 04, 2019 ©

Configuring Viz Mosart Server

Both AvAutomation and ManusAdministrator can be configured to use the Viz Mosart Template Database.

  • AvAutomation: For storing templates and AvConfig

  • ManusAdministrator: For storing NRCS template type aliases as configured in the newsroomsettings dialog. Note that all other information in newsroomsettings.xml is not stored in the database.

Both applications will extract information from the database and store the information locally on file:

  • AvAutomation: channeltemplates.xml and AvConfig.xml.

  • ManusAdministrator: newsroomsettings.xml.

Note that any existing files will be overwitten. Therefore prior connecting to the database the first time, a backup of those files should be done.

Connecting AvAutomation to the Mosart Template Database

Connecting AvAutomation to the Viz Mosart Template Database is done using the following settings in the general settings dialog (ctrl+shift+s):

  • UseTemplateDb: Set to true to enable connection to the Viz Mosart Template Database

  • ThisGallery: The name of the gallery. Should be unique among galleries but identical for Mosart main and backup servers.

  • TemplateDbConnectionString: Contains the database connection string to the database:

    server=hostname;User Id=username;Password=password;database=mosarttemplatedb

  • TemplateDbDefaultInserter: Identifies who is responsible for a database update. Only visible in the database itself where the _insertedby and _updatedby columns are populated with this property. Recommended set equal to ThisGallery + main/backup to identify main and backup servers respectively.

  • TemplateDbEnableAutoSynchronize: Set to true (default) if the AvAutomation shall automatically synchronize with the database. I.e. whether any changes in the database should be read immediately by AvAutomation. Recommend set to true unless intensive show design with frequent template changes occurs. Note that only idle servers will update automatically. Live servers requires a manual operation like opening the template editor, clicking on the status bar or by restarting AvAutomation.

  • TemplateDbPollIntervalSeconds: Number of seconds between polling the database for updates. Set to a higher value than the default (5 seconds) if multiple frequent template changes occurs.

  • TemplateDbEnableLocking (deprecated): Leave default value (true)

  • TemplateDbProviderName: Leave the default value for MySql (MySql.Data.MySqlClient)

For initial connection open the settings dialog and set the properties UseTemplateDb, ThisGallery, TemplateDbConnectionString and TemplateDbDefaultInserter then restart AvAutomation. If everything goes fine an entry for the gallery should be added to the database and initial templates (channeltemplates.xml) and AvConfig (avconfig.xml) uploaded.

Manual verification of a AvAutomation database connection

  1. Do the initial connection steps as outlined in the former section.

  2. Using any MySql database client, verify the content of the ga_gallery table. This table shall now contain a single row where ga_name=ThisGallery.

Manual import of channeltemplates.xml to the template database

It is possible to manually import channeltemplates.xml to the database. This is useful to populate the template database with the content from a channeltemplates.xml file. Either initially or as backup / transfer operation.

Import channeltemplates.xml file via the Template Editor in AvAutomation. From inside the Template Editor:

  1. Open any channeltemplates.xml from file using the "File/Open from file" menu option

  2. Select the "File/Save" menu option. The content of the selected channeltemplates.xml file shall now be uploaded to the template database.

When importing a channeltemplates.xml to the database any existing templates will be overwritten. No templates will be deleted from the database.

Manual import of AvConfig.xml to the template database

It is possible to manually import AvConfig.xml to the database. AvConfig.xml is stored entirely related to the gallery. Additionally the lists of vision mixer crosspoints and effects are extracted and stored as global lists within the database. This information is used by the Viz Mosart ActiveX

Import AvConfig.xml via the A/V Setup dialog in AvAutomation. From the A/V Setup dialog:

  1. Open any AvConfig.xml file using the "File/Open" menu option

  2. Select the "File/Save" menu option. The content of the selected AvConfig.xml file shall now be stored in the template database.

The content of the AvConfig.xml file is stored as it is, as a string, in the ga_gallery table.

Connecting ManusAdministrator to the Mosart Template Database

The only information stored in the database from ManusAdministrator is the newsroom aliases for the Mosart template types. This is done to make the newsroom aliases the same for all galleries connected to the database. This information is global and shared among all galleries. Therefore there is not gallery specific setting necessary to set within ManusAdministrator (like ThisGallery for AvAutomation)

Connecting ManusAdministrator to the Mosart Template Database is done using the following settings in the general settings dialog (ctrl+shift+s):

  • Use template database: Set to true to enable connection to the Mosart Template Database

  • ConnectionString: Contains the database connection string to the database:

    server=hostname;User Id=username;Password=password;database=mosarttemplatedb

  • Default inserter: Identifies who is responsible for a database update.

  • Provider name: Leave the default value for MySql (MySql.Data.MySqlClient)

Manual import of newsroomsettings.xml content to the template database

It is possible to manually import the NRCS template type aliases located in newsroomsettings.xml to the database.

Do this via the newsroomsettings dialog in ManusAdministrator: From the newsroomsettings dialog:

  1. Open any newsroomsettings.xml using the "File/Open" menu option.

  2. Select the "File/Save" menu option. The newsroom aliases for template types shall now be uploaded to the template database.

It is only the template type aliases that are stored in the template database. All other information remains locally as is the newsroomsettings.xml.

Viz Mosart Template Database and Viz Mosart ActiveX

The Viz Mosart ActiveX is used to insert Viz Mosart template information into the NRCS script.

The user selects a Viz Mosart type and variant to create an entry in the Viz Mosart rundown. When the script is saved, information is pushed to Manus Administrator and onto the active rundown in the Viz Mosart GUI.

For the ActiveX to function correctly, some parameters are required to be set that link the ActiveX content to your Viz Mosart Server installation. There are two ways to link the ActiveX to your Viz Mosart Server installation, via the Template Database or directly to the Viz Mosart Server.

See Connecting the ActiveX to Viz Mosart Server.