We updated the server the past two days, you should see some speed performance of our site.

Jump to content

_Mark__

Newbies
  • Content count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About _Mark__

  • Rank
    newbie

Profile Information

  • Title
    Digital Asset Manager
  • Industry
    Media

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Yosemite 10.10.5
  1. XLST for import to Filemaker

    I just tested your XSLT and titleID is populating just fine, but name and value aren't. Is there something I'm doing wrong, like do I need to add anything else to your XSLT? I'm attaching another XSLT I did based a for-each and this strategy you mentioned: <xsl:value-of select="name"/> As you suggested, I think if I can get this XSLT composited somehow with either yours or maybe my original XSLT that I posted previously, that's the fix. Is this possible? Again, I wish I knew more about this stuff but my job requires me to jump into the deep end. SYNOPSIS_DATA_BUT_ONLY_ONE_RECORD.xslt Edit: It should be mentioned that this XSLT doesn't 'loop', so it only imports one record. So the fix would be to get all records and nodes for the original metadata set in the native table and then 'loop' somehow to grab the 'value' nodes from the related table for each record. (Nice way for me to get to know XML for the first time...)
  2. XLST for import to Filemaker

    Hi ggt667, Thanks for your reply. I had no idea that data was from another table, but looking at it now, it makes sense. But yes, flattening the data is what I need to do as my database is structured very different than the source for a variety of reasons. I'll take a look at your suggestions and let you know when I find a solution. Thanks again for looking into this. Much appreciated. -Mark
  3. XLST for import to Filemaker

    Hi all, I'm completely new to XML and I'm making an XLST for an XML feed into my Filemaker database. Surprisingly, I got the basics down rather fast, but I'm really stumped on a few fields. See attached XLST, sample dataset and Filemaker test database. Referencing the XSLT metadata, the import works perfectly fine for the nodes named 'titleId' down through 'dealType' as well as the nodes under 'licensingWindow'. However I can't seem to get the values of a few other nodes. The trouble for me is that the nodes are nested in as child nodes that aren't named uniquely and I just can't figure out how to get their values. Example: <titleListingTextSets> <listingTexts> <listingText> <name>SYNOPSIS75</name> <value>Mickey continues to feel mounting pressure from the network.</value> </listingText> <listingText> <name>SYNOPSIS234</name> <value>Mickey continues to feel mounting pressure from the network as an affiliates dinner is fast approaching and they need something to sell to advertisers.</value> </listingText> <listingText> What I'm looking for is the value (text beginning with the word Mickey) of the field 'value' on the node under the ones whose name is 'name' containing the values 'SYNOPSIS75' and 'SYNOPSIS234'. Those values seem to be the only way to uniquely identify the 'value' fields. That's what I'm not getting. I had one try that did correctly identify and pull over the value data but it messed with the overall for-each I need for importing a number of records and thus I only got the data for a single record. I'm guessing there is an easy fix for this, but I'm just not familiar enough with XML to know it yet. I'd really appreciate it if someone could point me toward the right technique to use on this. You'll see in my XLST some of my failed attempts, if you'd like to see what I was trying. Thanks in advance, Mark NO_SYNOPSES_OR_LICENSE.xslt XML_TEST.fmp12 Sample_Data.xml
×

Important Information

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