Import and match metadata from Drylab set report 3

Drylab Set Report 3 app can export a .CSV file that can be imported into Silverstack to match to clips and add metadata captured in Set Report to the Silverstack library.

• Consult Drylab documentation for export of CSV from Set Report
• Matching Options
• Metadata Import Options & Mapping

Import a CSV file from Drylab set report 3 into Silverstack#

First select the folder or bin in the library that you want to import metadata for.

Then, in the “Import” menu button in the toolbar select the option Drylab CSV:

When the Finder dialog points you to select a file, choose the CSV file exported from Drylab SetReport and select “Open”.

Matching options#

There are two options to match the events in the CSV to the clips in the library:

• by Clip Name
• by Creation Date

Matching by clip name

Enabling the Clip Name option, looks for a match between the “filenameBase” column in the CSV and the Video Clip Name (Library Clip Name) in the Silverstack library.

Options

The pop up menu on the right side of the checkbox offers the option to take only a certain amount of characters of the clip names into account for matching.

Matching by creation date (Time of Day)

Enabling the Creation Date option, looks for a match between the “createdAt” column in the CSV and the Shooting/Recording Date (Library Clip Name) in the Silverstack library.

Options

• Date&Time with tolerance: You can adjust a slider to set the desired tolerance for the matching by Creation Date
• Date only: Matches the clips by the date only and neglects the time part of the timestamp

The matches are displayed in the table of clips with a blue checkbox. The left side shows the Silverstack library clip name event and the right side the event from the Set Report csv.

As soon as you obtained a proper matching, click “Continue”.

Metadata import options & mapping#

Import Section: In this step you can select or unselect the metadata that should be imported from the CSV to the Silverstack library.

Insert/Update Behavior: Choose if you only want to insert new metadata if a fields is empty or you want to force an overwrite.

The following import sections are available:

• Slate Info
• Reel
• Camera Settings
• Lens and Filter
• Production
• Comment and Caption
• “circled” Tag (as Flagged)
• Append Tags
• Day Number + Day Date (as Custom 1)

Mapping

This is the list of importable metadata from the CSV and to which fields it maps in the Silverstack library (sorted by Silvertack metadata section):