Hi there,

I tried to import data from an xml into Filemaker using an xsl.

It work fine with most of the variables, however I could not master to import all subsets of the abstract, which is organized like this in the xml:

<Abstract>

<AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">

</AbstractText>

<AbstractText Label="METHODS" NlmCategory="METHODS">

</AbstractText>

<AbstractText Label="RESULTS" NlmCategory="RESULTS">

</AbstractText>

<AbstractText Label="CONCLUSIONS" NlmCategory="CONCLUSIONS">

</AbstractText>

<CopyrightInformation>Copyright 2004 American Cancer Society.</CopyrightInformation>

</Abstract>

The part for this in the xsl looks like this:

<COL>

<DATA>

<xsl:for-each select="MedlineCitation/Article/Abstract">

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

</xsl:for-each>

</DATA>

</COL>

However Filemaker only imports the first subset "Background". What do I have to do, to import all? (I want the entire text in one cell...)

Thanks in advance!

there are no TEXT values to "AbstractText" only attribute values. If you want them imported, you need to point to them specifically:

<xsl:value-of select="AbstractText/@Label" />

<xsl:value-of select="AbstractText/@NlmCategory /> (if you want these values, too)

keep in mind that you will get all these jammed together in your for-each loop. You can add returns or space or comma+space:

<xsl:value-of select="AbstractText/@Label" /><xsl:text>, </xsl:text>

Beverly

On 7/27/2012 at 9:15 PM, beverly said:

there are no TEXT values to "AbstractText" only attribute values. If you want them imported, you need to point to them specifically:

 

<xsl:value-of select="AbstractText/@Label" />

<xsl:value-of select="AbstractText/@NlmCategory /> (if you want these values, too)

 

keep in mind that you will get all these jammed together in your for-each loop. You can add returns or space or comma+space:

<xsl:value-of select="AbstractText/@Label" /><xsl:text>, </xsl:text>

 

Beverly

Hi Beverly,

How would it be when there are multiple attributes within the subset?

Example:

-----------------

<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>

-----------------

Regards,

Daniel

@Quito

Instead of trying to revive old threads whose relevance to your situation is dubious at best, why don't you start a new thread and explain your problem from the beginning and in detail?

Edited December 10, 20169 yr by comment