I have an XML file that is generated by FINAL CUT PRO 4.5 ( A sequence XML Export) that contains data that I would like to import into a FILAMKER DB That I am Developing. The XML Output file from Final Cut Pro contains a LOT of Data, and I can see the parts of the data that I want when I look at the XML File with a TEXT App.

I have discovered that you need a "STYLE SHEET" or XSL file that FILEMAKER Needs when importing.

The Questions is...

How Do I make a "STYLE SHEET" that can extract only some of the required data from the XML File?

I am a beginner as far as XML is concerned, I have search the web only to get more confused with XML.

I have a very good understanding of FILEMAKER Though.

Can anyone assist me??

Thanks

Dave M

Beverly Voth's book will help. It covers conversion of XML via XSLT for import into FileMaker. It's not easy, but it's impossible without help. If someone else has already done such an XSLT you'd be in luck (if you could find it; I haven't seen such at the FileMaker XSLT Library), 'cause I bet it's fairly standard. You should get the book anyway though, if you're dealing with XML at all.

http://www.amazon.com/exec/obidos/tg/det...=glance&s=books

http://www.filemaker.com/technologies/xslt_library.html

Thanks Fenton,

I have already visited the FILEMAKER WEBSITE for info, They had examples but nothing for FINAL CUT PRO, The Book does look extensive But I don't feel like learning a NEW SUBJECT ( i.e XML) , It seems to be a difficult thing to get started in even just to get some simple results, I will keep googling..

Dave M

You could hire somebody to write it for you.

Good Luck.

Garry

Here is one that works for me:

XML:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE xmeml>

<xmeml version="1">

<sequence id="Seq1">

<name>Sequence 1</name>

<duration></duration>

<rate></rate>

<timecode></timecode>

<media>

<video>// 1

<format></format>

<track>

<clipitem id="Seq1Clip1">

<name>Sky Rockets</name>

<duration>751</duration>// 1

<in>0</in>

<out>751</out>// 2

<start>0</start>

<end>751</end>

</clipitem>

<clipitem id="Seq1Clip2">

<name>Big Bang</name>

<duration>700</duration>// 1

<in>0</in>

<out>700</out>// 2

<start>752</start>

<end>1452</end>

</clipitem>

</track>

</video>

</media>

</sequence>

</xmeml>

XSLT:

<?xml version='1.0' encoding='UTF-8' ?>

<xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>

<xsl:template match='/'>

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>0</ERRORCODE>

<PRODUCT BUILD="11/13/2002" NAME="Filemaker Pro" VERSION="6.0V4"/>

<DATABASE DATEFORMAT="d/M/yyyy" LAYOUT="" NAME="combotest.fp7" RECORDS="" TIMEFORMAT="h:mm:ss a"/>

<METADATA>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="name" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="duration" TYPE="NUMBER"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="start" TYPE="NUMBER"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="end" TYPE="NUMBER"/>

</METADATA>

<RESULTSET FOUND="">

<xsl:for-each select="./xmeml/sequence/media/video/track/clipitem">

<ROW MODID="" RECORDID="">

<COL><DATA><xsl:value-of select="./name" /></DATA></COL>

<COL><DATA><xsl:value-of select="./duration" /></DATA></COL>

<COL><DATA><xsl:value-of select="./start" /></DATA></COL>

<COL><DATA><xsl:value-of select="./end" /></DATA></COL>

</ROW>

</xsl:for-each>

</RESULTSET></FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet>

This one extracts the "name","duration","start" and "end" metadata/fields for each Clip.

Good Luck.

Garry

Garry,

Thank you very much for your sample XSL File, I got it to work PERFECTLY in FMP7,

I did have to edit out the stray characters with a text edit program.

It managed to import ALL CLIPS that I had scattered all over the timeline in Final Cut Pro and th data IMPORT cam out perfectly in FMP.

Thanks heaps.

So how much do I owe you?

Regards

Dave M

Sydney

A beer when I'm next in Sydney!

Garry