So you have some titles. Now is a good time to start making publicly viewable clips.

The next step in title creation is the adding of clip info into the online clip info document. Okay, so this is not title creation, but clip creation. However, these two things go hand in hand. After a new title has been created, it is ready to have a clip attached. As reference material. To the title. Aha, it is part of the process of a title's creation and re-creation. Um, where were we. Oh yes, we need to start the clip making process moving along, and shortly after the creation of a bunch of new titles is a good time to do it. Let us add some clip info to the spreadsheet.

As per usual, we begin with this step:

Log into MAVIS

• see above

Open Titles Module

• Single click on Titles

Find work titles

• Titles → Find or ctrl+F or click binoculars icon
• View → Field Query or ctrl+F
• Query: titleSearchClips
• Find

Remove titles that were already added to the spreadsheet, titles that will not receive clips

• Hold down Ctrl key and click on titles that apply
• Titles → Remove from List or Ctrl+R

Print preview to csv

• Titles → Print Preview or click printer with magnifying glass icon
• Click icon that looks like page with two orange arrows
• Choose file name to be saved in IMPORT-EXPORT\MAVISexportforClips folder (ie. videoTitles20120628.csv
• Format: Comma-Separated Values (CSV)
• Export

Copy into online doc

• Open .csv file with spreadsheet software (ie. OpenOffice)
• Open online document: clipMetadata
• In a new row:
  • Copy Title into TITLE NAME field
  • Copy Title No into Title No. field
  • Copy Duration Min into Title Duration field [note: If a title has a value in the Duration Hour field, you must place this value in the Title Duration field for that record along with the word hour (ie. 2 hours). If a title has no Duration Hour or Duration Min, you must place the Duration Sec value in the Title Duration field along with the word seconds (ie. 45 seconds).]

Input Source Item Info

• do find in item module for carriers attached to titles (carrierSearchTitles) [this is problematic as umbrella titles never go away]
• input item id numbers into doc
• input start/end times of umbrella-ed titles

Okay, good job there, Cataloger. At this stage you can return to fleshing out your title records, while the Media Specialist does what the Media Specialist does. Check back here later, though, to finish the clip making process.

• Please see the Media Specialist Notes

Okay, now it is time to attach the clips as reference material to the titles. This is a bulk import process. Hooray!

• Open online document: clipMetadata
• Check clipMetadata spreadsheet for inaccuracies
• Make sure videos have thumbnails in viddler
• Create .csv file for import
  • Download as OpenDocument Format (.ods)
    • Save File
  • Clean up downloaded file
    • Open .ods document
    • Delete description row (should be row number 2, orange colored)
    • Delete already imported rows (light green)
    • Delete rows that are not for clip-making (red)
    • Delete rows that are series titles¹⁾
  • Save as a .csv file
    • save in IMPORT-EXPORT\ClipImports folder
    • append yyyymmdd to file name (ie. clipMetadata20120629.csv)
    • check edit filter settings
    • Save, Keep Current Format
      • Baltic (Windows-1257)
      • ^ field delimiter
      • no text delimiter
      • OK
• For any “additional clips” (pink rows), make old clip non-olc
  • log into MAVIS
  • find title
  • open reference material
  • uncheck OLC tag
• Import into MAVIS
  • Xml File/Path: file is in IMPORT-EXPORT\ClipImports
  • Input format: CLIPS (should be import_clips.xsl, convert delimited file, caret)
  • Save converted xml
  • Archive imported files
  • Run Import
• Check titles for correctness
• Mark as imported in online doc
  • Open online doc (clipMetadata)
  • Highlight successfully imported rows
  • Change to light green background
• move xml and csv from savedImports to ClipImports\Imported folder
• Manually add reference materials for Series titles
  • Find title record
  • Go to Ref Material Tab
  • Right click, Add
    • Type: V: Video Clip
    • File Size: enter file size from spreadsheet
    • File Format: Video/mp4
    • OLC Display: check
    • Right click in Resource Identifier box, Add
      • Res. Identifier Type: File name
      • Resource Identifier: enter file name from spreadsheet
      • save record
      • close Resource Identifier window
    • Notes: enter Start Time - End Time of Source Item Used from spreadsheet (eg. 00:01:26 - 00:02:08 of 724)
    • save record
    • close reference material window
  • save record
  • Mark as imported in online doc
    • Open online doc (clipMetadata)
    • Highlight successfully added rows
    • Change to light green background