MBS FileMaker Plugin Changelog

What's new in MBS FileMaker Plugin 14.2 Pre-release 2

Apr 12, 2024
  • Fixed a problem with DynaPDF.ExtractText introduced in 14.x.
  • Fixed a problem with ListDialog freezing on Windows if you use alt-tab to switch to other apps and you switch back to the FileMaker window instead of the dialog itself.
  • Improved XL.Book.GetPictureType to report future types as number.
  • Improved XL.Book.GetPicture to return future pictures types as FILE containers.
  • Added SVG for XL.Book.GetPictureType and XL.Book.GetPicture.
  • Added work around for XL.Book.GetPicture to return image data, even if LibXL returns an error, but does provide data.
  • Improved PDFKit.SelectPrinter function.
  • Added widget to field picker to jump to last selected table occurence.
  • Updated LibXL to version 4.3.0.
  • Added keepAllSheets parameter for XL.LoadBookPartially function.

New in MBS FileMaker Plugin 14.2 Pre-release 1 (Apr 2, 2024)

  • Added QuickList.HasValues and Dictionary.HasKeys functions.
  • Added parameter for Hash.DigestFile to update progress dialog.
  • Updated DynaPDF to version 4.0.86.249.
  • Improved Matrix.HTML and JSON.ToHTML to use CSS for right alignment.
  • Improved EmailParser.HTMLToPlainText to handle title tag.
  • Improved auto complete to not suggest completions while inside a variable or function name to avoid in-word completions.
  • Updated to Xcode 15.3.
  • Added AnimationTime parameter for Overlay.Move function.
  • Implemented PDFKit.Print and related functions for iOS.
  • Added PDFKit.SelectPrinter function.
  • Added JSON.Merge function.
  • Fixed QLPreviewPanel.Show to make sure that a change in focus doesn't clear the content.
  • Added CertificateName parameter to DynaPDF.SaveAndSignFileWinCryptDialog function to skip dialog and pick certificate by name.
  • Added MongoDB.GetAppName, MongoDB.SetAppName and MongoDB.GetCredentials functions.
  • Added MongoDB.ClientCommand, MongoDB.ClientCommandQuery and MongoDB.ClientCommandWithServerId functions.
  • Improved localization of format button.
  • Added tooltip for Script IDs.
  • Improved script IDs to better find script Ids if script name are not unique.
  • Added Windows support for SystemInfo.CPULoad function.
  • Fixed the ListDialog functions to allow the red close widget to be used on the dialog to close it.
  • Added ListDialog.GetShowCloseBox and ListDialog.SetShowCloseBox functions.
  • Fixed an issue in auto complete where our underscore variable completion would prevent you from typing field names with underscores.
  • Added flag 16 for Matrix.JSONRecords to include field names as first row if outputting arrays.
  • Improved WordFile.ReplaceTag and WordFile.Substitute functions to remove control characters from replacement text to avoid creating broken word files.
  • Added Container.RemovePreview function to remove preview from container.
  • Updated CURL to version 8.7.1.
  • Added new XL functions to create conditional formatting including XL.Book.AddConditionalFormat and XL.Sheet.AddConditionalFormatting.
  • Improved Dialog.SetMode function for Note and Stop mode to use the given icon instead of the application icon.
  • Includes our CURL improvements for international domains on macOS/iOS.
  • Improved handling of font and format reference numbers in XL functions to cache the objects and reuse the indexes.
  • Improved localization for script IDs.

New in MBS FileMaker Plugin 14.1 (Mar 12, 2024)

  • Added Overlay functions to show little graphics on screen independent of FileMaker.
  • Added "Copy Full Field Specification" menu command for field specify dialog in FileMaker.
  • Added AVRecorder.GetVideoOrientation and AVRecorder.SetVideoOrientation function.
  • Added CF function as a shortcut for FM.CF function, which assumes you store custom functions in a dictionary named CF.
  • Added check to LibXL.Initialize to return error if you use the license key for a different platform.
  • Added Clipboard.Clear function.
  • Added DynaPDF.CreateGoToEAction function.
  • Added DynaPDF.GetActionsAsJSON function.
  • Added DynaPDF.Parser.SelectionText function.
  • Added empty check for debugger tooltips, so we show "$variable is empty", if IsEmpty() returns true for the variable.
  • Added Events.RequestFullAccessToEvents, Events.RequestFullAccessToReminders and Events.RequestWriteOnlyAccessToEvents functions.
  • Added fallback to Clipboard.GetText for Windows to read ANSI text if unicode text is not available.
  • Added Flags parameter to Window.List to return names instead of IDs and filter for database windows only and/or visible windows.
  • Added GMImage.Statistics function.
  • Added JSON.AddValueToArray and JSON.AddValueToObject functions.
  • Added KeyToCopy parameter to JSON.JSONPatch.FromDiff to copy primary keys.
  • Added LastErrorDetail function for Get() function links.
  • Added ListDialog.SetCloseDialogOnDoubleClick and ListDialog.GetCloseDialogOnDoubleClick to decide whether the dialog closes on double click.
  • Added possibility to hold option key for format button to get a calculation made compact.
  • Added RemoteControl.IsAltKeyDown, RemoteControl.IsCapsLockKeyDown, RemoteControl.IsCommandKeyDown, RemoteControl.IsControlKeyDown, RemoteControl.IsFunctionKeyDown, and RemoteControl.IsShiftKeyDown functions to check if a modifier key is down.
  • Added support for orientation in WebView.SetPrintParameter function for iOS.
  • Added SyntaxColoring.FormatCalculation function.
  • Added timeout for CLGeocoder.GeocodeAddressString and CLGeocoder.ReverseGeocodeLocation functions.
  • Changed Audit.Changed to ignore empty field names.
  • Changed JSON.Replace to accept text or number as replacement and convert it to JSON internally automatically instead of returning a parsing error.
  • Changed PageSetupDialog.GetLastSettings, PrintDialog.GetLastSettings and PDFKit.GetPrintLastSettings to log all text for trace log.
  • Changed Text.TextToRTF function to use RTF parser from macOS/iOS and Windows for these platforms.
  • Changed Trace function to not shorten texts with CURL.DebugMessages or returned error.
  • Disabled syntax coloring explicitly for preferences and file option dialogs.
  • Enabled auto complete for dialog to specify output file. Use Option-ESC or F5 depending on macOS version to trigger auto complete.
  • Fixed a bug in our syntax check button when using fancy quotes.
  • Fixed a crash in ListDialog.Sort when there is no list to sort.
  • Fixed a possible crash with deactivated MBS FileMaker Plugin. Still we welcome if you keep MBS FileMaker Plugin activated in FileMaker.
  • Fixed a problem in Container.Decompress function.
  • Fixed a problem where relationship graph search didn't work for macOS.
  • Fixed a problem with auto completion with underscore variables on macOS Sonoma.
  • Fixed a problem with Command - - shortcut in FileMaker.
  • Fixed a problem with SendMail.AddAttachmentContainer function where the file name included the remote: prefix for external containers.
  • Fixed a problem with Socket.SendMessageHex function.
  • Fixed an edge case with JSON.Replace where it didn't catch all spots.
  • Fixed an issue in SQL functions where an error message would be cut on the first character improperly encoded.
  • Fixed bug in Events.Item.SetTimeZone function.
  • Fixed bug in StoreKit.FinishTransaction function not finding the transaction.
  • Fixed headers in ListDialog functions to not show check boxes.
  • Fixed Window.FindByName for Windows to not find other applications windows.
  • Fixed Window.FindByName to return first matching window in case of a prefix match, not last.
  • Improved calculation formatting code.
  • Improved Clipboard.GetRTFText, Clipboard.GetHTMLText, Clipboard.GetStyledText and Clipboard_GetText for Windows to strip out an ending NULL character if the other application added it to the clipboard text.
  • Improved copying table contextual menu command to copy checkboxes as 0 or 1.
  • Improved Data Detector example to include a contextual menu routine for showing actions based on RegEx.DataDetector function.
  • Improved dialog functions on macOS to show buttons with borders if you have more than three buttons.
  • Improved DynaPDF.GetEmbeddedFileAsContainer to return images with preview.
  • Improved font mapping for DynaPDF.WriteStyledText to better handle bold fonts.
  • Improved formula formatting to keep comments on the end of the line there and better handle inline comments.
  • Improved IKScannerDevicePanel.Reset to clear values set with IKScannerDevicePanel.SetDocumentName, IKScannerDevicePanel.SetScanControlLabel and IKScannerDevicePanel.SetOverviewControlLabel, too.
  • Improved ImageCapture functions to connect scan dialogs with other functions. This allows you to set parameters without the GUI.
  • Improved ListDialog functions to match headers with all their items if you search for them.
  • Improved ListDialog functions to not show empty header lines if you filter entries.
  • Improved our RTF parser for Text.TextToRTF and Clipboard.GetStyledText function.
  • Improved SendMail functions to allow the creation of attachment only emails.
  • Improved SQL functions to better return error messages if the ODBC driver provided them with ASCII instead of UTF16/32 encoding.
  • Improved variable check to run better for smaller scripts.
  • Marked path functions to be free to use.
  • Updated DynaPDF to version 4.0.84.246.
  • Updated dyncall library to version 1.4.
  • Updated our headers for NetSNMP library.
  • Updated SQLite to version 3.45.1.
  • Updated to newer plugin SDK.

New in MBS FileMaker Plugin 14.1 Pre-release 6 (Mar 7, 2024)

  • Added AVRecorder.GetVideoOrientation and AVRecorder.SetVideoOrientation function.
  • Improved copying table contextual menu command to copy checkboxes as 0 or 1.
  • Changed Text.TextToRTF function to use RTF parser from macOS/iOS and Windows for these platforms.
  • Added "Copy Full Field Specification" menu command for field specify dialog in FileMaker.
  • Changed Audit.Changed to ignore empty field names.

New in MBS FileMaker Plugin 14.1 Pre-release 5 (Mar 1, 2024)

  • Changed PageSetupDialog.GetLastSettings, PrintDialog.GetLastSettings and PDFKit.GetPrintLastSettings to log all text for trace log.
  • Disabled syntax coloring explicitly for preferences and file option dialogs.
  • Fixed an edge case with JSON.Replace where it didn't catch all spots.
  • Improved SendMail functions to allow the creation of attachment only emails.
  • Improved font mapping for DynaPDF.WriteStyledText to better handle bold fonts.
  • Updated DynaPDF to version 4.0.84.246.
  • Added DynaPDF.Parser.SelectionText function.
  • Updated to newer plugin SDK.
  • Added timeout for CLGeocoder.GeocodeAddressString and CLGeocoder.ReverseGeocodeLocation functions.
  • Fixed Window.FindByName to return first matching window in case of a prefix match, not last.
  • Fixed Window.FindByName for Windows to not find other applications windows.
  • Fixed a bug in our syntax check button when using fancy quotes.

New in MBS FileMaker Plugin 14.1 Pre-release 4 (Feb 26, 2024)

  • Improved Clipboard.GetRTFText, Clipboard.GetHTMLText, Clipboard.GetStyledText and Clipboard_GetText for Windows to strip out an ending NULL character if the other application added it to the clipboard text.
  • Fixed a crash in ListDialog.Sort when there is no list to sort.
  • Marked path functions to be free to use.
  • Added check to LibXL.Initialize to return error if you use the license key for a different platform.
  • Added JSON.AddValueToArray and JSON.AddValueToObject functions.
  • Added fallback to Clipboard.GetText for Windows to read ANSI text if unicode text is not available.
  • Added Clipboard.Clear function.
  • Added possibility to hold option key for format button to get a calculation made compact for faster evaluation.
  • Added parameter for SyntaxColoring.FormatCalculation to get compact output.
  • Improved our RTF parser for Text.TextToRTF and Clipboard.GetStyledText function.
  • Added Flags parameter to Window.List to return names instead of IDs and filter for database windows only and/or visible windows.
  • Added RemoteControl.IsAltKeyDown, RemoteControl.IsCapsLockKeyDown, RemoteControl.IsCommandKeyDown, RemoteControl.IsControlKeyDown, RemoteControl.IsFunctionKeyDown, and RemoteControl.IsShiftKeyDown functions to check if a modifier key is down.

New in MBS FileMaker Plugin 14.1 Pre-release 1 (Feb 1, 2024)

  • Improved DynaPDF.GetEmbeddedFileAsContainer to return images with preview.
  • Added Events.RequestFullAccessToEvents , Events.RequestFullAccessToReminders and Events.RequestWriteOnlyAccessToEvents functions.
  • Added DynaPDF.CreateGoToEAction function.
  • Fixed a problem with auto completion with underscore variables on macOS Sonoma.
  • Fixed a problem with Command - - shortcut in FileMaker.
  • Improved formula formatting to keep comments on the end of the line there and better handle inline comments.
  • Improved dialog functions on macOS to show buttons with borders if you have more than three buttons.
  • Enabled auto complete for dialog to specify output file. Use Option-ESC or F5 depending on macOS version to trigger auto complete.
  • Updated dyncall library to version 1.4.
  • Added GMImage.Statistics function.
  • Improved Data Detector example to include a contextual menu routine for showing actions based on RegEx.DataDetector function.
  • Fixed a possible crash with deactivated MBS FileMaker Plugin . Still we welcome if you keep MBS FileMaker Plugin activated in FileMaker.
  • Improved documentation to better list constants. More in table views now.
  • Added Overlay functions to show little graphics on screen independent of FileMaker.
  • Fixed a problem in Container.Decompress function.
  • Improved ImageCapture functions to connect scan dialogs with other functions. This allows you to set parameters without the GUI.
  • Fixed a problem where relationship graph search didn't work for macOS.
  • Improved calculation formatting code.
  • Updated SQLite to version 3.45.1.
  • Added KeyToCopy parameter to JSON.JSONPatch.FromDiff to copy primary keys.
  • Fixed a problem with Socket.SendMessageHex function.
  • Fixed headers in ListDialog functions to not show check boxes.
  • Added ListDialog.SetCloseDialogOnDoubleClick and ListDialog.GetCloseDialogOnDoubleClick to decide whether the dialog closes on double click.
  • Improved ListDialog functions to not show empty header lines if you filter entries.
  • Improved ListDialog functions to match headers with all their items if you search for them.

New in MBS FileMaker Plugin 14.0 (Jan 16, 2024)

  • Added a Search Scripts example file to allow you searching your Script Workspace on Windows (and macOS) with the F8 hotkey.
  • Added caching for variable check to improve performance for longer scripts.
  • Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
  • Added checks for SQL functions in multiple places to avoid crashes if SQL command text is empty.
  • Added CNContactStore.ContactsMatchingURL function.
  • Added Command-+ and Command-- as keyboard shortcuts for calculation fields to directly adjust font size.
  • Added command-J to format text as JSON in a text view, e.g. in data viewer result.
  • Added Command-Option-Cursor key shortcuts for relationship graph on macOS to align items.
  • Added Command-Option-Shift-Cursor key shortcuts for relationship graph on macOS to resize items to smallest/biggest size.
  • Added Command-Shift-G for find bar to find previous match.
  • Added Container.IdentifyData, Files.IdentifyData and Text.IdentifyData functions.
  • Added CSS parameter for Matrix.HTML function.
  • Added curl triggers for success and failure: CURL.GetFailedEvaluate, CURL.GetFailedFileName, CURL.GetFailedScriptName, CURL.GetSucceededEvaluate, CURL.GetSucceededFileName, CURL.GetSucceededScriptName, CURL.SetFailedEvaluate, CURL.SetFailedScript, CURL.SetSucceededEvaluate, and CURL.SetSucceededScript.
  • Added CurrentTimeUTCMicroseconds for Audit as possible field.
  • Added CurrentTimeUTCMicroseconds for our get function links.
  • Added DynaPDF parser functions: DynaPDF.Parser.ChangeAltFont, DynaPDF.Parser.Create, DynaPDF.Parser.DeleteText, DynaPDF.Parser.ExtractText, DynaPDF.Parser.FindText, DynaPDF.Parser.Line, DynaPDF.Parser.ParsePage, DynaPDF.Parser.ReplaceSelText, DynaPDF.Parser.SetAltFont, DynaPDF.Parser.TextMatrix, DynaPDF.Parser.WriteToPage.
  • Added DynaPDF.GetFullyQualifiedFieldName function.
  • Added flags for List.BestMatch and QuickList.BestMatch to use Jaro-Winkler distance optionally and optionally return list of top 5.
  • Added FM.SQL.ToMatrix function.
  • Added FullyQualifiedFieldName as new field for DynaPDF.GetFieldAsJSON and DynaPDF.GetFieldAsJSON results.
  • Added JSON.JSONPatch.ApplyPatch, JSON.JSONPatch.FromDiff, JSON.MergePatch.ApplyPatch and JSON.MergePatch.FromDiff functions.
  • Added links to syntax coloring goodies from help pages.
  • Added List.Shuffle and QuickList.Shuffle functions.
  • Added Math.Random.ExponentialDistribution, Math.Random.NormalDistribution and Math.Random.PoissonDistribution functions.
  • Added Matrix.IndexOfFirstValueMatching function.
  • Added more Phidgets examples.
  • Added new parameter for Archive.AddContainer, Archive.AddFile and Archive.AddText to pass a timestamp to use.
  • Added Phidget.DisableServerDiscovery and Phidget.EnableServerDiscovery functions.
  • Added Phidget.GetTag and Phidget.SetTag functions.
  • Added QuickList.Release function as new name for QuickList.Free. Old name stays valid.
  • Added Reset Colors button to the preferences dialog.
  • Added SyntaxColoring.GetCodeFoldingEnabled and SyntaxColoring.SetCodeFoldingEnabled function.
  • Added XL.FormControl.JSON function.
  • Added XML.ToHTML function.
  • Changed DynaPDF.FontInfo to return numbers for FontBBox as list of values with numbers.
  • Changed FM.DeleteRecords to return OK if no record was found.
  • Enabled Folders.UserDownloads to work in iOS.
  • Fixed a bug for comment links which prevented them from working in older macOS versions.
  • Fixed a problem in Matrix.CopyRow when using row names.
  • Fixed a problem with custom web viewer to show PDF documents.
  • Fixed a problem with Get function links and non breaking space.
  • Fixed a problem with ImageView.CreateWithSize not working properly on macOS.
  • Fixed a problem with int32 read as string in SQL functions.
  • Fixed an edge case with auto complete of variables causing an exception.
  • Fixed an edge case with Path.LastPathComponent to return last path name, even if a slash is on the end of the path.
  • Fixed an endless loop in JSON.Search function with a bad query. Now propergates the error properly.
  • Fixed an issue where calculation coloring would run, even when it was disabled.
  • Fixed an issue with auto completing underscore prefixed local variables.
  • Fixed AppleScript.Compile to clear last error for AppleScript.LastErrorMessage function.
  • Fixed control placing on iOS to find layout view for a card window.
  • Fixed copy variables command to not limit it to 500 lines.
  • Fixed CURL.SetupAWS and CURL.SetupOAuth to reset NoBody flag if new transfer is not head.
  • Fixed DynaPDF field functions to try different field structure sizes, if the DynaPDF DLL is much newer/older than our plugin and prevent errors about different structure sizes.
  • Fixed Events.Item.GetCalendar function to not always return JSON.
  • Fixed ListDialog functions to not use column widths if you have only one column.
  • Fixed WebView.InstallUserMediaAccess to not return error when called a second time.
  • Fixed window functions for future FileMaker version, e.g. affect Printer.Print.
  • Implemented Time.Parse for Windows.
  • Improved animation for ProgressDialog functions on macOS.
  • Improved comment links with script: scheme to use script IDs in addition to names.
  • Improved format button to handle <=, >= and <> correctly. But you can also use ≤, ≥ or ≠ of course.
  • Improved handling of arrays for our JSON to HTML conversion in JSON.ToHTML function.
  • Improved performance for newer JSON functions.
  • Improved preferences dialog to not show Touch Bar ESC feature if you don't have a Mac with a Touch Bar.
  • Improved script coloring to better read script lines.
  • Improved SyntaxColoring.FactoryDefaults function to reset both dark and light colors.
  • Improved XL functions for form controls to take name of control in addition to index.
  • Removed support for Claris Pro/Server.
  • Rewrote DynaPDF.ExtractDocumentText using newer DynaPDF.ExtractText function internally.
  • The comment links to scripts can now recognize option key to open script in new window.
  • Updated CURL to version 8.5.0.
  • Updated DynaPDF to version 4.0.82.239.
  • Updated for future FileMaker version.
  • Updated openssl library to version 3.1.4.
  • Updated SQLAPI to version 5.3.0.
  • Updated SQLite to version 3.44.1.
  • Updated to LCMS 2.16.
  • Updated to Xcode 15.2.
  • Updated Visual Studio to version 2022.

New in MBS FileMaker Plugin 14.0 Pre-release 8 (Jan 14, 2024)

  • Added Phidget.GetTag and Phidget.SetTag functions.
  • Added more Phidgets examples.
  • Fixed Events.Item.GetCalendar function to not always return JSON.
  • Updated to Xcode 15.2.
  • Changed FM.DeleteRecords to return OK if no record was found.
  • Fixed control placing on iOS to find layout view for a card window.

New in MBS FileMaker Plugin 14.0 Pre-release 7 (Jan 8, 2024)

  • Rewrote DynaPDF.ExtractDocumentText using newer DynaPDF.ExtractText function internally.
  • Changed Archive.AddContainer, Archive.AddFile and Archive.AddText to use current timestamp for the archive entries.
  • Added new parameter for Archive.AddContainer, Archive.AddFile and Archive.AddText to pass a timestamp to use.
  • The comment links to scripts can now recognize option key to open script in new window.
  • Fixed a bug for comment links which prevented them from working in older macOS versions.

New in MBS FileMaker Plugin 14.0 Pre-release 6 (Jan 2, 2024)

  • Added Reset Colors button to the preferences dialog.
  • Improved SyntaxColoring.FactoryDefaults function to reset both dark and light colors.
  • Updated SQLAPI to version 5.3.0.
  • Fixed a problem with int32 read as string in SQL functions.

New in MBS FileMaker Plugin 13.6 Pre-release 5 (Dec 28, 2023)

  • Updated to Xcode 15.1.
  • Fixed a problem with custom web viewer to show PDF documents.
  • Added Container.IdentifyData, Files.IdentifyData and Text.IdentifyData functions.
  • Added checks for SQL functions in multiple places to avoid crashes if SQL command text is empty.
  • Added curl triggers for success and failure: CURL.GetFailedEvaluate, CURL.GetFailedFileName, CURL.GetFailedScriptName, CURL.GetSucceededEvaluate, CURL.GetSucceededFileName, CURL.GetSucceededScriptName, CURL.SetFailedEvaluate, CURL.SetFailedScript, CURL.SetSucceededEvaluate, and CURL.SetSucceededScript.
  • Updated Visual Studio to version 2022.

New in MBS FileMaker Plugin 13.6 Pre-release 3 (Dec 15, 2023)

  • Added Command-+ and Command-- as keyboard shortcuts for calculation fields to directly adjust font size.
  • Improved preferences dialog to not show Touch Bar ESC feature if you don't have a Mac with a Touch Bar.
  • Fixed an issue where calculation coloring would run, even when it was disabled.
  • Fixed window functions for future FileMaker version, e.g. affect Printer.Print.
  • Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
  • Improved handling of arrays for our JSON to HTML conversion in JSON.ToHTML function.
  • Added CSS parameter for Matrix.HTML function.
  • Added XML.ToHTML function.
  • Updated SQLAPI to version 5.3.

