merge csv

You can easily merge metadata from a csv (comma-separated-values) file with your master clips.  This can be useful for syncing script notes with dailies or submission notes with VFX shots.

to merge csv

1. Click the actions button
2. Click merge csv
3. Click select
4. Choose the csv file and click Insert
5. In the set import order window, map the csv columns to the bin columns (see options below) and click merge
6. Review the merged data in the merge csv window and either click done to return to all clips or go back to change the field mapping.

All master clips that matched to data in the csv file will be updated.

mapping options

	match	Data in the csv column equals data in the bin column.
	update	Copy the data from the csv column into the bin column.
	ignore	Do not import this column.

notes

• In the csv file, the column names can be anything and do not need to be in any specific order.  The only requirement is that the headings are on row 1 and that the data begins on row 2.
• Currently, Marvin supports a maximum of 20 columns; all others will be ignored.
• Click the csv data preview or column name headings to toggle between displaying the csv file's column names and the first row of data to make sure it's what you expect.
• One pair must be set to match, and at least one pair must be set to update.
• Merging performs an exact match search on the data, so if your clips include ".mov", then the csv clip values must also contain ".mov" at the end of each.

actions

• The clipboard button copies the list of missing clips to your computer's clipboard so that you can paste them into an email or other document.

exports

• Export the list of matched clips as an ALE file to merge with the corresponding master clips back in Avid.