Tools MenuScript BuilderThis window is displayed from within the Meeting Schedule Assistant Meeting Editor.
Select Script Builder from the Tools menu.

Script Builder windowSection OneSection TwoSection Three

Duty Assignment History can be included on schedules that are created using the Meeting Editor. This makes it possible to bring together all meeting assignments from both editors into a single schedule. Changes need to be made to the template for this information to be included and this Script Builder tool has been provided to simplify the customization process.


Overview

The Script Builder is effectively split into three sections:

  • Section 1 allows you to indicate what Duty Assignment History you would like to extra from the history database.
  • Section 2 displays the CSS (Cascade Stylesheet) classes.
  • Section 3 displays the XSL (Extensible Stylesheet Language) script.

It is assumed that you have already opened the Meeting Editor and selected the Legacy template in the drop-down list.

Notes IconThis How To help topic uses the Legacy template as a worked example and is not to be treated as an exhaustive set of instructions. It does go through the fundamentals of the steps involved in using the Script Builder. Please use the Meeting Editor — Templates support forum if you need further assistance.

Section One

The first thing you need to do is tell the Script Builder what duty assignment history you want to include. Do this by working through section one of the window and configuring as required.

Schedule Type

Do you make use of Schedule Types in the Assignments Editor? Select the schedule type you want to use in the drop-down list and this will make sure the script builder uses the correct duty history. Leave it with Default selected if you don't use schedule types.

Notes IconIn this tutorial we are using the Default schedule type.

Duty History Mode

Next, you need to select the right Duty History Mode. The choices in the drop-down list depend on the Report Mode for the selected schedule type.

  • Midweek (Meeting report mode).
  • Weekend (Meeting report mode).
  • Weekly (Weekly report mode).

The mode needs to be set correctly because it will make sure you get the correct duty information from the history database.

Notes IconIn this tutorial the Report Mode is Meeting and we are only interested in the Midweek duty assignments. So we selected Midweek in the drop-down list. So go ahead and select the mode you want to use.

Duty assignments to include

Use the checklist to specify which assignments you want to include. Only assignments that are actually used by the schedule type will be listed.

Notes IconGo ahead and select the assignments that you want to include.

Adjust order

Use the Up / Down buttons to adjust the order of the duty assignments. They will show is this order as a list on the schedule.

Reset

Clicking Reset will return to default sort order list with all assignments ticked.

By now you should have completed the configuration for section one and should see some sample CSS / XSL code on the right-hand side.


Section Two

Section two displays the CSS classes that need to be used to set the look and feel of the Duty Assignments on the schedule. Feel free to modify these classes to meet your requirements. Please use the Meeting Editor — Templates support forum if you need further assistance and there are many tutorials on the internet about using CSS classes.

Right-click the schedule and select View -> XSL from the context menu and it should open the template in a suitable text editor. Visual Studio or Notepad++ are good editors for these types files. Keep this file open because you will need to use it for section three.

Locate the name of the CSS stylesheet towards the top of the template:

A screen shot of a computer code??Description automatically generated with low confidence

Right-click the schedule again, select Open File Location from the context menu and find the CSS stylesheet in File Explorer. Create a copy of the CSS file and rename it by added a suffix (eg: "-Duty"):

Duplicate stylesheet

Click the Copy button above the CSS section to copy to clipboard. Now open the duplicate CSS file and paste the classes. For example:

A screen shot of a computer program??Description automatically generated with medium confidence

Save and close the file.


Section Three

Section three displays all the XSL script that needs to be used to display the Duty Assignments on the schedule. Feel free to modify this script if you are comfortable doing so. At the bottom of this How To help topic is a link to further resources that detail the syntax of the Duty Assignment History database file.

The XSL template should already be open in your text editor. Save the template with a new name by adding a suffix again (eg. "-Duty"):

A screenshot of a computer??Description automatically generated

The script needs to be copied into the renamed template in several stages as detailed below.

Step 1

As instructed "Add this to the xsl:stylesheet node right at the top". Like this:

A picture containing text, software, font, multimedia software??Description automatically generated

Step 2

As instructed "This goes towards the top of the script, just after the xsl:output node". Like this:

A picture containing text, screenshot, software, font??Description automatically generated

Step 3

Change the name of the linked CSS file to the new file:

Copying the script - step 3

Step 4

Now copy the function call line and paste where you would like the duty history displayed. This How To help topic assumes you want the assignments displayed at the bottom. Like this:

A screenshot of a computer screen??Description automatically generated with medium confidence

Step 5

Copy the actual function and paste it towards the bottom of the XSL file:

A screenshot of a computer screen??Description automatically generated with medium confidence


Save the template and close the file. 


Updating the Display

  1. Close the Script Builder.
  2. Go to the Worksheet (or any other) view.
  3. Go back to the Workbook view (this refreshes the drop-down list of templates).
  4. Select the new Duty template in the list.


A screenshot of a computer??Description automatically generated with medium confidence


Notes IconThere is no right or wrong way to present the duty info. This How To help topic presents the assignments in a basic list to cover all needs as simply as possible but you could now re-work the script to display the information in anyway you like.


Additional Resources

Help Topics

Other Templates / Tutorials