FORUMS: list search recent posts

Adding Custom MetaData to MP4s before import to AVID

COW Forums : Avid Media Composer

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Ben Mills
Adding Custom MetaData to MP4s before import to AVID
on Nov 30, 2011 at 1:44:19 pm

Hi there,

I am looking to add custom metadata columns and information into the AVID.

I have a huge amount of MP4 material to work with.

I would like to if possible apply the metadata information I have to the MP4 before it is imported into the avid, so that when it is imported all of the metadata shows in my AVID bins.

Just like when RED material is imported into the avid and you get all of the colour information etc.

I am looking to add custom metadata such as keywords etc. This information is already laid out in a tab delimited / excel file buti ts a case of stamping that onto the MP4.

is this possible and if not, what is my best work flow for dealing with this?

Thanks


Return to posts index

Justin Barham
Re: Adding Custom MetaData to MP4s before import to AVID
on Nov 30, 2011 at 8:52:15 pm

I haven't done this myself (yet), but I'd probably be looking towards formatting your Excel file properly for ALE, and then batch importing from the bin (making sure your names match exactly).

Just guessing.

- Justin Barham -


Return to posts index

Ben Mills
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 1, 2011 at 12:31:09 pm

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? :D


Return to posts index


Bouke Vahl
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 1, 2011 at 12:40:10 pm

This definitly works, but you need the proper syntax.

After you figured that out, relinking only works if the TC and Reel matches, so it's best to start with an ALE made from the already imported clips. If they don't have a Reelname, assign one.
Also, the exported ALE contains only the info currently shown in the bin, so make sure Start, End, Reel, Filename at least is visible.

If relinking failes, another trick is to highlight the clips, then import the ALE with the option 'merge event with known sources and create subclips'.

How many clips are we talking about?

Bouke

http://www.videotoolshed.com/
smart tools for video pros


Return to posts index

Ben Mills
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 1, 2011 at 5:10:17 pm

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!


Return to posts index

Bouke Vahl
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 2, 2011 at 7:16:55 am

What do you mean with tricky?

The header defines the FPS.
If you have mulitple FPS, make multiple ALE files.
You can sift on any header in the bin, so that is an easy task...

Bouke

http://www.videotoolshed.com/
smart tools for video pros


Return to posts index


Ben Mills
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 2, 2011 at 10:11:54 am

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


Return to posts index

Bouke Vahl
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 2, 2011 at 11:32:33 am

How about posting the first few lines?

Bouke

http://www.videotoolshed.com/
smart tools for video pros


Return to posts index

Ben Mills
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 2, 2011 at 1:32:41 pm

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?


Return to posts index


Bouke Vahl
Re: Adding Custom MetaData to MP4s before import to AVID
on Dec 2, 2011 at 5:30:29 pm

well, you're not exactly making it easy to help you...
So either post an example of what you are doing, or RTFM.

It works, and if it does not work for you, you are doing something wrong. And i'm not going to guess what that might be...

Bouke

http://www.videotoolshed.com/
smart tools for video pros


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2017 CreativeCOW.net All Rights Reserved
[TOP]