Jump to content
vier.gewinnt

Import all Subsets of a node from Pubmed?

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

@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 by comment

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

  • Who Viewed the Topic

    2 members have viewed this topic:
    FMDuck  jools 
×

Important Information

By using this site, you agree to our Terms of Use.