Metadata - can it query database/xml file?

pretty much instead of using a static list setup in the web client, we would like a few of our MediaBin metadata items thats are very long and updated frequently to be called from a database or from an xml file. i know when u export a metadata item its xml, but i couldnt find where they are being referenced in the MB folder structure. are they stored natively as xml or soemthing else?

Find more posts tagged with

Comments

B_Looser

Below is what Interwoven sent me when I asked. I pasted it, you can format it. Smiley Wink

Jim
---------

Kindly try the following steps:

· Access the MediaBin web client.

· Right click on Metadata Manager > Add > Metadata.

· In the name field, type the custom Metadata field name (e.g. Test) and save.

· Go to the Metadata menu option> select upd (Update) option and assign the value something like 123456 > Save.

· Click on Metadata Manager > Right click on Test > Export > Submit > Right click on Test.xml > Save Target as > Save.

· Open Test.xml.

· Open XMPMapping.xml in C:\Interwoven\MediabinAssetServer\MBDataDirectory\XMP and C:\Interwoven\MediabinAssetServer\Config Files and add the following code:

Test

<metadataid> {F67CB49E-A258-41D7-A927-5BD6C1E53B93}

http://ns.interwoven.com/mediabin/1.0/

mbn

Test

· Here the MetadataID is taken from Test.xml.

· Save and close XMPMapping.xml.

· Re-start the MediaBin Server service so that MediaBin recognizes the changes to XMPMapping.xml.

· In MediaBin, display the asset properties and verify that the custom metadata definition “TEST” and its associated value “123456” are maintained.

lyman

Sorry to be dense, but I am not sure I completely grasp the question being asked. You can retrieve the metadata definition in XML form. Also given the structure of that record you could construct a metadata definition whose choice list came from an external source and import it into MediaBin.

However, I suspect that this is not the intent of the question.

The internal format of a metadata entry is binary and incomprehensible to the outside which is why we added the XML export format to be more or less humanly readable.

Are you perhaps referring to how to customize the client so that it calls out to an external source to present the user with a list of possible values?

Yet another "xml-related" aspect of metadata is our ability to interact with XML a standard proposed by Adobe for metadata exchange between applications.

Once I understand the question better, I will do my best to elucidate!

Cheers,

Lyman Hurd

Migrateduser

im trying jims code now - thanks - pretty much here is what i want

we have metadata item with all of our school "Programs", i.e. 3D Modeling for Animation & Games, etc etc

all the "Allowed items" are a string list we typed into mediabin. we would like to populate the options dynamically since the programs change so much

Just to be clear - the meta data on the asset does not need an update as the programs change. We just need to have current programs available for upload and meta data change.

truebluetitan

I believe that what arthas76 is describing is the exact functionality that I'm looking for. I want to have an insertion task that has a required metadata field. This field would/should be populated from records that exist in a DB table. Is this possible?

Thanks in advance.

msrinivas

The only way that I think this can be accomplished is by a scheduled script that is written using the MB API.

Migrateduser

are there any examples or documentation on setting this up? would it be possible to hack/customize the .asp in the mediabin web client?