Oxygen XML Forum

Posted: **Thu Dec 07, 2006 1:52 pm**

HI

I have a problem with XML to XML with a XSL file.

I have Filmaker PRO wich produces a XML file. I want the information in a CMS system but this does only allow his own style.

I have to make a XSL (wich I did with many research beceause I am new to XML and XSL). But doesn't work jet. I hope somoene can help me out.

this is the XML file from filemaker PRo

Code: Select all


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

- <FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult">

  <ERRORCODE>0</ERRORCODE> 

  <DATABASE>XSL-Jeljer Geconverteerd 2.fp5</DATABASE> 

  <LAYOUT>Layout 2</LAYOUT> 

- <ROW MODID="3" RECORDID="2">

  <tekst>A</tekst> 

  <tekstvak>B</tekstvak> 

  </ROW>

- <ROW MODID="3" RECORDID="3">

  <tekst>C</tekst> 

  <tekstvak>D</tekstvak> 

  </ROW>

- <ROW MODID="3" RECORDID="4">

  <tekst>E</tekst> 

  <tekstvak>F</tekstvak> 

  </ROW>

- <ROW MODID="4" RECORDID="5">

  <tekst>G</tekst> 

  <tekstvak>H</tekstvak> 

  </ROW>

- <ROW MODID="2" RECORDID="6">

  <tekst>I</tekst> 

  <tekstvak>J</tekstvak> 

  </ROW>

  </FMPDSORESULT>

now How I want it to be (I made this XML file with the CMS system):

Code: Select all


<?xml version="1.0" encoding="iso-8859-1"?>

<object>

  <objectname>XSLT</objectname>

  <properties>

    <property id="94" type="textinput" required="false" searchable="false">

      <name><![CDATA[tekst]]></name>

      <defaultvalue><![CDATA[]]></defaultvalue>

      <validation><![CDATA[text]]></validation>

    </property>

    <property id="95" type="textinput" required="false" searchable="false">

      <name><![CDATA[tekstvak]]></name>

      <defaultvalue><![CDATA[]]></defaultvalue>

      <validation><![CDATA[text]]></validation>

    </property>

  </properties>

  <data>

    <item>

      <field propertyid="94"><![CDATA[A]]></field>

      <field propertyid="95"><![CDATA[B]]></field>

    </item>

    <item>

      <field propertyid="94"><![CDATA[C]]></field>

      <field propertyid="95"><![CDATA[D]]></field>

    </item>

    <item>

      <field propertyid="94"><![CDATA[E]]></field>

      <field propertyid="95"><![CDATA[F]]></field>

    </item>

    <item>

      <field propertyid="94"><![CDATA[G]]></field>

      <field propertyid="95"><![CDATA[H]]></field>

    </item>

    <item>

      <field propertyid="94"><![CDATA[I]]></field>

      <field propertyid="95"><![CDATA[J]]></field>

    </item>

  </data>

</object>

so now my XSL file (this doesn't work) :

Code: Select all


<?xml version="1.0" encoding="ISO-8859-1"?>

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

<xsl:output method='html' version='1.0' encoding='ISO-8859-1' indent='yes'/>

	<xsl:template match="/FMPXMLRESULT">

		<object>

		<objectname>NAAM KOMEN EHMMM...... TJA</objectname> 			

			<properties>

				<xsl:for-each select="field">

					<property id="position+90" type="textinput" required="false" searchable="false">

					<name>sorry weet nog niet hoe ik diet te pakke moet krijgen</name>

						<defaultvalue></defaultvalue>

						<validation>text</validation>

					</property>	

				</xsl:for-each>

			</properties>

			<data>

				<xsl:for-each select="RESULTSET">

					<xsl:for-each select="ROW">

					<item>

						<xsl:for-each select="COL">

							<field propertyid="position+90">

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

							</field>

						</xsl:for-each>

					</item>

					</xsl:for-each>

				</xsl:for-each>

			</data>

		</object>

</xsl:template>

</xsl:stylesheet>

so this is all, I hope someone can help me. I hope you can read my english ( I live in Holland) and that my code doesn't suck to much.

gr Heldopslippers

Oxygen XML Forum

filemaker PRO XML to XML for a CMS with XSL

filemaker PRO XML to XML for a CMS with XSL