So how do Walter Murch (and others) use File Maker Pro with FCP?

[Oliver Peters]

Dave,

I’ve interviewed both for Videography and the impression I have is that they have set up a custom database that they run in parallel to editing. Their use of this predates Murch cutting on FCP and I don’t think that they actually move data from FMP to FCP. It simply provides a more detailed cross-reference, including director’s comments, impressions of dailies, all the technical data, etc. I believe they put the database on their SAN system so it is accessible to all of the editors and assistants.

Sincerely,
Oliver

Oliver Peters
Post-Production & Interactive Media
Orlando, FL
http://www.oliverpeters.com

[David Dubois]

Thanks for the info Oliver.

I was leaning towards that description from what I had been reading.
Also, from what I can tell, they use XML to transfer timecodes and clip notes from FMPro to FCP.

If I’m correct, I’m amazed that Apple don’t hype this feature more as it could lead to more FMpro sales.
I know that I’d much prefer my director to be logging in FMpro rather than ‘word’ as I we get all sorts of issues cropping up almost daily.
Templates and workflow, Apple?… you listening?
🙂

Anyone else have any input?

Thanks again.

Dave

G5 2.5 Dual
2.5 gig ram
x800 xt
1TB media storage
23″ Cinema display
19″ IBM LCD – used for Cinema Display
FCP Studio (FCP 5.1.2)
After Effects 7
Shake 4

Currently working on ‘Lookin’ For Lucky’
Feature Film for Albino Injun Productions.
http://www.lookinforlucky.co.uk

[Paul Dickin]

Hi
Whilst FileMaker Pro is relative easy to use (for a mere video editor, not a database guru) to set up quite a sophisticated information database, setting it up any sort of timecode calculation fields is far from trivial.
Even for just straightforward PAL NDF logging – before you start complicating matters with DF/NDF, and colon/semi-colon display differences….

[David Dubois]

OK. Why is setting up a TC field difficult (I’ve never used FMpro but have seen it done in ‘word’)

And having said that, Walter and Sean have set up these fields… has anyone else managed to get a shot logging system set-up and working properly in FMPro?

Cheers

Dave

G5 2.5 Dual
2.5 gig ram
x800 xt
1TB media storage
23″ Cinema display
19″ IBM LCD – used for Cinema Display
FCP Studio (FCP 5.1.2)
After Effects 7
Shake 4

Currently working on ‘Lookin’ For Lucky’
Feature Film for Albino Injun Productions.
http://www.lookinforlucky.co.uk

[Paul Dickin]

[David DuBois] “Why is setting up a TC field difficult”
Because FM Pro doesn’t have a simple boolean calculation scripting language – if timecode = x then y frame numbers are dropped, if not then frame count increments normally, in 30s…
Instead FM Pro requires you to set up nested mini relational-databases to deal with each seperate if-then-else category.

[Bob Flood]

hi

https://www.pipelinedigital.com/logging-solutions.html

check this out for FMP users

bee eph

“I like video because its so fast!”

Bob Flood
Greer & Associates, Inc.

[David Dubois]

I gettcha Paul. Thanks for explaining.

and thanks for the link Bob. Looks really interesting!

Dave

G5 2.5 Dual
2.5 gig ram
x800 xt
1TB media storage
23″ Cinema display
19″ IBM LCD – used for Cinema Display
FCP Studio (FCP 5.1.2)
After Effects 7
Shake 4

Currently working on ‘Lookin’ For Lucky’
Feature Film for Albino Injun Productions.
http://www.lookinforlucky.co.uk

[Mark Raudonis]

As long as you’re recommending FMP based logging solutions… may I suggest checking this out:

https://www.pilotware.com/

This may be overkill for what you’re doing, but it’s been indespensible for us.

Mark

[Shelley Wenk]

Hi, Dave – Did you ever find a good Filemaker template for editing purposes? I’m trying to build a database to log and store raw clips for future use, and need to be able to play an embedded (not referenced) quicktime file in another container field in FMP (trying to replicate the Photo or Video Clip field from the Bento Video Clips template, if you’re familiar with that.)

swenk