Modding REDcsv

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[0] = f[0].split("/").last f[38] = "=\"" + f[38] + "\"" 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.