1 Reply Latest reply on Apr 15, 2009 12:06 PM by FentonJones

    Importing records using matching criteria

    guitarman

      Title

      Importing records using matching criteria

      Post

      I am trying to import a folder of pictures using matching criteria. I have a unique identifier in a field in my database that I want to match to a file names in the folder to import. I have done this successfully in the past and it works great. My question is whether the only option for matching is an 'exact' match. I don't see any option to do a  'partial' match. I can get the equals sign to come up beside the field I wish to match to the filename, but no option for exact match or partial match is obvious. The reason I need to do a partial match (preferably a 'contains' match) is that the content in the field is not an exact match for the filename. A 'contains' option would be perfect for what I am trying to accomplish. Of course I know I can rename all the files, but I would rather avoid that if possible as I need the full file names for other purposes.

       

      Thanks!! 

        • 1. Re: Importing records using matching criteria
          FentonJones
            

          There is no such thing as a "partial relational match" (which is pretty much what you're doing). I would say that your best bet would be to go ahead and do the Matching Records import, then see which ones did not get updated. That will be little tricky, because they would no longer be in the found set. You'd need to save the IDs of the original records, then compare via the matches ones. 

           

          So then you'll have a hopefully number that didn't match. Now what to do. There's various ways to proceed. Other than manually looking at the files, you would need to use some external tool to at the very least get a list of those files. If you had a list of files that matched, vs. ones that didn't, you could use a Loop in FileMaker and various tests against the file name to see if it was "close enough".  

           

          There are other tools, such as AppleScript, which can do "contains".