FCP XML to Excel – Anyone know how?

[Andy Mees]

try Final Print from Digital Heaven, you can print your bins with clip names, log notes comments, thumbnails etc … not bi-directional and not to Excel, but theres a free demo so its worth your time taking a look
https://www.digital-heaven.co.uk/finalprint/

[Jamie Pickell]

I have been looking for something similar, but to use the XML information to generate annotated EDLs otherwise known as Shot Sheets. I just found out last night that my assistant editor knows XML and he is trying to tackle this very problem of taking FCP’s XML data and translating it to an Excel spreadsheet.

I also sat in on a meeting yesterday regarding the use of PilotWare in our productions. It is my understanding that PilotWare uses EDLs to pass information back and forth with AVID, but uses XML to pass information back and forth with FCP. PilotWare is designed to track all the assets used in a particular production including stock footage and release information. It is also supposed to greatly help in the creation of annotated EDLs and music cue sheets. I have not seen it used, but hope to soon as our production/post-production division will be implementing it soon. It may be overkill for what your looking for, but check them out at pilotware.com

On the XML note, if my E2 comes up with an XML to Excel scripting program, I will be sure to post the results here on the Cow.

Jamie
FCP 5.1.4
Kona 2
Dual 2.5 G5
XRaid

[Bob Flood]

Hi

Spherico Film Tools has a product called XML to TEXT and it lets you save out an xml file as a text file, which you can then bring into Excel

but what about a batch list? this is basically a text version of a bin, with any and all columns visible in your bin showing up as tab delimited text, which can be brought into excel.

hope this helps

“I like video because its so fast!”

Bob Flood
Greer & Associates, Inc.

[John Adams]

Big thanks to both Andy & Jamie for their quick and helpful replies.

Andy — I just downloaded the trial of Final Print and although it’s not exactly what I’m looking for it’s a step in the right direction and a huge help.

Jamie — Pilotware sounds interesting. Thanks for the tip. And please do keep me in the loop if your no.2 pulls off some xml wizardry. I’ve got a coder friend working on the same thing for me. I’ll let you know if we get results.

[David Heidelberger]

I’ve got a beta version of a program to translate a sequence XML to Excel up on my website:

http://www.davidheidelberger.com/software.html

– David

[John Adams]

[Bob Flood] ”
but what about a batch list? this is basically a text version of a bin, with any and all columns visible in your bin showing up as tab delimited text, which can be brought into excel.”

I had to laugh at myself for a good long while before replying, Bob. Thanks for your tip. It’s just what I’m looking for. Was too busy thinking the solution needed something elaborate to see the simple answer in front of my face.

Cheers, Bob, and everyone for their help.

[Andy Mees]

[Bob Flood] “but what about a batch list?”

doh! can’t see the wood for the trees …. nice one Bob 🙂

[Jeremy Garchow]

[Bob Flood] “hope this helps”

Nice one, grasshoppa!

[Jamie Pickell]

David,

Thank you for your work on your XML analyzer tool. I read your Readme file and decided I couldn’t use your program at this time. All my shows are drop-frame and I rely on the Master Comments fields to input data such as shot ownership, production number, and other information my AP is required to put in the annotated EDL. Please conitnue your work on your XML analyzer, it sounds like a powerful tool and I look forward to putting it through its paces.

Cheers,
Jamie

FCP 5.1.4
Kona 2
Dual 2.5 G5
4GB Ram
XRaid

[Bob Flood]

thanx guys

happy to help

“I like video because its so fast!”

Bob Flood
Greer & Associates, Inc.