Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

FM.RunDatabaseDesignReport

Performs a data design report automatically.

Component Version macOS Windows Linux Server 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.
You may want to call Process.SetFrontMost to make sure FileMaker is front.

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

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 15th November 2014, last changed 8th February 2023


FM.QueryTableNames - FM.RunSaveAsXML