9 Replies Latest reply on Apr 20, 2016 8:23 AM by danshockley

    File name containing a period breaks some functions

      Summary

      File name containing a period breaks some functions

      Product

      FileMaker Pro

      Version

      12.03

      Operating system version

      Mac OS x 10.6.8

      Description of the issue

      If I name a file with a period in it (e.g. "test_v1.1") there are a number of functions that will break (they will return blanks results):  e.g.  ValueListItems(), ValueLists(), WindowNames()...

      This apparently have been a problem going back to version 9:
      http://fmforums.com/forum/topic/60368-fm-bug-with-valuelistitems-function/

      I am just reporting it again because it still exists.

      Expected result

      A list of items

      Actual result

      A blank result

      Workaround

      Name a file without periods, or include the extension in the filename (haven't tested the second one myself, but that is what was reported in the forum thread mentioned above).

        • 1. Re: File name containing a period breaks some functions
          philmodjunk

               I can replicate this behavior in WIndows Xp on FileMaker 12 for all the functions you list except WindowNames. That one still works when I rename a database file to include an extra decimal point.

               And including the file extension does work around this issue. I was able to modify the Get ( FileName ) call I ususally use in these functions to be:

               Get ( FileName ) & ".fmp12"

               to get things working. Knowing that, I can construct a different version of this expression that will append the correct file extension for the current file.

          • 2. Re: File name containing a period breaks some functions

            This is still a problem in FMPA 13.03.  I just ran across this bug again trying to use 'get(filename)' function to feed into the 'fieldnames()' function.  Very strange, and...still present.

            Putting quotes around the name (i.e. quote(get(filename)) doesn't help.  Escaping the period doesn't help (e.g. substitute ( get(filename) ; "." ; "\." ). 

            As Phil noted, though, if you re-append the file extension to the name, it is happy again:  get(filename) & ".fmp12"

            • 3. Re: File name containing a period breaks some functions
              TSGal

              Justin Close:

              Thank you for your post, and I apologize for not responding to the original post.

              Our Development and Testing teams are aware of this issue.  I have attached your post to the original report,  When more information becomes available, I will let you know.

              TSGal
              FileMaker, Inc.

              • 4. Re: File name containing a period breaks some functions

                @All:

                 

                The FileMaker Pro 14 Help for “Creating a FileMaker Pro file” states:

                 

                “For files you plan to host on FileMaker Server, avoid using more than one period in FileMaker Pro filenames. The filename should include only the period before the fmp12 filename extension.”

                 

                TSFalcon

                FileMaker, Inc.

                • 5. Re: File name containing a period breaks some functions

                  Interesting; is that a new suggestion with 14?  I don't recall if my test situation was on a local file or a server-file, either.

                  But in some respects that appears to not quite align with experience, though:  if you re-append the file extension (including another period) it would work fine.  So it works fine to have multiple periods as long as you provided the full file extension.  Again, not sure what the exact test environment was.

                  • 7. Re: File name containing a period breaks some functions
                    danshockley

                    That advice must be addressing a different issue, since it strongly implies it is only dealing with Server issues. This bug (and the one Fred linked to below) happens on local files, not just hosted ones.

                    • 8. Re: File name containing a period breaks some functions
                      danshockley

                      Any follow-up on this? The bug persists in FileMaker 14. And, the bug happens on local files, not just hosted files, so the advice mentioned by ntaylor is not sufficient.

                       

                      I usually avoid putting extra periods in my FileMaker file names (partially because that server-related advice has been around for over a decade, I believe), but the documentation should be more emphatic on this, unless the Development and Testing team intends to fix this bug.

                       

                      TSGal, can you let us know if there is any motion on this? At the very least, the documentation should explicitly say "Do NOT use periods in a FileMaker database name, except immediately before the file extension." This bug has been around for at least versions 11 through 14 (I just tested on 11, 12, 13, and 14), and I believe it has been around in versions since the functions in question existed (it's been too long for me to remember for sure). In the bug report I submitted, I have detailed instructions on how to demonstrate the bug exists (using LayoutNames, but all design functions behave similarly), as well as a nonsensical "work-around" that makes the functions return results again.

                      • 9. Re: File name containing a period breaks some functions
                        danshockley

                        Someone in the other thread pointed out that the documentation for the Design functions does say to include the file extension of the non-file-extension portion of the file name contains a period:

                        Design functions - http://www.filemaker.com/help/14/fmp/en/html/func_ref1.32.34.html

                         

                        That is good advice, when possible. But, sometimes you are not hard-coding a file name into a call to a Design function (in fact, it is usually unwise to hard-code a file name like that). Instead, you should be better off using Get ( FileName ), if you want to get some design information about the current file. But, then the functions break if your file name has a period in it.

                         

                        It seems the real problem is with terminology: it seems like the development team at FileMaker is using an inconsistent definition of what a FileName is, as reflected by the way different functions handle it differently. Perhaps the Design functions could be rebuilt to first TRY the name sent in before stripping off whatever comes after the last period? That would make them work as expected when they are called with a non-file-extension file name as the parameter, but also switch over gracefully to stripping off the file extension if the user sent that as the parameter.