Redemption by Surreal Road

[Jack James]

Hi all,

For better or worse, I've decided to release "Redemption" the application we've been using internally to track and manage the Red camera clip metadata for free (under a GPL) along with the Filemaker Pro source.

Right now it's mainly useful for building batch scripts and so on.

Some of its features:

• import a redline csv file
• add notes and images to clips for reference
• print a log of all the data, broken down by reel
• set up templates for batch-processing clips (e.g. with redline)
• automatically add proxy movies or generate reference stills from the r3d filenames and add them to the clip records
• execute redline commands directly from the Redemption UI.

More information and download links are at: http://redemption.surrealroad.com

There is a wiki with documentation available at http://sites.google.com/a/surrealroad.com/redemption/

Current build is 005.

Note: There is no upgrade mechanism right now. Installing a newer version will give you an empty database. You should export any previous database contents before upgrading to a newer version.

Feedback is appreciated, please leave it here...

A couple of screenshots are attached.

Jack

 

[Shawn Booth]

Thank you surreal.

 

[Andreas Herzog]

Thank you!

 

[Chris Swartz]

So if I have a version of Filemaker Pro for windows, this won't work?

Chris

 

[Jack James]

So if I have a version of Filemaker Pro for windows, this won't work?

Chris

The source (fp7) should certainly work, there's nothing in there specific to OS X, but there is no standalone build/.exe version (yet). I also have no experience of working with the windows version of Redline (if there is one).

Let me know if you run into problems with it.

 

[MikeHedge]

genius

 

[Jack James]

A new build is available (same link, see the original post).

Changes:

1. No longer goes to clip list if import is cancelled.
2. Import also prompts for reel generation.
3. Added option to show/hide toolbars
4. Changed the way the database summary is calculated
5. Fixed help page buttons
6. Removed script visibility from menus
7. Fixed redline template to correctly output format code
8. Template defaults to use _{Date} as part of filename output
9. Template field highlights when an invalid tag is set (for example if no filename is specified)
10. Fixed date formatting to match latest redline version
11. ReelID is now calculated from Camera and Reel if they are specified
12. Redemption will highlight redline options it thinks might be useful to change based on other options you’ve set
13. Fixed filename output for when filename begins with “././”
14. Fixed a crash that could occur due to a corrupt preferences file.
15. Added an (experimental) Windows version

Please note, upgrading from an earlier version is not currently possible. You can do it manually by exporting data from the old version and then importing it into the new one.

 

[Agustin Goya]

Thanks!

 

[lab601]

this is great, thanks!

 

[lab601]

add avid codecs?

add avid codecs?

redline seems to have limited codecs for qt transcode, do you know if it's possible to do QT transcode to Avid DNX codec with redline - if so it would be good to have it added to the dropdown choices? redcine allows this codec.

dave

 

[Jack James]

redline seems to have limited codecs for qt transcode, do you know if it's possible to do QT transcode to Avid DNX codec with redline - if so it would be good to have it added to the dropdown choices? redcine allows this codec.

Unfortunately redline doesn't seem to have this functionality (yet?). I might try to see if there's a way of doing it with Applescript, but I wouldn't hold your breath.

Having said that, I've just noticed that one of the more recent builds of redline include Uncompressed 4:2:2 8/10bit quicktime options which are not listed in Redemption.

I've just completed build 3 of Redemption (more details on that in a second), so those two presets will have to wait to get added in build 4.

 

[Jack James]

Build 3 is now available (the Windows version is unchanged).

Noteworthy changes are the use of Applescript to automatically add proxy movies or generate reference stills from the r3d filenames and add them to the clip records, and also execute redline commands directly from the Redemption UI.

Changes:

1. Added growl support (Mac OS X only)
2. Added the ability to highlight/select individual clips
3. Added the option to limit exported batch list to selected clips
4. Added {ResizeX} and {ResizeY} template tags
5. ISO value is now stored per clip
6. Added a button to run redline command from clip record (Mac OS X only)
7. Fixed {Path to Reel} tag to account for 2-digit year formatting of date
8. Added buttons to generate a reference image and insert it into the current clip record or for all clips (Mac OS X only)*
9. Added buttons to insert QuickTime proxy into the current clip record or for all clips (Mac OS X only)*
10. Prompts to automatically insert QuickTime proxies or stills after import
11. Added a button to the help page to execute the redline csv generation (Mac OS X only)
12. Separated out some of the data to help facilitate some sort of upgrade functionality in future versions
13. Shows random images on front page

*Note these functions require the Red QuickTime codecs to be installed, that the QuickTime wrappers have been created, and that the filepath is set as an absolute path (i.e. “/Volumes/Disk Drive/Folder/file”)

See the original post for download details

 

[lab601]

i just tried this but having trouble with the source paths that the script is generating.

after scanning the computer, import the csv, i have a filename that shows as

././Volumes/test/r3d/A001_C001_071104_001.R3D at the top

