Posted By

archlight on 01/20/09


Tagged

xml xls filemaker


Versions (?)

convert attributes to new node


 / Published in: XML
 

  1. <?xml version="1.0" encoding="windows-1250"?>
  2. <xsl:stylesheet version="1.0"
  3. xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  4. <xsl:template match="/">
  5. <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
  6. <ERRORCODE>0</ERRORCODE>
  7. <PRODUCT BUILD="06-20-2006" NAME="FileMaker Pro" VERSION="8.5v1" />
  8. <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="fixture.fp7" RECORDS="6107" TIMEFORMAT="h:mm:ss a" />
  9. <METADATA>
  10. <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ArticleNo" TYPE="TEXT" />
  11. <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ArticleName" TYPE="TEXT" />
  12. <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Description" TYPE="TEXT" />
  13. </METADATA>
  14. <RESULTSET FOUND="">
  15.  
  16. <xsl:for-each select="RECORDS/RECORD/ROW">
  17. <ROW MODID="" RECORDID="0">
  18. <COL>
  19. <DATA><xsl:value-of select="@ArticleNo" /></DATA>
  20. </COL>
  21. <COL>
  22. <DATA><xsl:value-of select="@ArticleName" /></DATA>
  23. </COL>
  24. <COL>
  25. <DATA><xsl:value-of select="@Description" /></DATA>
  26. </COL>
  27. </ROW>
  28. </xsl:for-each>
  29.  
  30. </RESULTSET>
  31. </FMPXMLRESULT>
  32. </xsl:template>
  33. </xsl:stylesheet>

Report this snippet  

You need to login to post a comment.