1 Reply Latest reply on Apr 5, 2013 1:09 PM by philmodjunk

    Batch-import of MP3-files to container

    StenStemme

      Title

      Batch-import of MP3-files to container

      Post

           I just learned from (very helpful) FileMaker support that you can not batch-import MP3-files (via Import folder) to be embedded in the FileMaker file. Batch-import of MP3-files only supports related records. So you would always have to maintain the MP3-file folder intact. This connection is vulnerable, and also impossible to use on FileMaker Go. 

           You can embed the MP3-files, but only one by one, as QuickTime-files, into each record's containter field. This is undoable with 100s of MP3-files.

           FileMaker support suggested use of a script that uses the pathway to the MP3-files, to import the actual MP3-files into the FileMaker file. 

           Any suggestions? Previous threads?

           /Gustavus

        • 1. Re: Batch-import of MP3-files to container
          philmodjunk

               Do you know how to create scripts?

               Do you know how to work with a $Path variable to refer to different files by differen names and paths?

               If you place your folder of Mp3 files inside your Documents folder, FileMaker can extract a list of all the file paths to the mp3 files using get ( DirectorypathListing). It can then loop through that list, importing each detected mp3 file to insert each one into a container field. You can then use Export field contents to export the iinserted "by reference" files to a location where you want to store the files. After exporting the files you re-insert them to update the file reference stored in the container field.

               Obviously not a simple option, but one that can be made to work.

               This thread on $Path variables that comes with a tutorial database file on the subject may be helpful: Exploring the use of a $Path Variable in Scripts