CatDV has a number of features that help to migrate from existing systems, whether on spreadsheets, other commercial systems, legacy database formats or bespoke implementations.
- For help migrating from Final Cut Server (FCS) please see this page.
- If metadata comes from one of the common NLE packages such as Final Cut Pro, Avid Media Composer, or Media Composer, please see this page and this page
Otherwise this document describes some common mechanisms to import existing data into CatDV. The general approach is to :
- extract data from the legacy system
- translate it into a format CatDV can understand
- Set up the field definitions for the import
- import the data
- if necessary relink the media files, however this step can usually be automated too.
Migrating Data using tab separated text
- create a spreadsheet with the legacy metadata in rows
- update the column headings in the spreadsheet to match the required field names in CatDV
- save as tab separated text (or tab delimited) text, usually in the Save As… menu
- set up the field definitions in CatDV to match the spreadsheet column headings (see here)
- use the CatDV, File – Import As – Tab Separated Text command to view the data
- consider setting up some custom Views or custom panels to see and manipulate the data in CatDV
The spreadsheet must contain the fields IN and NAME for the import to work. If the full path to the clip is the same as the file named ‘Media File’ then the clip will automatically be linked and analysed as part of the import process.
As an example the following text file can be used to demonstrate the concepts above: CatDVMigrationExample
Otherwise linking data records to the media can be done manually in a few ways:
- using the ‘Media – Attach Media’ menu for individual files,
- by opening the media in one window and the imported metadata in another window and using the ‘Edit – Copy’ and ‘Edit – Paste Metadata’ functions between the clips.
Migrating data using CatDV XML batch files
If you are a software developer and are looking to integrate with an external system then creating a CatDV XML batch file is a good approach. For an example of the CatDV XML file format you can use the File > Export As CatDV XML command. You should create an XML file that contains the media path and log notes you wish to import, then use the File > Import CatDV XML Batch File command.
If the file is online you do not need to specify technical metadata such as video or audio format as they will be determined by CatDV analysing the media files on import.