Patch > Database

The Database section provides you with additional fields for entering information that can be used by the [Query] function. These fields include {Notes} and {Text 1} through {Text 10}. Clicking on {Text 1} through {Text 10} will open up a display for selection of keywords. It will display keywords that were already created as well as showing an option for creating new keywords. Clicking on {New Keyword} will display an alphanumeric keyboard for entering in a new keyword.

  • {Text} - Text fields are used to provide up to ten keywords about any channel or group of channels. These fields can be anything that you think is important about a channel, such as its location (FOH), an attribute of it (wash, spot), or other characteristics of the channel (such as gel). Select {New Keyword} and use the virtual keyboard in the CIA, or an external keyboard, to provide up to 30 characters of key words about the device.
    • [5] {Database} {Text 1} < FOH right> [Enter] - adds text to channel 5.
    • [5] {Database} {Text 2} [Label]downstage right [Enter] - adds text to channel 5.
  • {Notes} - Provides you the ability to attach a text note to a channel or group of channels. Select the {Notes} button on the CIA to display the virtual keyboard. You may type a label or any length of note regarding your channel in this space.
    • [5] {Database} {Notes} <this fixture is a backup to channel 15 for front of house right / new lamp installed on 10/4/17> [Enter] - adds a note to channel 5.
  • {Gel} - The Gel field is a dedicated location for notes about gels.

Adding Keywords in Patch

If you plan on being able to query channels based on a keyword association, the keyword must be defined in Patch.

Keywords entered are automatically used by Augment3d as tags on the associated channel / fixture in the Hierarchy. Spaces are replaced with an underscore (_).

To enter a keyword for a channel:

  1. In Patch > Database, select a channel or range of channels in the command line.
  2. Use one of the {Text (1-10)} buttons in the CIA to specify which keyword you are entering. A list of previously defined keywords will be posted. Select from these or press {New Keyword}. A virtual alphanumeric keyboard will appear.
  3. Type the keyword or words you wish to use.
  4. When finished, press [Enter].

Once keywords have been created, they will appear in the keyword section of the CIA when a query is performed.

Deleting Keywords from the Database

Keywords can be deleted from any of the ten text fields in the database. To delete a keyword from the entire database, you would use the following syntax:

  • [Delete] {Text1} <orange> [Enter] [Enter]

This will delete orange anywhere it was used in any text field of any channel.

To just remove a keyword from a specific channel, you would use the following syntax:

  • [1] {Text1} [Enter]

That would remove the text from channel 1's first text field only. If you wanted to clear the second text field, you would select {Text2} and so on.

Renaming Text Fields in Patch

You can rename the text fields. By default, the text fields are named {Text 1} through {Text 10}. Text fields 1 through 10 display in the Patch display. Renaming those fields will rename the columns associated with them in the Patch display.

  • {Text 1} [Label] <Position> will rename the text 1 field to Position.