When you run the installer for Red Alert! it installs the RedAlert! application, the command-line utility RedLine, and also Automator Actions which include REDale, REDrender, REDwrapper and ... my personal favorite REDcsv. REDcsv returns the meta-data fields in the R3D file in a CSV table so you can use it in other ways. We use this all the time, primarily to create MEDIA REPORTS and DATA LOGS. There ate currently 43 meta-data fields exposed (as of FIRMWARE BUILD 17, RedAlert installer v3.6.0): 1 - Filename 2- ReelID 3 - Camera 4 - Reel 5 - Clip 6 - Date 7 -TimeStamp 8 -FrameWidth 9 - FrameHeight 10 - FPS 11 -Total Frames 12 - TOD TC Start 13 -Edgecode Start 14 - TOD TC End 15 - Edgecode End 16 - ColorSpace 17 - GammaSpace 18 - Kelvin 19 - Tint 20 - ISO 21 - Exposure 22 -Saturation 23 -Contrast 24 - Brightness 25 - GainRed 26 - GainGreen 27 - GainBlue 28 - Black X 29 - Black Y 30 -Toe X 31 - Toe Y 32 - Mid X 33 -Mid Y 34 - Knee X 35 - Knee Y 36 - White X 37 - White Y 38 - Shutter(ms) 39 - Shutter(sec) 40 - Shutter(deg) 41 - Firmware 42 - Audio Channels 43 - File Segments
Here's the basic Automator build:
Ask For Finder Items - I always type "Select Folder with REDCODE" after "Prompt:"
Get Folder Contents - check "repeat for each subfolder found"
Filter Finder Items - Whose: Name contains "_001.R3D"
REDcsv New Text File - "Save as:" enter name and location of where you want teh CSV saved I use Apple's NUMBERS - so I like to add the following - Open Finder Items - "Open with:" Numbers Now, the first think you will notice is that 42 fields is sometimes more than you want or need.
The next thing you will notice is that the Filename includes the PATH - which can be good - but sometimes you want JUST the actual filename. you get this: /Users/offhollywood/Desktop/A002_110275.RDM/A002_C001_1102AJ.RDC/A002_C001_1102AJ_001.R3D you want: A002_C001_1102AJ_001.R3D
You will also notice in the field Shutter(deg) - it displays a DATE in Numbers (or Exel) due to the assumtion of fomat based on "/".
So ... here are a few modifications we use with REDcsv:
Add a Run Shell Script Automator action right under the REDcsv action. After the "Shell:" select "/usr/bin/ruby" and also "Pass input" to "to stdin" - then add the following code: while gets f = $_.split(",") f = f.split("/").last f = "=\"" + f + "\"" print f.join(",") end This does two things - it removes the path from the filename field, and it corrects the formatting of the Shutter(deg).
Then, you can add another Add a Run Shell Script Automator action to CUT DOWN the number of fields to get just what you want/need: Run Shell Script - After the "Shell:" select "/bin/bash" then type cut -d, -f (field numbers you want separated by commas) Typically, I like Filename, Camera, Date, FrameWidth, FrameHeight, FPS, TOD TC Start, TOD TC End, Firmware, Audio Channels, File Segments - so I type cut -d, -f 1, 3, 6, 8, 9, 10, 12, 14, 41, 42, 43.
Hope this is helpful to some folks - and be aware that these fields & what REDcsv could change in future builds. ** please note: if you have and SPACES anywhere in the path to your REDCODE - the Automator action will fail.