XL Spreadsheet for Generating Final Cut Pro XML Sequences
Here is an Excel spreadsheet that I used to generate valid Final Cut Pro XML.
http://www.echochamberproject.com/files/FinalCutProXML.xls
Being able to generate Final Cut Pro XML means that it is definitely possible to generate sequences of sound bite clips within Drupal -- and provide some interesting possibilities for faciliating collaborative editing.
My intention with posting this is that at some point a PHP programmer will come along to code this spreadsheet into a Drupal module.
Note that being able to do this requires extracting the following eight variables from the Final Cut Pro XML data.
sequence id > media > video > track > clipitem id > in
sequence id > media > video > track > clipitem id > out
sequence id > media > video > track > clipitem id > name
sequence id > media > video > track > clipitem id > duration
sequence id > media > video > track > clipitem id > file id > pathurl
sequence id > media > video > track > clipitem id > file id > timecode > string
sequence id > media > video > track > clipitem id > file id > timecode > frame
sequence id > media > video > track > clipitem id > file id > timecode > reel > name
If you want to get this to work with sound bites and Final Cut Pro on your computer, then I suggest trying to recreate the XML with the spreadsheet first.
I copied and pasted the XML data into a Word document to remove all of the tabs (^t) and carrage returns (^p) before it would work.
I also created a special content type within Drupal that contains these 8 XML variables -- as well as the text of the sound bite.
Here is an example of a "Sound Bite" node from the Bill Plante interview -- and here is an aggregation of all of the Bill Plante sound bites.
So it is possible to assign each sound bite to a unique URL -- as well as collect metadata on each sound bite that could be fed back into Final Cut Pro.
For more information:
Collaborative Media with Drupal + Final Cut Pro XML
Preparing FCP Sequences for Distributed Editing via XML
Progress on Phase 01
