[Ben Mills]

Hi Michael,

I have tried doing the following…..

Export an ALE for the bin containing my AMA clips,
opening the ALE in excel,
adding in my own custom columns and data,
saving back out as a tab delim file
running through Avid Log Exchange with clean and relaxed checked (the only way it will work),
try to merge with AMA clips.

I keep getting an error for every entry when trying to merge the ALE with my AMA clips, then at the end of each error message, avid crashes!

I’ve tried both exporting an ALE, editing it and reimporting that, as well as going the ALE > excel > Tab Delim > Avid Log Exchange route.

When I try the ALE > excel > ALE route, the ALE appears to go in fine but I cannot find my new columns of data anywhere and I’ve even tried importing while on the Custom Bin view, but still the new columns do not show!

All my frame rates match correctly, there doesn’t seem to be any anomalies in the way the clips are named.

I really don’t want to have to go down the copy and paste each field route as there is set to be a lot of material!

Hope you can help,

Ben

[Ben Mills]

Sounds good thanks Reuben,

I’m guessing ffmpeg is command line input only? WHich I am no good with, an suggestions of how to ffmpeg running and be able to batch apply timecodes to mp4s?

Thanks

Ben

[Ben Mills]

No worries, I have solved the issue now.

I took a copy of the quicktime.framework, library/quicktime and system/library/quicktime folders from another machine also running 10.6.8 and QT Pro and it worked a treat.

I was previously trying to replace those folders with ones from 10.7.1 which is why it was causing the crash.

Thanks for getting back to me though!

[Ben Mills]

But on doing this with a Batch Import, each new offline clip relinks from frame 1 of my original material and not at (for example) frame 201 where the clip in the cut starts.

[Ben Mills]

SOrry I cant send an example I’m afraid as some of the clip names contain sensitive information.

I cant see anything wrong with the formatting though, nothing that untoward. Could excel be causing a problem when saving the information out?

[Ben Mills]

Sorry Bouke, the part I’m finding tricky is to get the ALE back into the AVID and merging my new custom metadata with my material.

The FPS part should be fairly straight forward, it’s just getting the ALE extracted from my bin, out of avid, into excel, adding the custom columns and metadata, saving it to the correct format and then back into the avid and merging correctly with the clips in the bin from which the original ALE came from.

As I mentioned earlierI keep getting a syntax error and I’m not sure why as everything looks correct.

I get this problem everytime, no matter how I edit my ALE.

The two approaches I have tried when editing my ALE are as follows:

First way is to edit the ALE in excel directly and save as an ALE.

Second way is to edit the ALE in excel, save as a tab delimited file and then run the tab delimited files through avid log exchange and export a new ale.

Both ways Im getting a syntax error on import :s

[Ben Mills]

By proper syntax, what do you mean?

Its quite awkward really as we have clips of different frame rates in the bin, so we were thinking that we could edit the header in the ale for each relevant frame rate and importing it and merging the metadata with the master clips already in the bin.

This is working for the 25 frame material but not any other frame rate.

Surely this should be an important part of clip organisation and allow custom metadata to be input, proving mind blowingly tricky!

[Ben Mills]

Hi Justin,

I’ve tried importing the clips initially into the AVID without additional custom metadata,

Then I’ve exported an ALE from that bin,

Then opened the ALE in excel and added all the additional custom metadata.

I have then tried two methods of getting the information back into the avid.

First method is to simply save back out as an ALE and import.

Second method is to strip off the headings, then save as a tab delimited file and run it through Log Exchange to create an ALE.

The first method does not work at all.
The Second Method then imports but throws up a syntax error for the first line of the ale. However all the clips show up in the bin, but on re-linking, it fails to relink!

Any other suggestions? 😀

[Ben Mills]

So AVID will recognise a DNG??

[Ben Mills]

All sorted, great stuff!

Thanks a lot Jeff!