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