Sign in to follow this  
Followers 0
ggt667

When exporting XML as fmxmlresult.xml when does FilMaker populate the content of the layout attribute?

1 post in this topic

Posted (edited)

When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute?

Usually it looks like

<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/>

Yet sometimes it looks like this

<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/>

Then again when querying the XML RPC it always look like this

<datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="0" />

Asking the question myself, answering the question myself as well. Checking the following checkbox populates the LAYOUT-attribute of FMPXMLRESULT

FMXMLRESULT LAYOUT populate.png

Edited by ggt667
Solved

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By AlanTrewartha


      View File fmresultsetjson.xsl
      XSLT to convert Filemaker's REST web-service XML response into clean JSON
      https://twitter.com/alantrewartha
      2017-03-06
      Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/
      Changed:
      * single quotes to JSON-standard double-quotes
      * removed "fieldDefinitions" block (personal preference)
      * stopped every field value being presented as an [ array ] even when not a "repeating field"
      * added whitespace escaping code
      The white-space escaping code was entirely cribbed from
      https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl
      Submitter AlanTrewartha Submitted 03/06/2017 Category Solutions FM Version FM Version: 0  
    • By AlanTrewartha
      XSLT to convert Filemaker's REST web-service XML response into clean JSON
      https://twitter.com/alantrewartha
      2017-03-06
      Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/
      Changed:
      * single quotes to JSON-standard double-quotes
      * removed "fieldDefinitions" block (personal preference)
      * stopped every field value being presented as an [ array ] even when not a "repeating field"
      * added whitespace escaping code
      The white-space escaping code was entirely cribbed from
      https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl
    • By cril
      Hi I'm trying to develop an interface between my filemaker database and a SOAP service. No where in the wsdl is there any authorisation so I believe I need to send my username and password before the SOAP envelope. I'm trying to do that with Scriptmaster but there are only three input parameters none of which appear useful for generating or inputting the HTTP authorisation Basic that needs to be in place. I can't see the fedex modules which may have had the parameters I needed. Can anybody help/advise or suggest another plugin I should use.
       
      Many thanks for reading this.
    • By Quito
      Hi FMForums Community,
      After exporting PubMed records in XML format (where the default file name is pubmed_result.xml), the first two lines within the file must be removed in order to import pubmed_result.xml into FileMaker (14 Adv, MacOS Sierra) using a custom .xsl file.
      Within the ArticleIdList subset there is the ArticleId, with multiple IdType. I am including the relevant XML and XSL portions.
      ----------------
      XML
      <PubmedArticleSet>
        <PubmedArticle>
          <PubmedData>
              <ArticleIdList>
                  <ArticleId IdType="pubmed">27167443</ArticleId>
                  <ArticleId IdType="pii">S1806-37132016000200162</ArticleId>
                  <ArticleId IdType="doi">10.1590/S1806-37562016000000114</ArticleId>
                  <ArticleId IdType="pmc">PMC4853075</ArticleId>
              </ArticleIdList>
          </PubmedData>
        </PubmedArticle>
      </PubmedArticleSet>
      ------------------
      XSL
                              <COL>
                                  <DATA>
                              <xsl:for-each select="PubmedData/ArticleIdList">
                                  <ArticleId>
                                     <xsl:for-each select="*">
                                        <xsl:value-of select="." />
                                        <xsl:if test="position()!=last()">
                                        <xsl:value-of select="'&#xD;'"/>
                                        </xsl:if>
                                     </xsl:for-each>
                                  </ArticleId>
                              </xsl:for-each>
                                  </DATA>
                              </COL>
      -------------------
      The result I'm getting after importing is:
      27167443
      S1806-37132016000200162
      10.1590/S1806-37562016000000114
      PMC4853075
      But I would like to include the ArticleId IdType attribute to make it look like this:
      pubmed: 27167443
      pii: S1806-37132016000200162
      doi: 10.1590/S1806-37562016000000114
      pmc: PMC4853075
      In another topic within fmforums.com there was a suggestion to use @ to capture multiple attributes within a subset.  Something like:
      <xsl:value-of select="ArticleId/@IdType" />
      What should the xsl contain in order to make pubmed: pii: doi: and pmc: visible?
      Many thanks in advance.
      Kind regards,
      Daniel
    • By Anna.anto
      Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic.
      If you cannot find one then you may delete this text and post your topic in this forum.
      Hi all, I need to import into filemaker table an XML file as this:
      <?xml version="1.0" encoding="utf-8"?>
      <Account>
        <Field APIName="WrntyID">6029065</Field>
        <Field APIName="ExternalID">1761A</Field>
        <Field APIName="Name">sayIT SA</Field>
      </Account>
      now I'am trying to create the xls file.
      This is my xls file....
      <?xml version='1.0' encoding='UTF-8'?>
      <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
          <xsl:template match="/">
              <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
                  <METADATA>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="WrntyID" TYPE="TEXT"/>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ExternalID" TYPE="TEXT"/>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name" TYPE="TEXT"/>            
                  </METADATA>
                  <RESULTSET>
                      <ROW>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[1]" /></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[2]” /></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[3]” /></DATA>
                          </COL>
                          </ROW>
                  </RESULTSET>
              </FMPXMLRESULT>
          </xsl:template>
      </xsl:stylesheet>
      This instruction <xsl:value-of select=“Account/Field[1]"/> doesn't work.
      What is the right syntax to retrive the value of the first TAG FIELD? Then the second end so on...?
      Many thanks
      Anna