Creating a Path for Reports
I want to set up a table that contains a list of file paths in it. Is there some way in filemaker to open open a dialog menu, browse through the directory structure and get back the path of the final directory?
Using just FileMaker, you can capture the filepath to to a file by using Insert File to insert a reference to the file into a container field. Since that path includes the path to the enclosing folder, this can enable you to also capture the path to the folder, but it's a bit of a kludge.
An alternative would be to use one of the plugins for file manipulation.
You can use one of the fuction in this free plugin "baseelements"
you can get both file and directory paths
I'll take a look at some plugins, but I would rather not buy something that I have to install on every computer for this small function.
Meanwhile, if I have used the Insert file command, is there a way to get the file path from the container field?
Thanks for the information about BaseElements. I think BE_SelectFolder is just what I need.I have installed the plugin, and created the layouts that I need, but I am not sure how to actually call the function.I created a script with an Inset Calculated Result command and used:External ( BaseElements::BE_SelectFolder )as the calculated result. I am getting a "The specified table cannot be found". Have I missed some step, or am I doing this completely incorrectly?Thanks.
GetValue ( YourContainerFIeld ; 2 )
will extract the file path from a container field if the file was inserted into the container field with Insert File and with "store a reference" enabled.
You may find this thread useful: Exploring the use of a $Path Variable in Scripts
I'm very close now, but neither method proposed above gives me the volume name if I am on a mac. Is there some way to find out the volume name as well?
The volume name should be part of the filepath that you can extract from the container field, if the file was inserted with the Store a reference option specified,
You may find this thread to be a helpful source of additional information: Exploring the use of a $Path Variable in Scripts
I had the same problem
look at this article: http://www.goya.com.au/blog/guide-filemaker-import-paths
very clear about volumes on mac
you can download some fuctions that helps on moving paths form extarnal to FM.
Retrieving data ...