2 Replies Latest reply on Jan 14, 2015 2:08 PM by TSGal

    Import alias file does not work



      Import alias file does not work


      FileMaker Pro



      Operating system version

      Mac OS X 10.10.1

      Description of the issue


      Filemaker Pro Advanced 12.05v5
      Mac OS X 10.10.1
      Level: Intermediate/Advanced
      Experience: 4 years

      I have a script which imports a file into a table. The script gets the file path from a variable in the format: filemac:/Macintosh HD/Users/path_to_file/filename.csv

      The file is an alias pointing to the actual file in another location on my hard disk. When the script runs, I get an error message saying unknown error:20401. If I replace the alias with the actual file and run the script, it imports the file as expected. If I import the alias file manually, Filemaker will import it but it just won't seem to do it via a script if the file is an alias.

      This seems to be a bug.

      Many Thanks


      Steps to reproduce the problem

      See above

      Expected result

      The file should be imported into filemaker table

      Actual result

      Unknown error: 20401

      Exact text of any error message(s) that appear

      see above


      Use an applescript to get the actual location of the file from the alias.

      tell application "Finder"
            set theFilePath to alias theFile
            set HFSfilePath to the original item of theFilePath as text
      end tell

        • 1. Re: Import alias file does not work


          Thank you for your post.

          In the Import Records dialog, when I add a file and select the alias file, the path is then automatically resolved.  That is, I cannot manually select the alias file to import.

          I have sent your post and my findings to our Development and Testing departments for review.  When I receive any explanation/clarification, I will let you know.

          FileMaker, Inc.

          • 2. Re: Import alias file does not work


            Using an alias as a filename in a variable does not provide automatic alias resolution.  The real path needs to be used instead.

            This information has been sent to Development and Documentation for review.

            FileMaker, Inc.