

_Mark__
Members-
Content count
6 -
Joined
-
Last visited
Community Reputation
1 NeutralAbout _Mark__
-
Rank
member
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
-
Find script for matching fields plus another string value
_Mark__ replied to _Mark__'s topic in Finding & Searching
Thanks for the replies guys. I found a solution. In my script I do a Perform Find with two criteria. The first compares a variable I set in the parent table for the movie name with the movie name in the child record. That covers any child records with identical string values. The second does the same except I add " ("* So basically it just adds literal text and zero or more characters beyond that. The logic is clearly not watertight, but it fits the conditions I need it for. Thanks again for the help, I'm looking into the suggestions anyway as they are quite clever and may be of use somewhere else in my database. Best, Mark -
Find script for matching fields plus another string value
_Mark__ replied to _Mark__'s topic in Finding & Searching
Thanks, Steve. I'll look into it and post the results. -
Find script for matching fields plus another string value
_Mark__ posted a topic in Finding & Searching
Hi all, I have an odd situation where I need to write a script that loops through two tables and finds not only records with exactly matching string values in a field but also that exact match AND one or more additional string values. Allow me to explain: The parent table contains a record with a field named Movie and a record with that field containing "This Movie". The child table contains a record with it's own field named Movie and a record with that field containing "This Movie" also. Easy find there. But the child also has another record with the field containing "This Movie (2007)". So how can I find both child records? The conditions are always that the additional records always match exactly except for a year within parenthesis, so I think some sort of find that looks for "(" in addition to an exact match would do. Thanks, Mark -
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...)
-
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
-
_Mark__ started following 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