I am working with Bill Bennett, ASC today to test out a workflow for VFX where we would be able to get Lens Data and Tilt/Roll information from the Log-C Quicktime files coming out of an Alexa Plus.
We knew that all metadata information is saved in the Quicktime video file including "per frame" info for things like F-Stop, Focal Length and Zoom data:http://www.arri.de/camera/digital_cameras/technology/recording_formats/metadata.html
The problem was that there aren't meta data readers available for quicktime that spit out frame-by-frame info. Luckily Arri just released "Meta Extract" for both Mac and PC which is a software that runs in a terminal window (command line) and allows you to spit out a semi-colon delimitated CSV database file which you can open in Excel. The database is organized by timecode and contains info for every frame in your shot. Some info is static (exposure index, look file, etc.) and other info changes line by line (f-stop, tilt, roll).
Here is the download page for both the instructions (release notes) and software for "Meta Extract":http://www.arri.com/download_search/download_search.html?action=fulltext&suchoption1_id=&suchoption2_id=&suchoption3_id=&searchtext=meta&cHash=0798f1595e344d26be316135a88cfbb0
Read the PDF as it gives you precise instructions on how to extract the data. For example, to extract the MetaData for a video file named "A002C016_110719_R33F.mov" on the desktop and make a CSV file called "A002C016_110719_R33F.csv" you would type:./ARRIMetaExtract /Users/MyUser/Desktop/A002C016_110719_R33F.mov /Users/heugel/Desktop/
This will also extract a look file, in .xml format, that was used for that shot (if you had a Look assigned in the camera) which you can run through the LUT generator to get an LUT without having to go back and find the original Look file.
When you want to look at the CSV file in Excel or another database viewer, make sure you open Excel and do an "import" of the CSV file as opening directly will give you an incorrect display. During import, be sure to specify that the file is "semi-colon delimitated" and don't reformat the columns. The database opens up and you can see your shot frame-by-frame along with all the MetaData that is recorded. To get a list of extracted fields that will show up in the database, see the Meta Extract release notes PDF. Here is a direct link to just the PDF:http://www.arri.com/?eID=registration&file_uid=8075
I have attached a CSV file that we were able to extract from a Quicktime ProRes 422(HQ) file that came out of Bill's Alexa Plus which had an LDS UltraPrime 50mm lens attached.
Post any questions!