-
Extracting Bin Info (ALEs from FCP)
Hi fellow COW-ers:
I’m trying to export an ALE type file detailing bin information for some merged clips. Specifically, I’m wanting to export the Source info that I can see in the bin from clips that are a merge of some P2 video with some 4-track audio. I need this for the sound department to track back to original sound takes, so they need to see the clip name and the corresponding audio source file name. I can see it on my FCP screen in the ‘Source’ column, but when I export a Batch List and open it in Excel, it doesn’t show the audio source, just the video source.
Does anyone know of a workaround for this? Would an XML export somehow provide info that an application like Filemaker pro would understand?
Any real world advice/experience much appreciated.
Best, JIM.
OSX.4.10
Dual 2.7 G5
3.5 GB RAM
Radeon X800 XT
Kona 2 / K-Box
Seritek 1.5 TB RAID
AVID XPRESS PRO/MOJO -
6 Replies
-
Highlight the bin. Choose File > Export > batch list. Open that resulting text file in Excel.
Does that help?
-
Cinema Tools can export ALE’s. Did you try that?
-
there are some columns in FCP that just wont go into a batch list.
source is one of them.is there ANOTHER column that has the clip names?
description?
scene & take?if not here’s an idea:
make a COPY of your project first, and do this in the copy.get al your audio clips together,
sort your columns by something other than name.
Reel & media start is good
(click on “Reel”, hold SHIFT and click on Media Start)export a batch list with the current clip names,
then select all the audio clips,
and chose Modify > Rename > Clip to MAtch Fileall the clips will adopt the FILE names
but wil still be sorted in the same orderexport another batch list.
you can undo if you want, and teh names should revert,
but this is a copy project, so maybe no need to.open both batch lsits,
and do a copy/paste of the columns.ther might be some Cinema Tools Approach,
but i think this should work.cheers,
nick -
I had this same problem with merged clips only showing video source in the exported batch list.
My solution was to select and drag all the merged clips into a sequence, lock audio tracks, delete video, and drag all the audio back into a new bin. That new audio only bin has the audio source, and exports this to a batch list.
-
Steven:
Thank you so much. Your method works brilliantly. Now the sound folks are much happier, and you know how important that is!
I had to take my clips one step further, and that was to remove the first track of audio from the clips in the sequence, because Track 1 was the original audio from the P2 file which we were using for reference. It was still causing the .mov file to show up in the source column. But once I deleted that everything works like a charm.
Thanks again. The COW rocks!
Best, JIM.
OSX.4.10
Dual 2.7 G5
3.5 GB RAM
Radeon X800 XT
Kona 2 / K-Box
Seritek 1.5 TB RAID
AVID XPRESS PRO/MOJO -
All the audio source information is also in the XML export. Maybe some day I’ll try my meager PERL skills to parse the XML and pull desired information out.
Of course, once I found the simpler solution, my desire to write a parser program went away.
Sound finishers are the editors best friends.
Reply to this Discussion! Login or Sign Up