I’m using FM14. I’m trying to import videos (stored in a folder on my PC hard drive) with the folder import function but I’m getting the following message. Would anyone know why, or what I am doing wrong.
The compatible list of formats is here:
FileMaker Pro 15 Help
Do you have a screenshot of that folder, or a list including the file formats?
Also, check the path to the folder, chances are it may not be a correct valid path. Are you manually selecting the path (File > Import Records > Folder ) or scripting it? Folder permissions can sometimes cause an issue similar to the behavior you are seeing.
The error message tells you. Only certain file types can be imported. Your video files aren't a type that can be imported by this menu option.
I just looked at the list of compatible formats. My video files have an .mts extension, which is not on that list. I suppose I'll have to write a script but the problem for me here is scripting the path to the folder. I spent a lot of time trying to write an import script before turning to FM folder import function, only to realize now that it won't do the job with the .mts extension.
So I'm back to the script option. Could anyone provide a few clues as to how to properly script the path to the folder.
And to answer Mike's question, I'm manually selecting the path.
The free BaseElements plugin has a function that will list all of the files inside of a folder (BE_ListFiles I believe). This could be adapted to a loop script that creates a new record and walks the list of the folder contents to create records and insert those files.
.mts is definitely a fringe format though, so more customized scripting and functions are required to achieve your results.
You will need to get the list of file names from the folder. Easiest way to do that is with a plug-in. System scripts/batch files can also be used. It's even possible to do it without a plug in or system script if your folder is inside the computer's documents folder by using Get ( DocumentPathList ).
Once you have that list, your script can loop thru it, setting a $path variable that you use with one of the insert steps to insert your file.
Thanks, I'll get to work on a script.
Retrieving data ...