Hi Josh,
I have never used XSL with FileMaker Pro, but I use that program a lot. Try
this, using XSLT magic:
<!-- loop through all tracks -->
<xsl:for-each select="/xmeml/sequence/media/video/track">
<ROW MODID="" RECORDID="">
<COL>
<DATA>
<!-- calculate the track number -->
<xsl:value-of select="count(preceding-sibling::track) + 1"/>
</DATA>
</COL>
<COL>
<DATA>
<!-- finds the clip name as child of clipitem -->
<xsl:value-of select="clipitem/name"/>
</DATA>
</COL>
<COL>
<DATA>
<!-- finds the in point of the source clip in frames -->
<xsl:value-of select="clipitem/in"/>
</DATA>
</COL>
<COL>
<DATA>
<!-- finds the out point of the clip in frames -->
<xsl:value-of select="clipitem/out"/>
</DATA>
</COL>
</ROW>
</xsl:for-each>
Am 21.01.2011 um 21:20 schrieb Josh Kirschenbaum:
Hello all - I'm new to XML / XSLT, so go easy on me!
I am trying to get an XML file from Final Cut Pro to Filemaker Pro
using an XSLT template.
The original XML has a basic structure like this (simplified for this
question)
<video>
<track>
<clipitem id="This Is The First Clip">
<name>The First Clip has a Name</name>
<in>140</in>
<out>240</out>
<...etc..>
</clipitem>
<clipitem id="And The Second Clip">
<name>Number Two</name>
<in>360</in>
<out>520</out>
<...etc..>
</clipitem>
<clipitem id="Finally The Third Clip">
<name>Three Is Not Company</name>
<in>140</in>
<out>240</out>
<...etc..>
</clipitem>
</track>
<track>
<clipitem id="First Clip on Another Track">
<name>Track Two's First Clip</name>
<in>140</in>
<out>240</out>
<...etc..>
</clipitem>
<clipitem id="Second Clip Second Track">
<name>Number Two Track Two</name>
<in>460</in>
<out>820</out>
<...etc..>
</clipitem>
<clipitem id="Second Track Third Clip">
<name>Three Is Not Company On This Track Either</name>
<in>158</in>
<out>655</out>
<...etc..>
</clipitem>
</track>
</video>
Obviously there are many other leaves inside of the <clipitem> tag.
And there are more <track> levels as well - once again, this is just
for illustration.
This is FileMaker Pro's XSLT template format (once again, slimmed
down) to pull out the three <clipitem> from the first <track> level.
This makes sense to me - it's very straightforward.
The issue is that I don't want to manually indicate which <track> to
"pick" by changing track[1] to track[2]. I want to traverse the entire
XML file - even when I don't know how many <track> occurences there
are.
<xsl:for-each select="/xmeml/sequence/media/video/track[1]/clipitem">
<ROW MODID="" RECORDID="">
<COL>
<DATA>
<!-- finds the clip name -->
<xsl:value-of select="./name"/>
</DATA>
</COL>
<COL>
<DATA>
<!-- finds the in point of the source clip in frames -->
<xsl:value-of select="./in"/>
</DATA>
</COL>
<COL>
<DATA>
<!-- finds the out point of the clip in frames -->
<xsl:value-of select="./out"/>
</DATA>
</COL>
</ROW>
</xsl:for-each>
I also want to add another <COL> set - one that outputs the number of
the <track> I'm on - kind of like this:
<COL>
<DATA>
<!-- finds the track number -->
<xsl:value-of select="count(/xmeml/sequence/media/video/track)"/>
</DATA>
</COL>
The problem is that this line of code just returns the TOTAL number of
<track> levels - in this case it would return "2". I want it to return
1, then all the clipitems on that level, then 2, then the clipitems on
that level, etc.
This is probably something that is SUPER straightforward, but as I
said, I'm a newbie to this stuff!!
Thanks in advance!!!
--
-. --- -- .- - - . .-. .-- .... . .-. . -.-- --- ..- --. --- - .... .
.-. . -.-- --- ..- .- .-. .
Josh Kirschenbaum
Visual Effects Director / Design
www.zeroperimeter.com
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--