Open folder to choose a file to Import

[CMA_2021]

I am still using FM Pro 12 advanced. Is there a way to open a folder so the user can choose a file to Import?

[comment]

It is not clear what exactly your question is.

If you don't specify a path to the source file in the Import Records script step then of course the user will be asked to select it.

If you are asking how to start from a specific folder, see:
https://fmforums.com/topic/103806-how-to-preset-next-filemaker-open-file-directory/#findComment-470868

 

[CMA_2021]

Users download an Excel file from the Internet. The file downloads to the default folder C:/Users/User_Name/Downloads

Then, that Excel file needs to be Imported into a Filemaker file. My customers are not computer savvy and they have trouble navigating to the Downloads folder - so I'm trying to make it to where when they click an import button - the script opens their Downloads folder for them. The file they downloaded from the internet is right at the top of the folder - so that's easy. It's just getting them there easily that is presenting the problem. If the filename was the same name always, I'd just enter the filename in the script as the $path and that would work. But the filename changes all the time, so that's not an option.

 

[comment]

  On 5/21/2025 at 11:16 PM, CMA_2021 said:

Users download an Excel file from the Internet.

Expand  

Perhaps the download could be automated so that the file name is known before starting the import.

If not, the other thread lists 2 ways to start the import dialog at the preferred folder.

  On 5/21/2025 at 11:16 PM, CMA_2021 said:

The file they downloaded from the internet is right at the top of the folder

Expand  

Note that the BaseElements plugin can get a list of files in a folder. Or such list could be produced using OS scripting. So then again user interaction would not be required.