Media

assistant editor Unix tricks

Monday, January 25th, 2010

It’s time to take apart some Final Cut Pro xml and add some newly received VFX clips to the VFX database. One of these days, I’ll explain all of these steps and how they might be useful in other workflows. For now, enjoy a look at a relaxing vacation from graphical user interfaces and mouse-clicks; A trip to the Terminal. If you have any Unix or XML knowledge, there might be something of interest in here.

Assistant-2:20100125 CAB$ xmlstarlet sel -t -m "//children/clip"\
-v "name" -o "," \
-v "out - in" -o "," -v "in" -o "," -v "out" -o ","\
-v "media/video/track/clipitem/start" -o "," \
-v "media/video/track/clipitem/end" -o ","\
-v "media/video/track/clipitem/file/timecode/frame" -o ","\
-v "media/video/track/clipitem/file/name" -o ","\
-v "media/video/track/clipitem/file/timecode/string" -o ","\
-v "media/video/track/clipitem/file/timecode/reel/name"\
-n 20100123_vfx_received.xml | tee 20100123_vfx_received.csv

52A-2_01_VFX_v1,178,0,178,0,178,,52A-2_01_VFX_v1.mov,,
52A-2_02_VFX_v1,141,0,141,0,141,,52A-2_02_VFX_v1.mov,,
52B-2_01_VFX_v1,152,0,152,0,152,,52B-2_01_VFX_v1.mov,,
53-3A_01_VFX_v4,307,0,307,0,307,,53-3A_01_VFX_v4.mov,,
54-3A_01_VFX_v1,188,0,188,0,188,,54-3A_01_VFX_v1.mov,,
C100_C016_0920LS_03_VFX_v1,102,0,102,0,102,,C100_C016_0920LS_03_VFX_v1.mov,,
C102_C011_0903RU_03_VFX_v1,79,0,79,0,79,,C102_C011_0903RU_03_VFX_v1.mov,,
C102_C011_0903RU_04_VFX_v4,256,0,256,0,256,,C102_C011_0903RU_04_VFX_v4.mov,,
C102_C011_0903RU_05_VFX_v2,200,0,200,0,200,,C102_C011_0903RU_05_VFX_v2.mov,,
C102_C011_0903RU_06_VFX_v2,147,0,147,0,147,,C102_C011_0903RU_06_VFX_v2.mov,,

Assistant-2:20100125 CAB$ cd thumbs/
Assistant-2:thumbs CAB$ tcsh
[Assistant-2:additions/20100125/thumbs] CAB% foreach foo (*.png)
foreach? convert -geometry 330x800 "$foo" "$foo:r.jpg"
foreach? rm "$foo"
foreach? end
[Assistant-2:additions/20100125/thumbs] CAB%

The starting point is a bin of clips in an FCP project. I’ve exported that bin as FCP XML, and have also batch exported the clips inside it as stills (to PNG, the default). The commands above are the meat of the process. Then the comma-separated-value list of clips I generate with the xmlstarlet command gets imported into an openoffice (or Excel) spreadsheet (a step I’ve ommitted here), and is massaged into a csv format for import into a Filemaker Pro database of VFX clips. Finally I import the thumbnails for each clip into the database. Fun stuff, pretty much.

Only in Hollywood -er, Burbank

Friday, November 13th, 2009

a sign at a restaurant in burbank that reads "Absolutely no autographs; no pictures"


Well, I didn’t feel like signing any autographs yesterday anyhow. (photo taken at Poquito Mas in Burbank, CA)

Leaving Michigan

Friday, October 23rd, 2009
Montcalm road
Montcalm road, Lowell, Michigan
My server’s been offline the better part of the last month due to the fact that I’ve been out of town and some errant process filled up my swap partition 1. So I’ll be backtracking in subsequent posts and filling in some details of my Michigan sojourn that I haven’t yet had the ability to post.

 Mg 1289
When the traffic signs are riddled with gunshot, it’s probably best to wear orange clothing and remove your bambi costume.
But here’s a bit of news from the present, surrounded by photos from my last drive into the countryside 2: I’ve been in Michigan for a couple of months working on a film, and today I’ll be heading back to LA to continue working on the film for another month. My plan then entails relaxing for a couple of days with nothing to do, then a freak out and mad scramble to find another gig. I’ll be back in Los Angeles come Monday 10/26/2009. Let the wild rumpus begin 3.

 Mg 1386
Does the windmill at the center of this field really serve any function at all? And what crop is that? It’s not corn, not wheat. Everything in this photo might represent form without function. I’d have trudged further out into this field to get you a better view, but the wacko crop made it difficult and I was worried the farmer would appear and shoot me.
I will miss some things about this town. I’ll save them for a later post, which would have been an earlier post but for the problem noted in paragraph 1 of this post. Ah well, life goes on. It’s nice to be back online, and will be nice to be back home.
 Mg 1243
Oh hey, a cat. Who doesn’t love cats?

  1. Yeah, one would think that swapping partitions was a “Free Love” era tradition, but it continues in all modern operating systems. There are even key exchanges. ↩︎
  2. Photos shot on 10/18/2009, click any of them to see them writ large. ↩︎
  3. “Begin” is an anagram for “being”. Think about it. Stop thinking about it. ↩︎

Maximum irony encountered while washing dishes

Sunday, September 20th, 2009

People fishing under the dam in Lowell

Sunday, September 20th, 2009
fishing under the dam in Lowell, Michigan
At left can be seen a few folk fishing under the dam (center) on the Flat River here in Lowell, Michigan

The photo was taken (and stitched) within a few feet of this location:


View Larger Map

Flags and Industry in Lowell, Michigan

Saturday, September 19th, 2009

A flag on main street
A flag on main street

  1. Stitched from a few photos on iPhone with the very fun ‘AutoStitch’ app. ↩︎

L’shana Tovah everyone

Saturday, September 19th, 2009
Img 3098

I’d have titled this “L’shana Tova Y’all”, but it appears that actor Levar Burton beat me to the punch.

After a few weeks of living in a hotel room in Grand Rapids, I’ve packed up my things and moved into a shared apartment with the film editor here in Lowell, MI, just a couple of blocks from the editing room. It’s nice to no longer have to drive 25 miles to and from work every day. Tonight I used that extra time to prepare my own dinner rather than eat out. Hooray for homey food that isn’t beige.

Lowell, MI 9/14/2009

Monday, September 14th, 2009

Seen on main street today while walking over to the Flat River Grill to pick up lunch for editorial.

photo of Lowell's main street

Life lessons from Ernest Borgnine

Sunday, September 13th, 2009

Ernest Borgnine, the vivacious 92-year-old actor who stars in the film on which I’m working ( The Genesis Code), dropped some impressive words of wisdom on a Fox News reporter a while back when asked for his anti-aging secret.

What he said.

The crackdown on motor vehicle fuel theft begins

Sunday, September 13th, 2009

I guess Michigan must have a serious “motor vehicle fuel theft” problem. That and the most serious-looking police officer/models in the country.

Img 3041
Drive-offs don't drive in Michigan
If one photo is good, two is better.