Michal,
I appreciate your follow up, especially since I had a misconception. I had the impression that the metadata was displayed on the video during playing only, and was not encoded in the video stream - which is not an unusual occurrence. However, it sounds like your metadata is indeed encoded in the video stream, and if this is true, the workflow you outline is correct. An added step is that you need to strip the metadata from your video before you can multiplex it into a MISB-compliant format the FMV Add-In can utilize. Let me summarize the workflow to be clear.
1) Start playing your video, then display the video metadata table that shows metadata values as the video plays. This sets up the environment. Stop playing the video.
2) In the metadata display window, select Record and navigate to an output directory and assign a name to the CSV metadata file to be created.
3) In the video player, go back to the very beginning of the video (00:00:00:00). Play the video which will also record the associated metadata at the same time and write the data to a metadata file on disk.
4) Strip the metadata from your video. Download and/or open VLC Media Player (free download). In VLC, main toolbar in the Media tab, choose Convert/Save. This opens a dialog; select your video on disk, then select Convert. This flips the dialog window to the Convert parameters, choose a video format and write to disk location. This process will export the video data to another disk file without metadata.
5) Review your metadata CSV file – open in MS Excel. You can either map your metadata field names using the Video_Multiplexer_MISB_Field_Mapping_Template.csv, or change the names of your metadata fields to be the MISB tag names.
6) The time stamp needs to be in UNIX time, use the converter at http://www.epochconverter.com/ to make sure your time is UNIX time in microseconds (16 digits). Convert the first time stamp and the last time stamp, then subtract the first timestamp from the last timestamp to get the total time range of your metadata. This should match the length of your video as a check.
7) In Excel, divide the total time range in (6) above by the number of metadata records to get the average increment change. Then in the second record in your metadata table, add this increment change to the first timestamp value to get the proper timestamp value for the 2nd record. Select the first 2 cells in the timestamp column (one containing the beginning UNIX timestamp and the 2nd contains the incremental value added to the first value) and drag this formula all the way to your last record. All the timestamp records should be incremented properly.
😎 Create a new column in your spreadsheet, and copy all the timestamp values computed by the formula into this new column as a value. Then delete the timestamp computed by the formula column and retain the UNIX timestamp written as values column.
9) Excel insists on storing large numbers in scientific notation. When you save your updated csv file, make sure it is saved with the UNIX timestamp column [format cells] saved as a number with zero decimal places.
10) Use the FMV GP tool Video Multiplexer with the inputs being the new VLC video, the metadata csv file and the Video_Multiplexer_MISB_Field_Mapping_Template.csv.
If you do not have video frame corner coordinates, nor the required sensor attitude info, you will only be able to display the ground track of the sensor on the map.
If you have the sensor location and the center of the video frame on the ground (in map projected space), I can see how the video frame could be computed using the Field of View and trigonometry, but that requires the talents of someone well versed in coordinate mathematics and is beyond the scope of this workaround.
All the Best!
Jeff
