We are running Webdirect on a FM Server. Our script finds a set of records. Then I want to export those records while in Webdirect. I've tried several approaches and nothing seems to work. Works fine in FM Pro Advanced.
I turns out that the script has to run in 'full access' mode to work. Even though clients have been given permission to export this is still required. There are no other restrictions except to their own client ID.
Have you tried the Export Records script step? Some limitations on file format, download location, and not available for mobile browsers.
FileMaker Pro 15 Help
Same export script will work on webd, only the file path is ignored, it is user's selection for security.
Here is the setup:
Even though with dialog on in Webdirect the dialog doesn't open and I have no idea where the export file went.
Since the dialog doesn't show up, the client can't choose the file path. Currently using Chrome.
Web direct saves files in the browser download folder. Cannot be changed.
Where is the 'browser download folder'? Here is the Chrome default. File isn't there.
If I can't find it how could one of our clients ever find the file.
Is there another approach? Possibly defining a variable as the export and putting it into a container field?
kurt, when you download the folder is USER-definable in the browser software Preferences. I have changed mine to be: "Always ask...", then I can choose a folder. But by default, I believe most browsers use the "Downloads" folder/directory.
In addition, after the download, my browsers (yes, I test with several) have a means to see the recent downloads and in fact allow me to "Find" the downloads just performed.
Is this possibly a USER instruction solution (as in how to find...)?
I guess we have two problems. First, given the setup above, from Webdirect the file isn't going into the downloads folder. So something wrong there.
Second, we are dealing with numbers of users, some sophisticated, some not. So giving them instructions on how to change their browser settings is not a practical or user-friendly solution.
Is it possible to insert/set the file into a container in the file?
Probably the best thing for us it to show a dialog after the script to direct the user to their download file.
However . . .
I changed the setting to dialog off and not automatically open the file. It's still not working. Our find is finding 3 records correctly and this works perfectly from FM Pro Advanced to server.
You got this to work, what am I missing?
Have you enabled popup on the browser for the webd site?
It seems FMS14.0.4 doesn't require unblock popup for download dialog any more.
Right, we're now on FMS 15 as well. Latest setting is with dialog off.
I can't understand why this is difficult. It seems very straigtforward.
Works fine for me too, both of the ways you've tried. I've tested with hitting WebDirect using Chrome and Safari on El Capitan.
What browser(s) and OS/version are you opening your WebDirect file in?
(If you happen to be using FireFox, you can get some strange things with WebDirect as it isn't officially supported. However, I just tested with FireFox on El Capitan and it worked (albeit the dialogue boxes rendered very poorly)).
Using Chrome and el Cap 10.11.3 and FMServer 15.
When you tested did the files end up in the downloads folder as expected?
Yep, it goes right to the downloads folder. I'm curious how far you are getting in the WebDirect export records process..... after you click the button or however you are invoking your export script, are you getting the dialogue box that WebDirect presents when a file is ready to download? It looks like this:
Then when I click on the button named "whatever.csv" (this is the file name I gave it in the script) it initiates the download and at that point the browser takes over. I rarely use Chrome, but did here to replicate your setup, to give you an idea of expected behavior. Chrome's download notification appears in the bottom left corner, and the button on the dialogue box then becomes greyed out and disabled leaving "Close" as the only clickable button, as in the following post-download screen grab:
Also, any chance you can try in Safari, and maybe from Windows with IE and/or Chrome and/or Edge? Sure seems like a browser issue or maybe an OS issue, but so hard to tell for sure.
Thanks for screen shot.
I think the pop up dialog is bad design, "Close" button looks like default "do the job" button, and the button with filename is needless since there is only one file to download, it can be start automatically.
The screen shots are super helpful. No, script is not getting that far. Fails with Crome and with Safari.
I think i'll rebuild the layout it's launched from and rebuild the script. Also restrict the exported fields to a couple of text fields.
Retrieving data ...