Filemaker XSL按名称选择列 [英] Filemaker XSL Select Column By Name

问题描述

我希望使用列名(而不是位置)从Filemaker导出.当前，我导出以下XSL样式表，该样式表按位置导出:

I am looking to export from Filemaker using column names (instead of positions). Currently I export the following XSL stylesheet that exports by position with:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
  xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >
<xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>
<xsl:template match="/">
  <people>
    <xsl:for-each select="fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW">
      <person>
        <name>
          <xsl:value-of select="fm:COL[01]/fm:DATA"/>
        </name>
        <location>
          <xsl:value-of select="fm:COL[02]/fm:DATA"/>
        </location>
      </person>
    </xsl:for-each> 
  </people>
</xsl:template>
</xsl:stylesheet>

有什么想法吗?谢谢.

推荐答案

如果您只是想让代码更具可读性，那么我建议您做些简单的事情，例如:

If you just want to make the code more readable, then I'd suggest something simple, like:

<!-- expected columns -->
<xsl:variable name="NAME" value="1" />
<xsl:variable name="LOCATION" value="2" />
<!-- ... -->
<people>
  <xsl:for-each select="fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW">
    <person>
      <name>
        <xsl:value-of select="fm:COL[$NAME]/fm:DATA"/>
      </name>
      <location>
        <xsl:value-of select="fm:COL[$LOCATION]/fm:DATA"/>
      </location>
    </person>
  </xsl:for-each> 
</people>

顺便说一句，使用<xsl:value-of />，您可以省略fm:DATA，即使用:

BTW, with <xsl:value-of /> you can omit the fm:DATA, i.e. use:

<xsl:value-of select="fm:COL[$LOCATION] />

它将返回相同的结果.

如果您需要更复杂的东西，请解释.

If you need something more sophisticated, please explain.

更新:

按列名引用列比较困难，但是可以通过以下方式实现:

To refer to columns by column names is harder, but possible with something like that:

<!-- Define a key to get a field and all fields that precede it by the field name -->
<xsl:key name="N" match="/fm:FMPXMLRESULT/fm:METADATA/fm:FIELD" use="@NAME" />
<xsl:key name="N" match="/fm:FMPXMLRESULT/fm:METADATA/fm:FIELD" 
  use="following-sibling::fm:FIELD/@NAME" />
<!-- Then *count* them it in the code like that -->
<people>
  <xsl:for-each select="fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW">
    <person>
      <name>
        <xsl:value-of select="fm:COL[count(key('N', 'name'))]" />
      </name>
      <location>
        <xsl:value-of select="fm:COL[count(key('N', 'location'))]" />
      </location>
    </person>
  </xsl:for-each> 
</people>

不是很优雅，但是可以.

Not utterly elegant, but works.

这篇关于Filemaker XSL按名称选择列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！