Metadata is stored for every frame of DV, HDV, AVCHD, supported MPEG2-PS files, and some MOV & MP4 files. This export facility can output the metadata items for each frame to a text file as a list of Comma-Separated Values (CSV), one line per frame. This file can then be imported to Excel or most other spreadsheet or database programs.

 

A Confirm Settings dialog box appears which allows you to check and if necessary change how the metadata is exported. These are the same settings that appear in the Tools > Options > Export Metadata menu. See Options - Export Metadata for details of the settings.

 

When your are satisfied that the settings are correct, click OK and you are prompted for the name and location of the output file. By default, the file name of the output file is the same as the input file but has .csv appended.

 

If any item of metadata is missing in a frame, it is written as an empty text string - i.e. you will just see two consecutive commas.

 

The metadata items appear on each line in the following order:

 

File Progress Timecode - effectively the location within the file
Timecode
User Bits
Recording Date
Recording Time
Shutter Speed
Iris (f-stop)
Image Stabiliser on or off
Gain in dB
Auto-Exposure mode
White Balance
Focus Distance in metres
Focus Mode

 

For DV file types, this is followed by:

 

Audio Sampling Frequency
Audio Locked/Unlocked

 

and for AVCHD, MOV, MP4 and MPEG-2 PS files is followed by these GPS Geotagging items:

 

GPS Latitude - in degrees, minutes and seconds N or S
GPS Longitude - in degrees, minutes and seconds E or W
GPS Altitude - height above sea level in metres
GPS Altitude Units - in metres or feet
GPS Speed - speed of camera's motion
GPS Speed Units - km/h, miles/h or knots
GPS Track - direction of camera's motion in degrees
GPS Track Ref - True or Magnetic

 

The latitude and longitude values have the degrees, minutes and seconds each separated by a single space - e.g. "28 21 57.8 N". You can also choose for them to be output as a decimal value of degrees by checking Display Geotagging locations in decimal in the Tools > Options > General menu. Also, you can choose for the altitude and speed to be output as feet and miles/h instead of the camera's native units (usually metric) by checking Display Geotagging distances in ft and mi/h in the Tools > Options > General menu.

 

Part of an example export file is shown below. This was exported from a DV AVI file.

 

 

00:00:00:00,00:17:01:09,01:11:0A:01,08/11/2003,16:43:48,50,1.5,OFF,0,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:00:07:21,00:17:09:05,01:11:0A:01,08/11/2003,16:43:56,50,2.0,OFF,0,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:00:54:08,00:17:55:17,01:11:0A:01,08/11/2003,16:44:42,50,1.5,OFF,6,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:00:55:14,00:17:56:23,01:11:0A:01,08/11/2003,16:44:43,50,1.5,OFF,10,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:00:56:03,00:17:57:10,01:11:0A:01,16/09/2003,13:45:29,,,,,,,,,48,UNLOCKED

00:00:56:04,00:17:57:11,01:11:0A:01,16/09/2003,13:45:29,50,1.5,OFF,17,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:00:58:13,00:17:59:20,01:11:0A:01,,,,,,,,,,,48,UNLOCKED

00:01:02:05,00:18:03:12,01:11:0A:01,17/08/2003,00:00:00,50,1.5,OFF,17,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:01:04:24,00:18:06:06,01:11:0A:01,17/08/2003,00:00:02,50,1.5,OFF,16,AUTO,AWB,5.0,MANL,48,UNLOCKED

00:01:07:03,00:18:08:10,01:11:0A:01,17/08/2003,00:00:04,50,1.5,OFF,16,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:12:07,00:18:13:14,01:11:0A:02,17/08/2003,00:00:10,50,1.5,OFF,6,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:12:16,00:18:13:23,01:11:0A:02,17/08/2003,00:00:10,50,1.5,OFF,0,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:12:24,00:18:14:06,01:11:0A:02,17/08/2003,00:00:10,50,2.0,OFF,0,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:13:15,00:18:14:22,01:11:0A:02,17/08/2003,00:00:11,50,2.4,OFF,0,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:13:23,00:18:15:05,01:11:0A:02,17/08/2003,00:00:11,50,2.8,OFF,0,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:14:06,00:18:15:13,01:11:0A:02,17/08/2003,00:00:12,50,3.4,OFF,0,MANL,AWB,5.0,MANL,48,UNLOCKED

00:01:14:16,00:18:15:23,01:11:0A:02,17/08/2003,00:00:12,50,4.0,OFF,0,MANL,AWB,8.0,MANL,48,UNLOCKED

00:01:15:05,00:18:16:12,01:11:0A:02,17/08/2003,00:00:13,50,4.8,OFF,0,MANL,AWB,8.0,MANL,48,UNLOCKED

00:01:15:10,00:18:16:17,01:11:0A:02,17/08/2003,00:00:13,50,5.7,OFF,0,MANL,AWB,8.0,MANL,48,UNLOCKED

00:01:15:16,00:18:16:23,01:11:0A:02,17/08/2003,00:00:13,50,6.7,OFF,0,MANL,AWB,8.0,MANL,48,UNLOCKED

00:01:15:23,00:18:17:05,01:11:0A:02,17/08/2003,00:00:13,50,8.0,OFF,0,MANL,AWB,8.0,MANL,48,UNLOCKED

00:01:16:12,00:18:17:19,01:11:0A:02,17/08/2003,00:00:14,50,9.5,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

00:01:16:17,00:18:17:24,01:11:0A:02,17/08/2003,00:00:14,50,11,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

00:01:16:23,00:18:18:05,01:11:0A:02,17/08/2003,00:00:14,50,13,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

00:01:17:02,00:18:18:09,01:11:0A:02,17/08/2003,00:00:14,50,16,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

00:01:17:14,00:18:18:21,01:11:0A:02,17/08/2003,00:00:15,50,19,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

00:01:17:18,00:18:19:00,01:11:0A:02,17/08/2003,00:00:15,50,23,OFF,0,MANL,INCAND,8.0,MANL,48,UNLOCKED

 

And here is the format of an export file containing GPS info from a GPS-equipped AVCHD camcorder (including the header):

 

File progress,Timecode,User Bits,Rec Date,Rec Time,Shutter Speed,Iris,Image Stabilizer,Gain (dB),Exposure Mode,White Balance,Focus,Focus Mode,GPS Latitude,GPS Longitude,GPS Altitude,GPS Altitude Units,GPS Speed,GPS Speed Units,GPS Track,GPS Track Ref

00:00:00;00,00:39:46;15,00:00:00:00,19/02/2010,12:20:45,250,9.6,ON,-3,AUTO,AWB,0.70,AUTO,33 36 17.4 N,117 42 13.7 W,101.7,m,16.6,km/h,126.6,T

 

 

Note that this tool is only available in the full version of DVMP Pro. It is not available in the demo version.

 

See Also:

Options - Export Metadata