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:
