MBS FileMaker Plugin 14.3 development

[MonkeybreadSoftware]

Hello,

in this thread I want to post to you what's new in development of MBS Plugin, version 14.3.

Download is available as usual here:

monkeybreadsoftware.com/filemaker/files/Prerelease/

If you like our plugin, bookmark, like or forward this thread.

If not, well you can ignore it.

New functions in documentation .

Thanks for supporting our plugin.

For questions please do not answer here, but start a new discussion.

You can click on the mbs-plugin-development tag and subscribe to get an email for new topics with this tag, so you get notified.

Greetings
Christian

[MonkeybreadSoftware]

14.3pr1:

• Added Python functions.
• Added Plugin.LockedFunctions function.
• Enhanced execute button for calculation dialog to allow pressing option key to only evaluate the selected text.
• Updated for future FileMaker version.
• Improved variable auto completion to better handle custom functions starting with underscore.
• Updated to newer plugin SDK for FileMaker 21.
• Fixed problem with JSON returning negative floating point numbers without leading 0.
• Updated to Xcode 15.4.
• Updated SQLAPI to version 5.3.2.
• Fixed the WordFile.ReplaceTag function, which broke in 14.2.
• Improved the formatting code for calculations to handle special words like or and and better.
• Update LibXL libraries for macOS and Windows to version 4.3.
• Fixed a bug in WebLink() function in DynaPDFMBS class returning negative number.
• Changed XL.Book.Version to have the book parameter optional.
• Added EmailParser.ReleaseAll function.
• Renamed EmailParser.Free to EmailParser.Release, but old name will stay valid.
• Fixed a memory leak in loading Excel file from disk with XL.LoadBook function.
• Fixed a problem with XL functions where license key was not recognized properly.
• Fixed a problem with copying script text would duplicate field names or calculations.
• Changed trace function to not log the password for a Files.Mount call.
• Added check to XL.Initialize and DynaPDF.Initialize to return an error if the license key includes invalid characters like a space character.
• Added Mutex.ReleaseAll function.
• Renamed Mutex.Free to Mutex.Release, but old name will stay valid.
• Updated SQLite to version 3.46.0.
• Updated our ICU integration for SQLite to the new SQLite version.
• Updated DynaPDF to version 4.0.87.251.
• Enhanced format button for calculation dialog to allow pressing shift key to only format the selected text.
• Updated curl to version 8.8.0
• Enhanced check syntax button for calculation dialog to allow pressing shift key to only check the selected text.

[weetbicks]

Love the enhancements to the data viewer and calc engine !

[weetbicks]

Just minor comment - looks like all the enhanced syntax/execute/format options for calc engine use the shift key which is great - the notes just refer to the execute button using the option key.

[MonkeybreadSoftware]

Yes, it was first option and then I switched to shift key for consistency. I'll update the release notes.

[weetbicks]

Thanks, I'm finding this so useful for debugging larger calculations without having to deconstruct components and split them out into separate data viewer calcs - being able to check all conditions of a Case statement in-line is a huge time saver

[MonkeybreadSoftware]

14.3pr2:

• Added DX, DY and ClassID parameters to Preview.CreateWithControl and Preview.Create functions.
• Enabled Python functions to work on iOS.
• Fixed JSON.GetPathItem to not return error for invalid JSON.
• Fixed an issue with server calling WMIQuery.Connect function.
• Fixed JSON.GetArraySize to return no error for empty JSON and just return zero.
• Added SystemInfo.MacMemoryHostStatistics function.
• Added MQTT example using CURL.
• Improved UNNotification functions to work better in FileMaker 21.
• Changed WindowsUserNotification and UNNotification functions to be free to use without license.
• Added QuickList.JSONArray function.
• Changed Matrix.JSONRecord and Matrix.JSONRecords to take field names from column names, if you have some and you don't pass field names.
• Changed Matrix.CSVSplit to handle CSV with multi line values better.
• Added header row flag for Matrix.CSVSplit to put first row into column names.
• Added Archive.CompressText function.
• Added CURL.SetMQTTScript, CURL.GetMQTTFileName and CURL.GetMQTTScriptName functions.
• Added CURL.GetMQTTMessages function.

[MonkeybreadSoftware]

14.3pr3:

