EDL Manipulator

[John-Michael]

Anyone know of a good tool to manipulate EDL files? In particular we get a lot of EDLs from outside editors that have either changed or striped out the reel names. This leads to a lot of manual time entering in the correct reel names in either excel or right in an NLE.

It would be great to have something that looks at the clip name and can insert the correct text in the reel column.

I.E.
clip = A001_C001_blahXY

this tool inserts the following for the reel (pending conform tool)...

reel = A001C001
or
reel = A001_C001

thanks,

[Noah Kadner]

You can typically edit most EDLs in Excel- they're basically text files.

Noah

[John-Michael]

been trying that but generally all the information for an event goes into a single block, which isn't very helpful. Not being much of an excel guy - is there a specific way an EDL needs to be imported to get event info broken out?

[Yevgeny Gultaev]

I do not sure that I understood this topic right, but here is what I have done:
Just a little Python script manipulator with EDL form Final Cut, which helps me to conform with SpeedGrade.

Python script, which makes the following thing with
CMX 3600 EDL file from Final Cut:
(Do not forget to checkup Clip Names check box and set audio tracks to none)


For example EDL includes the following block:
009 A001C007 V C 16:37:12:10 16:37:19:01 00:04:12:11 00:04:19:02
* FROM CLIP NAME: A001_C007_0711WG_M
FINAL CUT PRO REEL: A001_C007_0711WG REPLACED BY: A001C007


After edit with script it will be so:
009 A001C009 V C 16:37:12:10 16:37:19:01 00:04:12:11 00:04:19:02
* FROM CLIP NAME: A001_C007_0711WG_M
FINAL CUT PRO REEL: A001_C007_0711WG REPLACED BY: A001C009

After edit SpeedGrade DI will count reels number right.

I had to wrote this script because of I got the following blocks at my EDL.
For example:
009 A001C009 V C 16:37:12:10 16:37:19:01 00:04:12:11 00:04:19:02
* FROM CLIP NAME: A001_C007_0711WG_M
FINAL CUT PRO REEL: A001_C007_0711WG REPLACED BY: A001C009

010 A001C009 V C 16:37:12:10 16:37:19:01 00:04:12:11 00:04:19:02
* FROM CLIP NAME: A001_C007_0711WG_M
FINAL CUT PRO REEL: A001_C007_0711WG REPLACED BY: A001C009

011 A001C009 V C 16:37:12:10 16:37:19:01 00:04:12:11 00:04:19:02
* FROM CLIP NAME: A002_C007_0711WG_M
FINAL CUT PRO REEL: A001_C007_0711WG REPLACED BY: A001C009

As you can see in this case SpeedGrade DI will create one REEL called
A001C009 linked with A001_C007_0711WG_001.R3D, and
A002_C007_0711WG.R3D will get error "out of range".


Please take a look at attached zip file. It is includes script, "howto" and examples. Feel free to ask.

[John-Michael]

I think this is it - or very close.

In your examples you have a reel already in the correct section that you are changing to another clip. In my case I don't have a reel (is is listed as AX) that I want to replace with the correct reel (A00xC00x) - I'm going to run the script in a moment and test...

Out of curiosity, what made you want to change the reel to a different clip from the original. Or in other words why did you align A007 to A009?

[Yevgeny Gultaev]

Because of SpeedGrade did not "want to see" all clips used in the edl. Because of edl after Final Cut can include a lot of A007 associated with a lot of real name clips, in this case SpeedGrade will associate A007 with first one clip, each other will get error on conform.

[John-Michael]

I've tried a couple tests with no luck. the script seems to run but get stuck.

At first I tried it on an entire film reel (about 20 min) and when that didn't work I thought maybe there were too many events, so I tried a second edl with 3 events. it also got stuck.

could there be something I'm missing? I also checked for possible permissions issues that could have prevented the script from writing new data - but that seems fine too.


thanks!

[Yevgeny Gultaev]

Snow me your edl here, please.

[John-Michael]

please see attached docs. Note the events have no reel name entries - even noted in the EDL. It is bewildering how often this has been happening.

thanks!

[Karim Iglesias]

hello Yevgeny,
I downloaded the reelname corrector, but i dont know how to use it I've read the instructions but i don't know how todo steps 2 and 3, could you please explain me those steps?

thanks

Karim

[Michael Cinquin]

this tool : http://www.michaelcinquin.com/tools/edl_repair has a few different options for edl manipulation.
New options could be added via a http://www.michaelcinquin.com/tools/tailor_made job


cheers

[Mikael Lubtchansky]

I also wrote a small applescript to make RED16 EDLs out of Final Cut Pro ones...

check my signature below for the reduser link to the RED16 (free) script

Best

Mikael

[John Pilgrim]

Based on a current project need and in part inspired by this thread, I wrote some regular expressions and Python to add clipnames to video events in an EDL, based on the reel name. Here's a write up with the code: http://www.johnpilgrim.net/client/reference/grep/

[Björn Benckert]

Simple text / text edit works fine.

But do you need the reel names could you not just skip it and go by time code?

[John Pilgrim]

Anyone know of a good tool to manipulate EDL files? In particular we get a lot of EDLs from outside editors that have either changed or striped out the reel names. This leads to a lot of manual time entering in the correct reel names in either excel or right in an NLE. It would be great to have something that looks at the clip name and can insert the correct text in the reel column. This Python script solves the specific problem described by the OP. It replaces any reels "AX" with an "A00xC00x"-style reel derived from the 'from clip name' entry. Here is the code for your own use and amusement: http://johnpilgrim.net/client/reference/morePythonEDL/replaceBadReelEDL.02.py.zip In the code, the Python re.sub method scans the originalEDLcontent for a particular pattern (written in unix "regular expression" language) and replaces any matches with a replacement pattern (also written as a regular expression). The code could easily be reworked to generate a new reel from any part of each entry by changing the search and replacement pattern expressions. http://johnpilgrim.net/client/reference/morePythonEDL/replaceBadReelEDL.02.py.png