create EDL with durations

[Steven Gonzales]

I don’t know about EDL with duration, but you could select the sequence and export Cinema Tools Film List.

Create an empty database in cinema tools (the settings don’t matter, it’s just a dummy target). Change the Telecine Speed: to 30 (assuming you’re using a 29.97 timeline), and change Show: to Time and down below cut handles set Show: to Clip name.

Set your output file and choose your dummy database. You’ll have a listing that has clip name and duration (and a lot of other junk you don’t need.

There’s probably a method with XML, but an XML export REALLY has a lot of extra verbiage.

[Steven Gonzales]

I realized I explained that wrong. After making the dummy Cinema Tools database, (settings don’t matter) go back to Final Cut and File-export-cinema tools film list.

Then set the telecine speed, etc for that film list output, and point to the dummy database.

[Karen Skloss]

Hey, thanks for the work-around idea.

I really don’t use Cinematools and my FCP 5 doesn’t show it as an option to file export (only live type and sound edit). Cinema tools is installed and opens fine but no go. Hmmm…

[Steven Gonzales]

You have to have a sequence selected, or the sequence be the active window. Then you go to the File Menu, Export, and now Cinema Tools Film Lists.

On my version, this is explained on page 145 of the Cinema Tools Manual. To get to the Cinema Tools Manual, you open the Cinema Tools applications, go to the Help menu bar pulldown, and select Cinema Tools User Manual.

[William Gadea]

Another possibility is to drag all the clips in your timeline to a new bin. You will then see the durations in the duration column of the finder. The drawback is that they will no longer be in the correct order.

New York-based Editor-Compositor

[Steven Gonzales]

Also, here’s a timecode log spreadsheet.

You could extract the info from your EDL, plug it into the formulas used in this excel spreadsheet, and calculate duration that way.

You’d have to understand excel a little bit to split out your timecode to 2 columns (perhaps the function on 06:54:32:10 of “=left(cell with original TC, 8)” and “=right(cell with original TC, 2)” would give you 06:54:32 in the time column and 10 in the frames column.

https://www.kenstone2.net/fcp_homepage/images_timecode_spreadsheet/timecode_log.xls

[Carsten Orlt]

you can also use the ‘export>batch list’ function right in FCP

create a new bin
subclip the clips you want from your seq into this new bin
set the coloumns to: start/end/duration
sort by start time
make the tab of this new bin active
export>batch list
this will export a text file with the name and start/end/duration for your clips

if you want to do timecode calculations in excel try this free add in:
https://www.belle-nuit.com/timecode/index.html (haven’t checked for a while so hope it’s still active)

for extraction of clip information via XML have a look at:
https://www.spherico.de/filmtools/
bit cumbersome and limited posibilities but it might do what you want!?

Cofe

[Michael Gissing]

I still have Shotlister running on a PC. Although written for Win 3.1 it still runs under XP.

It convets an EDL into a graphic display of columns, like an old dubbing chart which film sound people used. Duration, source info, descriptions, relative and absolute offsets can be displayed so if you can find a copy of this software out on the net somewhere it will solve this and many other future EDL problems.

It also converts EDLs to other formats ie Sony to CMX etc.