EDL for Archive in Avid ?

[Michael Phillips]

Not quite following the whole flow – but it seems that vendor codes could be tracked in any custom column, and there are 5 extra timecode columns to track alternate/in-house codes. Depending on how this is tracked in spreadsheet/database, the TAB file can be converted to ALE and merged into existing clips.

Michael

[Rosie Walunas]

This is helpful.

Yeah, I was thinking, use a column to copy the original vendor codes to. But I assume this will not be exported in the EDL? Does the EDL just out put the clip names that the clips get called in the Name column? Or what?

How can these be used? “5 extra timecode columns to track alternate/in-house codes.” For example, the source TC of the clip probably starts at zero. But there’s probably a BITC in the clip that starts at 13hours or something. Is the source TC typically changed to match the BITC?

Not too sure, or knowledgeable about what this means: “TAB file can be converted to ALE and merged into existing clip.”

Thanks.

[Michael Phillips]

Does it need to be an actual EDL, or can it be some other file export that will list vendors codes and such?

I would need more detail, but as you say, the clip timecode is showing 00:00:00:00 but the BITC may be 13:00:00:00. This value can be entered in the AucTC1 column and tracked in lists be it EDL or other.

Michael

[Rosie Walunas]

Well I guess it doesn’t have to be a literal EDL for instance but a list of the archive and vendors and TC to order. Since I’m a new Avid AE I’m wondering how that list should be be comprised as far as accuracy and efficiency. Examples of experiences are always helpful.

Thanks for your help.

[Michael Phillips]

As far as timecode goes, you need both source and record side timecode?

Michael

[Rosie Walunas]

I’, just assuming I would for future ref. A lot of these places are mom and pop style vendors so having both can be really helpful.

Thanks.

[Michael Phillips]

If it’s just a list of archive (stock footage) type report. Adding the vendor code to a column in the bin as well as any other metadata tracking you want to do is probably the easiest way to start the tracking. For just a list of clips with source timecode and vendor information, save a bin view with all pertinent columns, then take your sequence and decompose or use “set bin display” to show hidden clips. Sort by any of those column heading, select only clips that have vendor ID’s then export as a TAB delimited file. This can be imported into Excel, FileMaker Pro, etc, as needed for your reporting.

MC 6 or later does have stock footage reports as part of the feature set, but it does not allow you to enter metadata into it to represent your own in-house archive which is too bad, as it can create the stock footage report directly from the timeline.

Michael

[Rosie Walunas]

I see. This is very interesting. Thank you for this feedback.

What about assigning “Tape” names for archive IDs? The “Tape” label cannot be edited once it’s created – kind of like an actual tape. Could there be problems with this?

Or, might it be better to have a sort of vendor name column, and then duplicate that column information in a sort of back up column so that in case the vendor ID gets changed, there’s a ‘back up.’ Though, I’m sure an archive person would also have a spread sheet with the info, theoretically.

Thanks again for your thoughts!

[Rosie Walunas]

Hi again. So I’ve gotten more into things with Avid and the project I’m working on.

You write, “For just a list of clips with source timecode and vendor information, save a bin view with all pertinent columns, then take your sequence and decompose or use “set bin display” to show hidden clips. Sort by any of those column heading, select only clips that have vendor ID’s then export as a TAB delimited file. This can be imported into Excel, FileMaker Pro, etc, as needed for your reporting.”

This all makes sense to me now, but as for executing it, could you point me in the direction of how to do this, or tutorial?

I’m under the impression that decomposing a sequence can be deconstructive.

What I’m interested to get right now is an ALE or EDL or both that will list out the specific “archive clips,” stills, music, etc. with time codes and durations so a budget can be worked up and the can be purchased.

Thanks.