3 Replies Latest reply on Jun 5, 2012 6:37 AM by philmodjunk

    Import (read) document file names from an external folder

    DavidLeav

      Title

      Import (read) document file names from an external folder

      Post

      Mac OSX 10.7.2
      Filemaker Pro Advanced 12.0v1

      Ok, here goes...

      I have a folder only for (User) Manuals. These could be for software, appliances, hardware, etc.

      I want to be able to use FMP to choose a manual and be able to display it for viewing. (Most are in PDF format, some in RTF, but if need be, I can convert the latter to PDF.)

      I saw the tutorial for viewing PDFs, etc., but having trouble finding how to access the folder and pull in the names of all the contents (files).

        1. Can FMP list all the file names within that folder, which is dynamic as I may add more to the folder, or delete some as we no longer need them?
        2. If so, how to handle this?
      Thanks for any help on this, even if it is a "No go". (Mr. Schuman (high school english teacher) will be ticked off, he always told us never to "thank" in advance.)

        • 1. Re: Import (read) document file names from an external folder
          davidanders

          Google "import files container site:forums.filemaker.com"
          https://www.google.com/search?q=import+files+container+site%3Aforums.filemaker.com

          Google "import files container site:help.filemaker.com"
          https://www.google.com/search?q=import+files+container+site%3Ahelp.filemaker.com

           

          FileMaker Pro 12 Help
          http://www.filemaker.com/12help/index.html

          Home > Sharing data > Saving, importing, and exporting data
          http://www.filemaker.com/12help/html/import_export.17.1.html#1045326

          Home > Sharing data > Saving, importing, and exporting data > Importing data into FileMaker Pro
          http://www.filemaker.com/12help/html/import_export.17.10.html#1027874

          Home > Sharing data > Saving, importing, and exporting data > Importing data into FileMaker Pro > Importing data into an existing file
          http://www.filemaker.com/12help/html/import_export.17.14.html#1028245

          Home > Sharing data > Saving, importing, and exporting data > Importing data into FileMaker Pro > Importing a folder of files all at once
          http://www.filemaker.com/12help/html/import_export.17.16.html#1044791

           

          7.
          In the File Type area, choose Picture and movie files or Text files, then click Continue.
          If you’re importing a folder of picture files, you can use the Import only a reference to each picture file option to indicate whether to import only a reference to each file, or import a copy of each file directly into the database.
          Important  Because movie files are usually large, they are always imported by reference. If you’re importing large picture files, consider importing only a reference to each file. However, if you import files by reference and later move, rename, or delete a source file, FileMaker Pro won’t be able to display it.
          8.
          In the Import Field Mapping dialog box, choose the type of import to perform, and map fields in your database to the data you want to import. Then click Import.
          For details on using the Import Field Mapping dialog box and finishing the import process, see Setting the import action and mapping fields during import.
          For Picture and movie files import, the following data mapping is available:
           
           
          Data
          Map to field type
          Image
          Container field
          File Name
          Text field
          File Path
          Text field
          Image Thumbnail
          Container field
          For Text files import, the following data mapping is available:
           
           
          Data
          Map to field type
          Text Content
          Text, number, date, time, timestamp, or container field
          File Name
          Text field
          File Path
          Text field
          Notes
           •
          Mac OS: FileMaker Pro can import a folder of Portable Document Format (PDF) files into a container field. Each PDF file appears in QuickTime format. To display different pages in a multi-page PDF file, click the PDF file container field and use QuickTime controls.
           •
          When the folder you specify for import contains shortcuts (Windows) or aliases (Mac OS) to either files or folders, FileMaker Pro does the following:
           •
          Shortcuts/aliases to files: FileMaker Pro locates each original file and imports it.
           •
          Shortcuts/aliases to folders: FileMaker Pro does not locate the original folders and import from them.
           •
          Some items are not imported:
           •
          Windows: FileMaker Pro does not import files or from folders that are hidden, offline, system, or temporary.
           •
          Mac OS: FileMaker Pro does not import invisible files or from folders that are invisible.
           •
          The maximum size of most text files that you import is 1 GB. The size limit on UTF-16 encoded text files is 2 GB.
           •
          If you import the File Path data into a field, you can open the original file directly from FileMaker Pro: select the entire file path text, right-click the text, and then choose Open File from the shortcut menu.


          • 2. Re: Import (read) document file names from an external folder
            DavidLeav

            davidanders: Perhaps I didn't explain my question clearly (and I apologise if that is the case), and I do appreciate the work that you put in to answer my query.

            All I need to find out is how to obtain the file names from a specified folder, not the files themselves. Once I have the names in a table, then I know how to display any that someone wants to view.

            This folder contains PDF versions of manuals that usually come with most things we might buy. Such as washing machine, dishwasher, vacuum, iMac, Notebook Pro, television, radios, etc.

            I will present the names of the available PDF documents. What I intend to do is each time this is run, it will clear out all the records in the table with the document names, and re-populate it with the names of the files currently in the folder. Say, my wife, will pick which manual she wants to look at, select it and the PDF will then come up on the screen.

            I am wondering if I need to figure out an AppScript to get the names and run that script within the Filemaker process. I hope not, means I need to search other forums. ::sighing:: 

            • 3. Re: Import (read) document file names from an external folder
              philmodjunk

              FileMaker can only access file names from folders contained in the documents folder on your system. (There's a get function for that.) To access file names in directories located elseswhere requires using either a plug in or a system script such as Apple Script or a Batch File--both of which can be executed from FileMaker--but which are platform specific.