I need to complete a music list for my producer. It has to include music title (= clip name) and duration of use. Composer, publisher, etc will be added later in Excel.

I generated an EDL with clip names included but when I open it in a text editor all I see is is √œ“D≈“†“≈≈Ɔ“≈√œ“DçBÃœ√K††00±ç††††††††††∆“œM†√Ã…P†NAM≈:††œP≈N≈“_AUD…œ.A…∆ç00000±†œP≈N≈“††A±†††√†††††††††††††±0:00:00.00†±0:00:0∑.05†±0:00:00.00†±0:00:0∑.05熆††††††††∆“œM†√Ã…P†NAM≈:††3∑3±¥≤_◊œ“S≈†‘HAN†Yœ ad nausem...

Consolidating the music tracks and exporting the bin as ALE isn't an option, that way I get the track info but not the actual duration of music use.

I could do it manually and spend several hours doing it but I figure since this sort of work happens a thousand times a day all over the planet there MUST be a simple solution.

Does anyone have one?

Thanks!

Rodney

EDL should be fine. I can't think why a normal text editor would not read it, as an EDL is a very, very simple plain vanilla text file.

Hi Rodney,

I haven't played with it much, but there's the "Generate Sequence Report" command (right-click on the composer window) that might help you.

ciao,
Carl 

camoscato:

Hi Rodney,

I haven't played with it much, but there's the "Generate Sequence Report" command (right-click on the composer window) that might help you.

ciao,
Carl 

 

I think I've looked at the reports a few times and although it look suseful I don't think it generates that sort of info. Which is a shame.

 

Job ter Burg:

EDL should be fine. I can't think why a normal text editor would not read it, as an EDL is a very, very simple plain vanilla text file.

I found it strange too. So I tried some other EDl types. The Sony Transfer format I used before I wrote in the forum produces goobledegook, others (Paltex, Sony5000, CMX Transfer, Abekas) produce readable text. 

 

One problem remains though:

An EDL produces much more information than I require:

 

* FROM CLIP NAME:  336328_BY THE STREAM.WAV

000002  336328_B A2    C        10:01:26:15 10:01:40:00 10:00:14:07 10:00:27:17

* FROM CLIP NAME:  336328_BY THE STREAM.WAV

000003  336328_B A2    C        10:00:25:13 10:00:33:20 10:01:12:12 10:01:20:19

 

It also runs information about one clip over two lines of text, making it tiresome to import the information into excel or numbers, forcing me to cut and paste to get the information into usable columns.

So does anyone have a workaround or a suggestion how I can get this done efficiently? 

After all every programme edited requires a music list after completion.

Rodney

 

 

 

The "Generate Sequence Report" option definitely rocks, but not quite for this intended use.  For "Music Cue Sheets" which are often a requirement of stock music licensing companies like KillerTracks and FirstCom, exporting something from the sequence specifically for this would be a nice thing to throw into the Feature Request forum.  In the meantime, since music can overlap in a sequence, it's a bit confusing to see it in the form of an EDL or some other whole-sequence report which includes other stuff as well.

So here's the answer I've been using for years making PBS shows -- works great!

1. Dupe the sequence.  Delete new seq's video layers.  Delete all locators in the sequence.

2. Assign two colors of locators as Music Start and Music Stop (say cyan for start and blue for stop).  Then open your locators window.  Go through seq to the beginning of each song and add a cyan.  Go through again to end and add blues.

3. Print locators.  All in/out info is there, along with NO other distracting information.

HINT -- there's even a Comments window for adding info like "Background" or "Primary" or "Theme" or "Credits".

Here's the solution to my own problem:

Open up the EDL and select EDL Format File_32

Select EDIT

Under the OPTIONS tab, select "show audio dissolves as cuts"

Under the COMMENTS tab, select nothing

Generate the sequence and save it the EDL.

Open a new page in Excel. select import and "text file" (I'm translating from German on the run, the English may be different), navigate to the EDL, ensure that "standard width" (as opposed to "commas and tabstops") is selected. Press the blue buttons and the EDL is imported into Excel with clip names in the second column. I'll still have to calculate the music length (no duration column sadly...) burt perhaps there's an excel formula for that :)

I've probably just reinvented the wheel, but it's a good feeling to know that I'll save myself a half day's work.

 

 

Pixel Monkey:

So here's the answer I've been using for years making PBS shows -- works great!

1. Dupe the sequence.  Delete new seq's video layers.  Delete all locators in the sequence.

2. Assign two colors of locators as Music Start and Music Stop (say cyan for start and blue for stop).  Then open your locators window.  Go through seq to the beginning of each song and add a cyan.  Go through again to end and add blues.

3. Print locators.  All in/out info is there, along with NO other distracting information.

HINT -- there's even a Comments window for adding info like "Background" or "Primary" or "Theme" or "Credits".

Hi Chris

thanks for the tip. But how do you get the music title into your locator list? And how do you work out the duration of each music item?

Agree with you on the Feature Request concept :)

Rodney

Yes sorry -- should have clarified.  I manually add the name to the Comments.  The reason is QUITE often there are five different versions of the song, and the imported clip name doesn't differentiate this.  (Bad metadata on the part of the stock library or the composer.) So I label it as such.  Here's a standard "Comments" field in one of my PBS shows:

MB07a:30-11Bkgd:TRT24

"MB" (Composer's name) "07" (track number as HE named it) "a:30" (track "a" is the :30 version) "-11" (volume I have it set at in the sequence is minus 11 db) "Bkgd" (used as background music, not prominent or theme, which in stock libraries sometimes defines how much the license costs) "TRT24" (total run time 24-seconds).

Note -- I do this process for Image Cue Sheets as well -- so for a documentary that has 249 archival images in it - all from different sources.  It's great because there is a timecode reference to exactly which image is used... so 20 years from now if someone wants to revisit the project (or even redo it), they'll have a paper trail to help them re-up the rights for the image use.

Hey Rodney,

why did you not just call me ;)

Create a sequence with music edits only (possibly A5-A8) and decompose it with no handles. In your bin, select duration as a bin heading. Export the bin with the newly created clips as .... let me have a look... Tab delimited, et voilá, here is your list for Gema.

Is that for Urs Althaus? ;)

cheers

-chris

Chris, that only works if you don't re-use any music.

RodneyinMunich:

I need to complete a music list for my producer. It has to include music title (= clip name) and duration of use.

 

I think Brewer has helped me out with this before... I've certainly used it for an archive tally...

Chris Aust:

Is that for Urs Althaus? ;)

Hi Chris

nope, did Urs Althaus by hand. It's only 25 minutes long and doesn't have all that much music. Now I have a Berlin Wall doco and a 9/11 doco (both 52 minutes) with wall-to-wall music and no opportunity to exploit an intern's youthful enthusiasm.

I just tried the decompose method: Job noted one limitation (repeats aren't listed). Another is that the order of clips seems random, which is a problem - one of the production companies needs the music list in programme order with master timecode start and end.

Rodney

Hi Rodney,

yes, then the option with the edl is the best one.

cheers

-chris