Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5    Statistic    FMM    Blog  

FM.RunDatabaseDesignReport

Performs a data design report automatically.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
FM 5.0 Yes Yes No No No
MBS( "FM.RunDatabaseDesignReport"; UseXML { ; Path; OpenWhenDone; FileNames } )   More

(old name: FM.RunDataDesignReport)

Parameters

Parameter Description Example Flags
UseXML Pass 1 to use XML or 0 to use HTML for the report. 1
Path The path where to save for MacOS.
If you don't specify a path, the last one used in the dialogs will be used.

No longer used on MacOS Mojave/Catalina due to raised security by Apple which prevents us changing the dialog.
"/tmp" Optional
OpenWhenDone Whether to open file when done.
Pass 1 to open file after creating DDR or 0 to not open.
Default is 0.
0 Optional
FileNames Available in MBS FileMaker Plugin 9.4 or newer.
The list of filenames to set checkmarks for.
Names must match exactly to be checked.
MacOS only.
"test.fmp12¶other.fmp12" Optional

Result

Returns OK or error.

Description

Performs a data design report automatically.
This must be the last step in a script, because it triggers an asynchronously process to make a report. So the plugin will run the menu command, set the options, press the create button and the save button for you.
If you like to run other things later, simply run a script 5 seconds later with FM.RunScriptLater.

FileMaker and the dialogs may need to be frontmost to have this work well.

May not work if debugger window is visible.
See also FM.RunSaveAsXML for FileMaker 18 or newer.

Needs accessibility permissions in system preferences to click save button for MacOS Catalina and may not set path there.
Fixed directory path passing for macOS in plugin version 10.4. If path contains a file name, we pass that to the save dialog and if possible don't show the dialog at all.

This function requires a native path. Use Path.FileMakerPathToNativePath to convert a FileMaker path to a native path if required. If you like to have the user choose the path, you can use FileDialog functions.

Examples

Make a XML report to temp folder on Mac:

Set Variable [$r; Value:MBS( "FM.RunDatabaseDesignReport"; 1; "/tmp" )]

Export to desktop:

Set Variable [$r; Value:MBS( "FM.RunDatabaseDesignReport"; 1; "/Users/cs/Desktop" )]
// please change path!

See also

Example Databases

Blog Entries

Release notes

Created 15th November 2014, last changed 4th September 2020


FM.QueryTableNames   -   FM.RunSaveAsXML

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins