Metadata Lookups

Lookups are pop-up menus with lists of values that a user uses to enter a metadata field’s data. Examples include:

The values depend on the data type and can include text, dates, numbers, or timecode values. The following chart shows a few examples:

Lookup name
Data type
Name entry
Value entry
Audio Sample Rate
Integer
32 kHz
44.1 kHz
32,000
44,100
Order Open
Boolean
Open
Closed
True
False
Calendar Year
Date
Year Start
Year End
1/1/2008 00:00
12/31/2008 23:59
Slate
Timecode
Slate In
Slate Out
00:00:25.00
00:00:26.10
Email List
Unicode String
Editor 1
Review Group
edit1@company.com
revgrp@company.com

Many standard metadata lookups are included with Final Cut Server. Additional lookups can be defined using the Lookup pane.

Figure. Administration window showing the Lookup pane and the Create button.

The Lookup pane contains the following columns:

Adding or Editing Lookups

You can add or edit custom lookups.

To add a custom lookup
  1. In the Lookup pane of the Administration window, click the Create button.

  2. In the Lookup window that appears, configure the settings for the lookup.

    Figure. Lookup window.

    See Settings for Lookups for more information on the settings.

  3. Click Save Changes to save the custom lookup.

The new lookup appears in the Lookup pane.

You can also open the Lookup window and edit existing lookups.

Note: You are not allowed to edit many of the provided lookups.

To edit an existing lookup
  1. Double-click the metadata lookup in the Lookup pane.

    The Lookup window appears, showing the settings for that lookup.

  2. Make any necessary changes and click Save Changes.

    The Lookup window closes.

See Settings for Lookups for more information on the settings.

Settings for Lookups

The Lookup window provides controls to edit an existing lookup or to define a new lookup.

Figure. Lookup window.

The Lookup window contains the following settings:

  • Name: Enter the name of the lookup.
  • Options: Enter the name and corresponding value for each lookup value.
    • Name: The name of the element; for example, 32 kHz. This is what the user sees in the pop-up menu when entering metadata.
    • Value: The value of the element; for example, 32,000. This is the metadata value that is stored and used for searches. For text fields (using the Unicode String data type), you will usually want this to be the same as the name.

    Click the Add button to add the name/value pair to the lookups, or click a name/value pair and click the Remove button to remove the name/value pair.

Data Types for Lookups

The data type you choose defines the type of values you can enter in a lookup list. The data type list is the same list as used when creating a metadata field. Following is a list of available data types:

  • Boolean: A true or false value. This data type usually has only two items in its list: one true (with the Value checkbox selected) and one false (with the Value checkbox not selected). For example, you could enter Order Status Open as the name with the Value checkbox selected and Order Status Closed as the name with the Value checkbox not selected.
  • Date: A date/time field
  • Floating Point Number: A floating-point number
  • Integer: An integer field that supports up to 32-bit numbers
  • Large Integer: An integer field that supports up to 64-bit numbers (not normally required for custom metadata)
  • Timecode: A video timecode value in the format hh:mm:ss:ff
  • Unicode String: An alphanumeric Unicode string