in the command script though it is making bad path to the source with a . in front so it cant find the file when you run it.

redline -i "./Volumes/test/r3d/A001_C001_071104_001.R3D" -o "/Volumes/Jekyll/temp/A001/2048x1024/" --format 10 --renum -1 --resizeX 2048 --resizeY 1024 --gammaCurve 1 --NR 250 --useMeta ./Volumes/test/r3d/

also the qts and single frames areentt working, but maybe the same issue with the path?

i swear i was working with this successfully yesterday...

any ideas?

 

[Jack James]

yes I see the problem. I'll have a new build with the fix in about an hour. Sorry about that.

 

[Jack James]

a quick update to address the problems just mentioned.

1. Purging database now also resets the Redline template.
2. Changed the way “././” in filenames is handled to be the same as build 2.
3. Added uncompressed 4:2:2 QuickTime codec choices.
4. Corrected ISO template tag.
5. Temporary workaround for curve parameter mis-match in redline when useMeta is unchecked.

 

[lab601]

thanks very much, i'll try it in the morning.

how would you use it on a project by project basis, would you do a "save as" and keep each project as it's own redemption file? what might be a good thing to think about is having multiple project indexing within the same database.

also, how does it deal with issues like moving the red data files to another location, will the 'update' on import add new records or update any changed location data for records already in the database.

being able to customize and save multiple batch templates would be nice too.

dave

 

[Jack James]

how would you use it on a project by project basis, would you do a "save as" and keep each project as it's own redemption file?

At the moment that would be the only way to do it. In theory you'd only need to keep the userdata.rdm file in each case, but it's worth saving the redemption.rdm also, just in case.

For what we've been doing, we've just nuked the database at each stage (i.e. preparing rushes, then preparing online, etc.) but I can see how having a permanent archive would be helpful.

The real issue right now is that Filemaker doesn't provide for any sort of upgrade mechanism, which means that every time the software is updated, you have to start with an empty database.

What I'll hopefully do for the next version is implement some method for exporting all the main stuff into a single file, and then that file can be imported into any future version of the software.

what might be a good thing to think about is having multiple project indexing within the same database.

That should be possible at some point. I can't promise it in the next version though...

also, how does it deal with issues like moving the red data files to another location, will the 'update' on import add new records or update any changed location data for records already in the database.

I just checked this, and it's currently set to match by filename, which doesn't make an awful lot of sense, I'll grant you. I'll change it to match by ReelID, date and timecode and see how that works out.

being able to customize and save multiple batch templates would be nice too.

The infrastructure for this is in place, I just need to sort out a few kinks.

 

[lab601]

thanks thats fixed the path for the script.

i am unable however to get the add qt proxy to it to work or dont see what it is supposed to do, it does say however that "imported proxies"

i dont seem to be getting the add images either- i says "movie unavailable" then "imported images" no image is added to the record. am i missing something?

also you should put in default values for the b/w toe mid and knee. otherwise they have to be manually entered to get something other than a black render.

another feature req would be the a button in the colour window to "reset" to default and also a "copy" and a "paste" colour buttons to transfer settings from clip to clip. or also "import" redalerts .RLX preset into the colour fields

this is turning into a great tool, thanks!

dave

 

[Jack James]

i am unable however to get the add qt proxy to it to work or dont see what it is supposed to do

The add proxy/auto-add images will only work if you have previously generated QT files with redline (or if you had set the camera to do this for you). What it does is load the quicktime (or an image from the quicktime) into the clip details page. Presumably you don't have these proxy files for any of your footage? If you do, let me know.

it does say however that "imported proxies"

I will change that t say how many it imported in the next version (in your case, 0).

i dont seem to be getting the add images either- i says "movie unavailable" then "imported images" no image is added to the record. am i missing something?

no, because importing the images works in the same way as importing the proxies-- you'd still need to have the proxies along with the R3D files.

also you should put in default values for the b/w toe mid and knee. otherwise they have to be manually entered to get something other than a black render.

This is very strange. If you used a CSV file to create the records, it should just use the values from that. Either way, if you leave it blank it will just go with the defaults. Perhaps in the next version I'll change the way this works.
The other problem is that the values that redline outputs for these are different from what it expects as an input-- I'm still waiting for someone to get back to me on that.

another feature req would be the a button in the colour window to "reset" to default and also a "copy" and a "paste" colour buttons to transfer settings from clip to clip.

A good idea.

or also "import" redalerts .RLX preset into the colour fields

No promises, but if I can find a simple way to do it, then sure!

 

[lab601]

This is very strange. If you used a CSV file to create the records, it should just use the values from that. Either way, if you leave it blank it will just go with the defaults. Perhaps in the next version I'll change the way this works.
The other problem is that the values that redline outputs for these are different from what it expects as an input-- I'm still waiting for someone to get back to me on that.

you are right, i looked at the csv and all those values are 0.00000, i guess that was how the camera recorded them, these files came from last year.

dave