How to set different metadata value to same key but for 1000 of assets?

Hi
I have around thousands of assets already inserted into MB in different folders. Now to each of these asset's metadata - named "asset_type", i have to set a new value. For different assets the value for metadata "asset_type" is diferrent.
The details about new metadata is currently stored in a Excel sheet and Currently i am manually editing each assets metedata and then setting new value to "asset_type" referring the excelsheet data. There are around 5000 to 8000 assets currently in MB. Now manual setting meta data data to each asset will be very time consuming. How Can this be programatically automated?done? is there any way?

Shakil

Find more posts tagged with

Comments

msrinivas

Read the docs for bulk editing metadata. I would recommend if it is a one time thing. If it is an ongoing thing I would recommend using MB API to create a script. If you do not have the resources to create the script then Interwoven CSO can help you with that. Contact your AE/ESE/SE.

shakilxy

Thanks!
Yes it is a one time activity. This is the first time i am using MB so i am not aware about using the script. Do we have CLTs to set the asset attributes in MB? Also if possible please post some sample script for doing a similar kind of operation?

Migrateduser

MediaBin currently has a system read-only metadata field named 'Asset Type' which contains the type of image asset (i.e. JPEG, Vector EPS, MS Word Document). To avoid confusion, you may wish to prepend your custom metadata field names with some characters relating to your company or department, as in XYZ_AssetType.