-
EDL to XLS
I was hoping someone could help tell me of an efficient way of exporting all my video information within a sequence into a nice neat excel spreadsheet. For the past 3 months, we’ve been doing shotsheets (for deliverables) in this painstaking process of exporting an EDL and then formatting it into an excel sheet. It’s a real pain in the butt. We’ve also experimented with using an XML. There is an XML to Text program out there, but it doesn’t work with FCP 5, and it leaves out a lot of information. What I need is the clip name, its in and out points in the sequence, and its duration in a nice neat XLS. I’d love to hear any suggestions. Thanks.
Neil
-
3 Replies
-
hey neil
i have been messing around with trying to get bin info and edl’s out of an older nle (edit) and into FCP, as we are migrating that way. As such I have been stumbling around looking for txt, edk, xml converters etc. Here are some suggetsions, which i have not tried but claim to work
Take your sequence, put it in a bin, make a batch capture log, and see if you can bring that into excel, it may even put your clips in sequence order
also look into dharmafilm.com and sebsky tools, for converting fcp into ALE, which is a text based file that can be brought into excel
is the xml to text program you are referring to here:
https://www.spherico.com/filmtools/XML2Text/
he sez he is looking for beta testers.
also how about automatic duck, maybe one of the flavors it supports can be read by ecel as a text file?
hope this helps
bee eph
Bob Flood
Greer & Associates, Inc. -
Thanks Bob. I appreciate your suggestions.
The problem with puting my sequence in a bin and making a batch capture log is that the sequence information is lost. I can get the ins and outs of the clip according to the original source material, but not the sequence ins and outs of the clip.
Yeah, that is the XML to text program I was referring to. It’ll be great when he’s done with it. He’s got a sure buyer here.
I’m going to look into automatic duck. Once again, its plugin is for FCP 4 and 4.5 so it’ll take me a bit longer to work with since we’re using 5 here. I’ll let you know. Couldn’t find anything at Sebsky.
Anyway, thanks again. I really appreciate your input.
-neil
-
I don’t know what your’e trying to do, but our plug-ins for Final Cut Pro work great in FCP 5.
— Wes Plate
Automatic Duck
Reply to this Discussion! Login or Sign Up