Well it can be done, but it does take some trial and error. In order for Media Composer to import an ALE, all columns must match Avid column exact if they are to be mapped to those columns. If not, they become custom colummns or may not work. Merging an ALE is even more stringent – The following three columns must match exactly, uppercase, lowercase and timecode:
Tape or Source File
Start
End
As mentioned timecode has to match exactly or it won’t merge. There is no concept of a fuzzy merge based on other common metadata fields (a long time request).
The header has become redundant over the years and I was really pushing for Avid to finally get rid of it with the latest version, but they did not. They kept it… arrrgh. The other issue is that line breaks are senstive and I’ve seen issues coming from Excel where they were not correct. “Cleaning an ALE” is a feature from the film to tape days that would check that there was no overlapping timecode in a file. You can turn this off.
Syntax errors can be a bunch of different things, and needs to be managed error by error. I’ll take a look at one of your ALE files from Excel if you want to see if I can fix it. Once it works, you can see what changes were done for your other files. Send to michael[at]24p[dot]com
Michael