Welcome to our community

Be a part of something great, join today!

  • Hey all, just changed over the backend after 15 years I figured time to give it a bit of an update, its probably gonna be a bit weird for most of you and i am sure there is a few bugs to work out but it should kinda work the same as before... hopefully :)

EDL Manipulator

John-Michael

Active member
Joined
Apr 3, 2007
Messages
26
Reaction score
0
Points
0
Age
48
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,
 
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?
 
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.
 

Attachments

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?
 
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.
 
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!
 
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!
 

Attachments

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
 
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
 
Simple text / text edit works fine.

But do you need the reel names could you not just skip it and go by time code?
 
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.
replaceBadReelEDL.02.py.png
 
Back
Top