This discussion is locked
-
All replies
-
Helpful answers
-
Oct 28, 2010 6:05 AM in response to Lichtblauby Alejandro Grigera,Yes it can be done but with the help of scripts.
If I have to do it today I would try to save those excel into a comma separated plain text files. Then I would build an script to read those columns of data from the text file (easy with awk command) and then write those fields to the FCS metadata. The tricky part is to link the file to the right asset inside final (you need to get the asset ID from the asset to be able to "setmd") The best way for me to do this (without accesing the database itself) is to have the name of the file (the plain text file) to be the same as the filename of the asset. This way you can then perform a "Write XML" from Final and you get an filename.xml where the Asset ID is located. After this is easy to build a custom XML file to fill with the excel metadata and perform a "setmd" to write back to FCS.
Hope this help -
Oct 28, 2010 12:34 PM in response to Alejandro Grigeraby Lichtblau,Thanks so much Alejandro, that really helps.
-DL -
Jan 6, 2011 3:32 PM in response to Lichtblauby iamrhys,thats really useful. do you know if there is any documentation on this topic.?
regards. -
Jan 7, 2011 1:17 PM in response to iamrhysby John F. Whitehead,http://developer.apple.com/library/mac/#technotes/tn2009/tn2255.html
You can also look at "FinalCutServerIntegrationSample" on the same site, though it's a little dated.