• Improved list functions to better split lists with CRLF as delimiter.
• Fixed Matrix.CSVSplit to split better (Broken in pr2).
• Improved UNNotification functions to work better in FileMaker 21, so both ways can be used together.
• Improved code formatting to detect semicolon first and then formats this way.
• Added Python.Path, Python.ProgramFullPath, Python.ProgramName, Python.PythonHome, Python.SetProgramName and Python.SetPythonHomefunctions.
• Changed CURL debug messages to include the full URL you requested for review. We include a warning, if URL has no scheme.
• Updated DynaPDF to version 4.0.88.252.
• Added KeepUnsupportedAnnots option for DynaPDF.FlattenAnnots function.
• Added DynaPDF.SetLineAnnotPoints and DynaPDF.EnableImageCache functions.

[FileKraft]

@MonkeybreadSoftware

• Updated to newer plugin SDK for FileMaker 21.

Would be interesting to know what enhancements under the hood are implied by the newer SDK?
Trying to find any updated specs like script parameter length and calculation statement length, sql statement length etc ...
???

[MonkeybreadSoftware]

Recent builds are also available here:

https://www.monkeybreadsoftware.com/filemaker/builds/

[MonkeybreadSoftware]

14.3pr4:

• Updated DynaPDF to version 4.0.88.253.
• Added Dictionary.GetTag and Dictionary.SetTag functions.
• Added Java.GetTag and Java.SetTag functions.
• Added Schedule.GetTag and Schedule.SetTag functions.
• Fixed Archive.AddContainer function to allow relative paths in file name parameter.
• Improved Files.ResolveAlias function to handle symbolic links, too.
• Added WebView.ClearVirtualHostNameToFolderMapping and WebView.SetVirtualHostNameToFolderMapping functions.
• Added FM.RecordStatistics function.
• Added CFunction.GetTag, CFunction.SetTag, CLibrary.GetTag and CLibrary.SetTag functions.
• Added Mutex.GetTag and Mutex.SetTag functions.

[MonkeybreadSoftware]

14.3pr5

• Changed ListDialog.SetShowCheckboxes to allow flag 4 to have checkboxes with only one checkbox checked at maximum.
• Improved UNNotification functions to work better in FileMaker 21, so both ways can be used together.
• Improved JSON.Import to report SQL statements in the error list for JSON.Import.Errors alongside the error messages.
• Improved XML.Import to report SQL statements in the error list for XML.Import.Errors alongside the error messages.
• Fixed a bug in IBAN.Format function.
• Fixed Archive.AddText function to allow relative paths in file name parameter.
• Added Plugin.SetLicenseKeyHidden and Plugin.IsLicenseKeyHidden functions.
• Added SystemInfo.isSequoia function.
• Reimplemented JSON.IsValid using newer JSON functions internally, so it catches more errors.
• Deprecated SystemInfo.isElCapitan, SystemInfo.isMavericks, SystemInfo.isSierra and SystemInfo.isYosemite functions.
• Updated DynaPDF to version 4.0.89.256.
• Added kstSearchAsIs flag for DynaPDFParserMBS class.
• Changed StoreKit.FinishTransaction to allow passing of index in additional of transaction Identifier.

[weetbicks]

I have an idea/request for the next release if possible.

99% of the time when developing in anchor-buoy solutions (or any type for that matter) when accessing the graph you want to jump to the current layouts table occurrence (the anchor) because you're usually working on that layout and thus any graph changes you're making are occurring on that anchor-buoy.

SO wouldn't it be nice to have a setting to always jump to the layout contexts TO by default when accessing the graph? The MBS search is already there, so I'm sure it could be utilised for this, where you could just grab the current layouts TO name and do a pre-search ?

This would save always having to locate the Anchor-buoy every time you go to the graph

[MonkeybreadSoftware]

14.3pr6:

• Fixed DynaPDF.DeletePage to return remaining pages on success.
• Improved JSON.SetPathItem to take the given value as text if it doesn't parse as JSON.
• Added Window.HasFormattingBar function.
• Added DragDrop.AttachToOverlay function to accept drops on an overlay.

[MonkeybreadSoftware]

14.3pr7:

• Added SyntaxColoring.AutoCompleteVariables.GetGlobals and SyntaxColoring.AutoCompleteVariables.SetGlobals functions.
• Added TotalSize entry for FM.TableStatistics and FM.RecordStatistics.
• Added FileName and Encoding parameters for Archive.CompressText function.
• Added Options parameter for Archive.Content, Archive.Extract, Archive.ExtractFile, Archive.FileList and Archive.GZipDecompress functions.

[MonkeybreadSoftware]

And released:

MBS FileMaker Plugin 14.3 for Claris FileMaker