Final cut server to resourcespace via xml

Started by Chlowden, January 30, 2011, 09:55:48 AM

Previous topic - Next topic

Chlowden

Hello
I am very interested in resourcespace.org as a mam that is fed video from Final cut server. Final cut server exports an XML file with each video file, similar to the exports adobe does with XMp in premiere pro cs5. It seems that resourcespaces uses exiftool to handle xmp imports so I was wondering if there is any possibility of it doing the same for final cut server xmls?
Many thanks

Phil Harvey

ExifTool already reads XML, although the support is unofficial because it is not possible to properly support all of the potential XML flavours.

So if you just want to extract metadata from the XML file, exiftool may already do what you want.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

Chlowden

Thank you for the reply. I presume that if the app that uses the plug does not offer XML, it is upto the developer to discover how to parse the info. Can I send you a sample file to see if you reckon there is hope before I contact the developer?

Phil Harvey

Sorry, but I have no idea what you just asked.

I suspect the Final Cut XML is probably Apple plist format, which exiftool will read, but the output format is not optimal.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

Chlowden

Many thanks for the reply.

I am no xml specialist, but it seems that this is not Apple plist. I am probably wrong. Below I attach a sample.  Is this readable?



<?xmlversion="1.0"?>
<FinalCutServer>
    <getMdReply>
        <entity entityType="asset"entityId="/asset/42">
            <metadata>
                <mdValue fieldName="Title" dataType="string">Whatever</mdValue>
                ...
                <annotations>
                    <annotation>
                        <mdValue fieldName="Annotation" dataType="string">Need to be brighter.</mdValue>
                        <mdValue fieldName="In" dataType="timecode">01:00:00:06/(25,1)</mdValue>
                        <mdValue fieldName="Out" dataType="timecode">01:00:00:08/(25,1)</mdValue>
                        <mdValue fieldName="Timestamp" dataType="dateTime">2009-04-02 16:59:33+0</mdValue>
                        <mdValue fieldName="User id" dataType="integer">1</mdValue>
                        <mdValue fieldName="Name" dataType="string">apple</mdValue>
                        <mdValue fieldName="Full name" dataType="string">Jonathan Apple</mdValue>
                    </annotation>
                </annotations>
            </metadata>
        </entity>
    </getMdReply>
</FinalCutServer>

Phil Harvey

Like I said, ExifTool will read XML but the output format may not be optimal:

> exiftool -a test.xml
ExifTool Version Number         : 8.48
File Name                       : t1
Directory                       : .
File Size                       : 1245 bytes
File Modification Date/Time     : 2011:02:05 21:05:59-05:00
File Permissions                : rw-r--r--
File Type                       : XML
MIME Type                       : application/xml
Final Cut Server Get Md Reply Entity Entity Type: asset
Final Cut Server Get Md Reply Entity Entity Id: /asset/42
Final Cut Server Get Md Reply Entity Metadata Md Value Field Name: Title
Final Cut Server Get Md Reply Entity Metadata Md Value Data Type: string
Final Cut Server Get Md Reply Entity Metadata Md Value: Whatever
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: Annotation
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: string
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: Need to be brighter.
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: In
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: timecode
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: 01:00:00:06/(25,1)
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: Out
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: timecode
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: 01:00:00:08/(25,1)
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: Timestamp
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: dateTime
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: 2009:04:02 16:59:33+0
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: User id
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: integer
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: 1
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: Name
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: string
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: apple
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Field Name: Full name
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value Data Type: string
Final Cut Server Get Md Reply Entity Metadata Annotations Annotation Md Value: Jonathan Apple


- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

Chlowden