New in MBS FileMaker Plugin 13.5 (Nov 7, 2023)

  • Added calculation formatting function with ƒ button for custom function and calculation dialogs.
  • Added JSON.Query function for JSON Path queries.
  • Added JSON.Replace to replace within a JSON.
  • Added JSON.Search to perform JMESPath queries in FileMaker.
  • Added support for having checkboxes in a list dialog for ListDialog functions.
  • Added "DefaultPDFA4" flag for DynaPDF.CheckConformance function.
  • Added "PDF/A 4", "PDF/A 4e" and "PDF/A 4f" conformation types for DynaPDF.CheckConformance function.
  • Added Command-Option-Shift-C to calculation text field for macOS to copy text with formatting as html:
  • Command-C: Copy as text
  • Command-Option-C: Copy as styled text
  • Command-Option-Shift-C: Copy as HTML
  • Added Command-Shift-F shortcut to show find & replace interface in calculation text field.
  • Added DynaPDF.CreateGeospatialMeasure function.
  • Added Files.IsApplication and Files.IsPackage functions.
  • Added Flags Parameter for Matrix.HTML function.
  • Added Flags Parmeter for Matrix.Evaluate. Pass 2 to continue after error.
  • Added functions to work with reaction effects on macOS 14 and iOS 17 with AVRecorder: AVRecorder.AvailableReactionTypes, AVRecorder.CanPerformReactionEffects, AVRecorder.PerformEffectForReaction, AVRecorder.ReactionEffectGesturesEnabled and AVRecorder.ReactionEffectsEnabled functions.
  • Added goto: and script: for comment URLs in script workspace to quickly jump to lines or scripts.
  • Added highlight support for Text.TextToHTML function.
  • Added IsApplication and IsPackage for Files.ListAsJSON function.
  • Added Matrix.Lookup function to get a value without error for invalid parameters.
  • Added MongoDB Audit.fmp12 example file.
  • Added new flags 512 to ignore duplicates (with FileMaker's validation) and 1024 to not create UUID fields to XML.Import and JSON.Import functions.
  • Added PDF/A 4, PDF/A 4e and PDF/A 4f for DynaPDF.SetPDFVersion function.
  • Added Phidget.ClearScriptTrigger function.
  • Added Plugin.ObjectCounts and Plugin.UsedFunctionCounts function.
  • Added Preview.SetFocus function.
  • Added SkaleAnnotIcons flag for DynaPDF.SetGStateFlags function.
  • Added Window.AddToTaskbar and Window.RemoveFromTaskbar functions.
  • Added Window.Parent function.
  • Added XML.Import.GetExtraFieldDefinitions and XML.Import.SetExtraFieldDefinitions functions to create custom fields.
  • Changed AVRecorder.Release to stop session if it is running.
  • Changed DynaPDF.Table.SetFont to have Style, Embed and CodePage parameters be optional with default style, embed = 1 and CodePage = Unicode.
  • Changed ListDialog.ShowDialog to allow two line prompt line.
  • Changed SQL functions, so you can load Actual Tech ODBC drivers directly without using iODBC.
  • Changed XL.Sheet.CellReadStyledText function to fall back to XL.Sheet.CellReadText for non styled cells.
  • Enabled fortified source checks for libc on Linux.
  • Enabled support for WebP pictures to GraphicsMagick functions for macOS ARM target.
  • Enabled WindowsOCR functions for server usage.
  • Fixed a problem with AVRecorder.AddPreviewWithControl and AVRecorder.StartRecording functions when they returned OK instead of the error.
  • Fixed a problem with AVRecorder.AddPreviewWithControl picking wrong window if layout and window had same name.
  • Fixed an edge case for shifting formula text left.
  • Fixed an exception in syntax coloring for empty texts.
  • Fixed an issue with RtlProcessFlsData crashing on Windows.
  • Fixed an issue with WebHook functions and HTTP headers sent in chunks.
  • Fixed error message for Text.FileExtensionToMimeType function.
  • Fixed Files.ListAsJSON function to not filter invisible files on macOS without asked to do that.
  • Fixed find bar in data viewer for the case you got actually two of them.
  • Fixed font for ListDialog's filter to make it bigger.
  • Fixed OpenSSL to not depend on GLIBC_2.25, so you can use our plugin on older linux versions again.
  • Fixed plugin not loading on macOS 10.13.
  • Fixed problem with ListDialog functions on Windows.
  • Fixed Shell.Terminate for Windows to work better.
  • Fixed XML.Import.ErrorCount and XML.Import.Errors to work better.
  • Improved IKDeviceBrowserPanel.Show and IKScannerDevicePanel.Show functions to internally call ImageCapture.Initialize if needed.
  • Improved Matrix.Evaluate and Matrix.Current to work better in multi threading environments.
  • Improved syntax coloring to recognize variable names in calculation comments, if a comment color and variable color is defined.
  • Improved SystemInfo.OSVersionString, SystemInfo.MacMajorVersion and SystemInfo.MacMinorVersion to return Ubuntu version on Linux.
  • Improved variable check to recognize /* or // @var $test or similar in front of Let statements to define new variables in a comment. Works with @constant, @variable or @parameter like normal comments and with multiple variables.
  • Rewrote script triggers for Phidget functions to not queue up too many scripts.
  • Updated CURL to version 8.4.0.
  • Updated DynaPDF to version 4.0.80.232.
  • Updated SQLAPI to version 5.2.6.
  • Updated SQLite to version 3.44.0.
  • Updated to Xcode 15.0.

New in MBS FileMaker Plugin 13.5 Pre-release 7 (Nov 2, 2023)

  • Added Window.AddToTaskbar and Window.RemoveFromTaskbar function.
  • Fixed XML.Import.ErrorCount and XML.Import.Errors to work better.
  • Added new flags 512 to ignore duplicates (with FileMaker's validation) and 1024 to not create UUID fields to XML.Import and JSON.Import functions.
  • Improved syntax coloring to recognize variable names in calculation comments, if a comment color and variable color is defined.
  • Fixed an exception in syntax coloring for empty texts.
  • Added Files.IsApplication and Files.IsPackage functions.
  • Added IsApplication and IsPackage for Files.ListAsJSON function.
  • Added /* in addition to // for variable detection before Let.
  • Added goto: and script: for comment URLs in script workspace to quickly jump to lines or scripts.
  • Enabled WindowsOCR functions for server usage.
  • Enabled support for WebP pictures to GraphicsMagick functions for macOS ARM target.
  • Improved IKDeviceBrowserPanel.Show and IKScannerDevicePanel.Show functions to internally call ImageCapture.Initialize if needed.

New in MBS FileMaker Plugin 13.5 Pre-release 6 (Oct 27, 2023)

  • Added functions to work with reaction effects on macOS 14 and iOS 17 with AVRecorder: AVRecorder.AvailableReactionTypes, AVRecorder.CanPerformReactionEffects, AVRecorder.PerformEffectForReaction, AVRecorder.ReactionEffectGesturesEnabled and AVRecorder.ReactionEffectsEnabled functions.
  • Fixed Files.ListAsJSON function to filter not filter invisible files on macOS without asked to do that.
  • Fixed error message for Text.FileExtensionToMimeType function.
  • Fixed problem with ListDialog functions on Windows
  • Changed DynaPDF.Table.SetFont to have Style, Embed and CodePage parameters be optional with default style, embed = 1 and CodePage = Unicode.
  • Fixed a problem with AVRecorder.AddPreviewWithControl and AVRecorder.StartRecording functions when they returned OK instead of the error.
  • Fixed a problem with AVRecorder.AddPreviewWithControl picking wrong window if layout and window had same name.
  • Improved variable check to recognize // @var $test or similar in front of Let statements to define new variables in a comment. Works with @constant, @variable or @parameter like normal comments and with multiple variables.
  • Fixed Shell.Terminate for Windows to work better.

New in MBS FileMaker Plugin 13.5 Pre-release 5 (Oct 19, 2023)

  • Added ListDialog.GetCheckedTags and ListDialog.GetCheckedTitles functions.
  • Updated DynaPDF to version 4.0.80.232.
  • Added "PDF/A 4", "PDF/A 4e" and "PDF/A 4f" conformation types for DynaPDF.CheckConformance function.
  • Added "DefaultPDFA4" flag for DynaPDF.CheckConformance function.
  • Added PDF/A 4, PDF/A 4e and PDF/A 4f for DynaPDF.SetPDFVersion function.
  • Tuned new JSON functions.
  • Improved SystemInfo.OSVersionString, SystemInfo.MacMajorVersion and SystemInfo.MacMinorVersion to return Ubuntu version on Linux.

New in MBS FileMaker Plugin 13.5 Pre-release 4 (Oct 16, 2023)

  • Changed ListDialog.ShowDialog to allow two line prompt line for macOS.
  • Fixed font for ListDialog's filter to make it bigger.
  • Rewrote script triggers for Phidget functions to not queue up too many scripts.
  • Added Preview.SetFocus function.
  • Added Phidget.ClearScriptTrigger function.
  • Added ListDialog.GetShowCheckboxes and ListDialog.SetShowCheckboxes functions.
  • Added ListDialog.GetChecked and ListDialog.SetChecked functions.
  • Added MongoDB Audit.fmp12 example file.
  • Added Command-Option-Shift-C to calculation text field for macOS to copy text with formatting as html:
  • Command-C: Copy as text
  • Command-Option-C: Copy as styled text
  • Command-Option-Shift-C: Copy as HTML

New in MBS FileMaker Plugin 13.5 Pre-release 3 (Oct 11, 2023)

  • Added Plugin.UsedFunctionCounts function.
  • Added flag to Plugin.ObjectCounts function to skip zero values.
  • Added Command-Shift-F shortcut to show find & replace interface in calculation text field.
  • Fixed find bar in data viewer for the case you got actually two of them.
  • Fixed an edge case for shifting formula text left.
  • Fixed an issue with WebHook functions and HTTP headers sent in chunks.
  • Updated DynaPDF to version 4.0.79.231.
  • Added DynaPDF.CreateGeospatialMeasure function.
  • Updated SQLAPI to version 5.2.6.
  • Updated SQLite to version 3.42.1.
  • Fixed an issue with RtlProcessFlsData crashing on Windows.
  • Updated CURL to version 8.4.0.

New in MBS FileMaker Plugin 13.5 Pre-release 1 (Sep 26, 2023)

  • Added Flags Parameter for Matrix.HTML function.
  • Added calculation formatting function with ƒ button for custom function and calculation dialogs.
  • Changed XL.Sheet.CellReadStyledText function to fall back to XL.Sheet.CellReadText for non styled cells.
  • Changed AVRecorder.Release to stop session if it is running.
  • Added JSON.Query function for JSON Path queries.
  • Added JSON.Replace to replace within a JSON.
  • Added JSON.Search to perform JMESPath queries in FileMaker.
  • Changed SQL functions, so you can load Actual Tech ODBC drivers directly without using iODBC.
  • Added Window.Parent function.
  • Fixed OpenSSL to not depend on GLIBC_2.25, so you can use our plugin on older linux versions again.
  • Enabled fortified source checks for libc on Linux.
  • Updated DynaPDF to version 4.0.78.230.
  • Added SkaleAnnotIcons flag for DynaPDF.SetGStateFlags function.
  • Updated CURL to version 8.3.0.
  • Added highlight support for Text.TextToHTML function.
  • Updated to Xcode 15.0.
  • Added XML.Import.GetExtraFieldDefinitions and XML.Import.SetExtraFieldDefinitions functions to create custom fields.
  • Improved Matrix.Evaluate and Matrix.Current to work better in multi threading environments.
  • Added Flags Parmeter for Matrix.Evaluate. Pass 2 to continue after error.
  • Added Matrix.Lookup function to get a value without error for invalid parameters.

New in MBS FileMaker Plugin 13.4 (Sep 12, 2023)

  • Added Phidget functions to control various USB devices from Phidgets Inc.
  • Added AsJSON parameters to Events.Calendars, Events.Source.Calendars, Events.Item.GetCalendar, Events.defaultCalendarForNewEvents, Events.defaultCalendarForNewReminders, Events.SourceWithType, Events.Sources and Events.DelegateSources functions to return result as JSON.
  • Added check to LDAP.ModifyJSON and LDAP.Modify to complain if dn is empty.
  • Added CURL.ProcessRelativeURL function.
  • Added DynaPDF.DeleteDPartNode function.
  • Added Files.EvictUbiquitousItem and Files.StartDownloadingUbiquitousItem functions.
  • Added Files.UbiquitousItemStatus function.
  • Added Flags parameter for QLPreviewPanel.Show function.
  • Added ForceInterpolation flag for DynaPDF.RenderPage function.
  • Added iOSApp.GetOrientationDidChangeEvaluate, iOSApp.GetOrientationDidChangeScript, iOSApp.SetOrientationDidChangeEvaluate and iOSApp.SetOrientationDidChangeScript functions.
  • Added MongoDB.IsTracing and MongoDB.Trace functions.
  • Added MongoDB.Ping function.
  • Added MongoDB.SetSSLOptions function.
  • Added MongoDB.SSLLibrary function.
  • Added new parameter useDetached for DynaPDF.SaveAndSignFileExt1 function.
  • Added new PhotoPicker functions.
  • Added SerialPort.OpenPath function, so you can use SerialPort functions to open special files or pipes.
  • Added SerialPort.WaitNamedPipe function to wait for a pipe and use with SerialPort.OpenPath on Windows.
  • Added SkipDPartData option for DynaPDF.SetImportFlags2 function.
  • Added TOTP.DecodeFromBase32 and TOTP.EncodeToBase32 functions.
  • Added XL.Sheet.SetHidden function.
  • Added XML.InsertRecords function.
  • Changed FileDialog functions to return error when called server side.
  • Changed JSON.GetStringValue, JSON.GetBooleanValue, JSON.GetDoubleValue, JSON.GetIntegerValue and JSON.GetValue to return empty result if called with empty value.
  • Changed plugin to free all MongoDB connections if needed when FileMaker quits.
  • Changed window searching on Windows to prefer visible windows for finding by title.
  • Fixed a bug in setting numeric values in SQL functions with floating numbers, caused by a bug fix in version 13.3. Values showed up as zero incorrectly.
  • Fixed a crash with Preview functions on macOS when releasing the temp file.
  • Fixed a possible crash in CURL.GetResultAsContainer function.
  • Fixed a problem with Dialog.SetTimeout closing a FileMaker custom dialog by accident on macOS.
  • Fixed a problem with handling of Shift JIS text encoding.
  • Fixed a problem with Path.FilePathToFileURL for Windows.
  • Fixed a problem with syntax coloring failing to color formulas in variable editing dialog.
  • Fixed a problem with WordFile.ReplaceTag and WordFile.Substitute functions when passing in NULL characters in the text.
  • Fixed an issue with CNContactPicker.Show raising an exception on iOS.
  • Fixed CNContactStore.Contacts to work better on newer macOS versions.
  • Fixed CURL.GetHeaderAsJSON function to make array for duplicate headers and filter duplicates.
  • Fixed exception for CNContact.JSON function.
  • Fixed loop highlighting in case you use bigger fonts.
  • Improved DynaPDF.FindField to better find a field in a group.
  • Improved JSON.Import to better handle arrays in arrays.
  • Marked a dozen files and text functions to be free to use.
  • Rebuild MongoDB-c library with tracing support.
  • Switched MongoDB on macOS and iOS to use OpenSSL for SSL.
  • Updated curl to version 8.2.1.
  • Updated DynaPDF to version 4.0.77.228.
  • Updated for future FileMaker version.
  • Updated SQLAPI to version 5.2.5.
  • Updated SQLite to version 3.43.0.
  • Upgraded WebDownloadDelegate functions to work on WebKit 2.0 on macOS and iOS.

New in MBS FileMaker Plugin 13.4 Prerelease 7 (Sep 8, 2023)

  • Updated SQLAPI to version 5.2.5.
  • Added SerialPort.WaitNamedPipe function to wait for a pipe and use with SerialPort.OpenPath on Windows.
  • Added new PhotoPicker functions.
  • Fixed a problem with syntax coloring failing to color formulas in variable editing dialog.
  • Fixed a problem with WordFile.ReplaceTag and WordFile.Substitute functions when passing in NULL characters in the text.

New in MBS FileMaker Plugin 13.4 Prerelease 6 (Sep 1, 2023)

  • Fixed a problem with Dialog.SetTimeout closing a FileMaker custom dialog by accident on macOS.
  • Improved DynaPDF.FindField to better find a field in a group.
  • Added SerialPort.OpenPath function, so you can use SerialPort functions to open special files or pipes.
  • Fixed a problem with handling of Shift JIS text encoding.
  • Fixed a bug in setting numeric values in SQL functions with floating numbers, caused by a bug fix in version 13.3. Values showed up as zero incorrectly.
  • Updated DynaPDF to version 4.0.77.228.
  • Added SkipDPartData option for DynaPDF.SetImportFlags2 function.
  • Added DynaPDF.DeleteDPartNode function.

New in MBS FileMaker Plugin 13.4 Prerelease 5 (Aug 28, 2023)

  • Changed window searching on Windows to prefer visible windows for finding by title.
  • Upgraded WebDownloadDelegate functions to work on WebKit 2.0 on macOS and iOS.
  • Updated for future FileMaker version.
  • Updated SQLite to version 3.43.0.

New in MBS FileMaker Plugin 13.4 Prerelease 3 (Aug 16, 2023)

  • Updated DynaPDF to version 4.0.76.224.
  • Added ForceInterpolation flag for DynaPDF.RenderPage function.
  • Fixed loop highlighting in case you use bigger fonts.
  • Fixed exception for CNContact.JSON function.
  • Fixed a problem with Path.FilePathToFileURL for Windows.
  • Added Flags parameter for QLPreviewPanel.Show function.
  • Added check to LDAP.ModifyJSON and LDAP.Modify to complain if dn is empty.
  • Changed plugin to free all MongoDB connections if needed when FileMaker quits.
  • Updated curl to version 8.2.1.
  • Improved JSON.Import to better handle arrays in arrays.
  • Added TOTP.DecodeFromBase32 and TOTP.EncodeToBase32 functions.
  • Updated for future FileMaker version.

New in MBS FileMaker Plugin 13.4 Prerelease 1 (Aug 1, 2023)

  • Added MongoDB.SetSSLOptions function.
  • Added MongoDB.Ping function.
  • Added iOSApp.GetOrientationDidChangeEvaluate, iOSApp.GetOrientationDidChangeScript, iOSApp.SetOrientationDidChangeEvaluate and iOSApp.SetOrientationDidChangeScript functions.
  • Fixed a crash with Preview functions on macOS when releasing the temp file.
  • Added AsJSON parameters to Events.Calendars, Events.Source.Calendars, Events.Item.GetCalendar, Events.defaultCalendarForNewEvents, Events.defaultCalendarForNewReminders, Events.SourceWithType, Events.Sources and Events.DelegateSources functions to return result as JSON.
  • Added CURL.ProcessRelativeURL function.
  • Rebuild MongoDB-c library with tracing support.
  • Added MongoDB.IsTracing and MongoDB.Trace functions.
  • Fixed an issue with CNContactPicker.Show raising an exception on iOS.
  • Added new parameter useDetached for DynaPDF.SaveAndSignFileExt1 function.
  • Added XML.InsertRecords function.
  • Changed JSON.GetStringValue, JSON.GetBooleanValue, JSON.GetDoubleValue, JSON.GetIntegerValue and JSON.GetValue to return empty result if called with empty value.
  • Changed FileDialog functions to return error when called server side.

New in MBS FileMaker Plugin 13.3 (Jul 18, 2023)

  • Added Preview functions to add a simple PDF file viewer for Windows and macOS on a layout.
  • Added auto completion for custom function dialog, but you need to press Function-F5 to trigger it.
  • Added DynaPDF.AddDPartNode, DynaPDF.CreateDPartRoot, DynaPDF.DeleteWatermark, DynaPDF.GetLastTextOffset, DynaPDF.HaveDPartRoot, DynaPDF.MarkTemplateAsWatermark and DynaPDF.OpenTagEx functions.
  • Added DynaPDF.AddFieldToFormAction, DynaPDF.CreateResetAction and DynaPDF.CreateSubmitAction functions.
  • Added DynaPDF.CreateAnnotAP function.
  • Added Files.DeleteLater function.
  • Added GMImage.Describe function.
  • Added JSON.FilterObjectArray function.
  • Added JSON.GetArrayItemsAsQuickList and QuickList.JoinJSON functions.
  • Added Matrix.HTML function.
  • Added new flag to XL.Book.GetText and XL.Sheet.GetText to return texts as rich text.
  • Added OCR.GetTextAsJSON function.
  • Added password parameter to WebHook.SetSSL function.
  • Added Schedule.GetEnabled and Schedule.SetEnabled functions to temporarily pause all schedules.
  • Added SystemInfo.isSonoma function.
  • Added Text.ConcatWithDelimiter function.
  • Added translation in German, Dutch, Italian, French, Swedish, Polish, Portuguese, Spanish, Chinese, Japanese and Korean for preferences dialog on macOS and various FileMaker enhancements. Please let us know if you see a typo or wrong translation.
  • Added XL.Sheet.CellWriteMatrix function.
  • Added XL.Sheet.SetColPx and XL.Sheet.SetRowPx functions.
  • Changed Audit functions to return SQL errors from Insert, so you may debug when something goes wrong.
  • Changed DynaPDF.Initialize to ignore calls with old license key, if a valid key was set before.
  • Changed DynaPDF.StampAnnot to have the last 3 parameters optional.
  • Changed ListDialog functions to allow cancel button to be hidden if it has empty label.
  • Changed ListDialog functions to have select button enabled on macOS if no selection is made, but empty selection is allowed (same as on Windows).
  • Changed reason parameter in ProcessActivity.beginActivity function to be optional.
  • Deprecated CGPSConverter.Convert function.
  • Deprecated WindowTransition functions.
  • Extended our search for links in the script workspace to also cover links in text of calculations.
  • Fixed a crash in script workspace for next FileMaker version.
  • Fixed a crash with SQL.SetParamAsNumber when parsing a string.
  • Fixed a memory leak with reusing shell on macOS to run multiple commands.
  • Fixed a possible bug in XML.SubTree function when XML is empty.
  • Fixed a problem with colorspace warning printed on console due to a change in NSColor handling by macOS.
  • Fixed a problem with Text.ReadTextFile reporting an error for zero byte files.
  • Fixed an issue on Linux with encoding text in native encoding.
  • Fixed an issue with SystemInfo.ADSystemInfo function reporting an error about not having initialized COM.
  • Fixed an issue with variable length keys in Encryption.Cipher function.
  • Fixed CURL.GetResultAsContainer function to prefer the download name over the given fallback name.
  • Fixed Events.RequestAccessToEntityType to return "Wait" not as error. And to wait up to 10 seconds for dialog response.
  • Fixed Files.AudioTags function for macARM target.
  • Fixed FM.ScriptNames for database file with dots inside.
  • Fixed problem with ProcessActivity.beginActivity not working well on Windows.
  • Fixed variable check, which broken in tuning in v13.2.
  • Fixed WebView.GetSourceData to return empty result if no data is available.
  • Improved if/loop highlights for transaction blocks when using Czech, Turkish or Polish localization.
  • Improved JSON.Text function to output less commas.
  • Improved showing script IDs when you have two files with same name open.
  • Our plugin now requires glibc 2.25 for openssl on Linux (from 2017)
  • Relaxed seats usage count checks a bit to complain less for being over the limit for a short time.
  • Removed PHP functions.
  • Rewrote Files.LaunchFile function for macOS to use newer API.
  • The plugin now prints a message on server to state whether license is loaded with expiration date for maintenance.
  • Updated CURL library to version 8.1.2.
  • Updated DynaPDF to version 4.0.75.218.
  • Updated LibSSH to version 1.11.0.
  • Updated LibXL to version 4.2.
  • Updated MongoDB-c library to version 1.23.4.
  • Updated openssl library to version 3.1.1.
  • Updated plugin to support next FileMaker version.
  • Updated SQLite to version 3.42.0.

New in MBS FileMaker Plugin 13.3 Pre-release 7 (Jul 12, 2023)

  • Tuned localizations.
  • Localized sort script commands for contextual menus.
  • Fixed positioning of Preview control on macOS with multiple screens.
  • Fixed a crash with SQL.SetParamAsNumber when parsing a string.
  • The plugin now prints a message on server to state whether license is loaded with expiration date for maintenance.
  • Deprecated WindowTransition functions.
  • Fixed Events.RequestAccessToEntityType to return "Wait" not as error. And to wait up to 10 seconds for dialog response.
  • Fixed Files.AudioTags function for macARM target.
  • Updated DynaPDF to version 4.0.75.218.

New in MBS FileMaker Plugin 13.3 Pre-release 6 (Jul 5, 2023)

  • Updated LibXL to version 4.2.
  • Added XL.Sheet.SetColPx and XL.Sheet.SetRowPx functions.
  • Improved JSON.Text function to output less commas.
  • Added Polish translations.
  • Improved if/loop highlights for transaction blocks when using Czech, Turkish or Polish localization.

New in MBS FileMaker Plugin 13.3 Pre-release 5 (Jul 3, 2023)

  • Tuned localizations.
  • Fixed a crash in script workspace for next FileMaker version.
  • Relaxed seats usage count checks a bit to complain less for being over the limit for a short time.
  • Rewrote Files.LaunchFile function for macOS to use newer API.
  • Added Files.DeleteLater function.
  • Added Preview.GetAutoResizingMask and Preview.SetAutoResizingMask functions.
  • Added Preview.GetAutostarts and Preview.SetAutostarts functions.
  • Added Preview.Available and Preview.Unload functions.

New in MBS FileMaker Plugin 13.3 Pre-release 4 (Jun 26, 2023)

  • Updated DynaPDF to version 4.0.74.217.
  • Tuned localizations.
  • Localized the contextual menu in script workspace.
  • Fixed a crash on quit on macOS, introduced in pr1.
  • Fixed an issue with variable length keys in Encryption.Cipher function.
  • Extended our search for links in the script workspace to also cover links in text of calculations.
  • Enabled legacy algorithms for openssl for Encryption.Cipher function.

New in MBS FileMaker Plugin 13.3 Pre-release 3 (Jun 16, 2023)

  • Added Preview functions to add a simple PDF file viewer for Windows and macOS on a layout.
  • Renamed WinPreview functions from pr2 to Preview.
  • Fixed an issue with DynaPDF.Optimize when using older dynapdf library with newer plugin (broken in pr2).
  • Enabled legacy algorithms for openssl, so blowfish is available in Encryption.Cipher.
  • Changed ListDialog functions to have select button enabled on macOS if no selection is made, but empty selection is allowed (same as on Windows).
  • Changed ListDialog functions to allow cancel button to be hidden if it has empty label.
  • Added Schedule.GetEnabled and Schedule.SetEnabled functions to temporarily pause all schedules.

New in MBS FileMaker Plugin 13.3 Pre-release 1 (Jun 1, 2023)

  • Added translation in German, Dutch, Italian, French, Swedish, Portuguese, Spanish, Chinese, Japanese and Korean for preferences dialog on macOS and various FileMaker enhancements. Please let us know if you see a typo or wrong translation.
  • Added auto completion for custom function dialog, but you need to press Function-F5 to trigger it.
  • Added DynaPDF.AddFieldToFormAction, DynaPDF.CreateResetAction and DynaPDF.CreateSubmitAction functions.
  • Added DynaPDF.CreateAnnotAP function.
  • Added GMImage.Describe function.
  • Added JSON.FilterObjectArray function.
  • Added JSON.GetArrayItemsAsQuickList and QuickList.JoinJSON functions.
  • Added Matrix.HTML function.
  • Added new flag to XL.Book.GetText and XL.Sheet.GetText to return texts as rich text.
  • Added OCR.GetTextAsJSON function.
  • Added password parameter to WebHook.SetSSL function.
  • Added Text.ConcatWithDelimiter function.
  • Added XL.Sheet.CellWriteMatrix function.
  • Changed Audit functions to return SQL errors from Insert, so you may debug when something goes wrong.
  • Changed DynaPDF.Initialize to ignore calls with old license key, if a valid key was set before.
  • Changed DynaPDF.StampAnnot to have the last 3 parameters optional.
  • Fixed a memory leak with reusing shell on macOS to run multiple commands.
  • Fixed a possible bug in XML.SubTree function when XML is empty.
  • Fixed a problem with colorspace warning printed on console due to a change in NSColor handling by macOS.
  • Fixed a problem with Text.ReadTextFile reporting an error for zero byte files.
  • Fixed an issue on Linux with encoding text in native encoding.
  • Fixed an issue with SystemInfo.ADSystemInfo function reporting an error about not having initialized COM.
  • Fixed CURL.GetResultAsContainer function to prefer the download name over the given fallback name.
  • Fixed FM.ScriptNames for database file with dots inside.
  • Fixed problem with ProcessActivity.beginActivity not working well on Windows.
  • Improved showing script IDs when you have two files with same name open.
  • Our plugin now requires glibc 2.25 for openssl on Linux (from 2017)
  • Removed PHP functions.
  • Updated CURL library to version 8.1.2.
  • Updated LibSSH to version 1.11.0.
  • Updated MongoDB-c library to version 1.23.4.
  • Updated openssl library to version 3.1.1.
  • Updated SQLite to version 3.42.0.

New in MBS FileMaker Plugin 13.2 (May 9, 2023)

  • Added Linux ARM 64-bit version of MBS FileMaker Plugin.
  • Added support for WebP pictures to GraphicsMagick functions.
  • Added WinPDF functions to use built-in PDF features on Windows.
  • Added AppleScript.LastErrorPosition function.
  • Added Archive.BZip2Version, Archive.LZ4Version, Archive.ZLibVersion, Archive.ZStdVersion and Archive.lzmaVersion functions.
  • Added automatic loading of zbar library if needed.
  • Added Clipboard.AddText function.
  • Added Dictionary.ToMatrix function.
  • Added DynaPDF.AddJavaScript, DynaPDF.ChangeJavaScript, DynaPDF.ChangeJavaScriptAction, DynaPDF.ChangeJavaScriptName, DynaPDF.GetActionCount, DynaPDF.GetJavaScript, DynaPDF.GetJavaScriptAction, DynaPDF.GetJavaScriptName.
  • Added DynaPDF.GetNeedAppearance and DynaPDF.SetNeedAppearance functions.
  • Added DynaPDF.OpenTag and DynaPDF.CloseTag functions to add tags for a tagged PDFs.
  • Added DynaPDF.SetTabLen and DynaPDF.SetTabLen functions.
  • Added flag 32 to XML.ToJSON function to keep empty nodes as text nodes instead of empty objects.
  • Added flags parameter for Icon.GetIconWithQuickLook function.
  • Added GMImage.WriteToWebPContainer function.
  • Added identifier value to the JSON returned by CNContact.JSON function.
  • Added ImagePicker.SetMediaTypes function.
  • Added Linux ARM 64-bit versions of DynaPDF and LibXL libraries.
  • Added ListDialog.IsVisible function.
  • Added MongoDB.ContainerToBinary and MongoDB.TextToBinary functions.
  • Added MongoDB.NowUTC and MongoDB.Time function.
  • Added new highlight style for DynaPDF.ConvertStyledText, DynaPDF.WriteStyledText and DynaPDF.WriteStyledTextEx.
  • Added PhotoPicker.SetSize function.
  • Added Plugin.WebPVersion function.
  • Added possibility to copy a field content or variable content via context menu (in addition to showing it via tooltip).
  • Added RegEx.Release and RegEx.ReleaseAll functions.
  • Added root name parameter to Dictionary.ToXML function.
  • Added sorting of scripts by IDs in addition by names. Press shift key to do sort by ID and option key for descending order.
  • Added WebView.SetPrintParameter and WebView.GetPrintParameter for Windows with this parameters: paperWidth, paperHeight, bottomMargin, topMargin, leftMargin, rightMargin, orientation and shouldPrintBackgrounds.
  • Added Window.HideKeyboard function.
  • Added Window.IsKeyboardVisible function.
  • Added WMFP.GetAudioBitsPerSample, WMFP.GetAudioChannels, WMFP.GetAudioSamplesPerSecond and WMFP.GetVideoFrameRate functions.
  • Added XL.Sheet.AreCellsEmpty function.
  • Added XL.Sheet.HyperlinkIndex function.
  • Adjusted plugin for FileMaker 2023.
  • Changed Audit.Delete and Audit.Delete2 to record new fields found before deleting with Delete instead of Create.
  • Changed container handler to only put in MAIN item for FileMaker 13 or newer.
  • Changed default for CURL.SetOptionConnectionTimeout to 10 seconds (unless you change it) to avoid long stalls in your application of 2 minutes when server is not reachable.
  • Changed DynaPDF functions returning PDF containers to include preview via PDFKit or WinPDF, if you don't have a DynaPDF Pro license.
  • Changed field quoting for FM.SQL.InsertRecordsToSQL and Matrix.InsertRecordsToSQL to handle non ANSI quotes for MySQL/MariaDB.
  • Changed ListDialog.SetOtherButtonEvaluate to query selection, so you can query it using ListDialog.GetSelectedTag and ListDialog.GetSelectedTitle in your expression.
  • Changed minimum version of macOS to 10.13.
  • Changed our error notifications to show script name and file name.
  • Changed Vision.RecognizeText to handle PDF documents on Windows, too.
  • Enabled lz4 and zstd for Archive functions.
  • Enabled web socket support for curl for Windows.
  • Enabled zstd for curl library.
  • Fixed a bug for WebView.Passwords.Install not installing the event.
  • Fixed a bug in MessageComposer functions on newer iOS versions.
  • Fixed a possible memory leak in Dictionary.AddSQL function.
  • Fixed a problem in PrintDialog.GetLastSettings function reporting an exception about a nil value.
  • Fixed a problem where WMIQuery.Query would not report the error message.
  • Fixed a problem which prevents Java.Initialize to initialize on macOS and Linux with current JDK 19.
  • Fixed a problem with Archive.Create and creating 7zip archive.
  • Fixed a problem with empty attributes causing an error in JSON for XML.ToJSON function.
  • Fixed an issue redraw problems in debugger with code folding while scrolling.
  • Fixed code to automatically find libjvm.dylib on macOS to work with JDK 19.
  • Fixed debugger tooltips to show variable name again.
  • Fixed DynaPDF.ParseContent to not complain about open page.
  • Fixed FM.SQL.Field function to handle flags better.
  • Fixed FM.SQL.Field function to return a name if there is no FNAM stream.
  • Fixed issue with indentation for copied script text. Now correct for 30+ level of nesting.
  • Fixed JavaScript.Available to return 1 on macOS and iOS, broken in 13.1.
  • Fixed problem in WinPDF.PageImageAtSize when passing width and height as zero.
  • Fixed script font color to use Menlo-Regular if you pick default since that seems to be what FileMaker uses without plugin instead of system font.
  • Fixed SyntaxColoring.SetFontSize to allow passing value zero to disable font size change.
  • Fixed variable auto completion to work for $~variables to work better.
  • Fixed WebView.FindByName function to find web viewer better on other windows for macOS.
  • Implemented PDFKit.GeneratePreview for Windows by using WinPDF functions.
  • Improved AppleScript.Compile function to return error code and position.
  • Improved Clipboard.GetTypes for Windows to report format list better.
  • Improved EmailParser.Attachment function to better handle PDF documents and return them as PDF container with preview.
  • Improved scroll performance for script workspace related to our search feature.
  • Improved turning off syntax highlighting features.
  • Improved WebView.Scrollbar.getHorizontalMaximum, WebView.Scrollbar.getHorizontalPosition, WebView.Scrollbar.getVerticalMaximum, WebView.Scrollbar.getVerticalPosition and WebView.Scrollbar.set to work on macOS when the web viewer is an interactive container showing a PDF document.
  • Removed MatrixDongle functions.
  • Rewrote parts of the variable check in Script Workspace to better recognize variables defined via target parameter.
  • Updated curl to version 8.0.1.
  • Updated DynaPDF to version 4.0.73.213.
  • Updated LibArchive to version 3.6.2.
  • Updated libwebp to version 1.3.0.
  • Updated LibXL to version 4.1.2.
  • Updated SQLAPI to version 5.2.4.
  • Updated SQLite to version 3.41.2.
  • Updated Xcode to version 14.3.
  • Upgraded PhotoPicker functions to work on macOS.

New in MBS FileMaker Plugin 13.2 Pre-release 5 (May 3, 2023)

  • Added ImagePicker.SetMediaTypes function.
  • Added Window.IsKeyboardVisible function.
  • Added RegEx.Release and RegEx.ReleaseAll functions.
  • Updated SQLAPI to version 5.2.4.
  • Added WebView.SetPrintParameter and WebView.GetPrintParameter for Windows with this parameters: paperWidth, paperHeight, bottomMargin, topMargin, leftMargin, rightMargin, orientation and shouldPrintBackgrounds.

New in MBS FileMaker Plugin 13.2 Pre-release 4 (Apr 26, 2023)

  • Added LinuxARM64 version of MBS FileMaker Plugin.
  • Added LinuxARM64 version of DynaPDF and LibXL libraries.
  • Adjusted plugin for FileMaker 2023.
  • Added Dictionary.ToMatrix function.
  • Added ListDialog.IsVisible function.
  • Fixed a problem with empty attributes causing an error in JSON for XML.ToJSON function.
  • Fixed an issue redraw problems in debugger with code folding while scrolling.
  • Fixed a bug for WebView.Passwords.Install not installing the event.
  • Fixed FM.SQL.Field function to handle flags better.
  • Fixed FM.SQL.Field function to return a name if there is no FNAM stream.
  • Fixed a possible memory leak in Dictionary.AddSQL function.
  • Fixed WebView.FindByName function to find web viewer better on other windows for macOS.
  • Added new highlight style for DynaPDF.ConvertStyledText, DynaPDF.WriteStyledText and DynaPDF.WriteStyledTextEx.
  • Fixed problem in WinPDF.PageImageAtSize when passing width and height as zero.

New in MBS FileMaker Plugin 13.2 Pre-release 3 (Apr 21, 2023)

  • Added flag 32 to XML.ToJSON function to keep empty nodes as text nodes instead of empty objects.
  • Added sorting of scripts by IDs in addition by names. Press shift key to do sort by ID and option key for descending order.
  • Added Clipboard.AddText function.
  • Added DynaPDF.AddJavaScript, DynaPDF.ChangeJavaScript, DynaPDF.ChangeJavaScriptAction, DynaPDF.ChangeJavaScriptName, DynaPDF.GetActionCount, DynaPDF.GetJavaScript, DynaPDF.GetJavaScriptAction, DynaPDF.GetJavaScriptName.
  • Fixed a problem in PrintDialog.GetLastSettings function reporting an exception about a nil value.
  • Changed DynaPDF functions returning PDF containers to include preview via PDFKit or WinPDF, if you don't have a DynaPDF Pro license.
  • Added automatic loading of zbar library if needed.
  • Enabled web socket support for curl for Windows.
  • Changed ListDialog.SetOtherButtonEvaluate to query selection, so you can query it using ListDialog.GetSelectedTag and ListDialog.GetSelectedTitle in your expression.
  • Updated DynaPDF to version 4.0.73.213.

New in MBS FileMaker Plugin 13.2 Pre-release 1 (Apr 3, 2023)

  • Added AppleScript.LastErrorPosition function.
  • Added Archive.BZip2Version, Archive.LZ4Version, Archive.ZLibVersion, Archive.ZStdVersion and Archive.lzmaVersion functions.
  • Added DynaPDF.GetNeedAppearance and DynaPDF.SetNeedAppearance functions.
  • Added DynaPDF.OpenTag and DynaPDF.CloseTag functions to add tags for a tagged PDFs.
  • Added DynaPDF.SetTabLen and DynaPDF.SetTabLen functions.
  • Added flags parameter for Icon.GetIconWithQuickLook function.
  • Added GMImage.WriteToWebPContainer function.
  • Added MongoDB.ContainerToBinary and MongoDB.TextToBinary functions.
  • Added MongoDB.NowUTC and MongoDB.Time function.
  • Added PhotoPicker.SetSize function.
  • Added Plugin.WebPVersion function.
  • Added possibility to copy a field content or variable content via context menu (in addition to showing it via tooltip).
  • Added support for WebP pictures to GraphicsMagick Plugin.
  • Added Window.HideKeyboard function.
  • Added WinPDF functions to use built-in PDF features on Windows.
  • Added WMFP.GetAudioBitsPerSample, WMFP.GetAudioChannels, WMFP.GetAudioSamplesPerSecond and WMFP.GetVideoFrameRate functions.
  • Added XL.Sheet.AreCellsEmpty function.
  • Adjusted plugin for the next version of FileMaker.
  • Changed field quoting for FM.SQL.InsertRecordsToSQL and Matrix.InsertRecordsToSQL to handle non ANSI quotes for MySQL/MariaDB.
  • Changed our error notifications to show script name and file name.
  • Changed Vision.RecognizeText to handle PDF documents on Windows, too.
  • Enabled lz4 and zstd for Archive functions.
  • Enabled zstd for curl library.
  • Fixed a problem where WMIQuery.Query would not report the error message.
  • Fixed a problem which prevents Java.Initialize to initialize on macOS and Linux with current JDK 19.
  • Fixed a problem with Archive.Create and creating 7zip archive.
  • Fixed code to automatically find libjvm.dylib on macOS to work with JDK 19.
  • Fixed DynaPDF.ParseContent to not complain about open page.
  • Fixed issue with indentation for copied script text. Now correct for 30+ level of nesting.
  • Fixed JavaScript.Available to return 1 on macOS and iOS, broken in 13.1.
  • Fixed script font color to use Menlo-Regular if you pick default since that seems to be what FileMaker uses without plugin instead of system font.
  • Fixed SyntaxColoring.SetFontSize to allow passing value zero to disable font size change.
  • Fixed variable auto completion to work for $~variables to work better.
  • Implemented PDFKit.GeneratePreview for Windows.
  • Improved AppleScript.Compile function to return error code and position.
  • Improved Clipboard.GetTypes for Windows to report format list better.
  • Removed MatrixDongle functions.
  • Rewrote parts of the variable check in Script Workspace to better recognize variables defined via target parameter.
  • Updated curl to version 8.0.1.
  • Updated LibArchive to version 3.6.2.
  • Updated libwebp to version 1.3.0.
  • Updated SQLAPI to version 5.2.4b2.
  • Updated SQLite to version 3.41.2.

New in MBS FileMaker Plugin 13.1 (Mar 7, 2023)

  • Added 45 new functions for XL functions to work on form controls and XL.Sheet.FormControlCount function.
  • Added Archive.Create, Archive.AddContainer, Archive.AddFile, Archive.AddText and Archive.Close functions.
  • Added Audit.BaseTableNameForID function.
  • Added ContinuityCamera.CanImport and ContinuityCamera.HasPopupMenu functions.
  • Added dot as valid character for field names for syntax coloring.
  • Added DynaPDF.ChangeNamedDest function.
  • Added DynaPDF.CreateStructureTreeEx function.
  • Added DynaPDF.SaveAndSignFileExt1 and DynaPDF.SaveAndSignFileExt2 functions to sign a PDF using external PKCS7 signature provider.
  • Added flag 32 for Text.TextToHTML function to use paragraphs.
  • Added flags parameter to Matrix.Text function and a flag for Matrix.CSV and Matrix.Text to include column names in first row.
  • Added FM.TextWithDataType function.
  • Added iOSApp.AddSwipeGestureRecognizer and iOSApp.ClearSwipeGestureRecognizer functions to recognize a swipe gesture on your layout.
  • Added JavaScript.LoadLibrary and JavaScript.Available functions.
  • Added MongoDB.Command, MongoDB.AggregateDatabase and MongoDB.AggregateCollection functions.
  • Added MongoDB.GetOptions, MongoDB.GetTLS and MongoDB.SetDatabase functions.
  • Added PDF/UA-1 for DynaPDF.SetPDFVersion function.
  • Added PKCS12.SignData function.
  • Added Plugin.IsMaintenanceExpired function.
  • Added Plugin.State function.
  • Added Process.GetDllDirectory and Process.SetDllDirectory functions.
  • Added Queue Length parameter for WebHook.Listen function.
  • Added shouldPrintBackgrounds parameter for WebView.SetPrintParameter for use in WebKit 1 and 2.
  • Added shouldPrintBackgrounds to WebView.SetPreferences and WebView.GetPreferences for WebKit 2 to control printing of backgrounds.
  • Added support for JavaScriptWebKit functions to work on Windows and Linux if you provide a JavaScriptEngine library file to load.
  • Added SyntaxColoring.ScriptSearchBox.GetRegEx and SyntaxColoring.ScriptSearchBox.SetRegEx functions.
  • Added Windows support for Clipboard.SetPDF and Clipboard.GetPDF functions.
  • Added Windows support for Container.ReadImage and Container.ReadImageFile functions to e.g. load HEIF/HEIC files on Windows.
  • Added WindowsML.List function.
  • Added WindowsOCR functions.
  • Added WindowsUserNotification.List function.
  • Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
  • Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
  • Added WindowsUserNotification.SetGroup and WindowsUserNotification.GetGroup functions.
  • Added WindowsUserNotification.SetNotificationMirroring and WindowsUserNotification.GetNotificationMirroring functions.
  • Added WindowsUserNotification.SetPriority and WindowsUserNotification.GetPriority functions.
  • Added WindowsUserNotification.SetRemoteId and WindowsUserNotification.GetRemoteId functions.
  • Added WindowsUserNotification.SetSuppressPopup and WindowsUserNotification.GetSuppressPopup functions.
  • Added WindowsUserNotification.SetTag and WindowsUserNotification.GetTag functions.
  • Added XL.Book.IsWriteProtected, XL.Sheet.DefaultRowHeight, XL.Sheet.GetTabColor, XL.Sheet.GetTabColorRGB and XL.Sheet.SetDefaultRowHeight functions.
  • Added XL.Sheet.AddSelectionRange, XL.Sheet.GetActiveCell, XL.Sheet.RemoveSelection, XL.Sheet.SelectionRange and XL.Sheet.SetActiveCell functions.
  • Adjusted various internals for future FileMaker versions.
  • Applied SQLAPI patch for Oracle fix in memory leak.
  • Changed all SystemInfo functions to be free to use without license.
  • Changed CURL.SetOptionPassword function to not show password in log.
  • Changed plugin to ignore Registration calls with older keys if a newer license was already set to avoid complaining dialogs when opening older solutions.
  • Changed script search to do regular repressions (opt-in via preferences dialog).
  • Changed search field for relationship graph on Windows to be a combo box.
  • Changed SQL functions to log SQL statements when trace is active.
  • Deprecated PHP functions.
  • Deprecated SystemInfo.isLeopard, SystemInfo.isSnowLeopard, SystemInfo.isLion and SystemInfo.isMountainLion.
  • Deprecated SystemInfo.isWindows2000, SystemInfo.isWindowsXP, SystemInfo.isWindowsVista and SystemInfo.isWindows7.
  • Deprecated SystemInfo.WinCSDVersion and SystemInfo.WindowsAero functions.
  • Deprecated SystemInfo.WinServicePackMajor and SystemInfo.WinServicePackMinor functions.
  • Deprecated WebView.Cookies.Count and WebView.Cookies.Query in favor of WebView.AllCookies function.
  • Disabled FTP access in libxml to avoid unintended network access.
  • Enabled the WindowsML functions again for the public release.
  • Fixed a bug in MongoDB.ChangeStreamErrorDocument, MongoDB.ChangeStreamResumeToken and MongoDB.NextChange functions.
  • Fixed a bug with library loading for aarch64 on Linux for libusb, libidn2, libiconv and libldap.
  • Fixed a crash in JSON.ToHTML function.
  • Fixed a crash in trace function.
  • Fixed a link error in the simulator plugin for Apple Silicon which prevented it from loading when used in newer iOS SDK versions when using newer Xcode version.
  • Fixed a problem loading iconv on Linux.
  • Fixed a problem with Container.ReadImage function returning error about NSRange being wrong.
  • Fixed a problem with CURL.SetProgressScriptName causing a crash when transfer went too fast.
  • Fixed a problem with export dialog tooltips not showing when using the script step.
  • Fixed a timing crash with option click on Set Field in newer FileMaker Pro being too quick.
  • Fixed Clipboard.SetPicture to better pass transparency.
  • Fixed CURL.GetProgressFileName and CURL.GetProgressScriptName functions.
  • Fixed FM.SQL.InsertRecords, FM.SQL.InsertRecordsToSQL, Matrix.InsertRecordsToSQL and Matrix.InsertRecords to quote the table name for the SQL used internally.
  • Fixed JavaScript.New to work on iOS again.
  • Fixed problem in Barcode.Generate and Barcode.GenerateJSON functions, where a warning from the zint library would be treated as an error.
  • Fixed relationship graph search box not showing in Dutch.
  • Fixed ScreenshotRect, Container.Screenshot and WebView.Screenshot for Windows to better use right DPI for high DPI screens.
  • Implemented local Hotkeys for Windows. So if HotKey.Register is passed Local = 1, we run a different code path to monitor keyboard instead of registering global hotkey.
  • Implemented Vision.RecognizeText for Windows using WindowsOCR functions.
  • Implemented WebView.AllCookies and WebView.PrintToFile for Windows.
  • Improved Clipboard.GetPicture to take JPEG, PNG or GIF directly from the clipboard if available. Falls back to bitmap if that is not available.
  • Improved Clipboard.SetPicture to put PNG on the clipboard in addition to a bitmap for applications, that can read PNG forever.
  • Patched SQLAPI to work again with Field() query without FetchNext.
  • Rewrote the WindowsUserNotification functions.
  • Updated CURL library to version 7.88.1.
  • Updated DynaPDF to version 4.0.72.208.
  • Updated DynaPDF.GetBookmark and DynaPDF.GetBookmarksAsJSON functions to return Action and NamedDest properties.
  • Updated LCMS2 library to version 2.15.
  • Updated LibXL to version 4.1.
  • Updated libxml to version 2.10.3.
  • Updated openssl library to 1.1.1t.
  • Updated SQLite to version 3.41.0.
  • Updated tiff library to version 4.5.0.

New in MBS FileMaker Plugin 13.1 Pre-release 6 (Mar 4, 2023)

  • Changed plugin to ignore Registration calls with older keys if a newer license was already set to avoid complaining dialogs when opening older solutions.
  • Added PKCS12.SignData function.
  • Updated LCMS2 library to version 2.15.
  • Changed SQL functions to log SQL statements when trace is active.
  • Applied SQLAPI patch for Oracle fix in memory leak.
  • Fixed ScreenshotRect, Container.Screenshot and WebView.Screenshot for Windows to better use right DPI for high DPI screens.
  • Added Process.GetDllDirectory and Process.SetDllDirectory functions.
  • Fixed a crash in trace function.

New in MBS FileMaker Plugin 13.1 Pre-release 4 (Feb 25, 2023)

  • Fixed Archive.Close to take a file name for the zip archive.
  • Added filename parameter for Archive.AddContainer function.
  • Fixed problem in Barcode.Generate and Barcode.GenerateJSON functions, where a warning from the zint library would be treated as an error.
  • Adjusted various internals for future FileMaker versions.
  • Fixed a problem with Container.ReadImage function returning error about NSRange being wrong.
  • Updated LCMS2 library to version 2.15rc1.
  • Updated CURL library to version 7.88.1.
  • Updated libxml to version 2.10.3.
  • Disabled FTP access in libxml to avoid unintended network access.
  • Updated SQLite to version 3.41.0.
  • Deprecated WebView.Cookies.Count and WebView.Cookies.Query in favor of WebView.AllCookies function.
  • Implemented WebView.AllCookies and WebView.PrintToFile for Windows.

New in MBS FileMaker Plugin 13.1 Pre-release 2 (Feb 6, 2023)

  • Added more WindowsOCR functions.
  • Added shouldPrintBackgrounds parameter for WebView.SetPrintParameter for use in WebKit 1 and 2.
  • Fixed a crash in JSON.ToHTML function.
  • Added MongoDB.Command, MongoDB.AggregateDatabase and MongoDB.AggregateCollection functions.
  • Updated LibXL to version 4.1.
  • Added XL.Book.IsWriteProtected, XL.Sheet.DefaultRowHeight, XL.Sheet.GetTabColor, XL.Sheet.GetTabColorRGB and XL.Sheet.SetDefaultRowHeight functions.
  • Added 45 new functions for XL functions to work on form controls and XL.Sheet.FormControlCount function.
  • Added XL.Sheet.AddSelectionRange, XL.Sheet.GetActiveCell, XL.Sheet.RemoveSelection, XL.Sheet.SelectionRange and XL.Sheet.SetActiveCell functions.
  • Added flags parameter to Matrix.Text function and a flag for Matrix.CSV and Matrix.Text to include column names in first row.
  • Added the | character for script search to search for multiple words, if you use | to separate them, e.g. "abc|def|ghi" for an OR search. Multiple words otherwise do AND. Both can be combined, e.g. "abc|def x".
  • Updated tiff library to version 4.5.0.

New in MBS FileMaker Plugin 13.1 Pre-release 1 (Feb 1, 2023)

  • Added Audit.BaseTableNameForID function.
  • Added ContinuityCamera.CanImport and ContinuityCamera.HasPopupMenu functions.
  • Added dot as valid character for field names for syntax coloring.
  • Added DynaPDF.ChangeNamedDest function.
  • Added DynaPDF.SaveAndSignFileExt1 and DynaPDF.SaveAndSignFileExt2 functions to sign a PDF using external PKCS7 signature provider.
  • Added FM.TextWithDataType function.
  • Added iOSApp.AddSwipeGestureRecognizer and iOSApp.ClearSwipeGestureRecognizer functions to recognize a swipe gesture on your layout.
  • Added JavaScript.LoadLibrary and JavaScript.Available functions.
  • Added MongoDB.GetOptions, MongoDB.GetTLS and MongoDB.SetDatabase functions.
  • Added PDF/UA-1 for DynaPDF.SetPDFVersion function.
  • Added Plugin.IsMaintenanceExpired function.
  • Added Plugin.State function.
  • Added Queue Length parameter for WebHook.Listen function.
  • Added shouldPrintBackgrounds to WebView.SetPreferences and WebView.GetPreferences for WebKit 2 to control printing of backgrounds.
  • Added support for JavaScriptMac functions to work on Windows and Linux if you provide a JavaScriptEngine library file to load.
  • Added Windows support for Clipboard.SetPDF and Clipboard.GetPDF functions.
  • Added Windows support for Container.ReadImage and Container.ReadImageFile functions to e.g. load HEIF/HEIC files on Windows.
  • Added WindowsML.List function.
  • Added WindowsUserNotification.List function.
  • Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
  • Added WindowsUserNotification.SetExpiresOnReboot and WindowsUserNotification.GetExpiresOnReboot functions.
  • Added WindowsUserNotification.SetGroup and WindowsUserNotification.GetGroup functions.
  • Added WindowsUserNotification.SetNotificationMirroring and WindowsUserNotification.GetNotificationMirroring functions.
  • Added WindowsUserNotification.SetPriority and WindowsUserNotification.GetPriority functions.
  • Added WindowsUserNotification.SetRemoteId and WindowsUserNotification.GetRemoteId functions.
  • Added WindowsUserNotification.SetSuppressPopup and WindowsUserNotification.GetSuppressPopup functions.
  • Added WindowsUserNotification.SetTag and WindowsUserNotification.GetTag functions.
  • Changed all SystemInfo functions to be free to use without license.
  • Changed CURL.SetOptionPassword function to not show password in log.
  • Changed search field for relationship graph on Windows to be a combo box.
  • Deprecated PHP functions.
  • Deprecated SystemInfo.isLeopard, SystemInfo.isSnowLeopard, SystemInfo.isLion and SystemInfo.isMountainLion.
  • Deprecated SystemInfo.isWindows2000, SystemInfo.isWindowsXP, SystemInfo.isWindowsVista and SystemInfo.isWindows7.
  • Deprecated SystemInfo.WinCSDVersion and SystemInfo.WindowsAero functions.
  • Deprecated SystemInfo.WinServicePackMajor and SystemInfo.WinServicePackMinor functions.
  • Enabled the WindowsML functions again for the public release.
  • Fixed a bug in MongoDB.ChangeStreamErrorDocument, MongoDB.ChangeStreamResumeToken and MongoDB.NextChange functions.
  • Fixed a bug with library loading for aarch64 on Linux for libusb, libidn2, libiconv and libldap.
  • Fixed a link error in the simulator plugin for Apple Silicon which prevented it from loading when used in newer iOS SDK versions.
  • Fixed a problem with CURL.SetProgressScriptName causing a crash when transfer went too fast.
  • Fixed a problem with export dialog tooltips not showing when using the script step.
  • Fixed a timing crash with option click on Set Field in newer FileMaker Pro being too quick.
  • Fixed Clipboard.SetPicture to better pass transparency.
  • Fixed CURL.GetProgressFileName and CURL.GetProgressScriptName functions.
  • Fixed FM.SQL.InsertRecords, FM.SQL.InsertRecordsToSQL, Matrix.InsertRecordsToSQL and Matrix.InsertRecords to quote the table name for the SQL used internally.
  • Fixed JavaScript.New to work on iOS again.
  • Implemented local Hotkeys for Windows. So if HotKey.Register is passed Local = 1, we run a different code path to monitor keyboard instead of registering global hotkey.
  • Implemented Vision.RecognizeText for Windows using WindowsOCR functions.
  • Improved Clipboard.GetPicture to take JPEG, PNG or GIF directly from the clipboard if available. Falls back to bitmap if that is not available.
  • Improved Clipboard.SetPicture to put PNG on the clipboard in addition to a bitmap for applications, that can read PNG forever.
  • Patched SQLAPI to work again with Field() query without FetchNext.
  • Rewrote the WindowsUserNotification functions.
  • Updated DynaPDF to version 4.0.71.204.
  • Updated DynaPDF.GetBookmark and DynaPDF.GetBookmarksAsJSON functions to return Action and NamedDest properties.

New in MBS FileMaker Plugin 13.0 (Jan 17, 2023)

  • Added WebSocket support for CURL functions.
  • Added functions to watch changes in MongoDB: MongoDB.ChangeStreamErrorDocument, MongoDB.ChangeStreamResumeToken, MongoDB.CloseChangeStream, MongoDB.NextChange, MongoDB.WatchClient, MongoDB.WatchCollection and MongoDB.WatchDatabase.
  • Added example database for SMTP with OAuth for Office 365 in FileMaker.
  • Add PATCH support for CURL.SetupAWS function.
  • Added AppleScript.List function.
  • Added AVExport.List function.
  • Added AVPlayer.List function.
  • Added AVRecorder.List function.
  • Added BinaryFile.List function.
  • Added CFunction.List and CLibrary.List functions.
  • Added CGImageSource.List function.
  • Added checkbox to preferences dialog for code folding and for export dialog tooltips.
  • Added checkbox to preferences dialog on Windows for relationship search box.
  • Added checkbox to preferences dialog to control the option-click feature in Script Workspace.
  • Added checkbox to preferences dialog to control the syntax highlighting for formulas independent of scripts.
  • Added control-F shortcut for Relationship search field on Windows to move focus to the search field. Press control-G to search next.
  • Added CoreML.List function.
  • Added CURL.GetDebugMessages to replace deprecated CURL.GetDebugAsText, but old name will stay around for a long time.
  • Added CURL.GetHeaders to replace deprecated CURL.GetHeaderAsText.
  • Added CURL.SetOptionCACacheTimeout and CURL.SetOptionQuickExit functions.
  • Added CURL.SetOptionWebSocketOptions, CURL.WebSocketReceive and CURL.WebSocketSend functions.
  • Added DNSLookup.List function.
  • Added DynaPDF.CreateICCBasedColorSpace and DynaPDF.CreateICCBasedColorSpaceContainer.
  • Added DynaPDF.GetPageField and DynaPDF.GetPageFieldAnnotation functions.
  • Added DynaPDF.Table.List function.
  • Added DynaPDF.TestGlyphs function.
  • Added ECKey.List function.
  • Added Events.Event.EventIdentifier function.
  • Added find and go to line commands to contextual menu for ScriptWorkspace to make them more visible.
  • Added fontname and fontsize as keys for the XML for Menu.DefineQuickMenuXML function. Now works for submenus, too.
  • Added FSEvents.List function.
  • Added ImageView.List function.
  • Added iOSApp.GetDidBecomeActiveScript, iOSApp.GetDidEnterBackgroundScript, iOSApp.GetDidReceiveMemoryWarningScript, iOSApp.GetSignificantTimeChangeScript, iOSApp.GetWillEnterForegroundScript and iOSApp.GetWillResignActiveScript functions.
  • Added Java.List function.
  • Added JavaScript.List function.
  • Added JSON.Text function.
  • Added LDAP.List function.
  • Added MapView.List function.
  • Added MarkDown.List function.
  • Added MetaDataQuery.List function.
  • Added new flags parameter to FM.SQL.CSV and Matrix.CSV.
  • Added new Get() function names in FileMaker 19.6 for our links in calculations.
  • Added new option to XML.Compact and XML.Format to skip the ?xml line with version details.
  • Added option key for code folding to decide whether we fold until next Else or End If.
  • Added PDFKit.List function.
  • Added PKCS7.List, PKCS12.List and PKey.List functions.
  • Added PortMidi.List function.
  • Added recursive parameter to Menu.FindItemWithTag and Menu.FindItemWithTitle functions.
  • Added RichText.CopyToClipboard and RichText.ReadFromClipboard functions.
  • Added SerialPort.GetTag and SerialPort.SetTag functions.
  • Added SerialPort.Path function.
  • Added Shell.GetTag and Shell.SetTag functions.
  • Added Shell.List function.
  • Added special handling in LDAP functions for returning objectSid and objectGUID values in order to return them formatted.
  • Added SSH.List function.
  • Added SyntaxColoring.GetExportTooltipsEnabled and SyntaxColoring.SetExportTooltipsEnabled functions.
  • Added TouchBar.List function.
  • Added UNNotification.List function.
  • Added WebRequest.GetMode function.
  • Added WhitespaceHeight, GuardDescent and WarnLevel options for Barcode.GenerateJSON functions.
  • Added Windows support for ProcessActivity.beginActivity function.
  • Added WMFP.List function.
  • Added WordFile.List function.
  • Added X509.List function.
  • Added XL.List function.
  • Added XL.Sheet.ReadCellsAsMatrix function to copy cell values into a new matrix.
  • Adjusted maximum object counts. Now DynaPDF.Table.Create can have 10000 tables at the same time in memory.
  • Changed context menu command to show "sort descending" only when you press option key. Without option key we sort ascending.
  • Changed DynaPDF.Initialize function to return an error, if the license key contains invalid characters on the beginning.
  • Changed Files.DeleteFolder for Linux to do recursive deletion.
  • Changed FM.SQL.Text and FM.SQL.CSV functions to return empty text if there are no rows and no row parameter.
  • Changed font popup in preferences dialog to list monospace fonts first.
  • Changed JPEG loader for GMImage.NewFromContainer, GMImage.NewFromFile and related to not stop loading of an image on a warning.
  • Changed JSON parser to skip non breaking spaces like regular spaces.
  • Changed JSON.SetPathItem to do nothing if value is empty (like v12.4 and before).
  • Changed minimum iOS version for deployment to iOS 12.0.
  • Changed search field in ScriptWorkspace to be a real search field with history menu.
  • Changed variable check to disable while scrolling on macOS Ventura with multi line comments in use to avoid layout trouble.
  • Deprecated CURL.GetProtocol function.
  • Deprecated CURL.SetOptionEGDSocket, CURL.SetOptionSSLEnableNPN, CURL.SetOptionSocks5GSSAPIService and CURL.SetOptionRandomFile functions.
  • Deprecated CURL.SetOptionProtocols in favor of CURL.SetOptionProtocolsString function.
  • Deprecated CURL.SetOptionRedirProtocols in favor of CURL.SetOptionRedirProtocolsString function.
  • Deprecated DynaPDF.ExtractPageRectText and DynaPDF.ExtractPageText functions in favor of DynaPDF.ExtractText function.
  • Deprecated FM.GetDictionary and FM.GetDictionaryList functions.
  • Deprecated Proj functions.
  • Deprecated SyntaxColoring.LineNumbers.Disable, SyntaxColoring.LineNumbers.Enable, SyntaxColoring.LineNumbers.Enabled, SyntaxColoring.LineNumbers.GetColor and SyntaxColoring.LineNumbers.SetColor functions.
  • Fixed a bug in LDAP.Search passing attribute names on macOS.
  • Fixed a crash in JSON function when parsing invalid JSON code, broken in 12.5 while fixing another bug.
  • Fixed a memory leak in LDAP.AddJSON and LDAP.ModifyJSON and added additional checks for the passed in JSON.
  • Fixed a problem with iOS plugins missing the version number.
  • Fixed a problem with macOS using same class name for a class as MBS. This may lead to a crash if one side tries to use the class and gets the one from the other side. We renamed our classes.
  • Fixed a problem with shifting text to left or right in first row of a calculation.
  • Fixed a problem with SQL.InsertOrUpdateRecords not finding the primary key field.
  • Fixed a problem with text jumping down when coloring in calculations.
  • Fixed a problem with XL.Book.AddSheet function not passing correct name each time.
  • Fixed an issue with relationship search box not hidden correctly when switching tabs.
  • Fixed bugs for search field for relationship graph on Windows.
  • Fixed PrintDialog.GetLastSettings to not return an error if there are no print settings yet.
  • Fixed problem passing field index to DynaPDF.FlattenAnnotOrField function.
  • Fixed problem with Schedule functions with storing result from evaluate.
  • Fixed Shell.ExitCode to work better on Linux.
  • Fixed Window.PositionNextDialog to work on Windows with the progress dialog shown by Insert From URL script step.
  • Fixed XL.Sheet.SetColumn and XL.Sheet.SetRow to better.
  • Improved Files.MoveFile on Linux to allow you to specify a folder as destination.
  • Improved our link detection for comment lines in ScriptWorkspace to better work with new line and all unicode space characters.
  • Improved Vision.SupportedRecognitionLanguages to report more languages.
  • Linux for ARM 64-bit now is compiled with C++11 standard library.
  • Optimized initialization to log better if something gets wrong to help debugging.
  • Removed syntax coloring support for FileMaker 13 and older since our plugin doesn't run there any more (since we moved to 64-bit only).
  • Updated CURL library to version 7.87.0.
  • Updated DynaPDF to version 4.0.70.201.
  • Updated for Claris Pro v40.1.
  • Updated GraphicsMagick to version 1.3.38.
  • Updated Plugin SDK or FileMaker 19.6.
  • Updated SQLAPI to version 5.2.3.
  • Updated SQLite to version 3.40.0.
  • Updated Xcode to version 14.2.
  • Updated zint library to version 2.11.1. Barcode text may be bigger.
  • Updated zlib to version 1.2.13.

New in MBS FileMaker Plugin 13.0 Prerelease 7 (Jan 11, 2023)

  • Added fontname and fontsize as keys for the XML for Menu.DefineQuickMenuXML function. Now works for submenus, too.
  • Deprecated Proj functions.
  • Adjusted maximum object counts. Now DynaPDF.Table.Create can have 10000 tables at the same time in memory.

New in MBS FileMaker Plugin 13.0 Prerelease 6 (Jan 9, 2023)

  • Added CURL.GetHeaders to replace deprecated CURL.GetHeaderAsText.
  • Added CURL.GetDebugMessages to replace deprecated CURL.GetDebugAsText, but old name will stay around for a long time.
  • Changed Files.DeleteFolder for Linux to do recursive deletion.
  • Changed DynaPDF.Initialize function to return an error, if the license key contains invalid characters on the beginning.
  • Fixed a problem with SQL.InsertOrUpdateRecords not finding the primary key field.
  • Added fontname and fontsize as keys for the XML for Menu.DefineQuickMenuXML function.
  • Added recursive parameter to Menu.FindItemWithTag and Menu.FindItemWithTitle functions.
  • Removed syntax coloring support for FileMaker 13 and older since our plugin doesn't run there any more (since we moved to 64-bit only).
  • Deprecated SyntaxColoring.LineNumbers.Disable, SyntaxColoring.LineNumbers.Enable, SyntaxColoring.LineNumbers.Enabled, SyntaxColoring.LineNumbers.GetColor and SyntaxColoring.LineNumbers.SetColor functions.
  • Added checkbox to preferences dialog to control the option-click feature in Script Workspace.
  • Added checkbox to preferences dialog to control the syntax highlighting for formulas independent of scripts.
  • Added checkbox to preferences dialog for code folding.
  • Changed font popup in preferences dialog to list monospace fonts first.
  • Added checkbox to preferences dialog for export dialog tooltips.
  • Added SyntaxColoring.GetExportTooltipsEnabled and SyntaxColoring.SetExportTooltipsEnabled functions.
  • Deprecated FM.GetDictionary and FM.GetDictionaryList functions.

New in MBS FileMaker Plugin 12.6 Prerelease 5 (Jan 2, 2023)

  • Updated CURL library to version 7.87.0.
  • Deprecated CURL.SetOptionEGDSocket, CURL.SetOptionSSLEnableNPN, CURL.SetOptionSocks5GSSAPIService and CURL.SetOptionRandomFile functions.
  • Deprecated CURL.SetOptionProtocols in favor of CURL.SetOptionProtocolsString function.
  • Deprecated CURL.SetOptionRedirProtocols in favor of CURL.SetOptionRedirProtocolsString function.
  • Deprecated CURL.GetProtocol function.
  • Added CURL.SetOptionCACacheTimeout and CURL.SetOptionQuickExit functions.
  • Linux for ARM 64-bit now is compiled with C++11 standard library.
  • Added iOSApp.GetDidBecomeActiveScript, iOSApp.GetDidEnterBackgroundScript, iOSApp.GetDidReceiveMemoryWarningScript, iOSApp.GetSignificantTimeChangeScript, iOSApp.GetWillEnterForegroundScript and iOSApp.GetWillResignActiveScript functions.
  • Added new flags parameter to FM.SQL.CSV and Matrix.CSV.
  • Updated SQLAPI to version 5.2.3.

New in MBS FileMaker Plugin 12.6 Prerelease 4 (Dec 21, 2022)

  • Added option key for code folding to decide whether we fold until next Else or End If.
  • Added find and go to line to contextual menu for ScriptWorkspace to make them more visible.
  • Tuned new search field in ScriptWorkspace.
  • Updated for Claris Pro v40.1.
  • Changed minimum iOS version for deployment to iOS 12.0.
  • Updated Xcode to version 14.2.
  • Added RichText.CopyToClipboard and RichText.ReadFromClipboard functions.
  • Fixed Window.PositionNextDialog to work on Windows with the progress dialog shown by Insert From URL script step.
  • Added Windows support for ProcessActivity.beginActivity function.
  • Added CFunction.List and CLibrary.List functions.
  • Added WMFP.List function.
  • Added MapView.List function.
  • Added MetaDataQuery.List function.
  • Added Shell.List function.
  • Added ImageView.List function.
  • Added CoreML.List function.
  • Added BinaryFile.List function.
  • Added PKCS7.List, PKCS12.List and PKey.List functions.
  • Added X509.List function.
  • Added TouchBar.List function.
  • Added SSH.List function.
  • Added AVExport.List function.
  • Added AVRecorder.List function.
  • Added FSEvents.List function.
  • Added LDAP.List function.
  • Added DNSLookup.List function.
  • Added ECKey.List function.
  • Added WordFile.List function.
  • Added JavaScript.List function.
  • Added MarkDown.List function.
  • Added PortMidi.List function.
  • Added AVPlayer.List function.
  • Added UNNotification.List function.
  • Added CGImageSource.List function.
  • Added DynaPDF.Table.List function.
  • Added Java.List function.
  • Added PDFKit.List function.
  • Added AppleScript.List function.
  • Fixed a problem with text jumping down when coloring in calculations.

New in MBS FileMaker Plugin 12.6 Prerelease 3 (Dec 15, 2022)

  • Added WebSocket support for CURL functions.
  • Added CURL.SetOptionWebSocketOptions, CURL.WebSocketReceive and CURL.WebSocketSend functions.
  • Added XL.List function.
  • Fixed PrintDialog.GetLastSettings to not return an error if there are no print settings yet.
  • Added JSON.Text function.
  • Changed variable check to disable while scrolling on macOS Ventura with multi line comments in use to avoid layout trouble.
  • Changed search field in ScriptWorkspace to be a real search field with history menu.

New in MBS FileMaker Plugin 12.5 (Dec 2, 2022)

  • Added a search field for relationship graph on Windows for European languages.
  • Added PhotoPicker functions to show newer image picker on iOS.
  • Added MongoDB.StartTransaction, MongoDB.CommitTransaction, MongoDB.InTransaction, MongoDB.AbortTransaction and MongoDB.TransactionState functions.
  • Added algorithm and DecodeBase32 parameters to TOTP.Calculate function.
  • Added App.GetFocussedWindowTitle function.
  • Added BigEndian flag to BinaryFile.WriteInt and BinaryFile.ReadInt functions.
  • Added command-[ and command-] shortcuts for macOS for text views, so you can indent text of formulas.
  • Added Files.IsReadOnly and Files.SetReadOnly functions for Windows.
  • Added FM.SQL.List, JSON.List, Matrix.List, MongoDB.List and XML.List functions.
  • Added LDAP.SetBinaryKeys and LDAP.GetBinaryKeys functions.
  • Added macOS support for CNContact.Show to show contact as popover.
  • Added Matrix.ConvertDataType function.
  • Added Matrix.SetColumnNames and Matrix.SetRowNames functions.
  • Changed code folding to collapse If to the next else.
  • Changed comment URLs to add current file name for URLs starting with "fmp://$/?".
  • Changed custom WebViewer to put it back if FileMaker rebuilds the layout. No longer need Window.SetCloseTrigger to trigger a script to do this.
  • Changed duplicate search for script workspace to skip separators.
  • Changed minimum iOS version for deployment to iOS 12.0.
  • Changed plugin to work with Claris Server.
  • Changed TOTP.Calculate function to return number with zeros on front.
  • Changed URL comments for ScriptWorkspace to encode unicode characters if needed.
  • Changed WebHook.Listen to allow passing zero as port number to pick a random port, which you then query via WebHook.GetPort.
  • Changed XML.ToJSON to better convert single values, which are boolean or number and not just text.
  • Disabled code folding for FileMaker 15 and older.
  • Disabled debug logging left over in CoreML.Update function.
  • Disabled debug logging left over in RegEx.DataDetector function.
  • Fixed a bug in Matrix.Add and Matrix.Multiply.
  • Fixed a but in XL.CopySheet, where it failed if the sheet didn't have a name.
  • Fixed a problem in Internal SQLite Library for new changes64 function.
  • Fixed a problem in SyntaxColoring.Format function.
  • Fixed a problem in XML.SetVariables and long variable names.
  • Fixed a problem showing IDs for scripts, layouts and value lists for Claris Pro.
  • Fixed a problem with Claris Pro not loading the plugin.
  • Fixed a problem with JSON.IsValid accepting garbage characters behind parsing.
  • Fixed a problem with restoring custom WebViewers with WebView.Create.
  • Fixed a regression in JSON.GetPathItem and JSON.SetPathItem to restore functionality, where you just grab an array item with just an index.
  • Fixed bug in coloring field names with underscore character.
  • Fixed bug in DynaPDF.AppendImagePage, where we missed last image in a multi image picture.
  • Fixed crash if text is missing in JSON for Barcode.GenerateJSON function.
  • Fixed issue with our script ID display hiding the script name.
  • Fixed JSON.Colorize to work better with color for keys in nested objects.
  • Fixed problem in JSON.GetStringValue crashing for invalid JSON.
  • Fixed problem in linux plugin preventing it to load in Claris Server.
  • Fixed problem in WordFile.ReplaceTag with all = true, where it returned error, but replaced tags.
  • Fixed problem with DragDrop.GetFileDescriptor not working in v12.4.
  • Fixed XL.Format.SetNumFormat and related functions to not crash if you pass an invalid format number.
  • Implemented ProgressDialog functions for iOS.
  • Implemented WebView.ClearSelection for WebKit 2 on macOS.
  • Improved Auto Complete to remove duplicates in MBS function list.
  • Improved EmailParser.HTMLToPlainText function to better handle comments in html and div tags.
  • Improved EventMonitor functions for Windows to recognize better 3rd, 4th or 5th mouse button.
  • Improved URL detection in Script Workspace to recognize fmp19:// URLs.
  • Updated CURL to version 7.86.0.
  • Updated DynaPDF to version 4.0.70.200.
  • Updated LCMS library to version 2.14.
  • Updated openssl to version 1.1.1s.
  • Updated SQLAPI to version 5.2.2.
  • Updated SQLite to version 3.39.4.
  • Updated Xcode to version 14.0.1.

New in MBS FileMaker Plugin 12.5 Prerelease 7 (Nov 5, 2022)

  • Fixed problem with missing version number for pr6.
  • Fixed XL.Format.SetNumFormat and related functions to not crash if you pass an invalid format number.
  • Added App.GetFocussedWindowTitle function.
  • Added LDAP.SetBinaryKeys and LDAP.GetBinaryKeys functions.
  • Disabled debug logging left over in RegEx.DataDetector function.
  • Disabled debug logging left over in CoreML.Update function.
  • Fixed bugs for new search field.
  • Fixed problem in SendMail function being unable to send emails since CURL update.
  • Fixed problem in JSON.GetStringValue crashing for invalid JSON.
  • Fixed a problem in Internal SQLite Library for new changes64 function.

New in MBS FileMaker Plugin 12.5 Prerelease 3 (Oct 17, 2022)

  • Improved EmailParser.HTMLToPlainText function to better handle comments in html and div tags.
  • Added Matrix.SetColumnNames and Matrix.SetRowNames functions.
  • Added Matrix.ConvertDataType function.
  • Fixed a bug in Matrix.Add and Matrix.Multiply.
  • Improved URL detection in Script Workspace to recognize fmp19:// URLs.
  • Fixed a problem showing IDs for scripts, layouts and value lists for Claris Pro.
  • Added DecodeBase32 parameter to TOTP.Calculate function.

New in MBS FileMaker Plugin 12.4 (Sep 6, 2022)

  • Added new MBS Xojo XML Plugin.
  • Added ErrorDocument method to MongoCursorMBS class.
  • Added HasBorder property to ScintillaControlMBS control.
  • Added InsertMany functions to MongoCollectionMBS class.
  • Added iOS support for DirectorySizeMBS class.
  • Added kgfDoNotComprMetadata constant for DynaPDFMBS class.
  • Added monospacedDigitSystemFontOfSize and monospacedSystemFontOfSize functions to NSFontMBS class.
  • Added more constants to PhidgetServerMBS class.
  • Added NewCursorFromCommandReply function to MongoClientMBS class.
  • Added OptionMimeOptions, OptionMaxLifeTimeConnection and OptionSSHHostPublicKeySHA256 properties to CURLSMBS class.
  • Added popoverShouldDetach and popoverDidDetach events to NSPopoverMBS class.
  • Added Prepare event to ScintillaControlMBS control.
  • Added Rename and FindIndexes functions to MongoCollectionMBS class.
  • Added SetRenderingIntent method for DynaPDFMBS class.
  • Added WinRTSControl property to SerialPortMBS class to control RTS line state.
  • Added withOverlays parameter to ShowAllAnnotations method in MKMapViewMBS class.
  • Added zstd support for CURLSMBS class.
  • Changed WindowsPreviewHandlerMBS to automatically call unload for you in destructor in case you forgot.
  • Deprecated CocoaControlMBS and WebViewControlMBS controls.
  • Fixed a problem where ScintillaControlMBS would not get the focus and Control-V would paste to the wrong control.
  • Fixed a problem where SelectedText in ScintillaControlMBS would return a NULL byte on the end.
  • Fixed a problem where the Xojo IDE would crash when using ScintillaControlMBS.
  • Fixed a problem with SplitCommaSeparatedValuesMBS not parsing properly quoted multi line value.
  • Fixed file path handling bug for Windows ARM affecting various functions.
  • Fixed picture and graphics handling bug for Windows ARM.
  • Implemented CopyPicture in NSImageMBS class.
  • Implemented DNSServiceMetaQueryMBS for iOS.
  • Improved BytesZeroMBS function in MemoryBlock class to be faster.
  • Removed kError_CONV_FAILED constant in CURLSMBS class.
  • Removed unneeded boolean return value for decidePolicyForNavigationAction event in WKWebViewIOSControlMBS class.
  • Renamed OptionFTPResponseTimeout property to OptionServerResponseTimeout in CURLSMBS class. (old mame stays valid, but deprecated)
  • Update Chromium plugin classes to newer Chromium version.
  • Updated CURL to version 7.85.0.
  • Updated DynaPDF to version 4.0.70.197.
  • Updated SQLite to version 3.39.2.

New in MBS FileMaker Plugin 12.3 (Jul 11, 2022)

  • Added MongoDB functions to connect to Mongo databases.
  • Added a button for links in comments in script workspace to open page in the browser.
  • Added ErrorLog function to query JSON of errors from function calls in MBS FileMaker Plugin since last call to ClearErrors function.
  • Added ' to list of allowed characters for variables or function names in syntax highlighting.
  • Added AddToErrorLog function to add custom log entries.
  • Added Audit.GetDateAndTimeAsNumbers and Audit.SetDateAndTimeAsNumbers to log dates, times and timestamps as numbers instead of text.
  • Added checkbox in preferences for comment links.
  • Added Collapse/Expand All commands to table views in the FileMaker user interface like layouts.
  • Added CURL.GetCAInfo and CURL.GetCAPath functions.
  • Added DynaPDF.GetFontSize function.
  • Added DynaPDF.SetDateTimeFormat function.
  • Added DynaPDF.SetTemplBBox function.
  • Added Find Duplicate Names contextual menu commands for layout window in FileMaker.
  • Added FM.VariableLookup and SharedMemory.LookupValue functions.
  • Added MariaDB as option for SQL.SetClient function.
  • Added Mode = 2 for SerialPort.List function to return information as JSON.
  • Added PDF support for Vision.RecognizeText function, so you can get live text from PDF documents.
  • Added PDF/X 5 and 6 values for DynaPDF functions.
  • Added SyntaxColoring.CommentLinks.GetEnabled and SyntaxColoring.CommentLinks.SetEnabled functions.
  • Added SystemInfo.isVentura function.
  • Added TOTP.Calculate function and TOTP.CurrentTime function to create Time-based one-time passwords.
  • Changed Container.GetDataURL function to use right mime type for WebP images.
  • Changed DynaPDF.SetFont, DynaPDF.SetFieldFont, DynaPDF.SetFontEx and DynaPDF.Table.SetFont to use unicode as default code page.
  • Changed variable check to handle "Perform Script", "Perform Script on Server" and "Install OnTimer Script" script steps.
  • Deprecated WebView.ShowDebugBar function.
  • Fixed a bug where debugger would crash if the script is zoomed in.
  • Fixed a possible race condition for CURL.GetResultAsText and similar.
  • Fixed a problem where changing font would remove our extra tab stops added for formulas.
  • Fixed a problem where WinPhotoAcquire.Files would not get all the pictures.
  • Fixed Container.GetBase64 function to work without error and only container parameter.
  • Fixed DynaPDF.SysFontInfo function and example database to not miss the last font.
  • Fixed List.DeCombine and QuickList.DeCombine to handle the ReturnNewline parameter correctly.
  • Fixed parameter count check for DynaPDF.DeleteAnnotation function.
  • Fixed problem in contextual menu, where wrong shortcut key was displayed.
  • Fixed problem with plugin correctly identifying Claris Pro.
  • Fixed SystemInfo.WindowsMachineInfo to report correctly for Windows on ARM.
  • Fixed to problem where the repetition field in a calculation window was too small.
  • Implemented recover for mutex handling, so we better handle if a function crashes and avoid timeout exceptions.
  • Implemented SerialPort.GetCTS, SerialPort.GetDSR, SerialPort.GetDTR, SerialPort.GetRTS, SerialPort.SetCTS, SerialPort.SetDSR, SerialPort.SetDTR, and SerialPort.SetRTS for Linux.
  • Updated CURL to version 7.84.0.
  • Updated DynaPDF to version 4.0.69.188.
  • Updated SQLAPI to version 5.2.1.
  • Updated tesseract support for OCR functions to work with version 5.1.
  • Updated LibXL to version 4.0.4.
  • Updated to Xcode 13.4.
  • Upgraded If/Loop colorization to detect more script steps in various localizations.
  • You can now use english spelling JSON.Colourise and XML.Colourise if you prefer to call JSON.Colorize or XML.Colorize.

New in MBS FileMaker Plugin 12.3 Pre-release 7 (Jul 8, 2022)

  • Updated openssl to version 1.1.1q.

New in MBS FileMaker Plugin 12.3 Pre-release 6 (Jul 6, 2022)

  • Updated SQLAPI to version 5.2.1.
  • Updated tesseract support for OCR functions to work with version 5.1.
  • Updated DynaPDF to version 4.0.69.188.
  • Added DynaPDF.GetFontSize function.
  • Added MongoDB.Keys function.

New in MBS FileMaker Plugin 12.3 Pre-release 5 (Jun 28, 2022)

  • Updated SQLAPI to version 5.2.0.
  • Added MariaDB as option for SQL.SetClient function.
  • Added more MongoDB functions: MongoDB.EstimatedDocumentCount, MongoDB.FindDatabases, MongoDB.MaxBSONSize MongoDB.MaxMessageSize, MongoDB.ServerDescription and MongoDB.ServerDescriptions.
  • Fixed problem in contextual menu, where wrong shortcut key was displayed.
  • Fixed parameter count check for DynaPDF.DeleteAnnotation function.
  • Fixed SystemInfo.WindowsMachineInfo to report correctly for Windows on ARM.
  • Added ErrorLog function to query JSON of errors from function calls in MBS FileMaker Plugin since last call to ClearErrors function.
  • Added AddToErrorLog function to add custom log entries.
  • Fixed Container.GetBase64 function to work without error and only container parameter.
  • Fixed a bug where debugger would crash if the script is zoomed in.
  • Changed MongoDB.Connect to connect right away and not later.
  • Fixed a problem where changing font would remove our extra tab stops added for formulas.
  • Fixed a possible race condition for CURL.GetResultAsText and similar.
  • Implemented recover for mutex handling, so we better handle if a function crashes and avoid timeout exceptions.
  • Updated CURL to version 7.84.0.
  • Deprecated WebView.ShowDebugBar function.
  • Added CURL.GetCAInfo and CURL.GetCAPath functions.

New in MBS FileMaker Plugin 12.3 Pre-release 3 (Jun 14, 2022)

  • Added Audit.GetDateAndTimeAsNumbers and Audit.SetDateAndTimeAsNumbers to log dates, times and timestamps as numbers instead of text.
  • Added DynaPDF.SetDateTimeFormat function.
  • Added SystemInfo.isVentura function.
  • Fixed problem in comment links.
  • Upgraded If/Loop colorization to detect more script steps in various localizations.

New in MBS FileMaker Plugin 12.3 Pre-release 2 (Jun 13, 2022)

  • Added FM.VariableLookup and SharedMemory.LookupValue functions.
  • Fixed problem with plugin correctly identifying Claris Pro.
  • Added more MongoDB functions.
  • Added a button for links in comments in script workspace to open page in the browser.
  • Added SyntaxColoring.CommentLinks.GetEnabled and SyntaxColoring.CommentLinks.SetEnabled functions.
  • Added checkbox in preferences for comment links.
  • Added Collapse/Expand All commands to table views in the FileMaker user interface like layouts.
  • Added Find Duplicate Names contextual menu commands for layout window in FileMaker.

New in MBS FileMaker Plugin 12.3 Pre-release 1 (Jun 3, 2022)

  • Added MongoDB functions to connect to Mongo databases.
  • Updated LibXL to version 4.0.3.
  • Changed DynaPDF.SetFont, DynaPDF.SetFieldFont, DynaPDF.SetFontEx and DynaPDF.Table.SetFont to use unicode as default code page.
  • Fixed DynaPDF.SysFontInfo function and example database to not miss the last font.
  • Fixed List.DeCombine and QuickList.DeCombine to handle the ReturnNewline parameter correctly.
  • Changed Container.GetDataURL function to use right mime type for WebP images.
  • Changed variable check to handle "Perform Script", "Perform Script on Server" and "Install OnTimer Script" script steps.
  • Fixed a problem where WinPhotoAcquire.Files would not get all the pictures.
  • Updated DynaPDF to version 4.0.67.185.
  • Updated to Xcode 13.4.
  • Added PDF/X 5 and 6 values for DynaPDF functions.
  • Added TOTP.Calculate function and TOTP.CurrentTime function to create Time-based one-time passwords.
  • Implemented SerialPort.GetCTS, SerialPort.GetDSR, SerialPort.GetDTR, SerialPort.GetRTS, SerialPort.SetCTS, SerialPort.SetDSR, SerialPort.SetDTR, and SerialPort.SetRTS for Linux.
  • Added Mode = 2 for SerialPort.List function to return information as JSON.
  • You can now use english spelling JSON.Colourise and XML.Colourise if you prefer to call JSON.Colorize or XML.Colorize.
  • Fixed to problem where the repetition field in a calculation window was too small.

New in MBS FileMaker Plugin 12.2 (May 17, 2022)

  • Added links in calculation dialogs for get functions to point to FileMaker documentation.
  • Added AsArray flag 4 for Matrix.JSONRecord and Matrix.JSONRecords functions.
  • Added ClearErrors and HadErrors functions.
  • Added Clipboard.GetPDF and Clipboard.SetPDF functions.
  • Added JavaScript.CallFunction, JavaScript.GetPropertyJSON and JavaScript.SetPropertyJSON functions.
  • Added JavaScript.CF function for using this JavaScript engine for custom functions, too.
  • Added Menu and MenuSet as types for Clipboard.DetectFileMakerDataType function.
  • Added new optional RootTableName parameter for JSON.Import function.
  • Added new parameter for JavaScript.New to name the instance.
  • Added new parameter to replace new lines in the list with replacement text for Matrix.GetColumn, Matrix.GetRow and Matrix.GetText functions.
  • Added SchemaCacheFlushed counter for Audit.Statistics function to show how often we flushed the table cache.
  • Added WordFile.Tags function.
  • Changed App.SetDockIcon to allow passing empty value to clear image.
  • Changed Container.GetBase64 and Container.GetHex to return main container item if no index is passed.
  • Changed DynaPDF.ReplacePattern to fallback to Courier (fixed pitch), Times (serif) or Helvetica as font.
  • Changed PDFKit.Combine to ignore empty value in parameters.
  • Changed SharedMemory.GetValue to trim trailing zero bytes.
  • Changed Text.AppendTextFile, Text.WriteToContainer and Text.WriteTextFile to allow writing BOM character.
  • Changed XML.NodeNames to return names in order of appearance.
  • Changed XML.SetPathValue to create text note if needed.
  • Deprecated Barcode.Detect in favor of Barcode.Scan function.
  • DynaPDF has been updated and tested to work with ZUGFeRD 2.2 / Factur-X 1.0.06.
  • Extended the menu for script list in script workspace and added sort commands.
  • Fixed a problem with Dialog.SetTextAlignment and FileMaker 18 causing an out of bounds exception.
  • Fixed a problem with high unicode character encodings for Text.TextToHTML function.
  • Fixed an edge case for Files.FileNameWithoutExtension, where the path contains no slashes.
  • Fixed an edge case in EmailParser functions where file name got an extra space in front.
  • Fixed DynaPDF.AttachFileContainer to allow PDF containers to be attached.
  • Fixed Files.List to better check directory status on macOS using alternative code path.
  • Fixed Files.Mount to return correct path when mounting to a folder.
  • Fixed issue with XL.Sheet.CellWriteText to allow you to pass empty value to not change format.
  • Fixed problem in DynaPDF.GetInPDFVersionEx and DynaPDF.GetPDFVersionEx not always returning the data.
  • Fixed problem with DynaPDF.CheckConformance not parsing options right, e.g. for DefaultPDFA3.
  • Fixed WebView.ClearSelection to work with Edge based WebViewer on Windows.
  • Fixed WebView.SetInternetExplorerVersion and WebView.SetInternetExplorerHiDPI to return OK on success instead of the new setting as documented.
  • Implemented DialogModifications functions for iOS to customize some error messages in FileMaker iOS application.
  • Improved Audit to only query metadata for required tables instead of all as that should be faster.
  • Improved CURL.SetProgressScript to not fire too often.
  • Improved exception handling for SQL functions.
  • Improved performance for scrolling in Script Workspace when debugger tooltips are enabled.
  • Improved trace logging for macOS to replace newsline for console output to have LF instead of CR for line endings.
  • Improved WebHook functions to work better with mixed IPv4 and IPv6 networks.
  • Marked FM.ExecuteSQL as deprecated in favor of newer FM.ExecuteFileSQL function.
  • Marked FM.ExecuteSQLOnIdle as deprecated in favor of newer FM.ExecuteFileSQLOnIdle function.
  • Optimized List.CSVSplit, QuickList.CSVSplit and Matrix.CSVSplit to better handle lonely quotes in quoted strings.
  • Optimized Schedule functions to be faster if there is no schedule to run.
  • Rewrote Window.ConfigureToolbarMenu for macOS 12 to make it work again.
  • Updated CURL to version 7.83.1.
  • Updated DukTape library for JavaScript functions to version 2.7.
  • Updated DynaPDF to version 4.0.66.181.
  • Updated openssl to version 1.1.1n.
  • Updated SQLite to version 3.38.5.
  • Updated Text.FilterASCII, Text.RemoveAccents and Text.RemoveAccentsCaseInsensitive functions to recognize more characters like ½.
  • Updated to Xcode 13.3.1.

New in MBS FileMaker Plugin 12.2 Pre-release 7 (May 13, 2022)

  • New in this prerelease of version 12.2 of the MBS FileMaker Plugin:
  • Fixed DynaPDF.AttachFileContainer to allow PDF containers to be attached.
  • Updated CURL to version 7.83.1.
  • Improved exception handling for SQL functions.
  • Fixed problem with DynaPDF.CheckConformance not parsing options right, e.g. for DefaultPDFA3.
  • Fixed problem in DynaPDF.GetInPDFVersionEx and DynaPDF.GetPDFVersionEx not always returning the data.

New in MBS FileMaker Plugin 12.2 Pre-release 6 (May 10, 2022)

  • Changed SharedMemory.GetValue to trim trailing zero bytes.
  • Added links in calculation dialogs for get functions to point to FileMaker documentation.
  • Updated SQLite to version 3.38.5.
  • Added AsArray flag 4 for Matrix.JSONRecord and Matrix.JSONRecords functions.

New in MBS FileMaker Plugin 12.2 Pre-release 5 (May 4, 2022)

  • Updated Text.FilterASCII, Text.RemoveAccents and Text.RemoveAccentsCaseInsensitive functions to recognize more characters like ½.
  • Fixed WebView.SetInternetExplorerVersion and WebView.SetInternetExplorerHiDPI to return OK on success instead of the new setting as documented.
  • Added new parameter to replace new lines in the list with replacement text for Matrix.GetColumn, Matrix.GetRow and Matrix.GetText functions.
  • Changed XML.NodeNames to return names in order of appearance.
  • Updated DynaPDF to version 4.0.66.181.
  • Updated DukTape library for JavaScript functions to version 2.7.
  • Added new parameter for JavaScript.New to name the instance.
  • Added JavaScript.CallFunction, JavaScript.GetPropertyJSON and JavaScript.SetPropertyJSON functions.
  • Added JavaScript.CF function for using this JavaScript engine for custom functions, too.
  • Fixed a problem with high unicode character encodings for Text.TextToHTML function.

New in MBS FileMaker Plugin 12.2 Pre-release 4 (Apr 29, 2022)

  • Optimized Schedule functions to be faster if there is no schedule to run.
  • Added Menu and MenuSet as types for Clipboard.DetectFileMakerDataType function.
  • Fixed an edge case for Files.FileNameWithoutExtension, where the path contains no slashes.
  • Changed App.SetDockIcon to allow passing empty value to clear image.
  • Fixed an edge case in EmailParser functions where file name got an extra space in front.
  • Updated SQLite to version 3.38.3.
  • Updated CURL to version 7.83.0.
  • Deprecated Barcode.Detect in favor of Barcode.Scan function.
  • Added ClearErrors and HadErrors functions.

New in MBS FileMaker Plugin 12.2 Pre-release 3 (Apr 22, 2022)

  • Changed Container.GetBase64 and Container.GetHex to return main container item if no index is passed.
  • Updated to Xcode 13.3.1.
  • Fixed issue with XL.Sheet.CellWriteText to allow you to pass empty value to not change format.
  • Changed XML.SetPathValue to create text note if needed.
  • Added new optional RootTableName parameter for JSON.Import function.
  • Rewrote Window.ConfigureToolbarMenu for macOS 12 to make it work again.
  • Implemented DialogModifications functions for iOS to customize some error messages in FileMaker iOS application.
  • Updated DynaPDF to version 4.0.66.180.

New in MBS FileMaker Plugin 12.2 Pre-release 2 (Apr 13, 2022)

  • Updated openssl to version 1.1.1n.
  • Improved CURL.SetProgressScript to not fire too often.
  • Improved WebHook functions to work better with mixed IPv4 and IPv6 networks.
  • Fixed WebView.ClearSelection to work with Edge based WebViewer on Windows.
  • DynaPDF has been updated and tested to work with ZUGFeRD 2.2 / Factur-X 1.0.06.

New in MBS FileMaker Plugin 12.1 (Mar 23, 2022)

  • WebHook
  • We already introduced the new WebHook component in the release 11.5. In the new release we provide a few new functions that should make your work with WebHooks easier. With the function WebHook.SetMaximumRequestSize we set the maximum allowed request size. This allows you to disconnect sockets, which send too much data. By default there is no limit, so people can send requests with several gigabytes of payload. Depending on your use can it may be worth to limit request size to a reasonable value. For example if you receive notifications from your phone system, you may set the maximum size to 10000 bytes and a timeout of 60 seconds for WebHook.SetTimeOut function. That is probably 10 times more than needed, but may avoid some malicious user from sending a ton of useless traffic. Matching to this there is the WebHook.GetMaximumRequestSize function which queries this set value if needed. We can also get the size of a certain web request. WebRequest.GetSize returns the total size of the request. The WebRequest.GetBodySize function then gives us the size of the body.
  • WebView:
  • When you use custom web viewer with our plugin, you may run into the situation, that FileMaker rebuilds the layout (e.g. after changing a value list). But sometimes you want to prove if it was really rebuild or you must do it by your own. For that situation we got the function WebView.HasParent. It checks whether the WebView has a parent control. If this function return 0, you know the layout was rebuild and the custom web viewer is no longer visible. Otherway you can rebuild it. So when you have a script triggered by user going to new layout, you can check the status of web viewer and if needed rebuild it. Or change workflows, so if user needs to change a value list, they may need to open a card window then reach the edit dialog and when they click back button to close card, you can recreate the web viewer and load the content again.
  • Math:
  • You want to calculate with FileMaker? Then I can recommend the new math functions. Calculate now the average, the maximum, minimum, the median, Sum, Standard Deviation and the Reciprocal with different numbers from a List. In the appropriate functions, you can specify a list of values that will be processed in the functions. Depending on the function, a single value or again a list is returned. With the function Math.Multiply we also have a function that can multiply the values of a list with a fixed value or with the entries of a second list. In the following example you can see the output of the functions for the always same list
  • Audit:
  • For the Audit area we have the new function Audit.Statistics. It queries statistics for Audit as JSON. You get the number of calls, fields and records, but also for the different error types like insert error or field type errors. If all things run normally the error counts are all zero. Additional we have the schema informations, how often we query the schema for tables, the schema for fields or related schema queries.
  • Files:
  • With the new Files.AudioCoverArt function we can query the cover image of a file. You can retrieve the cover of MP3, MP4 and FLAC files. As return you will get an image as container value in JPEG, PNG, GIF or BMP format. The image format depends on which image is stored in the cover information. In the parameters of the function you can specify the file path where the file is located from which you want to retrieve the cover. Please note that the path must be a native path. If we have the file only as a FileMaker path, it can be easily converted with the Path.FileMakerPathToNativePath function.
  • Dictionary:
  • We also have a new cool function in the Dictionary component. With the new Dictionary.Lookup function we query a value from the dictionary. If the key doesn't exist in the dictionary, we return the given default value instead of an error.
  • Plugin:
  • The new function Plugin.GetFunctionParameters helps you if you need more information about the parameters of a plugin function. It gives you the metadata for the parameter list. In the function you can specify the function name and get a list of all parameter names.
  • Text:
  • Sometimes you just have to look at things the other way around. The Text.Reverse function helps you to do this by writing a text from the bottom to the front, in other words, it completely reverses the order of the letters.
  • DynaPDF:
  • There is also news from the Dyna PDF area. With the new function DynaPDF.SetSpaceWidthFactor you can now set the space width factor. The space width factor is used by DynaPDF.ExtractText to determine whether the distance between two text records or glyphs should be interpreted as space character. PDF files do often not contain space characters. Depending on the font type, i.e. fixed pitch or proportional fonts, different default widths are used during text extraction. However, the full space width is mostly too large to find spaces. Therefore, the text extraction algorithm multiplies the default space width with the space width factor to find suitable values.

New in MBS FileMaker Plugin 12.1 Pre-release 7 (Mar 11, 2022)

  • Changed Archive functions to enable UTF-8 support by default, so asian characters work well.
  • Updated SQLAPI to version 5.1.9.
  • Fixed CURL.OpenInputFile to stream files over 1 GB again.
  • Fixed an issue in WebHook.Listen not working on Windows.
  • Fixed a memory leak on Windows for WebHook functions.

New in MBS FileMaker Plugin 12.1 Pre-release 6 (Mar 8, 2022)

  • Added Audit.Statistics function.
  • Added Dialog.SetTextAlignment and Dialog.GetTextAlignment functions to use left text alignment for dialogs on macOS.
  • Added proper error messages for sockets on Windows.
  • Fixed a problem with tunnel in SSH functions, where SSH.Tunnel.Cancel didn't end the tunnel quickly in some cases.
  • Fixed a problem with XML.Query, where the first only flag was not handled correctly.
  • Updated CURL to version 7.82.0.
  • Updated Method-Draw example to newer version, so it works in FileMaker 19.4 on Windows.

New in MBS FileMaker Plugin 12.1 Pre-release 2 (Feb 8, 2022)

  • Added WinPhotoAcquire functions.
  • Rewrote Text.RemoveControlCharacters, Text.ConvertUnicodeToCharacterDecomposition and Text.ConvertUnicodeToCharacterComposition functions to preserve text styles.
  • Fixed an issue with SQLAPI with a crash in SAMutex class on thread synchronization on macOS, iOS and Linux.
  • Changed Menu functions for Windows to make more room to show full text of menuitem when using different font sizes.
  • Fixed bugs in Audit.Changed when using repetition fields.
  • Fixed an issue with auto completing $~ variables.
  • Added new flag for XML.ToJSON to include namespaces.

New in MBS FileMaker Plugin 12.0 (Jan 18, 2022)

  • Added tools to add/remove table occurrence prefixes in calculations.
  • Added AVRecorder.VideoResolutions function for Windows.
  • Added DynaPDF.ActivateAltFontList, DynaPDF.CreateAltFontList, DynaPDF.DeleteAltFontList and DynaPDF.SetAltFonts functions.
  • Added Events.Event.BirthdayContactIdentifier and deprecated older Events.Event.BirthdayPersonUniqueID.
  • Added Files.IsExcludedFromBackup, Files.IsFileExtensionHidden, Files.SetExcludedFromBackup and Files.SetFileExtensionHidden functions.
  • Added FM.ExecuteFileSQLValue function.
  • Added FM.ValueListIDForValueListName, FM.ValueListNameForValueListID and FM.ValueListNames functions.
  • Added new parameters for AVRecorder.SetVideoDevice function to pick desired width and height of resolution.
  • Added Offset and Length parameters to CURL.SetInputFile, CURL.SetInputGIF, CURL.SetInputJPEG, CURL.SetInputPDF and CURL.SetInputPNG to only upload a portion of the container.
  • Added option to show IDs for value list.
  • Added Preferences.List function.
  • Added ProgressDialog.SetPositionWindowCentered function.
  • Added SQL.GetFieldAsNumber, SQL.GetParamAsNumber and SQL.SetParamAsNumber to better handle numeric values.
  • Added subscript and superscript to Text.TextToHTML function.
  • Added support for tab character in text replacements with WordFile functions.
  • Added SyntaxColoring.AutoCompleteVariables.GetEnabled and SyntaxColoring.AutoCompleteVariables.SetEnabled functions.
  • Added SyntaxColoring.GetShowValueListIDs and SyntaxColoring.SetShowValueListIDs functions.
  • Added WebHook.GetTimeOut and WebHook.SetTimeOut functions.
  • Added WebRequest.GetState function.
  • Added workaround for Files.MoveFile and Files.CopyFile when it fails with MAX_PATH error.
  • Changed default comment color in scripts to dark green instead of black. Feel free to adjust with SyntaxColoring.AddTag if you prefer other colors.
  • Changed DynaPDF.SetFont, DynaPDF.Table.SetFont, DynaPDF.SetFontEx, DynaPDF.ChangeFontEx, DynaPDF.SetFieldFont and DynaPDF.SetBookmarkStyle functions to accept styles as text.
  • Changed how we handles numbers in SQL functions to better handle numeric values and avoid conversion of numeric to floating pointer numbers.
  • Changed license checks to make another 500 plugin functions to not check license status. Currently only 4900 of over 6600 functions do that. Even if this is quick, not doing it everywhere could speed up some processing.
  • Changed object management to log warning if you have more than 100 objects allocated. This may point to an issue in your scripts not releasing objects.
  • Changed relationship search field to be smaller.
  • Changed showing of invisible characters in calculations to show more hidden characters like BOM character (Command-I in calculation to enable).
  • Changed variable check to find multiple variables in a comment separated by space or tab.
  • Changed variable coloring and checks to allow exclamation mark in variable names.
  • Changed XML parsing to explicit disable network access.
  • Changed XML.Query to remove surrounding quotes for namespaces.
  • Deprecated MenuItem.GetSelectable and MenuItem.SetSelectable since they don't work properly anymore on current macOS versions.
  • Deprecated SNMP functions in favor of running them via shell functions.
  • Documented missing color space handle parameter for DynaPDF.Table.SetColorFloat function.
  • Enhanced Clipboard.DetectFileMakerDataType and Clipboard.SetFileMakerData to recognize script folders.
  • Fixed a case where @param comments where not found with several spaces before the variable name.
  • Fixed a potential problem in SQL.InsertOrUpdateRecords function where it could crash with too many primary keys.
  • Fixed a problem in CURL.GetHeaderAsJSON introduced in v11.5.
  • Fixed a problem in email parser, which didn't get multi part right on Linux for EmailParser.Parse, EmailParser.ParseContainer and EmailParser.ParseFile.
  • Fixed a problem where context menu would crash if the plugin was updated via script.
  • Fixed a problem with WinSendMail.AddBCC, WinSendMail.AddCC, WinSendMail.AddRecipient, WinSendMail.AddTo not passing email when name is empty.
  • Fixed an edge case for syntax coloring with block comments to color the full comment.
  • Fixed Container.ReadFile to read empty files.
  • Fixed handling of PageNumber field for Audit.Changed functions.
  • Fixed issue with calendar item function, where a newly created event wouldn't be know on next function call if the calendar database reported change.
  • Fixed JSON functions to return NULL for numbers with no content, e.g. empty text. This affects JSON.CreateNumber, Dictionary.ToJSON, FM.SQL.JSONColumn, FM.SQL.JSONRecord and FM.SQL.JSONRecords functions.
  • Fixed Path.FileMakerPathToNativePath to recognise filelinux: prefix.
  • Fixed problem in WebView.AllCookies with NULL values.
  • Fixed problem where plugin would unnecessarily complain about mutex problem on server.
  • Fixed problem with Linux for Shell functions where you could get an error: "A NULL argv[0] was passed through an exec system call." message.
  • Fixed SyntaxColoring to colorize calculations starting with $ variable.
  • Fixed value list IDs to work for Japanese, too.
  • Redesigned our calculation dialog buttons to be a segmented control.
  • Updated archive library to version 3.5.2.
  • Updated cpuid library to version 0.51.
  • Updated CURL to version 7.81.0.
  • Updated DynaPDF to version 4.0.65.167.
  • Updated expat library to version 2.4.1.
  • Updated LCMS library to version 2.13rc1.
  • Updated lz4 library to version 1.9.3.
  • Updated openssl to version 1.1.1l.
  • Updated SQLAPI to version 5.1.8.
  • Updated SQLite to version 3.37.0.
  • Updated ssh2 library to version 1.10.0.
  • Updated SystemInfo.CPUBrandString to work on Apple Silicon.
  • Updated LibXL to version 4.0.1.

New in MBS FileMaker Plugin 11.6 Prerelease 4 (Dec 22, 2021)

  • Added ProgressDialog.SetPositionWindowCentered function.
  • Fixed a problem with WinSendMail.AddBCC, WinSendMail.AddCC, WinSendMail.AddRecipient, WinSendMail.AddTo not passing email when name is empty.
  • Improved auto complete to better allow you type other variable names.
  • Added WebRequest.GetState function.
  • Fixed problem with Linux for Shell functions where you could get an error: "A NULL argv[0] was passed through an exec system call." message.
  • Changed license checks to make another 500 plugin functions to not check license status. Currently only 4900 of over 6600 functions do that. Even if this is quick, not doing it everywhere could speed up some processing.
  • Fixed problem in WebView.AllCookies with NULL values.
  • Added workaround for Files.MoveFile and Files.CopyFile when it fails with MAX_PATH error.
  • Fixed handling of PageNumber field for Audit.Changed functions.
  • Deprecated SNMP functions in favor of running them via shell functions.

New in MBS FileMaker Plugin 11.6 Prerelease 1 (Dec 2, 2021)

  • Added SQL.GetFieldAsNumber, SQL.GetParamAsNumber and SQL.SetParamAsNumber to better handle numeric values.
  • Changed how we handles numbers in SQL functions to better handle numeric values and avoid conversion of numeric to floating pointer numbers.
  • Changed variable coloring and checks to allow exclamation mark in variable names.
  • Changed XML parsing to explicit disable network access.
  • Fixed a case where @param comments where not found with several spaces before the variable name.
  • Fixed a problem in CURL.GetHeaderAsJSON introduced in v11.5.
  • Fixed an edge case for syntax coloring with block comments to color the full comment.
  • Fixed Container.ReadFile to read empty files.
  • Fixed SyntaxColoring to colorize calculations starting with $ variable.
  • Updated archive library to version 3.5.2.
  • Updated cpuid library to version 0.51.
  • Updated curl to version 7.80.0.
  • Updated expat library to version 2.4.1.
  • Updated lz4 library to version 1.9.3.
  • Updated openssl to version 1.1.1l.
  • Updated ssh2 library to version 1.10.0.
  • Updated SystemInfo.CPUBrandString to work on Apple Silicon.
  • Fixed a potential problem in SQL.InsertOrUpdateRecords function where it could crash with too many primary keys.

New in MBS FileMaker Plugin 11.5 (Nov 16, 2021)

  • Implemented WebView functions for WebView2 control on Windows.
  • Added new WebHook functions.
  • Added DynaPDF.AddButtonImageEx2 function.
  • Added DynaPDF.CreateOCG function.
  • Added DynaPDF.GetInPDFVersionEx function.
  • Added DynaPDF.GetPDFVersionEx function.
  • Added DynaPDF.Print.FormNames function to get list of form names for printer on Windows.
  • Added FixedTextHeight flag for DynaPDF.Table.SetFlags function.
  • Added Float 16bit support for CoreML functions.
  • Added fraudulentWebsiteWarningEnabled and textInteractionEnabled settings for WebView.GetPreferences and WebView.SetPreferences functions.
  • Added MapView.CoordinateForPoint and MapView.PointForCoordinate functions.
  • Added new fields FmtTextColor and FmtText for DynaPDF.GetField and DynaPDF.GetFieldsAsJSON.
  • Added option for SyntaxColoring.AddTag to add formula wildcard tags to color specific words.
  • Added RemoteControl.MouseButtons function.
  • Added row number into tooltips for export dialog.
  • Added StartIndex parameter to JSON.FindValueInArray and JSON.FindValueInObjectArray functions, so you can repeat search until nothing more is found.
  • Added Text.Concat and Text.List functions.
  • Added WebView.CallFunction for MacOS and iOS.
  • Added WebView.SetDrawsBackground to make WebViewer transparent on MacOS and iOS.
  • Added WebView.ShowDevTools function.
  • Added wildcards for Plugin.SetFunctions functions.
  • Added XL.Sheet.AutoFilter.AddSort and XL.Sheet.IsAutoFilter functions.
  • Added XL.Sheet.CellReadValues function.
  • Added XL.Sheet.GetCellPicture function.
  • Added XML.ApplyStylesheet2 function.
  • Added XML.ItemRefs function.
  • Changed DynaPDF.ConvertStyledText to pass fonts as family names.
  • Changed implementation for HotKey functions for local hotkeys on macOS. Now hotkey set with HotKey.SetLocal to 1 will now process only within FileMaker and no longer block shortcuts in other applications.
  • Changed our function name check to validate prefix/postfix of function name independently.
  • Changed Plugin.SetPreviewSize to allow -1 for preview picture size to disable them.
  • Changed search for relationship graph to load suggestions when you click on the search field to make opening the dialog quicker.
  • Changed syntax colorization to detect first word in a comment in color and change color just like we do for scripts.
  • Deprecated ServerSocket functions in favor of new WebHook functions.
  • Fixed a bug in JSON.ToHTML function.
  • Fixed a crash in PDFKit.Combine function.
  • Fixed a problem in JSON.Colorize function with coloring arrays.
  • Fixed a problem with decimal data type for Firebird in our SQL functions.
  • Fixed a problem with email parser not separating plain text for attached email correctly.
  • Fixed a problem with PDFKit.SetPrintOption not setting value correctly.
  • Fixed a problem with removeObserver for macOS Monterey.
  • Fixed a problem with variable checking not parsing a comment correctly with a variable declaration.
  • Fixed an edge case for WordFile.Substitute not working correctly for text near the end of the document.
  • Fixed an issue with Archive.FileList function not picking up file names on Windows due to text encoding issue.
  • Fixed an issue with duplicate plugin warning on macOS.
  • Fixed bug in Notification.UnlistenAll not properly releasing all objects.
  • Fixed bug in WebView.PrintToFile and WebView.Print functions to make it work for WebKit 2.
  • Fixed crash in Clipboard.SetFileMakerData function.
  • Fixed documentation for DynaPDF.SaveAndSignFileExt and added missing ContactInfo parameter.
  • Fixed error message reporting problem for XML.ApplyStylesheet function.
  • Fixed Files.ListAsJSON to query date and size of a symlink instead of the target.
  • Fixed problem in DynaPDF.BeginLayer.
  • Fixed RepeatSeconds parameter in Schedule.StartScriptAtTime, Schedule.EvaluateAtTime and Schedule.ExecuteSQLAtTime function.
  • Improved DynaPDF.Print.SetSetting to make it work better.
  • Improved error message for out of bounds error when there are no elements.
  • Improved error messages when running JavaScript on macOS and iOS with WebView.Evaluate (and similar) to return the JavaScript exception message.
  • Optimized performance for showing script IDs for solutions with folders.
  • Removed field picker feature, which is no longer needed.
  • Updated CURL library to version 7.79.1.
  • Updated DynaPDF to version 4.0.63.161.
  • Updated LibXL to version 4.0.
  • Updated SQLAPI to version 5.1.7.
  • Updated Xcode to version 13.1.

New in MBS FileMaker Plugin 11.4 (Sep 7, 2021)

  • Added Container.Screenshot function, which may replace WebView.Screenshot for some users.
  • Added Dictionary.KeysWithPostfix and Dictionary.KeysWithPrefix functions.
  • Added DynaPDF.GetInIsTaggedPDF function.
  • Added DynaPDF.Print.GetSetting and DynaPDF.Print.SetSetting functions.
  • Added error message when tracing script calls and logging errors.
  • Added FM.CF.Parameter function.
  • Added HEAD as verb for CURL.SetupAWS and CURL.SetupOAuth functions.
  • Added password parameter for DynaPDF.GeneratePreview function.
  • Added password parameter for PKey.Read function to read encrypted private keys.
  • Added PKey.Read, PKey.ReadFromContainer and PKey.ReadFromFile functions.
  • Added PList functions for macOS and iOS.
  • Added possibility to use backslash in XML.GetPathValue to mask dots in xml node names.
  • Added question mark for valid variable name characters for our variable name check in script workspace.
  • Added SendMail.Sign function to send S/MIME signed emails.
  • Added SharingPanel functions for iOS.
  • Added SQL.FieldExists function.
  • Added SyntaxColoring.DontOpenManageDatabaseDialogWithRelations.SetEnabled and SyntaxColoring.DontOpenManageDatabaseDialogWithRelations.GetEnabled functions.
  • Added SystemInfo.isWindows11 function.
  • Added thread pool for Windows for multithreaded functions like CURL.PerformInBackground.
  • Added WordFile.Contains and WordFile.Substitute functions.
  • Added WordFile.WriteContainer function.
  • Changed SendMail functions to cache email source and not render it again each time you query it. And clear it when you change a property of the email.
  • Changed text position display for variable dialog to not show text position if window is too small.
  • Changed CURL to use http as default protocol.
  • Changed XML.SetVariables to assign XML block if item is a xml tree and not recursive.
  • Deprecated DynaPDF.ExtractImages and DynaPDF.ListImages in favor of DynaPDF.GetImage function.
  • Fixed a crash with PDFKit.Combine function.
  • Fixed a case where removing a table row with WordFile.RemoveTableRow function would not be saved.
  • Fixed a crash in JSON.GetObjectItem with big JSON arrays.
  • Fixed a problem with menu functions on macOS not showing diamond or bullet checkmarks.
  • Fixed a problem with menu functions on Windows to better measure space needed.
  • Fixed an issue with CURL.SetupAWS doing an unneeded lower case for the query parameter name.
  • Fixed an issue with XML.Import not parsing huge XML files with big text nodes correctly.
  • Fixed DynaPDF.AddFontSearchPath to return no error, but zero, when no fonts are found.
  • Fixed problem in PDFKit.GetPDFAttribute returning an error when no keywords are available.
  • Fixed problem in Twain.Acquire to fail better if we can't open the data source.
  • Fixed problem on Windows with GraphicsMagick initialization.
  • Fixed problem with menu functions on Windows not drawing disabled menu entries in gray when using font styles.
  • Implemented Screen.Count for iOS.
  • Improved Dictionary.SetVariables to not allow invalid variable names.
  • Improved threading for DynaPDF.Print functions to store settings per thread to avoid potential threading issues.
  • Updated CURL library to version 7.78.0.
  • Updated DynaPDF to version 4.0.58.153.
  • Updated SQLAPI to version 5.1.5.

New in MBS FileMaker Plugin 11.3 (Jul 12, 2021)

  • Added zbar library support to better detect barcodes with Barcode.LoadLibrary and Barcode.Scan functions.
  • Added OCR.Load and OCR.IsLoaded functions to use Tesseract 4.x for text recognition.
  • Added App.PlaySystemSound function.
  • Added Archive.GZipDecompress function.
  • Added Barcode.Loaded and Barcode.ZBarVersion function.
  • Added CURL.AWSPresignURL function.
  • Added CURL.SetOptionCAInfoBlob and CURL.SetOptionProxyCAInfoBlob functions.
  • Added DynaPDF.ChangeOCGName and DynaPDF.DeleteNamedDest function.
  • Added flag 16 for XML.Query to only return first item of result.
  • Added flag 32 for XML.Query to return multiple XML nodes as a list with each as XML.
  • Added FM.CF function to run custom functions defined in a database table and managed via Dictionary functions.
  • Added FM.ErrorMessage function.
  • Added JS.CF and example database for custom functions with JavaScript.
  • Added JS.List and JS.CallFunctionValues function.
  • Added List.GetColumn and QuickList.GetColumn functions to extract a column from a list.
  • Added List.MapEntries function.
  • Added OCR.SetImageContainer and OCR.SetImageFile functions to directly feed image files (and containers).
  • Added OCR.Version function to query Tesseract version.
  • Added OuterBorderTop, OuterBorderLeft, OuterBorderRight and OuterBorderBottom for DynaPDF.GetDefaultBarcodeParameters and DynaPDF.InsertBarcode functions.
  • Added PageSetupDialog.SetPaperHeight and PageSetupDialog.SetPaperWidth to define custom paper sizes.
  • Added parameter for JS.New function to define the identifier used for the new instance.
  • Added QLPreviewPanel.SetSharingAllowed and QLPreviewPanel.GetSharingAllowed functions.
  • Added recursion limit for FM.CF with 50000 as limit, but after about 200 deep FileMaker will report running out of memory.
  • Added SystemInfo.IsLowPowerModeEnabled function.
  • Added SystemInfo.isMonterey function.
  • Added Text.FromStyles function.
  • Added Text.RTFToText function.
  • Added WebView.GetUsePrivateBrowsing and WebView.SetUsePrivateBrowsing functions to enable private browsing in Web Viewers for FileMaker 16 to 19.x on macOS.
  • Changed CURL to fail if your URL does not contain a protocol specification.
  • Changed DynaPDF.GetDefaultBarcodeParameters and DynaPDF.InsertBarcode to work with older and newer DynaPDF libraries.
  • Changed Icon.GetIcon, Icon.SetIcon and Icon.GetIconWithQuickLook functions to better handle memory management on macOS.
  • Changed Java.Initialize to not to try to load JavaVM.framework, which results in a crash on Big Sur.
  • Changed JS.CallFunction and JS.SetGlobalProperty to not return an error for invalid JSON, but just take it as text for your convenience.
  • Changed JSON.GetObjectItemTree, JSON.GetObjectItemTreeRef, JSON.AddArrayToArray and JSON.AddItemToArray to ignore empty parameters.
  • Changed JSON.Import and XML.Import to be per thread, so they work better on server with multiple parallel scripts.
  • Changed LDAP.Search to hex encode UUID/GUID entries with 16 raw bytes.
  • Changed web viewer made with WebView.Create using WebKit 1 to output alert() as log messages to Console.app.
  • Fixed a memory leak in Container.ReadFile function when used on server and FileMaker creates a PDF preview.
  • Fixed a memory leak in DynaPDF.New function.
  • Fixed a problem on Windows server if it is not installed in C: drive.
  • Fixed a problem with a math function, which affected time zone calculation for EmailParser.SentDate, EmailParser.ReceiveDate and Time.TimeStampToUTC functions (broken in v11.2).
  • Fixed an issue with PDFKit.Combine called with multiple containers.
  • Fixed error message of Text.ConvertFromTextEncoding or Text.ConvertToTextEncoding functions.
  • Fixed Text.RemoveAccents to not uppercase all characters, broken in v11.2.
  • Fixed WebView.CopyFormattedText for Windows to return OK on success.
  • Formalized the functions taking variable parameters.
  • Implemented Clipboard.GetStyledText and Clipboard.SetStyledText for Windows.
  • Implemented TextView.GetSelectedStyledText, TextView.SetSelectedStyledText, TextView.GetStyledText and TextView.SetStyledText for Windows.
  • Improved AVRecorder.AudioDeviceInfo, AVRecorder.SetAudioDevice, AVRecorder.SetVideoDevice and AVRecorder.VideoDeviceInfo to query device list automatically.
  • Improved our script search field. Press return to search the script for the next line matching. Can take long for huge scripts and beeps when nothing is found, but wraps automatically.
  • Improved performance for DynaPDF.Release to be faster.
  • Improved Screenshot function to allow to capture other screens on Windows.
  • Removed debug messages from libidn loading.
  • Removed text size limit for SyntaxColoring.Format function.
  • Updated curl library to version 7.77.0.
  • Updated DynaPDF to version 4.0.54.148.
  • Updated openssl library to version 1.1.1k.
  • Updated SQLite to version 3.36.0.
  • Updated Vision.DetectBarcode and Vision.SupportedSymbologies to support newer barcode types in macOS 12.
  • Updated Xcode to version 12.5.1.

New in MBS FileMaker Plugin 11.2 (May 18, 2021)

  • Added Apple Silicon for macOS version of the plugin.
  • Added a lot of tooltips for preferences dialog to explain further the options.
  • Added backslash as escape character for Menu.DefineQuickMenu function.
  • Added checks to make sure GraphicsMagick resource limits are not too small to create a picture.
  • Added code to use ICU libraries for SQLite. See SQL.InternalSQLiteLibrary.ICUEnabled, SQL.InternalSQLiteLibrary.ICULoaded, SQL.InternalSQLiteLibrary.ICUUsed and SQL.InternalSQLiteLibrary.SetICUEnabled functions.
  • Added Container.ReadImageFile function.
  • Added CURL.GetReferer, CURL.SetOptionDOHSSLVerifyHost, CURL.SetOptionDOHSSLVerifyPeer and CURL.SetOptionDOHSSLVerifyStatus functions.
  • Added Debugger.IsDataViewerVisible function.
  • Added DefaultNormalize, DefaultPDFA1, DefaultPDFA2, DefaultPDFA3 flags to DynaPDF.CheckConformance function.
  • Added DynaPDF.ChangeFontEx function.
  • Added EndOfLine parameter for ScriptWorkspace.ScriptText function.
  • Added Events.DelegateSources function for iOS.
  • Added flag 4 for FM.SQL.JSONRecords and FM.SQL.JSONRecord to return result as array of arrays instead of array of objects.
  • Added FM.InsertOrUpdateRecord4 and FM.InsertOrUpdateRecord5.
  • Added JS.InitModules function.
  • Added ListDialog.SetColumnAlignment and ListDialog.GetColumnAlignment functions.
  • Added ListDialog.SetColumnWidth and ListDialog.GetColumnWidth functions.
  • Added milliseconds for SQL.ConvertDateTimeFromSQL and SQL.ConvertDateTimeToSQL functions.
  • Added milliseconds for timestamps in JS.TimeToUTCDate and JS.UTCDateToTime functions.
  • Added milliseconds for timestamps in several functions returning NSDate, e.g. Files.CreationDate.
  • Added milliseconds for timestamps in XL functions.
  • Added new flags for XML.ToJSON to detect numbers and booleans better.
  • Added option-key check for when you open variable/field definition window to directly jump into the calculation dialog.
  • Added optional ContentTypeMethod parameter for SendMail.AddAttachmentContainer, SendMail.AddAttachmentFile and SendMail.AddAttachmentText functions.
  • Added Process.List function for macOS and Windows.
  • Added RemoteControl.GetWindowsListAsJSON function.
  • Added SQL.ConvertDateTimeFromSQL and SQL.ConvertDateTimeToSQL functions.
  • Added strikethrough as attribute recognized by Text.TextToHTML function.
  • Added SystemInfo.LinuxSystemInfo function.
  • Added SystemInfo.WindowsMachineInfo function.
  • Added SystemInfo.WindowsSystemInfo function.
  • Added Time.Wait function.
  • Added trace logging for DynaPDF progress for import, convert, write and print.
  • Added Trace.IsEnabled and Trace.IsPaused functions.
  • Added Trace.Path function.
  • Added Trace.Pause and Trace.Resume functions.
  • Added workaround for error 561 in Barcode.Generate. We lower ECC level now if text doesn't fit otherwise.
  • Added XL.Book.AddFontFromBook and XL.Book.AddFormatFromBook functions.
  • Added XL.CopyCellValue function.
  • Added XL.Sheet.SetRows function.
  • Changed a couple of internal text functions to recognize that text with UTF-8 as a BOM for UTF-16 or UTF-32 and then reinterpret bytes to handle that. Useful for Shell.ReadOutputText, when a command line tool outputs UTF-16 instead of expected UTF-8.
  • Changed CURL functions to not print password for SFTP transfer in debug log. Left overs from debug session in 11.1 betas.
  • Changed FM.InsertRecordCSV and FM.InsertRecordTSV to recognize backslash escapes to have returns and tabs escaped in text.
  • Changed JSON.Parse to be accept leading zeros on numbers.
  • Changed OCR functions to separate different threads on server better.
  • Changed our buttons for Data Viewer to hide if we can't evaluate as no file may be open.
  • Changed plugin on Server to log StdOut and StdErr to log files for Windows and MacOS, as we did before on Linux.
  • Changed search box for Script Workspace to consume double clicks to avoid resizing window.
  • Changed SQL errors to add field name for SQL update statements for type mismatch errors.
  • Changed Trace function to create log file, which is readable by other applications like a good text editor.
  • Changed trace output for audit to show field name audited.
  • Changed XL.Initialize to accept empty path and pick the file name automatically per platform.
  • Deprecated DragDrop.CreateWithWindow in favor of DragDrop.AttachToWindow function.
  • Deprecated GMImage.SetCacheThreshold function.
  • Deprecated Toolbar.InstallBackground function.
  • Deprecated Window.ResizeContentView, Window.GetTitlebarAppearsTransparent and Window.SetTitlebarAppearsTransparent functions.
  • Deprecated Window.ShowScrollbars function.
  • Enabled math and geopoly functions for internal SQLite library. see SQL.InternalSQLiteLibrary.Activate
  • Fixed a problem in CURL with CURL.SetOptionSSLKeyBlob function not working correctly.
  • Fixed a problem with cursor being repositioned by our syntax highlighting in set variable dialog.
  • Fixed a problem with menu functions on Windows with alignment of text relative to picture next to it.
  • Fixed an issue with Big Sur where Script Workspace didn't show title bar text.
  • Fixed an issue with DynaPDF.Optimize complaining about no open output file.
  • Fixed Archive functions to do AES256 encryption on Windows.
  • Fixed DynaPDF.GetFieldsAsJSON function to produce better JSON.
  • Fixed DynaPDF.SetFieldName to allow to specify field to rename by name.
  • Fixed error handling in JavaScript functions, broken in v11.1.
  • Fixed Files.DiskInfo for Linux.
  • Fixed Files.FileName and Files.FileNameWithoutExtension to work on macOS in case you pass Windows path.
  • Fixed GMImage.AveragePixelValue to run with only 2 parameters.
  • Fixed JSON.Format to not return reference number for JSON reference numbers as input, broken in 11.1.
  • Fixed preferences dialog to show the checkmark for Bracket Highlighting correctly.
  • Fixed problem of Window functions on Windows not finding them.
  • Fixed problem on Windows with AVRecorder.AddPreviewWithControl and AVRecorder.AddPreviewToWindow not using the FileMaker window, but a separate one.
  • Fixed problem with StoreRegistration function on Linux server.
  • Fixed problem with XML.ExtractText and XML.GetPathValue not seeing all text if there are XML nodes within a text block.
  • Fixed Shell functions for Windows to allow PowerShell.exe to run.
  • Fixed trace logging for DynaPDF to work on Windows with UTF-16 trace file properly.
  • Fixed WebView.SetFocus for iOS.
  • Improved custom function test case execution to be a bit more flexible with spacing in parameter declaration.
  • Improved memory usage of Container.ReadImage, PDFKit.GeneratePreview and PDFKit.GetPDFPageImage functions, especially for server.
  • Improved ProgressDialog functions for Big Sur to show indeterminate progress bar again.
  • Improved XML functions (on Windows) to better handle unknown encodings.
  • Optimized UUID.FromNumber and UUID.ToNumber to be a bit quicker.
  • Patched SQLAPI to parse timestamps with fraction better.
  • Removed empty lines for RemoteControl.GetWindowsList function.
  • Updated CURL library to version 7.76.1.
  • Updated DLL linking for Windows to direct link functions requiring Windows 7.
  • Updated DNS functions for Windows.
  • Updated DynaPDF to version 4.0.52.146.
  • Updated Linux 64-bit build machine to Ubuntu 18.04. Plugin still compatible to Ubuntu 16 and CentOS 7.7.
  • Updated SQLAPI to version 5.1.4 with new DuckDB support.
  • Updated zxing library to get a few newer bug fixes for Barcode.Detect function.

New in MBS FileMaker Plugin 11.1 (Mar 9, 2021)

  • Added IBAN functions to validate or calculate checksums.
  • Added RegEx.DataDetector function.
  • Added RegEx.Extract function.
  • Added buttons for custom function dialog and to various calculation dialogs to check syntax or execute a test case.
  • Added App.Exit to quit current FileMaker process. Allows to restart server scripting engine.
  • Added Archive.CompressContainer function.
  • Added Barcode.Modulo10Checksum function.
  • Added checkbox for variable check in debugger to preferences dialog.
  • Added CoreLocation.requestLocation for macOS 10.14 or newer.
  • Added CoreLocation.requestTemporaryFullAccuracyAuthorization function for iOS.
  • Added CoreLocation.requestWhenInUseAuthorization, CoreLocation.startUpdatingHeading and CoreLocation.dismissHeadingCalibrationDisplay for macOS 10.15 or newer.
  • Added Dictionary.AddDictionary and Dictionary.FromJSON functions.
  • Added DynaPDF.Table.SetCellStyledText function.
  • Added emojis to the documentation to clearer show what items are supported for each platform.
  • Added extra line to CURL debug log to indicate the version of MBS FileMaker Plugin, CURL library used and what OS is used and FileMaker application. See CURL.CreateDebugOutputFile and CURL.GetDebugAsText functions.
  • Added Files.FileNameWithoutExtension function.
  • Added FillColor and FillColorSpace options for DynaPDF.GetImage function.
  • Added functions for iOS applications to catch URL requests: iOSApp.InstallOpenURLHandler, iOSApp.LastURL, iOSApp.SetDidOpenURLEvaluate and iOSApp.SetDidOpenURLScript.
  • Added GMImage.SetLogEventMask and GMImage.IsLoggingEnabled functions.
  • Added List.Find and QuickList.Find functions.
  • Added Math.FormatNumber function.
  • Added Math.NormInv function.
  • Added new socket functions to set send/receive buffer size: Socket.GetReceiveBufferSize, Socket.GetSendBufferSize, Socket.SetReceiveBufferSize, Socket.SetSendBufferSize.
  • Added option to have links to functions generated as Dash links.
  • Added PageSize setting for PDFKit.SetPrintSetting and PDFKit.GetPrintSetting functions.
  • Added Plugin.PrepareForUpdate function.
  • Added QLPreviewPanel.GetEditingAllowed, QLPreviewPanel.SavedFiles, QLPreviewPanel.SetDismissTrigger and QLPreviewPanel.SetEditingAllowed functions to use markup editing of documents on iOS.
  • Added Speech.Stop function.
  • Added superscript and subscript support DynaPDF.ConvertStyledText and related functions.
  • Added SyntaxColoring.GetCustomFunctionToolsEnabled and SyntaxColoring.SetCustomFunctionToolsEnabled functions.
  • Added SyntaxColoring.GetFormulasWithDashLinks and SyntaxColoring.SetFormulasWithDashLinks functions.
  • Added SyntaxColoring.SetDebuggerTooltipsEnabled and SyntaxColoring.GetDebuggerTooltipsEnabled functions to configure the new debugger tooltip feature.
  • Added timeout for loop/if check to exit after 10 ms to avoid longer delays.
  • Added Windows support for PKCS12.ShowDialog and X509.ShowDialog functions.
  • Added Windows support for WebView.StopLoading function.
  • Added XML.SetPathCData function.
  • Applied SQLAPI patch for SQL Server precision for number types (Int64 vs. Numeric).
  • Changed color for MBS function in Dark Mode to be a lighter blue.
  • Changed DragDrop.RegisterDropTypes to use a better set of image pasteboard types to catch HEIF, too.
  • Changed Script ID column for Script Workspace to be a few pixel wider.
  • Changed ScriptWorkspace.OpenScript to remove search string for script search if script is not found.
  • Changed variable check to disable for Script Workspace windows in the background.
  • DynaPDF works with ZUGFeRD 2.1.1.
  • Fixed a problem with a crash in CURL with SFTP with empty password or username.
  • Fixed a text encoding problem with our built-in default rules for SyntaxColoring.FactoryDefaults, so they work better with asian languages.
  • Fixed alpha channel handling for passing colors to GraphicsMagick functions.
  • Fixed an issue where DragDrop.CreateWithControl and similar function would not position correctly if Dock is on the left side of the screen.
  • Fixed an issue with searching umlauts with filter in ListDialog functions.
  • Fixed bug in DynaPDF.SaveAndSignFileExt function.
  • Fixed DragDrop.CreateWithControl to accept DX/DY on macOS, too.
  • Fixed issue where Copy Script button won't work if script is open in a new window.
  • Fixed memory leak in Archive.Content function.
  • Fixed memory leak in CURL.GetResultAsEMailList function.
  • Fixed memory leak in FM.SQL.JSONRecord and Matrix.JSONRecord functions.
  • Fixed parameters for Matrix.Evaluate function.
  • Fixed preferences dialog for Windows to show more text.
  • Fixed problem in Math.FormatNumber with missing zero before decimal separator for small number.
  • Fixed problem in QLPreviewPanel.Show function.
  • Fixed rounding error with Time.Sleep function.
  • Improved error message for Files.MoveToTrash when file to delete is in use.
  • Improved ListDialog functions on Windows to not redraw list while filling it. A massive performance improvment!
  • Reduced number of exported symbols in Windows DLLs.
  • Rewrote SystemInfo.IsAdminUser function to work again on macOS.
  • Rewrote Time.UnixTimeStamp function to work for dates before 1970 on Windows.
  • Updated CURL library to version 7.75.0.
  • Updated DukTape library for JavaScript functions to version 2.6.
  • Updated DynaPDF to version 4.0.49.139.
  • Updated dyncall library to version 1.2.
  • Updated LCMS to version 2.12.
  • Updated LibXL to version 3.9.4.
  • Updated LibXML to version 2.9.10.
  • Updated LibXSLT to version 1.1.34.
  • Updated openssl to version 1.1.1i.
  • Updated plugin SDK for version 19.2.
  • Updated SQLAPI to version 5.1.4b5.
  • Updated to Xcode 12.4.

New in MBS FileMaker Plugin 11.0 (Jan 19, 2021)

  • Added DragDrop.AttachToWindow function to allow drop to whole window on Windows.
  • Added DragDrop.GetFilePathsToDrag, DragDrop.SetDragImage and DragDrop.SetFilePathsToDrag functions to allow drag from Drag & Drop control..
  • Added DynaPDF.Lab function.
  • Added DynaPDF.SaveAndSignFileExt function to sign PDF file with 2048 or 4096 bit key length.
  • Added DynaPDF.SetFillColorValue and DynaPDF.SetStrokeColorValue functions.
  • Added DynaPDF.SetPageBreakExpression and DynaPDF.GetPageBreakExpression to allow custom page breaks and multi column output.
  • Added filter for ListDialog and related functions: ListDialog.GetFilter, ListDialog.GetShowsFilter, ListDialog.SetFilter and ListDialog.SetShowsFilter.
  • Added leading factor parameter for DynaPDF.ConvertStyledText, DynaPDF.WriteStyledText and DynaPDF.WriteStyledTextEx.
  • Added mode 16 for number sorting to QuickList.SortWith function.
  • Added new DirectoryPath parameter for DocumentPicker.Import and DocumentPicker.Open functions.
  • Added PassThroughNativePath flag to Path.FileMakerPathToNativePath function to disable the pass through of valid paths.
  • Added PrintDialog.GetReverseOrder and PrintDialog.SetReverseOrder functions.
  • Added Speech.AttributesForVoices function.
  • Added SystemInfo.IsiOSAppOnMac function.
  • Added Window.GetTitlebarSeparatorStyle and Window.SetTitlebarSeparatorStyle functions.
  • Added Window.GetToolbarDisplayMode and Window.SetToolbarDisplayMode functions to configure macOS toolbar to show icons and/or labels.
  • Added Window.GetToolbarStyle and Window.SetToolbarStyle for macOS 11.0
  • Changed Barcode.Generate to default to 8-bit per channel for the generated image to avoid trouble if receiving software can't handle 16 bit per channel. You can still change with GMImage.SetDepth, e.g. to make a monochrome version.
  • Changed coloring scheme for Dark mode to show set variable a bit lighter. You may need to run SyntaxColoring.FactoryDefaults to see changes.
  • Changed DocumentPicker.Import and DocumentPicker.Open to make second parameter flags, so you can decide to show file name extensions.
  • Changed DragDrop.CreateWithControl, DragDrop.CreateWithSize, DragDrop.CreateWithWindow to return an error if the control can't be created properly.
  • Changed DynaPDF.ConvertStyledText to fall back to Helvetica if font is not found.
  • Changed MarkDown functions to output footnotes.
  • Changed MBS items for Script Workspace and Debugger to better hide if window is not wide enough.
  • Changed QuickList.MatchesSubString to use caseless comparison on Windows and Linux and not just on macOS/iOS.
  • Changed SQL functions to automatically use CLOB/BLOB type for strings for SQL Server if length is >8000.
  • Disabled the zoom button for inspector from 10.5 due to problems.
  • Enhanced Matrix.InsertRecords to detect field data type and pass numbers and date/time/timestamp to FileMaker.
  • Fixed a bug in Schedule functions where timer may not fire after midnight.
  • Fixed a memory leak in WordFile functions.
  • Fixed an issue with SQL.Connect function connecting to MySQL when server doesn't know utf8mb4 text encoding.
  • Fixed an issue with WebDownloadDelegate.SetBeginDownloadHandler not calling the script.
  • Fixed bug in Font.Deactivate for macOS, where deactivate was not working since v10.3.
  • Fixed DynaPDF.CreateAxialShading and DynaPDF.CreateRadialShading to return handle for new shading.
  • Fixed DynaPDF.GetFieldAsJSON and DynaPDF.GetFieldsAsJSON to return ActionType with that key name instead of Action twice.
  • Fixed DynaPDF.SetCMapDir to return number of CMaps loaded instead of OK.
  • Fixed edge case where a function name on the start of calculation would not get colored.
  • Fixed FileDialog.GetNameFieldStringValue for Windows to return name of chosen file after dialog showed.
  • Fixed issue with FM.SQL.JSONRecord, FM.SQL.JSONRecords and Dictionary.ToJSON where long numbers where truncated to double precision.
  • Fixed ListDialog functions on macOS to handle Command-C, Command-V, Command-X and Command-A for the filter text field.
  • Fixed plugin to load on Windows 7 again. Broken in 10.5 when adding WindowsML functions.
  • Fixed problem with bracket highlighting voiding your selection on Big Sur.
  • Fixed problem with Command-R taken for the plugin for Database Definition dialog. You can now use it again to pick Container in field types popup.
  • Fixed problem with plugin preventing variable name being selected when you open a Set Variable dialog by formatting text twice.
  • Fixed problem with WordFile functions and some Word documents with older encodings.
  • Fixed rate parameter for Speech.Speak function for macOS.
  • Fixed Window.GetCurrentTag function.
  • Improved DynaPDF.ConvertStyledText to handle size difference better.
  • Improved if/loop highlighting to find matching exit loop even if it is within an If block.
  • Improved image drawing for Windows DragDrop functions, so the control looks better.
  • Optimized EmailParser.HTMLToPlainText function to add new line after pre element and to skip space runs.
  • Rewrote Files.FileSize, Files.AccessDate, Files.CreationDate and Files.ModificationDate to use newer APIs on macOS.
  • Split local offline documentation in separate download.
  • Tuned bracket highlighting to not edit text attributes if there are no brackets.
  • Updated SQLite library to version 3.34.0.
  • Updated curl to version 7.74.0.
  • Updated DynaPDF to version 4.0.46.132.
  • Updated LibXL to version 3.9.3.
  • Updated SQLAPI to version 5.1.3.
  • Updated to Xcode 12.3.

New in MBS FileMaker Plugin 10.1 (Mar 10, 2020)

  • Added context menu command for MacOS to sort entries in a list in FileMaker, e.g. layouts or fields.
  • Added font popup menu to preferences dialog to choose font for script workspace or calculations.
  • Added | to the list of characters valid for variable names in our variable check.
  • Added alpha part for returning color from ColorPanel.GetColor and similar functions.
  • Added auto mode for Clipboard.SetFileMakerData and Clipboard.GetFileMakerData functions.
  • Added CLGeocoder.JSON to return JSON for a geo coder with all details.
  • Added Clipboard.DetectFileMakerDataType function.
  • Added CNContact.DeleteValue function.
  • Added CNContact.Show method to show contact as sheet.
  • Added CNContactPicker.Show and related functions to show contact picker on MacOS and iOS.
  • Added CURL.Features function.
  • Added DynaPDF.SaveAndSignFileWinCrypt and DynaPDF.SaveAndSignFileWinCryptDialog functions.
  • Added DynaPDF.Uninitialize and XL.Uninitialize functions.
  • Added FM.GetDisableContextualMenus and FM.SetDisableContextualMenus functions to disable contextual menus.
  • Added GMImage.ExifThumbnail function.
  • Added GMImage.FontMap function.
  • Added handing of Strikethrough text attribute for styled text conversion from NSAttributedString to FileMaker. Affects WebView.GetFormattedText, Clipboard.GetStyledText, RichText.FormattedText and other functions.
  • Added iOSApp.SetIdleTimerDisabled and iOSApp.GetIdleTimerDisabled to disable sleep on iOS.
  • Added JS.ObjectCount and JS.StringCount functions.
  • Added Menu.List and MenuItem.List to list all IDs for menu entries.
  • Added preferences dialog for Windows.
  • Added Proj functions to use Proj library for transforming geo coordinates between various projections.
  • Added remembering of column widths for themes, custom menus, data sources, security and privileges and value lists.
  • Added ScriptWorkspace.StyledScriptText and ScriptWorkspace.CopyScriptText functions.
  • Added SharedMemory functions.
  • Added SyntaxColoring.GetFontName and SyntaxColoring.SetFontName functions.
  • Added SyntaxColoring.GetFontSize and SyntaxColoring.SetFontSize functions.
  • Added time functions for JavaScript functions: JS.Now, JS.TimeToDateComponents, JS.TimeToUTCDate and JS.UTCDateToTime.
  • Added wait parameter for CLGeocoder.GeocodeAddressString or CLGeocoder.ReverseGeocodeLocation function.
  • Added wait parameter for CNContactStore.RequestAccesss function.
  • Added WebView.PostURL function to post data or include headers.
  • Added WMFP.GetLoop and WMFP.SetLoop functions.
  • Added WMFP.Screenshot function.
  • Changed Audit.Changed and related to work with PageNumber and LayoutNumber as numeric fields.
  • Changed DynaPDF.Initialize to accept Starter, Lite, Pro and Enterprise texts for demo modes again.
  • Changed FM.InsertRecord, FM.CompareTables, FM.DeleteRecord, FM.DeleteRecords, FM.InsertOrUpdateRecord and FM.UpdateRecord to take table name from first field name if table name is empty.
  • Changed Socket.NewTCPSocket to mark sockets to accept IPv4 connections on IPv6 sockets.
  • Deprecated LDAP.Add, LDAP.AddList, LDAP.AddRecord in favor of LDAP.AddJSON.
  • Deprecated LDAP.Modify and LDAP.ModifyRecord in favor of LDAP.ModifyJSON.
  • Deprecated Window.AddBottomOverlay, Window.ShowContent, Window.HideContent, Window.ShowOverlay and Window.HideOverlay. If you need those, let us know soon.
  • Documentation now includes references to FileMaker Magazin articles in html and pdf.
  • Fixed a problem with recursive templates in DynaPDF.ExtractDocumentText, DynaPDF.ExtractPageRectText and DynaPDF.ExtractPageText functions.
  • Fixed an issue with script search not showing on MacOS 10.11.
  • Fixed bug in DNSLookup.LookupHostByAddress function when parsing IPv4.
  • Fixed bug in PrintDialog.SetDestinationPath not working with space in file path.
  • Fixed bug in Shell.PeekErrorText function for MacOS.
  • Fixed bug with DynaPDF.GetContent function.
  • Fixed bug with Text.ConvertUnicodeToCharacterComposition function not working for all characters.
  • Fixed bugs related to future FileMaker versions.
  • Fixed CNContactStore.Contacts, CNContactStore.UnifiedMeContact, CNContactStore.ContactsInGroup, CNContactStore.ContactsMatchingName and others to work if your iOS application has not the entitlement to access notes in contacts.
  • Fixed crash in LDAP.AddJSON with invalid data by improving error handling.
  • Fixed dark mode check to not prevent script workspace to show search bar for older MacOS versions.
  • Fixed issue with FM.RunDatabaseDesignReport to work in MacOS Catalina. Needs accessibility permissions in system preferences to click save button.
  • Fixed PopupMenu on Windows to use more space for custom fonts.
  • Fixed problem with DynaPDF.RenderPage not returning container if you pass empty file path parameter.
  • Fixed ScriptWorkspace.ScriptText and related to copy script with tab characters included.
  • Fixed tray setting for PDFKit.SetPrintSetting function.
  • Fixed WebView.SetFormInputValue and related to take index for form instead of name.
  • For DynaPDF we will rename the DLL to have 64-bit library named dynapdf.dll in future and dynapdf32.dll for the 32-bit version.
  • Improved error message for SerialPort.Open to include port name.
  • Improved performance for using JavaScript functions in parallel scripts on Server.
  • Optimized syntax highlighting to reduce number of redraws we need. This should speed up scrolling.
  • Removed check from ImageCapture.RequestScan to check for open session.
  • Rewrote PDFKit.GetPrintLastSettings, PageSetupDialog.GetLastSettings and PrintDialog.GetLastSettings to return result as JSON.
  • Updated CURL to version 7.69.0.
  • Updated DynaPDF to version 4.0.37.107.
  • Updated Plugin SDK.
  • Updated SQLAPI to version 5.0.5.
  • Updated SQLite to version 3.31.0.

New in MBS FileMaker Plugin 9.4 (Sep 17, 2019)

  • Added barcode type Ultra.
  • Added Barcode.GenerateJSON function.
  • Added CGImageSource.ClearProperties function.
  • Added CGImageSource.Export and CGImageSource.SupportedExportTypes functions to export image.
  • Added CGImageSource.FileName function.
  • Added CGImageSource.HasProperty and CGImageSource.SetProperty to set metadata (IPTC/EXIF) and write file back.
  • Added check to FileDialog.OpenFileDialog, FileDialog.SaveFileDialog, FileDialog.SelectFolderDialog and FileDialog.SelectItemDialog to ignore invalid initial directory for Mac.
  • Added CoreLocation.hasLocation function.
  • Added CURL.SetOptionSASLAuthZID function.
  • Added EmailParser.AttachedEmails function.
  • Added error check to Encryption.Cipher to report if de/encryption fails instead of silently return no or garbage data.
  • Added fileNames parameter for FM.RunDatabaseDesignReport on MacOS.
  • Added Files.AudioTags to read ID tags from audio files.
  • Added Files.SetAudioTags to change ID tags for audio files, e.g. ID3v2 tags in MP3 files.
  • Added FM.ChooseDictionary, FM.GetDictionary and FM.GetDictionaryList to control which dictionary is selected in FileMaker (Mac)
  • Added GMImage.Hash function.
  • Added MapView.AddCircle function.
  • Added MapView.AddPoint, MapView.AddPolyline and MapView.AddPolygon functions.
  • Added MapView.Annotations, MapView.Overlays, MapView.RemoveAnnotation, MapView.RemoveOverlay and MapView.SetAnnotationPinColor.
  • Added MapView.SetAnnotationCoordinate and MapView.GetAnnotationCoordinate.
  • Added MBS to ID columns to avoid confusion, about what features MBS Plugin provides.
  • Added more array support for Java functions to handle boolean, short, float, double and object arrays.
  • Added new dedicated script to code sign FileMaker 18 runtimes.
  • Added new keys FontColor and BackColor elements to XML for Menu.DefineQuickMenuXML to define colors.
  • Added SpeechRecognition functions.
  • Added SSL connection modes for CubeSQL client.
  • Added SystemInfo.MacBoardID function.
  • Added SystemInfo.MacROMBootVersion function.
  • Added Text.ConvertToTextEncoding and Text.ConvertFromTextEncoding functions.
  • Added UNNotification.SetNFCScript function for background scanning with URL trigger in NFC card for iOS.
  • Added Vision functions for text recognition, barcode detection and image classification on MacOS and iOS.
  • Added WebView.SetFocus function.
  • Changed Barcode.EANChecksum, Barcode.ISBNChecksum and Barcode.UPCChecksum to only use digits and ignore spaces or dashes in input.
  • Changed Command-I to show invisible characters to no longer hide line numbers in script workspace.
  • Changed CurrentHostTimeStamp field for Audit to be either text or timestamp. Text still preferred.
  • Changed MapView.AddPin, MapView.AddPinWithAddress or MapView.ShowAddress to return identifier for new pin.
  • Changed Path.AddPathComponent to accept multiple parameters.
  • Changed SQL functions for ODBC on Mac to not complain about missing SQLBrowseConnect.
  • Changed Syntax colorizing to not draw into hidden windows. This avoids crashes while closing debugger.
  • Fixed a bug in CURL.CloseDebugFile, CURL.CloseHeaderFile, CURL.CloseInputFile and CURL.CloseOutputFile to avoid.
  • Fixed a bug in WordFile.ReplaceTag where it would not update the modified XML correctly for replace in header section.
  • Fixed a problem with ActualTech ODBC drivers to connect from Mac to Microsoft SQL server.
  • Fixed a problem with loading LDAP.framework on Mac for use in CURL.
  • Fixed bug in EmailParser.Parse where html text sometimes contained an extra = on the end.
  • Fixed bug with long array passing in Java functions.
  • Fixed Files.FileSize for iOS.
  • Fixed problem with Layout IDs not showing with dot in filename (same for script IDs).
  • Improved Java search for Java.Initialize function on Windows to find jvm.dll.
  • Improved pretty formatting for JSON arrays in JSON.Format.
  • Notarized the disk image for MacOS Catalina.
  • Now showing version number in FileMaker preferences when you click on MBS plugin.
  • Optimized script search to filter control characters from search text.
  • Rewrote BlueThermProbe functions.
  • Rewrote EmailParser.SourceWithoutAttachments function.
  • Updated CURL library to version 7.66.0.
  • Updated DynaPDF to version 4.0.30.92.
  • Updated to Xcode 10.3.
  • Updated website links in preferences dialog and help menu.
  • Updated zint library to version 2.6.5.

New in MBS FileMaker Plugin 9.3 (Sep 17, 2019)

  • Improved performance and stability on server with more mutex checks.
  • Added examples for ZUGFeRD 2.0 and Factur-X for DynaPDF.
  • Added FM.CompareTables function.
  • Added Barcode.LibVersion function.
  • Added CURL.SetOptionMaxAgeConn function.
  • Added Events.Reminder.GetDueTimestamp and Events.Reminder.GetStartTimestamp functions.
  • Added flags for DynaPDF.Optimize: ConvertToGray, ConvertToRGB, ConvertToCMYK and ReplaceJP2KWithJPEG.
  • Added GMImage.WriteToContainer function.
  • Added identifier and color parameters for MapView.AddPin, MapView.AddPinWithAddress, MapView.PlanRoute and MapView.ShowAddress functions.
  • Added iOS support for WebView.SetCustomUserAgent function.
  • Added JSON.Import.ErrorCount, JSON.Import.Errors, XML.Import.ErrorCount, XML.Import.Errors.
  • Added JSON.Sort function.
  • Added LDAP.StartTLS function.
  • Added location cache for MapView to cache in memory the coordinates to addresses to avoid repeated server queries.
  • Added MapView.Screenshot function.
  • Added MapView.SetScript function.
  • Added mode parameter to FM.RunScript and EventMonitor.SetCardWindow functions.
  • Added options to DynaPDF.SetPDFVersion function to create ZUGFerd 2.0 and Factur-X files.
  • Added parameter for EmailParser.Inline or EmailParser.Attachment to pass text encoding or file name.
  • Added parameter for script parameter for EventMonitor.SetCardWindow function.
  • Added Plugin.CallCounter function.
  • Added Plugin.InstallSignalHandlers function.
  • Added Preferences.GetValueType function.
  • Added preserveLineEndings parameter for CURL.GetDebugAsText, CURL.GetHeaderAsText, CURL.GetInputAsText and CURL.GetResultAsText function.
  • Added Shell.GetArguments function.
  • Added SystemInfo.ADSystemInfo function to query Active Directory details for current user.
  • Added Text.FilterUTF16 function.
  • Added Text.Styles function.
  • Added Trace.GetErrorsOnly, Trace.GetWithTimes, Trace.SetErrorsOnly and Trace.SetWithTimes.
  • Added UNNotification.Deliver, UNNotification.GetDescription and UNNotification.SetCalendarDateTrigger functions.
  • Added Webview.GetAllowsLinkPreview, WebView.HasOnlySecureContent, Webview.SetAllowsLinkPreview and WebView.StopLoading.
  • Changed C++ to 2017 dialect for Xcode 11.
  • Changed CURL progress logging to skip duplicate lines.
  • Changed CURL to not collect data in memory if used with CURL.CreateOutputFile.
  • Changed field quoting for FM.UpdateRecord and others to not quote ROWID as field name.
  • Changed JSON.GetValue to pass number via string to avoid double rounding.
  • Changed MapView to show details on map pins if you provide title text.
  • Changed tab stops for calculation dialog to be 36.
  • Changed UNNotification functions to initialize on demand and not a startup.
  • Changed WebView functions to look in front document window on MacOS and Windows instead of any window. This way functions now work in data viewer or the dialog to enter a new calculation.
  • Fixed a bug with GraphicsMagick initialization if two scripts called it at the same time on server.
  • Fixed a linking issue in 9.2 on Windows, so plugin didn't load on server.
  • Fixed a problem where accessing a web viewer via ID would crash if web viewer was destroyed by FileMaker.
  • Fixed a problem with DynaPDF.ReplacePattern function and fonts missing the CID Ordering table.
  • Fixed a problem with scrolling in FileMaker 15 Script Workspace with scrolling.
  • Fixed BlueThermProbe.GetProbeButtonHasBeenPressedEvaluate function.
  • Fixed bug in Text.DecodeFromBytes function.
  • Fixed HTML tag for JSON.ToHTML.
  • Fixed issue with LDAP functions sometimes not passing attributes correctly on MacOS.
  • Fixed MapView.ShowAddress to correctly center on the found placemark instead of the region for that placemark.
  • Fixed memory leak in XML.ReadContainer function.
  • Fixed potential crash with SQL.FreeCommand and SQL.FreeConnection in server scripts.
  • Fixed potential problem with socket background checking.
  • Fixed preferences for relation ship graph search. Now you can turn it off.
  • Fixed problem in parameter parsing for Java.NewClassObject function.
  • Fixed problem with Events.RefreshSourcesIfNecessary.
  • Fixed QLPreviewPanel.Show to work if used with cards.
  • Fixed Time.Format to return week numbers correctly.
  • Implemented FontManager.ListFontFamilies function for iOS.
  • Implemented GraphicsMagick font mapping for iOS, so you can references fonts by name.
  • Implemented WebView.AllowsAnyHTTPSCertificateForHost for WebKit 2.x, so it works in FileMaker 16 and newer.
  • Improved code adding tab stops for formula editor.
  • Rewrote FM.InsertRecordCSV to support multi line values.
  • Updated CURL to version 7.65.3.
  • Updated DynaPDF to version 4.0.30.87.
  • Updated libcpuid to version 0.4.1.
  • Updated libiconv to version 1.16.
  • Updated libPNG to version 1.6.37.
  • Updated libssh2 to version 1.8.2.
  • Updated libxlst to version 1.1.33.
  • Updated libxml2 to version 2.9.9.
  • Updated libzint to version 2.6.3.
  • Updated OpenSSL to version 1.1.1c.
  • Updated PCRE to version 8.43.
  • Updated SQLite to version 3.29.0.

New in MBS FileMaker Plugin 9.2 (Sep 17, 2019)

  • Added new ContinuityCamera functions for taking picture and scanning documents with iPhone or iPad to use on your Mac.
  • Added PageSetupDialog functions to change paper format on MacOS.
  • Added TextView functions to have our own text control for Mac, iOS and Windows.
  • Added Matrix functions for a two dimensional list with FileMaker native data types.
  • Added 20ms pause after setting copies in Printer.Print to let dialog notice the change.
  • Added AddPageBreak parameter for WordFile.Append.
  • Added Archive.Verify function.
  • Added Calendar.Initialize function.
  • Added check to Files.Delete to prevent you using paths ending in // or \, which may unexpectedly delete a whole folder.
  • Added Command-R to calculations to show ruler to define tabs.
  • Added DragDrop.CreateOnPopoverWithControl and DragDrop.CreateOnPopoverWithSize.
  • Added DragDrop.GetHTML and DragDrop.GetRTF functions.
  • Added DynaPDF.ConvertColors function.
  • Added DynaPDF.GetViewerPreferences and DynaPDF.SetViewerPreferences functions.
  • Added FM.RunSaveAsXML function.
  • Added GMImage.GetAttributeNames and GMImage.GetAttributesJSON functions.
  • Added Hash.DigestFile function to calculate hashes of big files.
  • Added ListDialog.ClearColumnHeaders, ListDialog.GetColumnHeader andListDialog.SetColumnHeader functions.
  • Added ListDialog.ColumnCount and ListDialog.SetColumnCount for multi column list dialogs.
  • Added MapView.FormatDistance, MapView.ParseDistance and MapView.PlanRoute functions.
  • Added Math.PolylineEncode and Math.PolylineDecode functions for Google's Encoded Polyline Algorithm Format.
  • Added new optional type parameter to PrintDialog.SetOption and PDFKit.SetPrintOption to set data type.
  • Added new parameter for Files.CreateAlias to specify icon for the alias/link file.
  • Added PaperSize option to RichText.SetAttribute and RichText.Attribute functions.
  • Added PDFKit.GetPrintLastSettings function.
  • Added PDFKit.GetPrintOption and PDFKit.SetPrintOption functions to set custom options.
  • Added PKCS12.ShowDialog and X509.ShowDialog functions.
  • Added Printer.CurrentNumberOfCopies function.
  • Added ProgressDialog.GetImageHeight, ProgressDialog.GetImageWidth, ProgressDialog.SetImageHeight, ProgressDialog.SetImageWidth to show bigger images.
  • Added Screen.Scale function.
  • Added Socket.List function.
  • Added support for passing automatically string, int and long arrays to/from our Java functions.
  • Added Text.DecodeIMAPFolderName function.
  • Added UserNotification.removeAllScheduledNotifications function.
  • Added withEXIF parameter to ImagePicker.MediaEditedImage and ImagePicker.MediaOriginalImage functions.
  • Added workaround for SerialPort.Open to avoid Windows bug with COM ports >9
  • Adjusted offsets for DragDrop.CreateWithControl to position on top of control better.
  • Changed Archive.Content to return error if archive is broken.
  • Changed Dialog.Run to return error if called on Server.
  • Changed DragDrop functions on Windows to allow transparent area for drop area.
  • Changed DynaPDF.Initialize to load dylib on iOS, too.
  • Changed JSON.SetPathItem to create objects if they are missing.
  • Changed plugin to not link to EventKit functions, CalendarStore and TWAIN frameworks directly.
  • Changed Printer.Print to only set collatePages is 0 or 1 and ignore parameter otherwise.
  • Changed ProgressDialog on Windows to respect DPI of display.
  • Changed SQL functions to not complain about missing functions with freetds.
  • Changed SQL.SetConnectionOption to pass more options to commands for MS SQL: SQL_ATTR_CURSOR_TYPE, SQL_ATTR_QUERY_TIMEOUT, SQL_ATTR_CONCURRENCY, SQL_ATTR_CURSOR_SCROLLABLE and SQL_ATTR_CURSOR_SENSITIVITY.
  • Changed syntax colorizing for formulas to ignore white space between function name and bracket.
  • Changed SystemInfo.HardDiscSerial for Windows to make sure to ignore removable media.
  • Changed SystemInfo.MACAddress for Windows to look for Ethernet port first, than for Wifi and than for other adapters.
  • Changed WordFile functions to also handle OpenDocument text files.
  • Changed WordFile functions to not reformat XML unless changed.
  • Changed WordFile.ReplaceTag to look for tags in document properties.
  • Disabled HealthKit for public release due to Apple's automatic tests. If you need a plugin with HealthKit, please contact us.
  • Fixed a problem with FMWrapper loading for Mac runtime apps.
  • Fixed a problem with NTML authentication with CURL functions on Windows.
  • Fixed an issue where notification on iOS would not show up in the app or trigger script.
  • Fixed Archive.Content to return flags correctly.
  • Fixed bug in JSON generation for NULL strings.
  • Fixed bug with WordFile.SetMarkers.
  • Fixed DynaPDF.IsColorPage function result.
  • Fixed LDAP timeout functions LDAP.GetNetworkTimeOut, LDAP.GetTimeOut, LDAP.SetNetworkTimeOut and LDAP.SetTimeOut.
  • Fixed problem preventing search in script to work in scripts opened as dialog.
  • Fixed problem with CGPSConverter.Convert and big files.
  • Fixed problem with delimiter detection in FM.InsertRecordCSV.
  • Fixed problem with Dialog.Run if other button is empty text.
  • Fixed problem with DynaPDF.RotateTemplate function and 180 degree.
  • Fixed problem with Path.RemoveLastPathComponent and path ending with (back)slash.
  • Fixed QLPreviewPanel.Clear for iOS.
  • Implemented Process.SetFrontMost for Windows.
  • Improved 64-bit integer handling for JSON to avoid rounding errors with doubles.
  • Improved error handling for DynaPDF.ImportPDFPage function.
  • Improved error message for SerialPort.Open to include name of the COM port.
  • Improved startup time of the plugin by delaying loading of Calendar, Events, LDAP, GraphicsMagick, CoreML, SmartCard, Windows User Notification APIs until needed.
  • In formula editor, you can now press Command-I to show spaces and control characters more visually.
  • Little fixes for next FileMaker version.
  • Manually applied CURL fix: vauth/oauth2: Fix OAUTHBEARER token generation #3377
  • Manually applied NTML fix for CURL.
  • Notarized Runtime Shrinker, Form Utility and Clipboard Helper applications.
  • Removed compatibility for Windows Vista, so Windows 7 is minimum to load MBS Plugin 9.2.
  • Renamed FM.RunDataDesignReport to FM.RunDatabaseDesignReport, but old name stays valid.
  • The syntax highlighting for calculation dialog now adds extra tab stops.
  • Updated CURL to version 7.64.1.
  • Updated DynaPDF to version 4.0.27.80.
  • Updated Hotkey key names to use left/right/up/down for Mac and Windows.
  • Updated LibXL to version 3.8.5 for MacOS and 3.8.5.1 for Linux and Windows.
  • Updated SQLite to version 3.28.0.
  • Updated to Xcode 10.2.

New in MBS FileMaker Plugin 9.1 (Mar 12, 2019)

  • Added DocumentPicker functions to get file dialog to pick or export file on iOS.
  • Added feature to sort layout style entries in context menu in FileMaker layout editor.
  • Added PKCS7 functions to read signed data.
  • Added append parameter for Trace function.
  • Added AVRecorder.EncoderCount, AVRecorder.EncoderInfo, AVRecorder.GetEncoder and AVRecorder.SetEncoder functions to define encoder for AVRecorder on Windows.
  • Added AVRecorder.ShowPropertyDialog function.
  • Added backlog parameter for Socket.Listen.
  • Added CloseDialog = 3 mode for Printer.Print to keep main dialog open, but close sub dialog.
  • Added DragDrop.GetAutoResizingMask and DragDrop.SetAutoResizingMask functions.
  • Added DynaPDF.GetOCG, DynaPDF.GetOCGContUsage, DynaPDF.GetOCGCount, DynaPDF.GetOCGUsageUserName and DynaPDF.SetOCGState functions for PDF layers.
  • Added DynaPDF.Table.SetCellAction function.
  • Added FM.SQL.Max, FM.SQL.Min, FM.SQL.Avg and FM.SQL.Sum functions.
  • Added ImageCapture.PDF function to return PDF document for scanned documents.
  • Added MapView.RemoveAnnotations and MapView.RemoveOverlays function.
  • Added MapView.ShowAllAnnotations function.
  • Added MaxRes Parameter for DynaPDF.Print function.
  • Added mitigation for Folders.UserTemporary function for Mac on Server.
  • Added more CoreLocation functions for iOS.
  • Added NewTextColor parameter for DynaPDF.ReplacePattern function.
  • Added PlainText flag to DynaPDF.WriteFText, DynaPDF.WriteFTextEx and DynaPDF.WriteFTextExRotated functions.
  • Added providesAppNotificationSettings, showPreviewsSetting and criticalAlertSetting for UNNotification.NotificationSettings function.
  • Added support for binary format to X509.Read, X509.ReadFromContainer and X509.ReadFromFile.
  • Added Time.TimeZoneOffset function.
  • Added tooltip for Export dialog for MacOS. If a table name is selected in popup, we can show field type in tooltip for list entries.
  • Added Trace.WriteLine function to write text/data into trace logging.
  • Added UNNotification functions for MacOS 10.14 and newer.
  • Added WIA.Images function.
  • Added WinSendMail.SendAsync function.
  • Added WordFile.AddMediaFile function.
  • Added X509.Write function.
  • Changed UNNotification functions to return error on server.
  • Changed code signing to also sign debug version of our Windows plugin.
  • Changed email decoding to use iconv to support GB2312 text encoding.
  • Changed freeing SQL connections to also free all related SQL commands.
  • Changed GMImage.AveragePixelValue to make rectangle optional.
  • Changed GraphicsMagick to detect installed fonts at runtime for MacOS instead of hard coded list.
  • Changed MapView.CreateWithControl so the map view is placed in the document view from FileMaker and scrolls with the other controls.
  • Changed MapView.ShowAddress and MapView.AddPinWithAddress to return errors if address is not found.
  • Changed script search to delay search a few milliseconds to avoid search while typing.
  • Changed TAPI.Initialize to return windows error code if initialization fails.
  • Changed web viewer made with WebView.Create to open links with target=_blank in browser.
  • Changed WebView.FindByName to better find web viewer.
  • Changed XML.Import to ignore BOM character.
  • Fixed a problem with XL.Sheet.CellWriteTexts function and empty entries in value list.
  • Fixed a problem with XML.Parse getting an XML reference number.
  • Fixed bug for Time.TimeStampToUTC on Windows with day change.
  • Fixed bug in CURL.GetResultAsEMailList to include several CC addresses.
  • Fixed bug in handling 16-bit color for GraphicsMagick, which affected the trim and replace color examples.
  • Fixed bug in WebView.FindByName for Mac.
  • Fixed bug with Archive.Compress not writing file on Windows.
  • Fixed bug with image indexes for DynaPDF.AppendImagePages function.
  • Fixed bug with SQL.SetParamAsTime and SQLAPI handling TIME field type for SQLite.
  • Fixed crash with connecting to SQL Anywhere when creating connection failed. Now reports an error instead.
  • Fixed GameKit.Leaderboard.New function.
  • Fixed problem with Events.Reset function.
  • Fixed problem with MapView.CreateWithControl on iOS not initializing correctly.
  • Fixed problem with Printer.Print picking items in popup menu if you have two similar starting entries.
  • Fixed problem with URL trigger for sockets.
  • Fixed problem with XL.Sheet.SetTabColorRGB function.
  • Fixed text encoding issue with Trace logs for Audit.
  • Implemented FM.MouseWheelScriptTrigger for MacOS to navigate through records with mouse wheel.
  • Manually applied CURL fix: vauth/oauth2: Fix OAUTHBEARER token generation #3377
  • Rewrote Container.Compress and Container.Decompress to work faster.
  • Rewrote FM.QueryFieldsForTableName and FM.QueryFieldsForBaseTableName to avoid join operation and gain better performance with lots of tables.
  • Rewrote RichText.HTMLText to return better html.
  • Updated CURL to version 7.64.0.
  • Updated DynaPDF to version 4.0.26.74.
  • Updated SQLAPI to version 4.2.5.
  • Updated SQLite to version 3.27.1.

New in MBS FileMaker Plugin 8.0 (Jan 22, 2018)

  • Added MetaDataQuery functions for macOS and iOS, usually called Spotlight search.
  • Added Command-F shortcut to show find bar in text views, so you can search calculations, custom functions and more.
  • Added IDN support for CURL functions on Windows Vista and newer. Does give error if you try it on older Windows XP.
  • Added allowUniversalAccessFromFileURLs parameter for WebView.SetPreferences.
  • Added App.EffectiveUserID, App.ProcessID and App.UserID.
  • Added AVAsset.WaitForLoaded function.
  • Added better error message when calling XL.LoadBook or XL.NewBook without calling XL.Initialize.
  • Added Command-Option-C shortcut to copy text with formatting for calculation fields.
  • Added DynaPDF.RenderPDFFileEx, DynaPDF.FileAttachAnnotEx and DynaPDF.ExtractText.
  • Added example for Swiss QR-Code for invoices (ISO 20022).
  • Added FM.UpdateRecord2, FM.UpdateRecord3, FM.UpdateRecords2 and FM.UpdateRecords3.
  • Added FM.VariableNames function.
  • Added JSON functions for LDAP: LDAP.AddJSON, LDAP.JSON and LDAP.ModifyJSON.
  • Added NoActivate parameter to ProgressDialog.Show function.
  • Added PDFKit function for iOS. Printing is still macOS only.
  • Added PrintDialog.GetConfiguration and PrintDialog.SetConfiguration functions.
  • Added Settings tab to Form Utility with a field to enter user agent string to use.
  • Added Socket.LocalPort and Socket.LocalIP functions.
  • Added SyntaxColoring.GetAddFindbars and SyntaxColoring.SetAddFindbars function.
  • Added Tray setting for PDFKit.SetPrintSetting.
  • Added XL.LoadBookPartially function.
  • Added XL.Sheet.CellReadBooleans, XL.Sheet.CellReadComments, XL.Sheet.CellReadDates, XL.Sheet.CellReadFormulas, XL.Sheet.CellReadNumbers, XL.Sheet.CellReadTexts, XL.Sheet.CellWriteBlanks, XL.Sheet.CellWriteBooleans, XL.Sheet.CellWriteComments, XL.Sheet.CellWriteDates, XL.Sheet.CellWriteFormulas, XL.Sheet.CellWriteNumbers, XL.Sheet.CellWriteTexts, XL.Sheet.GetCellErrors, XL.Sheet.GetCellFormats, XL.Sheet.RemoveComments and XL.Sheet.SetCellFormats.
  • Added Audit.FieldNameForID and Audit.TableNameForID.
  • Changed Audit to be able to use UUID field, even if it's not in the field list passed to audit function.
  • Changed CURL.SetOptionCAINFO, CURL.SetOptionCAPATH, CURL.SetOptionCookieFile, CURL.SetOptionCookieJar, CURL.SetOptionIssuerCert, CURL.SetOptionNETRCFile, CURL.SetOptionRandomFile, CURL.SetOptionSSHPrivateKeyfile, CURL.SetOptionSSHPublicKeyfile, CURL.SetOptionSSLCert, CURL.SetOptionSSLKey to use always UTF-8 on Mac/Linux and on Mac do the unicode transformation for decomposed characters to avoid trouble with special characters in file paths.
  • Changed DynaPDF.Initialize to return expiration error if license key is too old.
  • Changed Events.Item.SetCalendar to pick reminder calendar by name if you edit reminder and not an events calendar.
  • Changed FM.InsertRecordCSV and FM.InsertRecordTSV to detect whether columns are numbers instead of text and handle it correctly.
  • Changed FM.RunDataDesignReport to work better on High Sierra with new Save Dialog.
  • Changed PDFKit.WriteToPath to report errors better.
  • Changed SQL.SetParamAsDateTime and SQL.SetParamAsDate to set param to NULL if you pass empty value.
  • Changed SystemInfo.HardDiscSerial on Mac to prefer serial from internal disk.
  • Changed WindowsUserNotification.ShowNotification to better handle empty texts.
  • Changed XML.Query to return attribute list properly.
  • Fixed an issue where Path.FileMakerPathToNativePath would not convert a path on Windows.
  • Fixed an issue with Audit for FileMaker 11.
  • Fixed bug in CURL.SetupAWS when wrong date was used.
  • Fixed bug in GMImage.Composite with 4th parameter.
  • Fixed bug search for FileMaker 14 and 15 to redraw table when editing search text to give instant search results (failed only in FMP15).
  • Fixed bug with PDFKit.Watermark for High Sierra.
  • Fixed bugs with DynaPDF.Print and scaling pages for some printers.
  • Fixed EnvironmentVariables.Names to not crash on Linux.
  • Fixed IsIOS and added IsIOSSimulator and IsIOSDevice functions.
  • Fixed issue with preference dialog not hiding when using the cancel and apply buttons on macOS 10.13.
  • Fixed JSON.CreateNumber to return 0 for empty string.
  • Fixed List.InsertValue for appending.
  • Fixed little but with out of bounds NSArray access for FileMaker 16.
  • Fixed out of bounds problem in Barcode.Detect. And now returns checksum errors properly.
  • Fixed parameter count error for LDAP.AddJSON.
  • Fixed problem where plugin would colorize script even when it's disabled in preferences.
  • Fixed problem with AVExport.ExportSessionMerge and new example to work.
  • Fixed SQL.GetFieldAsDate to assign a date and not a timestamp.
  • Fixed SystemInfo.UserName for Linux. Returns usually fmserver.
  • Fixed ZipFile.SetCompressionLevel to work with compression better.
  • For FileMaker Cloud we now redirect plugin output to ServerScriptingPluginsStdErr.log and ServerScriptingPluginsStdOut.log in /FileMakerData/Logs directory.
  • Improved CSV split (List.CSVSplit) to handle multi line text values better.
  • Improved CSV split to also auto detect tab instead of just comma and semicolon.
  • Improved Syntax Highlighting speed for macOS 10.13.
  • Renamed existing DynaPDF.ExtractText to DynaPDF.ExtractDocumentText. New function does the same, but now part of DynaPDF itself and not a helper function from our plugin.
  • Switched to Xcode 9.2.
  • The preferences dialog now warns if you run a beta version after release.
  • Trace function now writes text content for external containers, so you see the path.
  • Updated AVExport functions to work on iOS.
  • Updated CGImageSource functions to work on iOS, e.g. to convert HEIF images.
  • Updated Clipboard functions to work on iOS.
  • Updated CURL library to version 7.57.0.
  • Updated DynaPDF to version 4.0.15.42.
  • Updated Events functions to work on iOS.
  • Updated OpenSSL to 1.1.0g and 1.0.2m
  • Updated SQLAPI to version 4.2.1.

New in MBS FileMaker Plugin 8.0 Pre-release 7 (Jan 11, 2018)

  • Added XL.LoadBookPartially function.
  • Updated DynaPDF to version 4.0.15.42.
  • Fixed problem with AVExport.ExportSessionMerge and new example to work.
  • Added AVAsset.WaitForLoaded function.
  • Changed DynaPDF.Initialize to return expiration error if license key is too old.
  • Trace function now writes text content for external containers, so you see the path.
  • Changed color of disclosure triangle in button setup to be light gray instead of dark gray in case the plugin turns panel to black background.
  • Updated Events functions to work on iOS.
  • Updated Clipboard functions to work on iOS.
  • Updated AVExport functions to work on iOS.
  • Updated CGImageSource functions to work on iOS, e.g. to convert HEIF images.
  • Changed Events.Item.SetCalendar to pick reminder calendar by name if you edit reminder and not an events calendar.
  • Changed WindowsUserNotification.ShowNotification to better handle empty texts.
  • Changed SystemInfo.HardDiscSerial on Mac to prefer serial from internal disk.
  • Fixed SQL.GetFieldAsDate to assign a date and not a timestamp.
  • Fixed bug in CURL.SetupAWS when wrong date was used.
  • Fixed bug search for FileMaker 14 and 15 to redraw table when editing search text to give instant search results (failed only in FMP15).

New in MBS FileMaker Plugin 7.4 Pre-releases 5 (Sep 13, 2017)

  • Added FM.ExecuteSQL.LastSQL function to query last executed SQL command.
  • Last SQL error is now stored per thread, so you can get right result for multiple scripts on server.
  • Updated FSEvents for future.
  • Changed Linux plugin to include build number in SONAME field so OS can distinguish different versions better.
  • Updated DynaPDF to version 4.0.12.34.
  • Added AVPlayer.GetProgressEvaluate, AVPlayer.GetProgressInterval, AVPlayer.SetProgressEvaluate and AVPlayer.SetProgressInterval to track progress when playing audio.
  • Changed function to return nothing in the plugin to return now variable with data type invalid. This allows you to differentiate between empty text and no value.
  • Added LDAP.SearchResult.AttributeValuesByName function.
  • Added AVPlayer.GetFinishedEvaluate, AVPlayer.GetFinishedFileName, AVPlayer.GetFinishedScriptName, AVPlayer.SetFinishedEvaluate and AVPlayer.SetFinishedScript.
  • Changed CURL functions to explicit flush output files after Perform finished.
  • Added Webview.Close function.
  • Added checks to ExecuteSQL to return error for ALTER TABLE and CREATE TABLE to remind you to use FM.ExecuteSQLOnIdle.

New in MBS FileMaker Plugin 7.3 (Jul 26, 2017)

  • Added BinaryFile functions.
  • Added MailComposer functions to send email on iOS with email app, text or html and multiple attachments.
  • Added SocialComposer functions for iOS to post on Facebook, Twitter, SinaWeibo and TencentWeibo.
  • Added GMImage.CopyChannel function.
  • Added AVPlayer.FindPlayers function to access playing interactive containers on iOS.
  • Added AVPlayer.GetAsset function.
  • Added Dialog.GetLeft, Dialog.GetTop, Dialog.SetLeft and Dialog.SetTop functions to position dialogs.
  • Added EventMonitor.ClearCardWindow and EventMonitor.SetCardWindow to handle clicks outside a card window.
  • Added EventMonitor.LastMousePositionY and EventMonitor.LastMousePositionX functions.
  • Added Filter column functions for Excel functions.
  • Added GMImage.FontTypeMetrics function.
  • Added IgnoreDuplicates parameter to SQL.InsertRecords functions to ignore duplicate error on insert.
  • Added Linux support for SNMP.Get.
  • Added new flag for Files.ListRecursive to ignore invisible folders and better check for hidden elements.
  • Added new mode to Encryption.Cipher with type "auto" for returning container data and detect type based on a given filename.
  • Added new option DriveType for Files.DiskInfo on Windows.
  • Added parameter for QuickList.FindUnequals and List.FindUnequals to only return items from first list.
  • Added PHP.IsInitialized function.
  • Added Plugin.PNGVersion function.
  • Added SocialRequest and Social functions for iOS.
  • Added SQL.InsertOrUpdateRecords function.
  • Added support for FileMaker 16 for WebView.Passwords.Install function.
  • Added support on iOS to load dynapdf.framework to use DynaPDF functions inside iOS SDK app.
  • Added Text.ReplaceAll function.
  • Added Text.Speak and Text.Speak.AvailableVoices for iOS.
  • Added UNNotification.AuthorizationError and UNNotification.AuthorizationGranted.
  • Added UUID mode for Audit. Call Audit.SetUUIDField please to enable.
  • Added Webview.SendCommand and Webview.ExecCommand.
  • Added XML.Parse and XML.Release to parse XML once and query several times to get better performance.
  • Added DynaPDF methods for Metafile conversion (EMF/WMF)
  • Bug fixes for future macOS versions.
  • Calling StoreRegistration function now also invokes Register to test the key before storing it.
  • Changed Audit.SetIgnoredFieldNames to accept list of field names.
  • Changed AVAsset.OpenContainer to accept wav files.
  • Changed linux linking to avoid loader to connect function to wrong library if several versions of the library exists.
  • Changed script coloring to keep gray script lines (deactivated or incompatible) in gray.
  • Changed SQL.GetFieldAsNumber and SQL.GetParamAsNumber to return numbers outside 32-bit integer as text.
  • Changed syntax coloring to not highlight text of comments.
  • Changed variable check to accept comments declaring variables with @param: # @param $firstName The first name parameter.
  • Changed variable check to allow special rules ending with $ to catch commands with variables.
  • Changed variable checks in script editor to remove error messages and notifications better.
  • Creating barcode no longer changes locale settings.
  • Enabled SSE2 extension for libPNG for macOS as all Macs with Intel CPU should have SSE2.
  • Fixed a bug with Math.InsidePolygon.
  • Fixed bug in Int64 parsing when FileMaker uses scientific notation.
  • Fixed bug where variable detection would not handle variable containing ~ correct.
  • Fixed bug with DynaPDF.ShowDifferences and rotated pages.
  • Fixed bug with Encryption.Cipher to better handle longer keys (e.g. blowfish with up to 64 bytes) and invalid key lengths.
  • Fixed crash when quitting runtime app. The register script step is missing in runtimes and so the plugin should not register/unregister script step.
  • Fixed FileDialog.GetNameFieldStringValue function to provide name from dialog.
  • Fixed issue for iOS where version number was too long. Now last digit is not included.
  • Fixed issue with DynaPDF.HighlightPattern function.
  • Fixed issue with iOS plugin startup when not using optional MBSInit framework.
  • Fixed issue with SerialPort.ReadLine being off by one.
  • Fixed plugin to load again on Windows XP. The registry functions broke it for 7.2.
  • Fixed problem where variable name check would complain about variable name being part of script name.
  • Fixed RemoteControl.ClickMouse to not move mouse on Mac for 0/0 coordinate.
  • Improved formula coloring in calculation dialog to handle better various quote characters.
  • Improved Math.BitwiseAND, Math.BitwiseOR, Math.BitwiseNOT, Math.BitwiseXOR, Math.BitwiseShiftRight and Math.BitwiseShiftLeft to use 64-bit integers instead of 32-bit.
  • Improved SNMP.Get function to report errors better.
  • Improved speed of XML functions.
  • Improved XML parsing for huge XML texts.
  • Reduced memory consumption for email sending, so you can now queue 1000+ emails.
  • The Notification functions on Mac can now pass JSON payload.
  • Updated discount library to version 2.2.2
  • Updated DynaPDF library to version 4.0.11.31.
  • Updated libPNG to version 1.6.30.
  • Updated OpenSSL to 1.1.0f and 1.0.2l
  • Updated SQLite to 3.19.3.
  • Updated to FileMaker 16.0.2 SDK.
  • Zooming in script workspace can now be triggered with Command and Plus/Minus keys.

New in MBS FileMaker Plugin 6.4 (Sep 27, 2016)

  • New function in 6.4
  • Added ImageCapture functions to replace TWAIN on Mac.
  • Added contextual menu commands for copy/paste to script workspace and other list controls.
  • Added Container.ReadFile and Container.WriteFile.
  • Added BigEndian parameter for Math.EncodeNumber and Math.DecodeNumber.
  • Added Dialog.AddField, Dialog.ClearFields, Dialog.GetFieldText and Dialog.SetFieldText.
  • Added DynaPDF.CreateButton.
  • Added DynaPDF.CreateJSAction and DynaPDF.AddActionToObj functions.
  • Added DynaPDF.GetBBox function.
  • Added DynaPDF.GetColorSpaceInfo to query details on a color space.
  • Added DynaPDF.GetImage and DynaPDF.GetImageCount.
  • Added DynaPDF.ListImages function to list images in a PDF file.
  • Added DynaPDF.OpenOutputFileEncrypted.
  • Added EmailParser.ReceiveDate and renamed EmailParser.Date to EmailParser.SentDate.
  • Added Files.AddedToDirectoryDate function.
  • Added FM.GetSQLBatchMode and FM.SetSQLBatchMode functions to speed up some SQL inserts.
  • Added FM.SQL.InsertRecords function to insert records from FileMaker within FileMaker.
  • Added FM.SQL.InsertRecordsToSQL function insert records from FileMaker to SQL Database.
  • Added IKSlideShow.ItemAtIndex and IKSlideShow.Count. Function IKSlideShow.Clear now can optionally take index parameter.
  • Added IKSlideShow.SetScreen, IKSlideShow.GetScreen, IKSlideShow.GetAudioFile and IKSlideShow.SetAudioFile.
  • Added LDAP.AddList and added more parameters for LDAP.Add.
  • Added List.HasValue function.
  • Added Math.DecodeNumber and Math.EncodeNumber.
  • Added PHP.GetResultContainer function.
  • Added ProgressDialog.Reset function.
  • Added RichText.ReplaceTexts function.
  • Added RunTask.Wait function.
  • Added Schedule.ReleaseAll function.
  • Added SmartCard.HeaderTemplate function and fixed bugs in SmartCard.Transmit function.
  • Added SQL.GetCommandTag, SQL.GetConnectionTag, SQL.SetCommandTag and SQL.SetConnectionTag.
  • Added SQL.ListCommands and SQL.ListConnections.
  • Added Text.Speak.AvailableVoices function.
  • Added Time.Format function to format time, date or timestamp.
  • Added Time.Parse function.
  • Added Toolbar.SetImage, Toolbar.SetLabel, Toolbar.SetPaletteLabel, Toolbar.SetTooltip.
  • Added transparent as a possible color value for GraphicsMagick.
  • Added Webview.GetInternetExplorerVersion and Webview.SetInternetExplorerVersion.
  • Changed Addressbook to more often return unique ID more often instead of our own IDs.
  • Changed email functions to return error if you pass email address, subject or message ID including newline character.
  • Changed EmailParser to ignore an erroneous From line on top of email.
  • Changed FileDialog.SelectFolderDialog to support multiple selection on Windows Vista and newer.
  • Changed plugin to show dialogs when using expired license key.
  • Changed ServerSocket functions to provide service via IPv6 and IPv4. That solves the problem when ServerSocket in 6.3 tried to connect via IPv6 to a IPv4 socket.
  • Changed SQL.NewCommand and SQL.NewConnection so you can pass your own ID instead of getting one from plugin.
  • Changed trace feature to not log calls to Log function.
  • Changed Twain plugin to also load TwainDMS if Twain is not available. This allows you to install open source twain for 64-bit.
  • Fixed a bug for Japanese with Set Variable checking.
  • Fixed a calendar issue with OS X 10.8 or older.
  • Fixed a few minor memory leaks.
  • Fixed a problem with some XML with XML.Import where no fields where imported.
  • Fixed bug in FM.StopScriptIdle function.
  • Fixed bug in PortMidi.OpenOutput function.
  • Fixed Dialog.AddField to work on OS X 10.9 or older. Also fixed black label background for FileMaker 11.
  • Fixed duplicate detection for Text.ReplaceNewline.
  • Fixed IKSlideShow.SetMode function.
  • Fixed issues on Windows with Files.CopyFile and Files.Delete.
  • Fixed ListDialog.SetSelectedTitle. (broken in 6.3)
  • Fixed memory leak in blob passing for SQL functions.
  • Fixed ProgressDialog layout for Windows.
  • For DynaPDF.RenderPDFFile and DynaPDF.RenderPage you can now specify flags as text instead of only number.
  • Loading PHP now returns better error on Mac.
  • Plugin works again fine on Windows XP with FileMaker 10.
  • Rewrote AppleScript functions for better 64-bit compatibility.
  • Rewrote Files.List and Files.ListRecursive functions.
  • The dialog functions now set the dialog title on Mac, too.
  • Trace now logs duration in seconds for long running SQL commands.
  • Updated OpenSSL to 1.0.2i
  • Updated plugin for future FileMaker versions.
  • Updated SQLite to 3.14.2.
  • Updated to DynaPDF 4.0.3.9

New in MBS FileMaker Plugin 6.4 Prerelease 1 (Jul 20, 2016)

  • Updated to DynaPDF 4.0.2.4
  • Added DynaPDF.GetColorSpaceInfo to query details on a color space.
  • Added DynaPDF.ListImages function to list images in a PDF file.
  • Fixed a problem with some XML with XML.Import where no fields where imported.
  • Added DynaPDF.OpenOutputFileEncrypted.
  • Plugin works again fine on Windows XP with FileMaker 10.
  • Changed ServerSocket functions to provide service via IPv6 and IPv4. That solves the problem when ServerSocket in 6.3 tried to connect via IPv6 to a IPv4 socket.
  • Added DynaPDF.GetBBox function.
  • Added Math.DecodeNumber and Math.EncodeNumber.
  • Added transparent as a possible color value for GraphicsMagick.

New in MBS FileMaker Plugin 6.3 (Jul 18, 2016)

  • Added SSH functions
  • Added Text.Speak function
  • Added Clipboard.GetPicture and Clipboard.SetPicture
  • Added ColorTolerance parameter for DynaPDF.ShowDifference
  • Added CUPS.PrintDataEncoding function
  • Added CURL.GetDebugWithProgress and CURL.SetDebugWithProgress functions
  • Added DynaPDF.AppendImagePage and DynaPDF.AppendImagePages
  • Added EmailParser.ParseContainer function
  • Added EventMonitor.GetEnabled and EventMonitor.SetEnabled
  • Added Files.CreateHardLink and Files.CreateSymbolicLink
  • Added FM.DataViewerContent function
  • Added FM.MouseWheelScriptTrigger function
  • Added GMImage.GetXMP and GMImage.SetXMP
  • Added JSON.IsValid function
  • Added List.DeCombine function
  • Added Menubar.IsMenuCommandChecked function
  • Added MenuItem.GetSelectable and MenuItem.SetSelectable functions
  • Added new flag to XML.Query to ignore namespaces and do the queries without them
  • Added SmartCard functions
  • Added SQL.FreeAllConnections
  • Added SyntaxColoring.GetRelationGraphSearchBoxPreferredSize and SyntaxColoring.SetRelationGraphSearchBoxPreferredSize
  • Added SystemInfo.WinSystemMetrics function
  • Added WebView.Passwords.Clear, WebView.Passwords.Install and WebView.Passwords.Set to provide passwords for web authentication in webviewer
  • Added Window.GetCurrentTag, Window.GetTag, Window.SetCurrentTag and Window.SetTag
  • Added WordFile.GetMediaFile, WordFile.MediaFiles and WordFile.SetMediaFile functions
  • Changed Barcode.Detect to better detect barcodes which have no whitespace around
  • Changed Files.Delete to accept a list of paths
  • Changed Files.RevealFile, so you can pass a list of paths on Mac
  • Fixed an issue where XML.Query would respond with two ?xml lines with encodings
  • Fixed bug with StoreRegistration function so it now works again
  • Fixed for GraphicsMagick to change resolution to DPI and not just return cm resolution as DPI
  • Fixed PortMidi.GetDeviceInfo's Name property to correctly handle special characters on Mac
  • Improved CURL.GetResultAsContainer to detect extension based on mime type
  • Improved internal item management. Now quicker to find object for item which you notice in menu building for example
  • Improved menu functions to work better in calculations, so you can show a menu with just one Let statement
  • Improved speed of Menu.DefineQuickMenu a lot
  • The events functions now look for events ±4 years in the database if we don't find them by ID
  • The script search box is now hidden if you disable Syntax Highlighting
  • Updated to DynaPDF 4.0.1.3
  • We now convert line endings for SSH and RSA keys to LF to avoid errors reading keys with CR line endings

New in MBS FileMaker Plugin 6.2 (May 24, 2016)

  • New function in 6.2:
  • Added AVExport.ExportSessionMerge function
  • Added AVRecorder.CaptureStillPhoto function
  • Added CURL.GetDebugWithData, CURL.GetDebugWithTime, CURL.SetDebugWithData and CURL.SetDebugWithTime
  • Added CURL.LibSSHVersion function
  • Added date sorting mode for List.Sort and QuickList.Sort
  • Added delimiter parameter to QuickList.GetList
  • Added Dialog options to not have a designated cancel/default button
  • Added Dictionary.SetList function
  • Added DynaPDF.ExtractPageRectText function
  • Added Events functions to query Reminders and Events on Mac OS X in 64-bit application
  • Added filename parameter for FM.QueryBaseTableNames, FM.QueryFieldsForBaseTableName, FM.QueryFieldsForTableName and FM.QueryTableNames
  • Added Files.FolderSize function
  • Added Files.GetComment and Files.SetComment
  • Added Files.GetFinderLabel and Files.SetFinderLabel
  • Added FM.InsertSetUpdateProgressDialog to allow FM.InsertRecordQuery, FM.InsertRecordQueryIgnoreDuplicates and FM.InsertRecordTSV to show progress
  • Added Folders.UserDownloads function
  • Added GMImage.GetiptcProfileValues
  • Added Menubar.RemoveMenuCommand function
  • Added mode to Window.RemoveMenu to clear menu
  • Added more evaluate calls: Addressbook.Notification.Evaluate, Calendar.Notification.Evaluate, CoreLocation.SetFailEvaluate, CoreLocation.SetUpdateLocationEvaluate, Dialog.GetSheetEvaluate, Dialog.SetSheetEvaluate, Events.SetNotificationEvaluate, FSEvents.GetEvaluate, FSEvents.SetEvaluate, SerialPort.SetDataAvailableEvaluate, Socket.SetDataAvailableEvaluate, Socket.SetErrorEvaluate and Socket.SetNewConnectionEvaluate
  • Added more PrintDialog functions for copies and first/last/all pages
  • Added new mode for List.Crossproduct to combine each item from left list with right list
  • Added PrintDialog.ClearOption, PrintDialog.ClearOptions, PrintDialog.GetLastSettings, PrintDialog.GetOption, PrintDialog.SetOption to set low level print options
  • Added QuickList.SortWith function
  • Added RemoteControl.PressDialogButton command
  • Added RightShift, RightOption and RightControl for hotkey registration as modifiers
  • Added RSA.GeneratePrivateKey and RSA.GetPublicKey
  • Added RSA.PrivateDecrypt, RSA.PrivateEncrypt, RSA.PublicDecrypt and RSA.PublicEncrypt
  • Added RSA.Sign and RSA.Verify
  • Added scale parameter for DynaPDF.ShowDifferences
  • Added Schedule.GetLastTimeStamp
  • Added SQL.GetFieldAsContainer and SQL.GetParamAsContainer
  • Added the possibility to add more parameters for FM.InsertRecordTSV
  • Added Webview.AllowsAnyHTTPSCertificateForHost to allow ignoring bad SSL certificates
  • Added Webview.PressKey function to press @ key on Windows. Works also on Mac/Win to press other keys
  • Added Window.Scrollbar.getHorizontalMaximum, Window.Scrollbar.getHorizontalPosition, Window.Scrollbar.getVerticalMaximum, Window.Scrollbar.getVerticalPosition and Window.Scrollbar.set
  • Added WordFile.GetXML and WordFile.SetXML functions
  • Added WordFile.Parts function and Part options to WordFile functions. Now can replace placeholders in footer/header, too
  • Added XML.Canonical and XML.Format
  • Changed Files.ListRecursive on Mac to include trailing slash in folder paths
  • Changed Schedules to not fire in layout mode
  • Changed SendMail.AddAttachmentContainer and SendMail.AddAttachmentFile to have file name optional. We can use file name from container or file path. Mime type is detected from file extension if needed
  • Changed SerialPort.List to return on Mac the full device name which may include an ID to make it unique if you have several devices with same name. The SerialPort.Open function accepts full name and shorter name
  • Dialog functions now set Parent window on Windows to make sure the dialog doesn't go behind your FileMaker window
  • Fixed a bug where debug messages would log too much data
  • Fixed a text encoding problem on Mac with Log method. Now umlauts show properly
  • Fixed an issue in WordFile functions to handle more special cases
  • Fixed an issue with ODBC and SQL functions read CLOB fields
  • Fixed an issue with releasing objects on shutdown
  • Fixed bug for SQL.SQLite3.SetKey
  • Fixed bug in DynaPDF.SetReplaceICCProfile
  • Fixed bug in FM.InsertRecord with handling container
  • Fixed bug in FM.InsertRecordTSV for handling extra fields and more columns in some lines
  • Fixed bug in XML.Query to not return too many text when returning text lists
  • Fixed bug with creating dataMatrix barcodes
  • Fixed bugs in RemoteControl.ClickMouse for Windows
  • Fixed Events functions so you can specify calendar by it's name
  • Fixed issue where plugin didn't load on Windows XP or Windows Server 2003
  • Fixed XML.Import.Cancel to clear the insert command list, too
  • For evaluate, if we have an ID available, we replace $$ID$$ in expression with our ID, so you can use it
  • Improved DynaPDF.ShowDifference to better handle transparent areas and recognize smaller changes
  • Improved session handling for future Server versions
  • Improved XML.Import to better handle extra tables for attributes
  • Rewrote dialog function. Now icon, timeout and custom button names work
  • Rewrote Window.SetTitleIcon. No longer needs a separate mask image. Now takes an image with alpha channel and creates nicer icons
  • The Menu code for Windows now better handles transparency
  • The ProgressDialog image for Windows is now using transparency correctly
  • Updated CURL to version 7.47.1
  • Updated DynaPDF to version 3.0.52.156
  • Updated libJPEG to version 9b
  • Updated LibSSH2 to version 1.7.0
  • Updated SQLAPI++ 4.1.9
  • Updated SQLite to 3.13.0
  • Updated Windows to also use latest SSH/SSL

New in MBS FileMaker Plugin 6.1 (May 24, 2016)

  • New function in 6.1:
  • Added Addressbook.multivalue.identifiers, Addressbook.multivalue.labels, Addressbook.multivalue.valueForLabel and Addressbook.multivalue.values.
  • Added Addressbook.person.ExternalUID and Addressbook.searchPersonWithExternalUID to help with CardDAV servers.
  • Added App.CancelUserAttentionRequest and App.RequestUserAttention.
  • Added asText parameter for Addressbook.person.vCardRepresentation.
  • Added AVExport functions to convert video files on Mac.
  • Added AVRecorder functions to record audio/video.
  • Added CLGeocoder.Distance function.
  • Added CURL.GetFinishedEvaluate, CURL.GetProgressEvaluate, CURL.SetFinishedEvaluate, CURL.SetProgressEvaluate, HotKey.GetEvaluate, HotKey.SetEvaluate, Menu.GetEvaluate, Menu.SetEvaluate, MenuItem.GetEvaluate and MenuItem.SetEvaluate.
  • Added Dictionary.Clone, JSON.Clone and QuickList.Clone.
  • Added Dictionary.ToJSON, Dictionary.ToText and Dictionary.ToXML.
  • Added FM.InsertOrUpdateRecord2 and FM.InsertOrUpdateRecord3.
  • Added highlighting of If/Loop blocks for Mac in FM 14 or newer.
  • Added IsIOS, IsLinux, IsMacOSX and IsWindows functions.
  • Added JSON.SetPathValue, JSON.GetPathValue and JSON.GetValue function.
  • Added List.AddPostfix, List.AddPrefix, List.CrossProduct, List.RemovePostfix and List.RemovePrefix.
  • Added Menubar.SetMenuCommandTitle function.
  • Added QTExport functions to convert video files with QuickTime in 32-bit FileMaker.
  • Added QuickList.AddPostfix, QuickList.AddPrefix, QuickList.CrossProduct, QuickList.RemovePostfix, QuickList.RemovePrefix.
  • Added SendMail.ClearHeaders function.
  • Added SyntaxColoring.GetScriptIfColor, SyntaxColoring.GetScriptLoopColor, SyntaxColoring.GetScriptSearchColor, SyntaxColoring.SetScriptIfColor, SyntaxColoring.SetScriptLoopColor and SyntaxColoring.SetScriptSearchColor.
  • Added SyntaxColoring.SetUseBoldFont to disable bold font in syntax coloring. This helps some asian users who don't see brackets.
  • Added Text.RemovePrefix and Text.RemovePostfix.
  • Added Window.ClearFocus.
  • Added Window.FlashWindow.
  • Added DynaPDF.GetReplaceICCProfile and DynaPDF.SetReplaceICCProfile.
  • Changed JSON functions to better detect invalid JSON text.
  • Changed JSON to return JSON text now with Char(13) for newline delimiter.
  • Changed ProgressDialog functions to return an error if called on server.
  • Fixed bug in XL.Sheet.CellReadBlank.
  • Fixed a bug in ZipFile.CompressFiles for Windows.
  • Fixed a bug with Encryption.Cipher.
  • Fixed bug in Dictionary.Serialize.
  • Fixed issue with LDAP.Bind not working correctly on Windows for all auth methods.
  • Fixed JSON.GetArrayItemsAsList function.
  • Fixed QuickList.HasValue function.
  • Fixed ZipFile.CompressFiles to handle no password case better.
  • Improved Syntax Highlighting to support setting variable with Get Directory script step.
  • Improved error messages on Windows for Save/Open Dialogs.
  • Improved socket implementation with better ID handling.
  • Improved Syntax Highlighting to support setting variable with Get Directory script step.
  • Removed GraphicsMagick signal handlers so the plugin doesn't show up in crash reports on Mac when crashing.
  • Trace now also prints out details on evaluate.
  • Updated DynaPDF to version 3.0.50.150.
  • Updated OpenSSL to 1.0.2f
  • Updated SQLite to 3.11.0.
  • You can now pass text for the flags to DynaPDF.SetImportFlags and DynaPDF.SetImportFlags2.
  • You can now set HandleResult property for SQL Connection and it propergates to SQL Command objects automatically (like PreFetchRows, Scrollable, CommitRetaining and SQL_ATTR_QUERY_TIMEOUT).

New in MBS FileMaker Plugin 6.0 (Feb 6, 2016)

  • Rewrote most of JSON so you can now optionally use JSON reference numbers for JSON objects for faster processing.
  • Added DNSLookup functions.
  • Added LDAP functions.
  • Added Clipboard.GetHTMLText and Clipboard.SetHTMLText.
  • Added Content option for DynaPDF.GetEmbeddedFile function.
  • Added contextual menus to most tables in FileMaker on Mac to copy content of table.
  • Added DynaPDF.AssociateEmbFile, DynaPDF.AttachFile and DynaPDF.AttachContainer functions to embed XML for PDF invoices.
  • Added DynaPDF.GetTextDrawMode and DynaPDF.SetTextDrawMode.
  • Added DynaPDF.Optimize function.
  • Added example for Solution Registration via elliptic curve signature.
  • Added Flags parameter for Hash.MD5.HMAC, Hash.PBKDF2.HMAC, Hash.SHA1.HMAC, Hash.SHA256.HMAC and Hash.SHA512.HMAC so you can define if input is Hex encoded or not.
  • Added FM.DeleteRecord and FM.DeleteRecords functions.
  • Added FM.InsertRecordQueryIgnoreDuplicates function.
  • Added FM.UpdateRecord and FM.InsertOrUpdateRecord functions.
  • Added FM.UpdateRecords functions.
  • Added JSON.AddBooleanToObject and JSON.CreateBoolean functions.
  • Added JSON.Release, JSON.CreateArrayRef, JSON.Parse and JSON.CreateObjectRef functions.
  • Added more FSEvents functions.
  • Added more options for QuickList.MatchesPostfix and QuickList.MatchesPrefix.
  • Added more path functions.
  • Added new function DynaPDF.ExtractText to extract text of whole document.
  • Added new optional ScriptParameter parameter to MenuItem.SetScriptAction and Menu.SetScriptAction.
  • Added new parameters for DynaPDF.ReplacePattern: TextScaling and TextRise.
  • Added Preferences.HasValue and Preferences.DeleteValue functions.
  • Added QuickList.MatchesSubString function.
  • Added SyntaxColoring.ContextualMenuEnabled.SetEnabled and SyntaxColoring.ContextualMenuEnabled.GetEnabled functions.
  • Added UnZipFile.ExtractFiles and ZipFile.CompressFiles functions.
  • Added Window.GetTitleVisible, Window.GetTitlebarAppearsTransparent, Window.SetTitleVisible and Window.SetTitlebarAppearsTransparent.
  • Added Window.Maximize and Window.Minimize.
  • Added Window.ResizeContentView.
  • Changed script trigger functions. If you pass script name which is only digits, we lookup the script name for this script ID for you and trigger it.
  • Changed a lot of .Release functions to accept a list of reference numbers, e.g. PDFKit.Release
  • Changed calculation formatting to not format very long texts. New limit is 30000 characters.
  • Changed goto line to animate and jump to the middle.
  • Changed JSON.Add* functions to allow multiple parameters to be passed to add a lot of values.
  • Changed plugin to return container values with GIF images always now without JPEG preview. FileMaker doesn't need it.
  • Changed plugin to return JPEG preview for containers with PNG images only in FileMaker 11 and older.
  • Changed plugin to use DynaPDF if initialized to render PDF preview images for PDF in container on Windows. This allows FileMaker to show preview on Windows. For Mac we render them using PDFKit.
  • Changed QTMovie.OpenContainer to work better with MP3 files.
  • Changed Search Field in scripts. When you close script editor, the search is reset.
  • Changed Syntax Coloring. Unless you open a script editor, relation graph window or debugger, we keep the colors off. This should avoid your clients see colors in text or search fields.
  • Fixed a bug in FM.StopScriptIdle and in FM.RunScriptIdle.
  • Fixed a memory leak in the internal function to query idle time on Mac.
  • Fixed a problem in email parsing to not mark some inline text segments as attachments.
  • Fixed bug in ECKey.Verify.
  • Fixed bug in FM.SQL.Field function.
  • Fixed bug in ServerSocket.SendQuery when reporting connection errors.
  • Fixed bug in Syntax Coloring to make sure some letters like a single a is no longer red.
  • Fixed FM.InsertRecordQuery to copy containers, too.
  • Fixed FM.RunDataDesignReport to work better if save dialog is slow to list files.
  • Fixed Plugin.Path function for Windows.
  • Fixed problem in QuickList.MatchesSubString not splitting right.
  • Fixed RichText.ReplaceText to replace more than 100 items.
  • Fixed RichText.WriteContainer to use filename parameter correctly.
  • For addressbook properties and labels you can now both pass with or without kAB prefix. So kABUIDProperty and UIDProperty work now.
  • For PDFKit.Combine and PDFKit.CombineRef the PDFs parameters can also be lists of paths or reference numbers.
  • Improved error message when loading a library file fails.
  • Improved XML.Import for some special XMLs.
  • Removed debug messages for launch of plugin.
  • Updated DynaPDF to version 3.0.48.143.
  • Updated libXL library to version 3.6.5.2.
  • Updated openssl to 1.0.2e.
  • Updated Runtime Shrinker to version 2.0 for FileMaker 11 to 14.
  • Updated SQLAPI++ 4.1.7.
  • Updated SQLite to version 3.10.2.
  • Updated to newer plugin SDK.
  • When copying scripts, the plugin now adds links to MBS plugin reference automatically.

New in MBS FileMaker Plugin 5.4 (Nov 24, 2015)

  • Added FSEvents functions.
  • Added WordFile functions.
  • Added elliptic curve key generation for public and private keys and functions to sign and verify digital signatures.
  • Added JavaScript functions for Mac.
  • Added search field for relationship graph dialog.
  • Added search field for script editor on Mac. Highlights lines with matching visible text in yellow.
  • Added "cent variable name" tag for syntax coloring.
  • Added a new tag for syntax coloring so you can define field color, and, or, not and xor colors for calculations.
  • Added Addressbook.person.SetBirthdayComponents function.
  • Added Addressbook.recordsMatchingSearchElement, Addressbook.searchElementForConjunction and Addressbook.searchElementForProperty to make complex searches in addressbook.
  • Added Audit.GetIgnoreSummaryFields and Audit.SetIgnoreSummaryFields.
  • Added AVAsset.TimeCodes function.
  • Added CURL.List function.
  • Added CURL.SetOptionLoginOptions.
  • Added DynaPDF.Print function to print PDF on Windows.
  • Added EmailParser.Date, EmailParser.Hash, EmailParser.Source and EmailParser.SourceWithoutAttachments functions.
  • Added Encoding parameter for Barcode.Detect.
  • Added Files.CanOpenFile function.
  • Added flags parameter to XML.Query to get result as text list, enable/disable formatting.
  • Added HotKey.GetEnabled, HotKey.GetIgnoreOnModal, HotKey.SetEnabled and HotKey.SetIgnoreOnModal.
  • Added HotKey.GetLocal or HotKey.SetLocal to limit hotkeys to only FileMaker.
  • Added HotKey.GetName, HotKey.GetTag, HotKey.SetName and HotKey.SetTag.
  • Added JSON.Import functions.
  • Added List.MatchesPostfix, List.MatchesPrefix, List.ValueIndex, QuickList.MatchesPostfix, QuickList.MatchesPrefix and QuickList.ValueIndex.
  • Added new color parameter for DynaPDF.ShowDifferences and changed function to return number of annotations.
  • Added new keys OwnerPassword, UserPassword, EncryptionKeyLength, AllowsPrinting and AllowsCopying for PDFKit.GetPDFAttribute and PDFKit.SetPDFAttribute.
  • Added plugin reference as PDF file.
  • Added Plugin.LimitFunction, Plugin.LockFunction and Plugin.UnlockFunction.
  • Added RichText.ReadWebviewer function.
  • Added selector parameter for XML.Import.Todo and JSON.Import.Todo.
  • Added SerialPort.CloseAll.
  • Added support for RC5 cipher.
  • Added SyntaxColoring.GetScriptHighlightColor and SyntaxColoring.SetScriptHighlightColor to have plugin overlay the selection in script editor and provide a selection color with more contrast.
  • Added Text.FileExtensionToMimeType and Text.MimeTypeToFileExtension functions.
  • Added Text.Serialize and Text.Deserialize.
  • Added Window.Fade function.
  • Added Window.ModalDialogFront function.
  • Added Window.Screenshot function.
  • Added XL.Book.DeleteSheetsExcept, XL.Book.SheetIndexForName and XL.Book.Sheets.
  • Added XML.Import.Work and JSON.Import.Work.
  • Changed Menubar.SetMenuCommandVisible to remove menu items on Windows.
  • Changed SerialPort DataAvailable Script. Ones you got a script triggered, you must use Read command to actually get data before the plugin will trigger the script again. This should help debugging and avoid scripts being triggered too often.
  • Changed SQL functions returning Date to check if date is empty and return empty result in that case.
  • Changed Text.TextToHTML and Text.TextToRTF to include font.
  • Entering multi line text in search field for script search now searches for several words. Use Control-Enter to type a newline there.
  • Fixed a bug in PDFKit.GetPDFPagesPDFRef with ranges of pages.
  • Fixed a bug in Twain where driver would request a higher preferred buffer size than the maximum buffer size.
  • Fixed a crash in UnZipFile.OpenContainer when container does not contain a valid zip file.
  • Fixed a problem with SQL Execute called in FileMaker 11.
  • Fixed an edge case where email subjects where not always decoded properly.
  • Fixed an issue with WebView.LoadHTML called without URL.
  • Fixed bug in window ID handling on Mac.
  • Fixed bug with container processing when containing a MAIN item.
  • Fixed crash in JSON.GetObjectNameList when passing an array.
  • Fixed crash with SerialPort functions on Mac.
  • Fixed parameter passing for FM.InsertRecordQuery.
  • Fixed PrivilegeSetName field for audit logging so it is now logged.
  • Fixed Window.HideScrollbars to work better for FileMaker 14.
  • For our new search fields, the escape key now clears the field content.
  • Improved email generation for related/alternative content.
  • Improved email parser to detect errors better like BOM characters.
  • Improved Window.Move and Windows.Resize on Windows to animate better.
  • Recompiled CURL with max buffer size of 1 MB. OptionBufferSize is set to 16K as before, but you can now change it to bigger buffer.
  • Same for Sockets with Error, DataAvailable and NewConnection script triggers.
  • The colors for AND, OR, NOT and XOR now also apply for localized variants.
  • Updated DynaPDF to version 3.0.46.135.
  • Updated SQLite to 3.9.2. Now with FTS5 and JSON extensions enabled.
  • Updated TinyMCE example to version 4.2.6.
  • Updated to Xcode 7.1.

New in MBS FileMaker Plugin 5.3 (Oct 6, 2015)

  • Added Container.Compress and Container.Decompress functions.
  • Added functions for email parsing and an email receiving example.
  • Added new XML.Import functions.
  • Added FM.InsertRecordTSV function.
  • Added CMYK options for DynaPDF.RenderPage and DynaPDF.RenderPDFFile.
  • Added compressed option for Files.ReadFile function.
  • Added DynaPDF.GetGStateFlags and DynaPDF.SetGStateFlags functions.
  • Added DynaPDF.InitColorManagement function.
  • Added DynaPDF.ShowDifferences function.
  • Added internal SQLite library which you can activate and no longer need to provide sqlite dll/dylib.
  • Added more modes to auto, pdf, png, jpg, tif, gif, bmp or psd.
  • Added new Audit example showing audit log changes in portal.
  • Added new index parameter for SerialPort.Open function.
  • Added new parameter for List.RemoveDuplicateItems to remove all duplicates without leave one.
  • Added new socket functions: Socket.GetBroadcast, Socket.GetMulticastLoop, Socket.GetMulticastTimeToLive, Socket.GetTimeToLive, Socket.SetBroadcast, Socket.SetMulticastLoop, Socket.SetMulticastTimeToLive and Socket.SetTimeToLive.
  • Added QuickList.List and RegEx.List to list IDs of current lists or regular expressions.
  • Added Social and SocialRequest functions to use OS X social accounts like Twitter or Facebook.
  • Added some Windows support for URLScheme.SetDefaultHandler.
  • Added SQL.GetRecordsAsText function.
  • Added Text.ReadEMLXFile function.
  • Added Window.AddBottomOverlay function.
  • Changed Files.Launch to accept more than one file as parameter.
  • Changed RegEx.Match to return empty result instead of error for now match.
  • Changed SystemInfo.isWindows8 to return true for 8.1, too.
  • Changed Files.Delete to use newer API.
  • Changed Text.DecodeFromHex to ignore a prefix 0x in the text.
  • Changed window functions to once again accept three ways: Empty parameter or zero for front window, ID number for Window reference or title of any window.
  • Fixed a bug in WebView.Screenshot with use of more than one display on Mac.
  • Fixed a bug with SystemInfo.OSVersionString not reporting Windows 10.
  • Fixed a problem with Calendar functions running out of memory.
  • Fixed bug in DropView which was not removed properly on closing from the window.
  • Fixed bug in DynaPDF.RenderPage which prevented use of resolution = 0 for using fixed size.
  • Fixed bug in PHP plugin which caused crash with phpinfo function.
  • Fixed bug in RichText.ReplaceText which now works with empty text.
  • Fixed bug with sending emails. Inline graphics were not embedded correctly.
  • Fixed problem in UnZipFile.ReadToFile with zero length compressed files.
  • In Addressbook API you can now specify the group by name instead of ID.
  • Rewrote PHP plugin part to use PHP version 5.6.12 and work with 64-bit.
  • The internal SQLite library now includes the SQLite Encryption Extension.
  • Updated CURL to version 7.44.0.
  • Updated DynaPDF to version 3.0.43.130.
  • Updated Files.MoveToTrash to use newer API to work better on OS X 10.8 and newer.
  • Updated libcpuid.
  • Updated libXL to version 3.6.4.
  • Updated openssl to 1.0.2d.

New in MBS FileMaker Plugin 5.2 (Oct 6, 2015)

  • Added Schedule functions.
  • Added asynchronous CURL transfers.
  • Added AVAsset functions to use OS X functions for getting images and metadata for movies.
  • Added EventMonitor functions to check if which button the last mouse click used.
  • Added MatrixDongle functions.
  • Added Windows support for HotKey functions and a few more functions.
  • Added Text.Characters, Text.ConvertUnicodeToCharacterComposition and Text.ConvertUnicodeToCharacterDecomposition.
  • Added "underscore variable name" and "tilde variable name" tags for syntax coloring.
  • Added code to overwrite FileMaker overwriting our drag cursors. So DragDrop.SetCursor does again do its job.
  • Added CURL.GetResultAsContainer function.
  • Added Dialog.SetTimeout for Mac to hide dialog after some time.
  • Added Dictionary.List function.
  • Added DynaPDF.GetInMetadata, DynaPDF.GetMetadata and DynaPDF.SetMetadata.
  • Added DynaPDF.GetOutputIntent and DynaPDF.GetOutputIntentCount functions.
  • Added EventMonitor.LastMouseClickIsDoubleClick function.
  • Added Files.FileExtension function.
  • Added FM.VariableClearAll function.
  • Added functions for serialize and deserialize for container, dictionary and lists: Container.Deserialize, Container.Serialize, Dictionary.Deserialize, Dictionary.Serialize, List.Deserialize, List.Serialize, QuickList.Deserialize and QuickList.Serialize.
  • Added Menu.DefineQuickMenuXML function.
  • Added more CURL functions.
  • Added mutex so trace logs don't mess up on server with multiple threads logging.
  • Added NetworkInterfaces.Default function.
  • Added new mode to CURL.GetResultAs* functions to use the file name from URL if you don't provide one.
  • Added new print options for WebView.SetPrintParameter: PaperName, PaperWidth and PaperHeight.
  • Added Notification.SendDirect function.
  • Added parameter for DynaPDF.ReplacePattern for alignment.
  • Added parameters for Files.Mount function for showing dialogs while mounting.
  • Added ProcessActivity.beginActivity and ProcessActivity.endActivity.
  • Added RichText.ReadHTML and RichText.ReadRTF functions.
  • Added SQL.InsertRecords function.
  • Added SyntaxColoring.CopyButton.GetEnabled and SyntaxColoring.CopyButton.SetEnabled functions to switch copy button on/off.
  • Added SystemInfo.IsAdminUser function.
  • Added SystemInfo.isWindows10 function.
  • Added Text.Character and Text.Code functions.
  • Added Text.InvalidCharactersForEncoding function.
  • Added Text.RedefineEncoding function.
  • Added Window.Current function.
  • Changed CURL plugin to turn off VerifyHost and VerifyPeer if you didn't set them or provided certificates. This should avoid beginner mistakes.
  • Changed CURL to set Verbose option on by default.
  • Changed Files.Mount on Windows to load required DLL dynamically, so plugin loads on older Windows versions.
  • Changed IsError function to be more thread safe and work better on FileMaker server.
  • Changed responses from ServerSocket via HTTP to request client to not cache responses.
  • Changed ServerSocket.SendQuery to have a 3 second connect timeout.
  • Changed syntax coloring to not color text black unless we have something to format like a bracket. This way you should normally not see syntax coloring in field picker.
  • Changed Text.WriteTextFile and others to better handle null characters in text.
  • Changed the variable declaration check to show user notification, because we can't show it inline for FM 14.
  • Changed Windows plugin to no longer link directly to Mpr.dll and Rpcrt4.dll
  • Fixed an issue with Dialog functions where Dialog.SetButtons overwrote on Mac the buttons.
  • Fixed an issue with Syntax Coloring on FM 14.
  • Fixed AVAsset.MetadataKeys to work on Mac OS X 10.9 and older.
  • Fixed bug for Menu.SetFontSize, so that entries with custom font are not always bold and italic.
  • Fixed bug in GMImage.NewFromBase64.
  • Fixed bug in Text.InvalidCharactersForEncoding.
  • Fixed bug with Dictionary.AddSQL's parameter passing.
  • Fixed copy button to copy even lines not currently visible in FileMaker 14.
  • Fixed Drag and Drop for Emails for OS X 10.10.x where Apple changed it a little bit.
  • Fixed handling of separators in Menu.DefineQuickMenu function.
  • Fixed indexed for parameters to WebView.Screenshot function.
  • Fixed issue on Windows where plugin did not load on older Windows versions.
  • Fixed issues with TWAIN plugin by working more asynchronously. This helps getting plugin work with drivers it did not work before. But the modal parameter is no longer used.
  • Fixed problem in QTMovie.Release function.
  • Fixed ProgressDialog.Show to reset Cancel flag on Windows, too.
  • Fixed RemoteControl.MouseY function for FM14.
  • Fixed some list functions to not return a newline character on the end if told to do so.
  • Fixed SyntaxColoring.Disable for FileMaker 14 to actually disable script colors.
  • Fixed text encoding bug with Text.EncodeToXML function.
  • Fixed text encoding for JSON.GetArrayItemsAsList.
  • Fixed variable declaration check for FileMaker 14.
  • For CURL.GetHeaderAsText, CURL.GetDebugAsText, CURL.GetInputAsText and CURL.GetResultAsText we now always fix line endings for you.
  • Implemented better caching for calendar objects.
  • Optimized away some debug details on Windows plugin, saving 100 KB in plugin size.
  • Plugin builds with Xcode 7 on 10.11 beta. Fixed a few minor problems detected by newer analyze function.
  • Updated DynaPDF to version 3.0.40.122.
  • Updated system information functions to properly detect Windows 10.
  • Upgraded Xcode to version 6.3.2
  • When using QuickMenu functions we now release any menu with same name defined before.

New in MBS FileMaker Plugin 5.1 (May 19, 2015)

  • Added MarkDown functions.
  • Added EnvironmentVariables functions.
  • Added grouping to ListDialog.
  • Added Clipboard.GetFiles and Clipboard.SetFiles functions.
  • Added Dictionary.SetVariables function.
  • Added Dictionary.Values, Dictionary.AddSQL, Dictionary.ValueTypeForKey and QuickList.AddSQL.
  • Added DynaPDF.EditTemplate, DynaPDF.EditTemplate2 and .
  • Added DynaPDF.SetFieldFont and DynaPDF.SetFieldFontEx functions to support asian characters in form fields.
  • Added DynaPDF.SetPrinterSettings, DynaPDF.GetPrinterSettings and DynaPDF.GetInPrinterSettings functions.
  • Added DynaPDF.SysFontInfo and DynaPDF.FontInfo functions.
  • Added Files.Mount and Files.Unmount functions.
  • Added FM.ArgumentCount and FM.Argument functions.
  • Added FM.CurrentScriptID, FM.ScriptNameForScriptID and FM.ScriptIDForScriptName functions.
  • Added FM.DisableMouseWheel for Windows to block mouse wheel usage.
  • Added FM.InsertRecord function.
  • Added FM.InsertRecordQuery function.
  • Added FM.SQL functions to get SQL results in native data types.
  • Added Folders.UserTrash function.
  • Added function FM.NULL to get null values to pass to SQL.SetParamValue(s).
  • Added functions FM.CurrentThreadID, FM.IsMainThread and FM.MainThreadID.
  • Added GMImage.NewImagesFromContainer and GMImage.NewImagesFromFile to split tiff.
  • Added inline option for SendMail.AddAttachmentFile and SendMail.AddAttachmentContainer.
  • Added ListDialog.AddSQL to add list items via SQL.
  • Added Menu.DefineQuickMenu.
  • Added Menu.FindItemWithTag and Menu.FindItemWithTitle functions.
  • Added MenuItem.ApplyColor function to color menu entries on Mac.
  • Added MenuItem.GetBold, MenuItem.GetFontName, MenuItem.GetFontSize, MenuItem.GetItalic, MenuItem.GetUnderline, MenuItem.SetBold, MenuItem.SetFontName, MenuItem.SetFontSize, MenuItem.SetItalic and MenuItem.SetUnderline.
  • Added MenuItem.GetRequireCommand, MenuItem.GetRequireControl, MenuItem.GetRequireOption, MenuItem.GetRequireShift, MenuItem.SetRequireCommand, MenuItem.SetRequireControl, MenuItem.SetRequireOption and MenuItem.SetRequireShift.
  • Added OCR.SetResolution function.
  • Added parameter for RichText.ReplaceText to replace all.
  • Added parameter for various functions returning PDF containers to disable rendering of JPEG preview: SQL.GetFieldAsPDF, SQL.GetParamAsPDF, WebView.RenderPDF, CURL.GetResultAsPDF, PDFKit.GetPDFPageValue, Files.ReadPDF, Window.AsPDF, Container.DecodeFromBase64, ServiceProvider.Value, CGPSConverter.Convert, PDFKit.GetPDFPagePDF and PDFKit.GetPDFPagesPDF.
  • Added parameter to Math.TextToNumber to detect dot or comma for decimal separator.
  • Added parameter to Text.DecodeFromHTML to decode html entities, but leave xml entities there.
  • Added parameter to XML.Query to ignore errors in parsing.
  • Added Plugin.SetPreviewSize function to control preview sizes.
  • Added Plugin.SetSuccessReturn and Plugin.GetSuccessReturn to modify what plugin returns for success.
  • Added RegEx.FindMatches function.
  • Added RichText.WritePDF and RichText.GeneratePDF functions.
  • Added SerialPort.SetDataAvailableHandler and SerialPort.ClearDataAvailableHandler functions.
  • Added SetFunctions to limit what functions the plugin allows you to call.
  • Added SQL error code into error messages for SQL.Execute and other functions.
  • Added SQL.GetFieldNameList, SQL.GetFieldValueList, SQL.GetParamNameList and SQL.GetParamValueList functions.
  • Added SQL.GetFieldValue, SQL.GetParamValue, SQL.SetParamValue and SQL.SetParamValues.
  • Added text encoding parameter for Barcode functions. Default stays at UTF-8.
  • Added Text.CapitalCase, Text.LowerCase and Text.Uppercase with full unicode support.
  • Added TimeOut option for Socket.Connect.
  • Added Twain.SetPaper, Twain.SetPaperSize and Twain.GetPaper functions.
  • Added UnZipFile.UsePassword and ZipFile.UsePassword to encrypt Zip archives.
  • Added WebView.InstallMultiFileOpenDialog function to allow multiple selection file dialogs in a webviewer.
  • Added Windows support for WebView.LoadHTML.
  • Added XL.CopyContent function to copy content from one XL document to other, useful for converting between XLS and XLSX formats.
  • Changed Calendar functions to return UID instead of plugin ID if possible.
  • Changed DragDrop feature to accept promised file drops. This allows files to be dropped from Photos app to FileMaker.
  • Changed DynaPDF.Save to close current page if you forgot that.
  • Changed FM.ExecuteSQL to return error messages in clear text on error. You can use IsError function to know if it was an error.
  • Changed PDF preview rendering to make smaller previews in faster speed.
  • Changed PDFKit preview rendering of PDF pages to take care of rotation.
  • Changed RegEx.FindMatches to switch ReturnWholeMatch parameter to true if you don't have captures in your search pattern.
  • Changed ZipFile.WriteContainer to accept writing empty file.
  • Fixed a bug with WebView.GetFormTextAreaValue on Windows which did crash sometimes.
  • Fixed bug in GMImage.WriteImages function. Now working again.
  • Fixed bug in JSON.GetObjectName. Reports now an error if index is out of bounds instead of crashing.
  • Fixed bug in Path.NativePathToFilemakerPath.
  • Fixed bug in Text.DecodeFromXML and Text.DecodeFromHTML about html entities not being decoded correctly.
  • Fixed bug in Text.EncodeToHTML.
  • Fixed GMImage.GetPixelColor to return correct error message if coordinate is out of bounds.
  • Fixed problem in Files.GetPathFromNodeID function.
  • Fixed SyntaxColoring for comments for FileMaker 14.
  • Fixed Twain.SetDuplexEnabled so you can now disable duplex.
  • Fixed WebView.SetFormSelectValue to work also if there is no form name given.
  • Fixed ZipFile.WriteText function. Now text is again parameter 1 and not 2.
  • Functions like IsServer now also work if demo mode expired.
  • Added a version check to query server for update information while in development.
  • Improved copy script text button. Should not copy the list of available script steps.
  • Improved error message for Container.Export function.
  • Improved error message handling for Firebird database connector part in SQL functions.
  • Improved some of the Windows Webviewer functions to handle memory usage better.
  • Marked a lot of functions to not be available on server due to FileMaker Server not performing Script calls on the server.
  • Some smaller fixes for FileMaker 14.
  • The Audit.Change function now returns an error message if the given table name is invalid.
  • The Webviewer Form and Field functions now find fields and forms by ID on Mac and not just by name.
  • Tracing script calls now shows also name of current script, file, user and host if available.
  • Updated DynaPDF to version 3.0.39.116.
  • Updated LCMS to 2.7.
  • Updated libSQL to version 4.1.5.
  • Upgraded Xcode to version 6.3.1

New in MBS FileMaker Plugin 5.1 Prerelease 7 (May 7, 2015)

  • Improved error message for Container.Export function.
  • Updated libSQL to version 4.1.5.
  • Updated DynaPDF to version 3.0.39.116.
  • Added MenuItem.ApplyColor function to color menu entries on Mac.
  • Added Menu.FindItemWithTag and Menu.FindItemWithTitle functions.
  • Added FM.InsertRecordQuery function.
  • Added parameter for RichText.ReplaceText to replace all.
  • Added FM.InsertRecord function.
  • Made SerialPort.SetDataAvailableHandler work correctly.

New in MBS FileMaker Plugin 5.1 Prerelease 1 (Mar 17, 2015)

  • Added RegEx.FindMatches function.
  • Added inline option for SendMail.AddAttachmentFile and SendMail.AddAttachmentContainer.
  • Added DynaPDF.SetPrinterSettings, DynaPDF.GetPrinterSettings and DynaPDF.GetInPrinterSettings functions.
  • Added RichText.WritePDF and RichText.GeneratePDF functions.
  • Added parameter to Math.TextToNumber to detect dot or comma for decimal separator.
  • Added Dictionary.SetVariables function.
  • Added Dictionary.Values, Dictionary.AddSQL, Dictionary.ValueTypeForKey and QuickList.AddSQL.
  • Added GMImage.NewImagesFromContainer and GMImage.NewImagesFromFile to split tiff.
  • Added XL.CopyContent function to copy content from one XL document to other, useful for converting between XLS and XLSX formats.
  • Added Text.CapitalCase, Text.LowerCase and Text.Uppercase with full unicode support.
  • Added Plugin.SetPreviewSize function to control preview sizes.
  • Changed PDF preview rendering to make smaller previews in faster speed.
  • Added parameter for various functions returning PDF containers to disable rendering of JPEG preview: SQL.GetFieldAsPDF, SQL.GetParamAsPDF, WebView.RenderPDF, CURL.GetResultAsPDF, PDFKit.GetPDFPageValue, Files.ReadPDF, Window.AsPDF, Container.DecodeFromBase64, ServiceProvider.Value, CGPSConverter.Convert, PDFKit.GetPDFPagePDF and PDFKit.GetPDFPagesPDF.
  • Fixed bug in GMImage.WriteImages function. Now working again.
  • Changed FM.ExecuteSQL to return error messages in clear text on error. You can use IsError function to know if it was an error.
  • Updated DynaPDF to version 3.0.39.113.
  • Added FM.ArgumentCount and FM.Argument functions.
  • Fixed GMImage.GetPixelColor to return correct error message if coordinate is out of bounds.
  • Fixed bug in JSON.GetObjectName. Reports now an error if index is out of bounds instead of crashing.
  • Changed ZipFile.WriteContainer to accept writing empty file.
  • Added UnZipFile.UsePassword and ZipFile.UsePassword to encrypt Zip archives.
  • Fixed bug in Text.DecodeFromXML and Text.DecodeFromHTML about html entities not being decoded correctly.

New in MBS FileMaker Plugin 5.0 (Feb 24, 2015)

  • Added HotKey functions for Mac.
  • Added MountNotification functions.
  • Added suggestions when you use an unknown plugin function: [MBS] Unknown function: CURL.SetOptionVerifyPeer. Did you mean CURL.SetOptionSSLVerifyPeer?
  • Added new functions for DynaPDF to query, create and change annotations.
  • Added Barcode.EANChecksum and Barcode.ISBNChecksum functions.
  • Added BuildNumber function.
  • Added checks to addressbook functions to report back if user denied addressbook access.
  • Added code to detect Windows 8.1. Due to Windows 8.1 reporting itself as 8.0, we have to do special things to check for 8.1.
  • Added DynaPDF.GetTextWidth, DynaPDF.WriteDemoText, DynaPDF.RenderPDFFile function.
  • Added error user notifications for Mac OS X to notice you about script errors.
  • Added Files.DiskInfo function.
  • Added FM.RunDataDesignReport function to automatically write data design reports.
  • Added FM.StopScriptIdle function to stop idle timer. Also idle timer is cancelled when you start new timer.
  • Added functions for SerialPort to get/set parity and stop bits.
  • Added GMImage.FindColorInRow and GMImage.FindColorInColumn.
  • Added GMImage.MultiplyChannel and GMImage.PurgeTemporaryFiles function.
  • Added Is64bit function.
  • Added List.BestMatch and QuickList.BestMatch function.
  • Added ListDialog.GetAllowEmptySelection and ListDialog.SetAllowEmptySelection functions.
  • Added Menu.ItemAtIndex and Menu.Items functions.
  • Added Menubar commands to list menu commands, check if one exists, trigger one or change shortcut or visibility.
  • Added MethodDraw SVG Editor example.
  • Added more keys for TAPI.CallInfo function: Ref, Privilege, Origin, Reason, CallerIDAddressType, CalledIDAddressType, ConnectedIDAddressType, RedirectionAddressType and RedirectedAddressType.
  • Added MovieView.PauseDelayed and QTMovie.StopDelayed functions to play video and stop later.
  • Added MovieView.SetCurrentTime function.
  • Added new PDF Kit functions: PDFKit.AddEmptyPage, PDFKit.AddImagePage, PDFKit.AddImagePage and PDFKit.NewPDFDocument.
  • Added offset parameter to RegEx.Execute function.
  • Added parameter to DynaPDF.RenderPage function to write directly to file.
  • Added parameters to DynaPDF.GeneratePreview to query image.
  • Added Path.FileURLToFilePath and Path.FilePathToFileURL functions.
  • Added PrintDialog.SetPrintType, PrintDialog.SetPaperName and PrintDialog.GetPaperName function.
  • Added QTMovie.ParseTime and QTMovie.FormatTime functions.
  • Added QuickList.AddList, QuickList.AddQuickList, QuickList.HasValue, QuickList.Remove and QuickList.RemoveValue.
  • Added support to SendMail functions for encoding attachment file names.
  • Added SystemInfo.HostDNSName function.
  • Added TAPI.ListenOnAddress.
  • Added TAPI.SetCallStateScript, TAPI.GetCallStateScriptName, TAPI.GetCallStateScriptFileName, TAPI.SetNewCallScript, TAPI.GetNewCallScriptName and TAPI.GetNewCallScriptFileName and removed TAPI.SetCallScript, TAPI.GetCallScriptName, TAPI.GetCallScriptFileName. Now we pass call ID to parameter.
  • Added TAPI.Transfer function.
  • Added Trace.EnableErrorNotifications, Trace.DisableErrorNotifications and Trace.AreErrorNotificationsEnabled functions.
  • Added Webview.Cookies.ClearForURL, Webview.Cookies.Count and Webview.Cookies.Query.
  • Added WebView.GetFormattedText for Mac and added formatted text parameter to WebView.SelectedText function.
  • Added WebView.GetIcon function.
  • Added Webview.Scrollbar.getHorizontalMaximum, Webview.Scrollbar.getHorizontalPosition, Webview.Scrollbar.getVerticalMaximum, Webview.Scrollbar.getVerticalPosition and Webview.Scrollbar.set for Mac.
  • Added Webview.SelectedText function.
  • Added XL.Date.DoubleToTimeStamp, XL.Date.TimeStampToDouble, XL.Sheet.CellReadDate and XL.Sheet.CellWriteDate functions.
  • Changed DLL loading on Windows to automatically try a 64 before the DLL extension when running on 64bit FileMaker (Server).
  • Changed functions for global variables to store data in their native type (no longer converts everything to text).
  • Changed Line Numbers to work in FileMaker Pro, too (not just advanced). Please report any window you see which has unnecessary line numbers.
  • Changed ListDialog to show on Windows always one column with vertical scrolling.
  • Changed Menu.AddItems to now make separators if you add a line with minus and added a parameter for tags.
  • Changed parameter functions for SQL to also accept parameter by index with # as prefix.
  • Changed PDFKit functions to accept also file paths where they used to accept only URL.
  • Changed plugin to load QTkit Framework dynamically so we can be accepted for the Mac App Store.
  • Changed SerialPort.Read and SerialPort.ReadHex to return empty text if no data was available instead of error code 35.
  • Changed SQL Plugin to default to Scrollable = false for cursors. You can enable it if you need.
  • Disabled code in OpenSSL trying to load config files.
  • Disabled OpenSSL loading config files in CURL which can cause error message dialog on Windows.
  • Fixed a bug in ServerSocket.SendQuery which can lead to a crash in case of a timeout.
  • Fixed a bug where server license would not allow use in both Scheduled Scripts and Web Publishing/Direct.
  • Fixed a bug with reading container data.
  • Fixed a bug with RichText.SetFormattedText function.
  • Fixed a bug with SQL connections not freed correctly.
  • Fixed a possible problem with registration check and stored registration on Mac.
  • Fixed a problem with license network check.
  • Fixed an issue where FileMaker would block after Registration of plugin.
  • Fixed bug for SQL ODBC plugin functions to return error messages without garbage text in-between.
  • Fixed bug in Container.GetTypeSize.
  • Fixed bug in Dialog buttons.
  • Fixed bug in GraphicsMagick reading jpeg 2000 images.
  • Fixed bug in SerialPort.SetDataBits function.
  • Fixed bug in TAPI.CreateCall function.
  • Fixed bug where default text encoding was not used when needed. (introduced bug in pr1)
  • Fixed bug with formatting date in SendMail functions.
  • Fixed bug with GMImage.Copy function.
  • Fixed bugs for future FileMaker version.
  • Fixed crash in Text.ReplaceNewline on Windows with empty text.
  • Fixed drop area image, so you can set an image again with DragDrop.SetImage function.
  • Fixed drop areas, so they don't move if you change window size.
  • Fixed DynaPDF error reporting, so that IsError function also notices them.
  • Fixed Menu.SelectedItem function for Windows.
  • Fixed problem in DynaPDF.InsertImage and DynaPDF.InsertImageFile.
  • Fixed problem with QuickLook feature in Open dialogs not working due to MBS plugin's code for QLPreviewPanel functions.
  • Fixed problem with Text.TextToHTML not encoding all characters correctly.
  • Fixed test mode for DynaPDF works again. Use Starter, Lite or Pro to test if functions are okay with given license type.
  • Functions check now text encoding parameters better and report errors for unknown text encoding values.
  • GraphicsMagick functions taking color now also allows taking Random, RandomDark and RandomLight as parameter.
  • Improved BCC handling in SendMail function.
  • Improved code for future (e.g. better 64-bit support).
  • Improved DynaPDF.SetBBox to fix wrong boundary boxes automatically.
  • Improved error messages from calendar functions if calendar/reminder/event could not be saved or deleted.
  • Improved trace output to show special characters correctly (e.g. umlauts).
  • More XL functions return proper error messages.
  • Optimized GraphicsMagick image loading in plugin to avoid trying several decoders.
  • PHP support is deprecated and will be removed soon.
  • Rewrote parts of TAPI, so we now have TAPI IDs for the calls, so you can distinguish between different calls. You have to change your scripts!
  • The function to disable webviewer alerts now disables more alerts.
  • The list in the listdialog on Windows now has a border line and the buttons are higher.
  • The listdialog on Windows now reacts on escape and return key
  • Trace command now also logs Audit results. Also SQL/Evaluate errors while Audit are written to Console/DebugView.
  • Tracing will now also log script starts.
  • Updated Bonjour SDK on Windows to newer version.
  • Updated DynaPDF to version 3.0.38.112.
  • Updated LibXL to version 3.6.1.
  • Updated Text.EncodeToHTML and Text.DecodeFromHTML to handle UTF32 correctly and encode smileys well.
  • Updated to CURL 7.39.0.
  • Updated to GraphicsMagick 1.3.20.
  • Updated to libJPEG 9.1.
  • Updated to libPNG 1.6.14.
  • Updated to newer SDK.
  • Updated to OpenSSL 1.0.1j.
  • Updated to PCRE 8.36.
  • Upgraded Xcode to version 6.1
  • When looking for front window, we now better ignore floating palettes like Data Viewer on Mac.
  • When passing parameters, the plugin now more often return back the wrong value, so you can easier find a case where you passed wrong parameter.
  • Window and Webview reference numbers are now numbers returned as text.

New in MBS FileMaker Plugin 4.3 PreRelease 7 (Aug 26, 2014)

  • Changed JSON.GetObjectItemTree to also look into arrays. Please pass index in array as parameter.
  • Added new toolbar functions to add your own toolbar items.
  • Added new functions for Mac to configure the toolbar in a FileMaker window.
  • Added FM.DisableRuntimeEndWindow function.

New in MBS FileMaker Plugin 4.3 PreRelease 1 (Jul 3, 2014)

  • Added Container.ExtractStream and Container.RenameStream.
  • Added IsClient, IsRuntime and IsServer functions.
  • Added ZipFile.CRCFile function.
  • Added Socket.LastError function.
  • Updated DynaPDF to version 3.0.33.96.
  • Added DragDrop.GetTypes function.
  • Changed DragDrop.CreateWithSize to be relative to content frame.
  • Changed GMImage.Annotate to accept gravity parameter also as text and not just as number.
  • Weak linked all libraries. This way even on older Mac OS X versions the plugin should load again. But if functions like GraphicsMagick use a function which does not exist on Mac OS X 10.4 or 10.5, it may crash.
  • Added SQL.GetFieldAsPDF and SQL.GetParamAsPDF.
  • Added Files.SetPosixPermissions and Files.GetPosixPermissions.
  • Added function to control size of list dialog.
  • Fixed an issue where ListDialog being closed left FileMaker window disabled.

New in MBS FileMaker Plugin 4.1 (Mar 18, 2014)

  • Added Menu/MenuItem functions and a Menu.Popup method to show popup menu on Mac.
  • Added new functions Encryption.Cipher and Hash.Digest with a lot of options.
  • Added CLGeocoder functions to map address to geo coordinate and back on Mac OS X.
  • Added Dialog functions for showing message dialogs.
  • Added DynaPDF functions: DynaPDF.GetImportFlags, DynaPDF.SetImportFlags, DynaPDF.SetTextFieldValue and DynaPDF.SetTextFieldValueEx.
  • Added DynaPDF.AddFontSearchPath function.
  • Added DynaPDF.CreateCheckBox and DynaPDF.CreateTextField.
  • Added DynaPDF.FindText function.
  • Added Files.ListRecursive function.
  • Added functions Audit.SetLogAccess and Audit.GetLogAccess.
  • Added JSON.CreateStringArrayWithList function.
  • Added Math.BitwiseAND, Math.BitwiseOR, Math.BitwiseNOT, Math.BitwiseXOR, Math.BitwiseShiftRight or Math.BitwiseShiftLeft.
  • Added new grapichsmagick path drawing methods.
  • Added new mode to String.ReplaceNewline for html/xml.
  • Added PrintDialog.SetDuplex and PrintDialog.GetDuplex.
  • Added RunTask methods to add arguments and read/write data to the launched app.
  • Added WebViewer functions to zoom page or text.
  • Changed Audit functions to ignore fields in the audit table which are not used. This way you can have automatically calculated fields there.
  • Changed plugin to return error message if you pass compressed container value. We have no idea on how to uncompress.
  • Changed String.EncodeToHTML to ignore lower ASCII control characters.
  • Changed Trace command to no longer show serial number.
  • Fixed a build problem on Windows where some parts where not probably recompiled for 4.0 release (plugin still reported version 3.5).
  • Fixed a problem with CGImageSource.Keys function where it crashed with invalid image reference.
  • Fixed bug in DynaPDF.GetTextFieldValue and DynaPDF.GetTextFieldDefaultValue function.
  • Fixed bug with Mac file path handling for our text functions. String.ReadTextFile for example failed.
  • Fixed caching issue with calendar and addressbook script notifications.
  • Fixed functions Files.FileExists, Files.ItemExists, Files.DirectoryExists to return 0 on Mac instead of error if file/item/directory is not found.
  • Fixed problem with DynaPDF.OpenPDFFromContainer crashing if you passed empty container.
  • Improved container reading for movie files.
  • Improved DynaPDF.GeneratePreview to flattens annotations and forms.
  • Improved Form Utility. New menu command to open file. If field or form names are not unique, we use index, not name. Retina is now supported and last 10 URLs are saved in preference file.
  • Improved QTMovie and PDFKit functions to read external containers by file.

New in MBS FileMaker Plugin 4.1 PreRelease 1 (Feb 18, 2014)

  • Fixed bug with Mac file path handling for our text functions. String.ReadTextFile for example failed.
  • Fixed problem with DynaPDF.OpenPDFFromContainer crashing if you passed empty container.
  • Changed Trace command to no longer show serial number.
  • Added WebViewer functions to zoom page or text.
  • Added DynaPDF.FindText function.
  • Fixed caching issue with calendar and addressbook script notifications.

New in MBS FileMaker Plugin 4.0 (Feb 18, 2014)

  • Added PDFKit.Print functions for printing/faxing PDF files on Mac OS X.
  • Added QTMovie functions to query information on audio/video files on Mac. Also good for preview creation, playing sound or getting details.
  • Added Process.IsRunning to check if a PID is valid or a process with a name or bundle ID exists on Mac.
  • Added WebView.PrintToFile function to print PDF on Mac OS X from webviewer.
  • Added 40 new field related functions for DynaPDF, so you can fill form fields.
  • Added a few more MovieView methods.
  • Added ClearBackground option for PDFKit.GetPDFPageImage to render transparent PNGs from PDF pages.
  • Added Clipboard.SetFileMakerData, Clipboard.GetFileMakerData and Clipboard.GetTypes.
  • Added DynaPDF functions for bookmarks.
  • Added DynaPDF.CMYK and DynaPDF.RGB functions to help calculate colors.
  • Added DynaPDF.GeneratePreview function to add preview to a PDF in a container.
  • Added DynaPDF.GetCompressionLevel, DynaPDF.SetCompressionLevel and DynaPDF.WebLink.
  • Added DynaPDF.ParseContent, DynaPDF.SetBBox, DynaPDF.SetLineJoinStyle and DynaPDF.SetMiterLimit.
  • Added FM.VariableList and FM.VariableReset.
  • Added functions CURL.AddInputPDF, CURL.GetResultAsPDF and CURL.SetInputPDF for up/download of PDF files.
  • Added Hash.SHA256.HMAC, Hash.SHA512.HMAC and Hash.MD5.HMAC functions.
  • Added JSON.GetObjectName and JSON.GetObjectSize.
  • Added LCMS.ProfileInfo function.
  • Changed functions creating or opening files to return more detailed error messages with error number from OS and if possible a describing text.
  • Changed ServerSocket, so you can query on localhost.
  • Changed Window.ShowOverlay so it works on FileMaker 13 Mac.
  • Fixed an issue where editing a calender item failed.
  • Fixed memory leak with CURL plugin when using FormFinish method.
  • Fixed registration issue with FileMaker Server.
  • Improved speed on SQL plugin for reading integers from SQLite databases. Much faster now!
  • Rewrote DynaPDF.HighlightPattern. Now with case insensitive option.

New in MBS FileMaker Plugin 4.0 PreRelease 2 (Jan 9, 2014)

  • Added DynaPDF.GeneratePreview function to add preview to a PDF in a container.
  • Added functions CURL.AddInputPDF, CURL.GetResultAsPDF and CURL.SetInputPDF for up/download of PDF files.
  • Fixed Clipboard.SetFileMakerData, Clipboard.GetFileMakerData functions for ScriptStep/Script on Windows.

New in MBS FileMaker Plugin 3.5 (Jan 9, 2014)

  • Added Barcode creation and recognition functions.
  • Added DynaPDF Table functions.
  • Added first version of 64bit plugin for Windows, required for WebDirect on FileMaker 13.
  • Added line numbers for Scripteditor and Debugger.
  • Added SSL socket methods for our socket functions.
  • Added additional checks to OCR functions to avoid a crash if you OCR without an image.
  • Added Addressbook.personFromVCardTextRepresentation.
  • Added Addressbook.searchPeopleWithModificationDate and Addressbook.searchPeopleWithCreationDate to find recent changes.
  • Added all the missing libXL functions and renamed existing ones (old names still valid).
  • Added App.GetProcessPath function.
  • Added CURL.SetOptionTLSAuthPassword, CURL.SetOptionTLSAuthType and CURL.SetOptionTLSAuthUsername.
  • Added DynaPDF orientation functions.
  • Added DynaPDF.HighlightPattern function to search for text and add highlight annotations.
  • Added DynaPDF.Release and DynaPDF.New functions.
  • Added FileMaker Clipboard Helper application.
  • Added Files.ReadFile and Files.WriteFile function.
  • Added FM.ExecuteFileSQL function.
  • Added functions to get notifications from Addressbook about inserted, updated or deleted persons/groups.
  • Added functions to get notifications from Calendar about inserted, updated or deleted events/tasks/calendars.
  • Added GMImage.Strip.
  • Added JPEG 2000 support for GraphicsMagick on Mac OS X (was already there on Windows).
  • Added more calendar functions related to Alarms and Attendees (see new example database).
  • Added new RichText functions to also write RTF/Doc files on Mac.
  • Added PrintDialog functions to control printer dialog on Mac. (print to specific printer and print to PDF)
  • Added String.SoundExGerman.
  • Added SystemInfo.isMavericks function.
  • Added Trace.ErrorsOnly function.
  • Added Twain functions for AutomaticBrightness, Brightness, Contrast, Gamma, Shadow and Highlight.
  • Added Mac OS X 10.9 Mavericks functions:
  • Added MediaLibraryBrowser functions.
  • Added UserNotification functions.
  • Added Files.GetTagNames and Files.SetTagNames.
  • Changed DynaPDF functions to not only take flags as text, but also as numbers.
  • Changed DynaPDF functions to take new first parameter with the PDF Reference. This way we can make the plugin thread safe for FileMaker server and you can edit multiple PDFs at the same time. You need to call DynaPDF.New to get a new PDF reference and pass it to all functions. Finally call DynaPDF.Release to free memory.
  • Changed PNG library and Graphicsmagick library to not throw exception in case of some warnings.
  • Fixed a couple of memory leaks with Webviewer extensions on Windows.
  • Fixed bug in Container.GetTypeSize.
  • Fixed bug in CURL.SSLVersion on Windows.
  • Fixed bug in SQL plugin with setting text parameter to SQLite prepared statement.
  • Fixed bug in writing zip archives on Windows. Archives were bloated/corrupt.
  • Fixed bug with Zip file creation. Finder now unpacks them again.
  • Fixed crash with geometry functions in GraphicsMagick.
  • Fixed CURL on Windows to once again include SSL. (broken in 3.4)
  • Functions returning UTF-8 text not validate the UTF-8 in order to avoid FileMaker crashing with invalid UTF-8 characters.
  • Improved detection of undeclared variables in script editor.
  • Restored compatibility to FileMaker 10 on Windows. This was broken due to using FileMaker 12 only functions which are now loaded on demand.
  • The highlighting of variable names being undeclared is now off by default and can be enabled by SyntaxColoring.CheckVariableDeclaration.Enable command.
  • Updated SQLAPI++ 4.1.2.
  • Updated Syntax Highlighting to show also colors in FileMaker 12 on the script step list in script editor.

New in MBS FileMaker Plugin 3.4 (Oct 8, 2013)

  • Added new UnZipFile functions to read zip file.
  • Added new ZipFile functions to write zip file.
  • Added CGImageSource functions.
  • Added DynaPDF.DeletePage function.
  • Added DynaPDF.EnableEncryption function.
  • Added DynaPDF.ExtractImages function.
  • Added DynaPDF.ReplacePattern and DynaPDF.FindPattern.
  • Added DynaPDF.SetUserUnit and DynaPDF.GetUserUnit functions.
  • Added first version with 64 bit support for Mac OS X. This enables you to use our plugin in WebPublishing on FileMaker Server.
  • Added GMImage.WriteImages function.
  • Added Math.InchToPixel, Math.MillimeterToPixel, Math.PixelToInch and Math.PixelToMillimeter.
  • Added much better default rule set for Syntax Colorization.
  • Added new SerialPort functions: GetRTS/SetRTS, GetXON/SetXON, GetDTR/SetDTR, GetCTS/SetCTS and SetDSR/GetDSR to set flow control options.
  • Added RemoteControl.HideCursor and RemoteControl.ShowCursor.
  • Added ServerSocket.GetAllowedScripts, ServerSocket.GetAllowedTypes, ServerSocket.SetAllowedScripts and ServerSocket.SetAllowedTypes.
  • Added Windows support for FM.RunScriptIdle.
  • Fixed a bug with SQL.GetFieldName and index = 0.
  • Fixed bug in Addressbook.searchGroupsWithName.
  • Fixed bug with Japanese Characters in Formulas.
  • Fixed GMImage.GeticcColorProfile and similar functions to return empty result if there is no profile.
  • Fixed memory leaks with NSImage handling on Mac.
  • Fixed problems with DragDrop reference number being invalid.
  • Fixed XML.Query function to also return string, number or boolean.
  • Improved PDFKit handling of Document references to make it not crashing when using invalid reference numbers.
  • Improved SQL functions to work on FileMaker 12 and newer version.
  • Improved Syntax Highlighting. Invalid MBS Function names are now highlighted with red color like wrong brakets.
  • More Windows related functions now return also an error code in the error message to help finding the reason of the error.
  • Our Mac plugin is now code signed.
  • Streamlined error handling. You can now call IsError function to know if last function returned an error.
  • Updated bzip2 library to version 1.0.6.
  • Updated CURL to version 7.32.0.
  • Updated DynaPDF to version 3.0.29.74.
  • Updated FreeType to version 2.5.0.1.
  • Updated GraphicsMagick to version 1.3.18.
  • Updated jpeg library to version 9.
  • Updated LCMS to version 2.5.
  • Updated png library to version 1.6.3.
  • Updated tesseract library to version 3.0.2.
  • Updated tiff library to version 4.0.3.
  • Updated Window functions for disabling the close/maximize/minimize buttons on Mac OS X. As FileMaker 12 reenables them all the time, we simply hide them now.
  • Updated zlib library to version 1.2.8.

New in MBS FileMaker Plugin 3.3 (Jul 24, 2013)

  • Added more DynaPDF functions.
  • Added Hash.PBKDF2.HMAC function.
  • Added Hash.RandomHexString function.
  • Added Addressbook.searchGroupsWithName function.
  • Added Container.Remove function.
  • Added DragDrop.GetTag, DragDrop.GetWindowRef and DragDrop.SetTag.
  • Added Email.Verify function.
  • Added example for sending commands from webviewer to Filemaker which works with Serversocket and with IE10.
  • Added flags parameter to ServerSocket.Start.
  • Added FM.RunScriptIdle and SystemInfo.MacGlobalIdleTime for Mac.
  • Added Mac version of Window.GetClassName function.
  • Added Notification.List and Notification.Unlisten.
  • Added option to ServerSocket.Start so it works with Filemaker Go.
  • Added Plugin.Path function.
  • Added SerialPort.LastError function to query last system error code for serial port functions.
  • Added SystemInfo.IdleTime function for Mac and Windows.
  • Added Trace.Off function.
  • Added Twain.ClearCancelScript, Twain.ClearNotificationScript, Twain.GetUIVisible, Twain.SetCancelScript.
  • Added Twain.GetAutomaticBorderDetection, Twain.GetAutomaticRotate, Twain.SetAutomaticBorderDetection and Twain.SetAutomaticRotate.
  • Added Window.List function.
  • Added Window.RemoveMenu function.
  • Changed a couple of Mac functions to return Mac error number and some error description instead of just "Invalid Path".
  • Changed CURL.OpenInputFile to also set OptionInputFileSize for the file.
  • Fixed a bug with Path.FilemakerPathToNativePath function on Windows.
  • Fixed a bug with syntax coloring and curly brakets.
  • Fixed Addressbook functions to load on older Mac OS X versions.
  • Fixed bugs with CURL.FormAddKey* functions.
  • Fixed SerialPort.ReadByte to accept 2 instead of 3 parameters.
  • For TCP Sockets you can now more reliable get the remote IP/Port information.
  • Improved socket handling, so we get Error Script called if socket is disconnected from the other side.
  • Improved String.EncodeURLComponent to encode the way we need for Twitter search.
  • Improved twain image acquire to work better on feeders.
  • Removed CURL.SetOptionInFileLarge, CURL.SetOptionMaxFileSizeLarge, CURL.SetOptionPostFieldSizeLarge and CURL.SetOptionResumeFromLarge. The existing functions without large now also handle 64bit integers, so you don't need extra functions here.
  • Updated SQLAPI++ 4.1.1.

New in MBS FileMaker Plugin 3.2 (May 8, 2013)

  • Added Addressbook functions to work on the Mac OS X Contacts database.
  • Added ServerSocket functions.
  • Added Socket functions.
  • Added App.GetDockIcon, App.GetProcessName, App.SetDockIcon and App.SetProcessName
  • Added Hash.SHA1, Hash.SHA1.HMAC, Hash.SHA256 and Hash.RandomString.
  • Added IKSlideShow.AddImage, IKSlideShow.AddPath, IKSlideShow.AddPDF and IKSlideShow.AddURL.
  • Added IKSlideShow.GetMode and IKSlideShow.SetMode.
  • Added JSON.GetObjectItemTree function.
  • Added Math.IsValidCC function.
  • Added more DynaPDF functions for drawing graphics.
  • Added new mode for Files.List for Windows to use more wildcards.
  • Added oAuth example project.
  • Added optional parameter to Hash functions to return either Hex or Base64.
  • Added PDFKit.WriteToPath function.
  • Added RunTask functions and ExtractText utility for Mac.
  • Added String.DecodeURLComponent and String.EncodeURLComponent.
  • Added Syntax Coloring for Script Debugger on Mac.
  • Added System.Logout, System.Restart, System.Shutdown and System.Sleep.
  • Added Time.UnixTimeStamp.
  • Added Twain.GetCloseAfterTransfer and Twain.SetCloseAfterTransfer.
  • Added Twain.GetCompressionQuality, Twain.GetFilePaths, Twain.GetFileType, Twain.GetFolderPath, Twain.SetCompressionQuality, Twain.SetFileType and Twain.SetFolderPath.
  • Added Twain.GetDiscardBlankPages, Twain.GetDuplexEnabled, Twain.SetDiscardBlankPages and Twain.SetDuplexEnabled.
  • Added Twain.GetImageCount function.
  • Added Twain.GetPixelType and Twain.SetPixelType.
  • Added UTF-16, UTF-16BE, UTF-16LE text encoding options for CURL.GetResultAsText, CURL.GetDebugAsText, CURL.GetHeaderAsText, CURL.GetInputAsText, SerialPort.Read and Socket.Read.
  • Added Webview.GetPlainText and WebView.CopyFormattedText functions.
  • Added Window.SetTitleIcon.
  • Changed CURL FTPPort, CustomRequest and Range options to pass nil to CURL if you pass empty string in order to disable/reset the feature.
  • Changed FM.ExecuteSQLOnIdle to also set values for FM.ExecuteSQL.LastErrorMessage and FM.ExecuteSQL.LastError.
  • Changed GraphicsMagick Write methods to scale down jpeg previews for PNG/GIF/BMP to maximum of 600 pixels in width/height.
  • Changed license key check for DynaPDF. You now can use one DynaPDF license key from us for both Filemaker and Real Studio / Xojo plugin.
  • Changed Twain plugin store several images and not just the last one.
  • Fixed a memory leak with ProgressDialog.SetFont on Windows.
  • Fixed a problem with scanning images without GUI to a file.
  • Fixed an alignment bug with Twain functions.
  • Fixed bug in Bookmark functions.
  • Fixed bug in Files.Rename on Windows where you could get an error dialog.
  • Fixed bug in PDFKit.GetPDFAttribute with Keywords parameter.
  • Fixed bug in Twain.SetDefaultDSIdentity. You can now pass text.
  • Fixed problem where our plugin doesn't load on Windows XP.
  • Fixed problem with SerialPort.Read when it waited for data to arrive.
  • Fixed problem with Twain plugin giving white only pictures with scanning BW/Gray.
  • Functions which return text and handle UTF-16 will now respect the Byte Order Mark.
  • Improved multi page scanning in twain.
  • Plugins are now compiled with Xcode 4.6 on Mac.
  • Updated libXL to version 3.4.2
  • Updated DynaPDF to version 3.0.25.65
  • Updated String.ReadTextFile to also read UTF-16 files if you pass right text encoding.

New in MBS FileMaker Plugin 3.1 (May 8, 2013)

  • Added Twain functions.
  • Added new DynaPDF commands for adding images.
  • Added a warning message dialog for Mac version which appears if you have two copies of the MBS plugin installed. We hope this helps to avoid some problems.
  • Added Audit.ClearCaches function.
  • Added Audit.Delete2 and Audit.Change2 functions which take positive list of field names.
  • Added CURL.AddInputGIF, CURL.GetResultAsGIF and CURL.SetInputGIF.
  • Added file functions for NodeID and bookmarks (called Alias in Finder)
  • Added FM.QueryBaseTableNames, FM.QueryFieldsForBaseTableName, FM.QueryFieldsForTableName and FM.QueryTableNames.
  • Added FM.QueryFields and FM.QueryTables.
  • Added Modbus.CalculateRTUMessageCRC.
  • Added OCR.WriteToPDF function.
  • Added PDFKit.AppendPages function.
  • Added SerialPort.GetBaudRate, SerialPort.GetDataBits, SerialPort.SetBaudRate and SerialPort.SetDataBits.
  • Added several functions for DynaPDF to write text, set font and color.
  • Added SNMP.Get.
  • Added SNMP.SetRetries and SNMP.SetTimeout.
  • Added SystemInfo.DoubleClickTime.
  • Added WebView.GetFormSelectOptions function.
  • Changed Audit function to cache more values which doubles speed. Values are cached for up to a minute.
  • Changed DynaPDF functions so you can also use them with a Lite license key if needed.
  • Changed Files.List to also filter by extension if flags parameter is zero.
  • Changed GMImage.NewFromContainer to also read from referenced container values.
  • Changed Syntax Coloring so variable and function names can have _ as character.
  • Fixed a bug with reading from container with file referenced on disk and multiple paths for that one file.
  • Fixed a crash on Files.List function on Windows.
  • Fixed a little bug with backslashes in text for calculation syntax highlighting.
  • Fixed a memory leak in CURL.SetInputText and CURL.AddInputText.
  • Fixed bug with curl linked to wrong crypto library.
  • Fixed SNMP library linking, so the plugin works again on Mac OS X 10.6.
  • Fixed some bugs in new Audit functions. Now we don't record extra fields you specify.
  • Fixed String.ReadTextFile function to actually close the file correctly.
  • Fixed UserNotification.Release.
  • Improved memory allocations so we have a few less memory leaks.
  • Improved WebView code to find front window even if Filemaker is not in foreground on Mac.
  • Internal reading from container now also handles image: and file: path. So you can use that for reading image to GraphicsMagick for example.
  • Removed FM.QueryFields and FM.QueryTables.
  • Updated curl to version 7.28.1 on Mac OS X and Windows.
  • Updated SQLAPI++ to 4.0.3b1.

New in MBS FileMaker Plugin 3.0 (May 8, 2013)

  • Added DynaPDF functions for Mac/Win PDF functions.
  • Added SerialPort functions.
  • Added RichText functions for Mac.
  • Added Syntax Coloring for Filemaker 11/12 on Mac.
  • Added Printer.SetDefaultPrinter, Printer.PrinterName, Printer.PrinterCount and Printer.GetDefaultPrinter.
  • Added ClearRegistration, IsRegistered and StoreRegistration for preloading registration on Macs used for training.
  • Added Container.GetName and Container.Rename function.
  • Added FM.ExecuteSQL.LastErrorMessage to get error message of last SQL command.
  • Added GMImage.AveragePixelValue.
  • Added GMImage.GetJPEGAsBase64, GMImage.GetJPEGAsHex, GMImage.GetPNGAsBase64, GMImage.GetPNGAsHex, GMImage.NewFromBase64, GMImage.NewFromHex.
  • Added Graphicsmagick functions to draw rectangle, line, round rectangles, circle, ellipse and arcs to image.
  • Added MovieView functions.
  • Added parameters for Audit function, so you can now pass "fieldname|value" to set additional fields in Audit call in your AuditLog table.
  • Added SQL.GetFieldAsJPEG, SQL.GetFieldAsPNG, SQL.GetParamAsJPEG, SQL.GetParamAsPNG and SQL.SetParamAsContainer.
  • Added String.DecodeFromBase64 and String.EncodeToBase64.
  • Added String.EncodeToBytes, String.EncodeHexToBase64, String.EncodeBytesToBase64, String.DecodeHexFromBase64, String.DecodeFromBytes and String.DecodeBytesFromBase64.
  • Added String.FindBetween function.
  • Added SystemInfo.Time
  • Added URLScheme.GetDefaultHandler.
  • Added WebView.RenderImage support to Windows, not perfect, but works often.
  • Added WebView.RenderPDF function for Mac.
  • Added WebView.SetEditable, WebView.LoadHTML and WebView.GetEditable.
  • Added window functions for fullscreen mode on Mac OS X.
  • Added XML.Query for XPath queries on XML text.
  • Changed Container.GetDataURL to also work with PDFs.
  • Changed Container.GetTotalSize and Container.GetTypeSize to work with referenced files.
  • Changed SQL.NewCommand function to automatically set scrollable option for new commands.
  • Changed Syntax Coloring to also see functions if between function and braket is a space.
  • Changed Syntax Coloring to be lowercase. So please reset settings with SyntaxColoring.FactoryDefaults.
  • Changed SyntaxColoring.AddTag function to take a new selector parameter to specify what to color: function, scriptstep, variable or formula.
  • Fixed Audit Function to work in Filemaker 10. BaseTable and Tables must match here and we can't query TableID/FieldID.
  • Fixed bug in Path.FilemakerPathToNativePath and Path.NativePathToFilemakerPath on Windows.
  • Fixed memory leak in OCR.setImage function.
  • Fixed problem with CURL and SFTP transfers (SSH).
  • Fixed NSUserNotification so it works now even if Filemaker is frontmost.
  • Improved trace output on Windows.
  • On Filemaker Server we now write to DebugView/Console.app the message that the plugin has been loaded. This makes it easier to verify things are working.
  • Renamed SetDefaultHandlerForURLScheme function to URLScheme.SetDefaultHandler and InstallURLEventHandler to URLScheme.InstallURLEventHandler.
  • You can now also use "dos" as text encoding name.

New in MBS FileMaker Plugin 2.9 (Oct 3, 2012)

  • Added new OCR functions.
  • Added new XL methods for using libxl to read/write Microsoft Excel files.
  • Added PHP plugin functions.
  • Added Runtime Shrinker application.
  • Added WebView.SetCustomUserAgent and WebView.GetCustomUserAgent functions.
  • Added functions for container value encryption: Encryption.EncryptContainerBlowfish, Encryption.DecryptContainerBlowfish, Encryption.EncryptContainerAES and Encryption.DecryptContainerAES.
  • Added String.LevenshteinDistanceMBS and String.JaroWinklerDistanceMBS.
  • Added ProgressDialog.SetFont.
  • Added NSEventFilter.DisableEvents, NSEventFilter.EnableAllEvents and NSEventFilter.EnableEvents.
  • Added Process.IsFrontMost and Process.SetFrontMost.
  • Added Math.NumberToText and Math.TextToNumber.
  • Fixed debug output from Trace so it works on Mountain Lion.
  • Added new PDFKit methods.
  • Added Files.AccessDate, Files.CreationDate, Files.FileDisplayName, Files.FileKind, Files.FileName, Files.FileUTITypes and Files.ModificationDate.
  • Added SQL.MySQL.InsertID and SQL.SQLite3.LastInsertRowID functions.
  • Added Window.DisableScrollbars and Window.EnableScrollbars.
  • Added parameter to WebView.Reload to force reload.
  • Fixed a bug with the plugin not reading containers correct with external stored file data.
  • Fixed CURL to reset input file pointer when uploading same file data to multiple locations.
  • Fixed crash when disabling the MBS Filemaker Plugin in Filemaker Preferences.
  • Fixed FileDialogWatcher.Install so you can't install it several times.
  • Fixed Windows clipboard functions. Sometimes they had extra characters at the end of the text.
  • Fixed a bug with GraphicsMagick functions error handling for loading an image.
  • Fixed Window.Resizable for Filemaker 12.
  • Fixed bug in internal text encoding conversion. Affected several functions like the XL functions and on Windows the File Dialogs, File functions, Preferences and fonts.
  • Changed Files.FileSize to give on Mac also data- or resourcefork size and either logical or physical size.
  • The plugin shows now the version number if you click configure button in Filemaker Preferences after selecting our plugin there.
  • Moved plugin to FM12 SDK and already preparing to support 64 bit in a future release.
  • Performance improvements for Audit function. Some values like UserName are only queried once per record instead of per field.

New in MBS FileMaker Plugin 2.8 (Oct 3, 2012)

  • Added Audit functions.
  • Added UserNotification functions for Mac OS X 10.8.
  • Added RemoteControl functions.
  • Added WebDownloadDelegate.SetFolder, WebDownloadDelegate.GetFolder and WebDownloadDelegate.ClearFolder functions.
  • Added Files.CopyFile, Files.MoveFile and Files.MoveToTrash.
  • Added String.AppendTextFile function.
  • Added CURL.GetInputAsText function. (For Email with Attachments example)
  • Added Files.RenameFile.
  • Added more SystemInfo functions.
  • Added Window.Update command.
  • Added RemoteControl.GetWindowsList
  • Added Window.GetClassName
  • Added Preferences.GetTextSelectionWithDragAndDrop and Preferences.SetTextSelectionWithDragAndDrop.
  • Added Window.Activate function.
  • Added DisableFunction function.
  • Added new parameter to Window.HideScrollbars to disable our resize event watcher.
  • Added Window functions to query left, top, width and height.
  • Added Files.List function
  • Form utility improved: Avoids black input fields, shows HTML code, shows options for select fields and updates URL field to current URL. And code signed for Mountain Lion.
  • Fixed problem with CURL.AddInputPNG.
  • Fixed a bug in a Mac function which verified window references so you once again can work on multiple windows and not just the front window.
  • Fixed Window.SetAlpha to return errors on Windows correctly.
  • Fixed crash with Path.FilemakerPathToNativePath on Windows.
  • Fixed bug on Mac in Webviewer callback handler. Please check that your projects will work.
  • Changed Path.FilemakerPathToNativePath to also remove filemac:, filewin: and file: prefixes.
  • Ported project to Xcode 4.4 on Mac OS X 10.8. We only had to update screen functions.
  • With backdrop window on Mac we hide other apps if you switch to Filemaker from other app and backdrop is active.
  • Normal drag handler scripts are no longer called in layout mode. We could also disable other script callings in that case if needed or make it an option.
  • Improved SQL functions Unicode string handling. Now using UTF-8 for all strings.
  • If trace is on, the webview callback prints the received status message to debug console.
  • Updated to SQLAPI++ 4.0.1.

New in MBS FileMaker Plugin 2.7 (Oct 3, 2012)

  • Added FileDialog functions.
  • Added JSON functions.
  • Added CoreLocation functions to query location of a Mac.
  • Added Encryption.DecryptBlowfish and Encryption.EncryptBlowfish.
  • Added Encryption.DecryptAES and Encryption.EncryptAES.
  • Added Hash.MD5 and Hash.SHA512 functions to get hashes of UTF-8 text.
  • Added WebPolicyDelegate functions to decide which files should be downloaded.
  • Added WebDownloadDelegate functions so you can get downloads from WebViewer on Mac.
  • Added functions Files.AppPath, Files.Launch, Files.LaunchFile and Files.RevealFile.
  • Added duration parameter for Mac OS X to Window.Resize and Window.Move.
  • Added WebView.EstimatedProgress.
  • Added Icon.SetIcon and Icon.ClearIcon for Mac to set/remove file icons.
  • Added new CURL functions: CURL.AddInputFile, CURL.AddInputJPEG, CURL.AddInputPNG and CURL.AddInputText.
  • Added Files.FileSize function.
  • Added more parameter for Mac to Webview.LoadURL function.
  • Added Window.ScrollbarsVisible function.
  • Added Window.GetAlpha.
  • Added Preferences.SetValue and Preferences.SetValue functions.
  • Added Files.DirectoryExists, Files.FileExists and Files.ItemExists functions.
  • Added PDFKit.Watermark function.
  • Added PDFKit.GetPDFPageFormattedText function.
  • Fixed crash on Windows with CURL options using lists.
  • Fixed Window.HideScrollbar function for Filemaker 12 on Mac and Windows.
  • Fixed GraphicsMagick functions to no longer crash if you call them with Destroyed image reference.
  • Changed CURL.SetUpdateProgressDialog to now also work for uploads.
  • Changed CURL debug output to no longer contain SSL raw data of transfer.
  • Changed Webview and Window functions on Mac so they better check if a handle is no longer valid. We now track which windows are closed and invalid window references so they can't be used.
  • Changed plugin to use more Unicode APIs for better file name handling.
  • Improved Drag and Drop. You can now specify email and receive email drags from Apple Mail.
  • Improved hidden scrollbars on Mac for Filemaker 12 so they stay hidden even with resizing window.
  • Implemented Path.NativePathToFilemakerPath and Path.FilemakerPathToNativePath for Windows.

New in MBS FileMaker Plugin 2.6 (Mar 22, 2012)

  • Added new SQL methods for accessing multiple SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and ODBC, SQLite).
  • Added AppDockTile.getBadgeLabel, AppDockTile.getHeight, AppDockTile.getWidth and AppDockTile.setBadgeLabel.
  • Added Clipboard.GetText and Clipboard.SetText.
  • Added FileDialogWatcher.GetLastPath and FileDialogWatcher.Install functions.
  • Added CURL.CloseDebugFile, CURL.CloseHeaderFile, CURL.CloseInputFile and CURL.CloseOutputFile
  • Added CURL.CreateDebugOutputFile, CURL.CreateHeaderOutputFile, CURL.CreateOutputFile AND CURL.OpenInputFile
  • Added CURL.FormAddKeyContainer, CURL.FormAddKeyContainerContentType, CURL.FormAddKeyFile, CURL.FormAddKeyFileContentType, CURL.FormAddKeyText and CURL.FormAddKeyTextContentType.
  • Added CURL.SetOptionFileOnlyMode.
  • Added DragDrop.GetText and DragDrop.GetURL for URL and text dropping.
  • Added Font.Activate and Font.Deactivate functions.
  • Added MouseCursor.Set function to show different mouse cursor while processing.
  • Added Notification.Listen and Notification.Send.
  • Added ProgressDialog.GetPositionX and ProgressDialog.GetPositionY.
  • Added ProgressDialog.GetTopMost and ProgressDialog.SetTopMost
  • Added ProgressDialog.Update to redraw dialog.
  • Added String.DecodeFromURL and String.EncodeToURL functions.
  • Added WebView.PrintPreview (For Windows)
  • Fixed crash with CGPSConverter.Convert function.
  • Fixed CURL.SetOptionMailFrom function.
  • Fixed Mac plugin to be compatible again to Mac OS X 10.4 and newer. We lost that with adding SQL functions in pr2.
  • Fixed ProgressDialog.GetBottomText to return bottom text on Mac and not top text.
  • Fixed UUID functions which were broken.
  • Improved ProgressDialog button caption so it automatically fits the text length on Mac.
  • Improved Webviewer memory handling on Windows.