FMDiff™

This site is W3C compliant:
Valid XHTML - Valid CSS
Last modified May 23 2010, 04:00:29 CEST.

Export a list of all fields of a table

Perform an XML export and use this style sheet.

• Save the text below as "exportfields.xsl" next to your FileMaker file
• Go to a layout that is based on the table of interest
• Select Export from the File menu
• In dialog Export Records to File select Type: XML
• In Specify XML and XSL Options select the grammar FMPXMLRESULT and
• the file "exportfields.xsl" as XSL style sheet
• In Specify Field Order for Export move all fields to the export order
• Export
• Open the resulting file with a text editor and find a list of all fields

Applicable with FileMaker® Pro 6 and up.

Download example style sheet exportfields.xsl.zip 0.8 KB

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:fmp="http://www.filemaker.com/fmpxmlresult">
  <xsl:output method="text"/>
  <xsl:variable name="newline" select="'&#10;'"/>
  <xsl:variable name="tab" select="'&#9;'"/>
  
  <xsl:template match="/">
    <xsl:for-each select="//fmp:METADATA/fmp:FIELD">
      <xsl:value-of select="@NAME"/>
      <xsl:value-of select="$tab"/>
      <xsl:value-of select="@TYPE"/>
      <xsl:value-of select="$tab"/>
      <xsl:value-of select="@MAXREPEAT"/>
      <xsl:value-of select="$newline"/>
    </xsl:for-each>
  </xsl:template>
  
</xsl:stylesheet>

You will get a tab-delimited list with field name, field type, and number of repetitions. To speed up the process select only one record for export - no data will be exported anyway.

If you just need the name, reduce the middle part to

      <xsl:value-of select="@NAME"/>
      <xsl:value-of select="$newline"/>