MoneyWorks

11 Dec 2024

Performance and important stability enhancements

• Fixed potential data corruption when merging accounts
• Preferred bank account is no longer unexpectedly changed by opening a transaction that uses a different bank account
• Fixed search optimiser crash searching for the pseudo-field detail.net
• Fixed Forms Designer crash when changing visibility settings on Windows 64-bit Gold
• Previous Custom plugins locations are now dropped when you close a document and open one that does not have custom plugins
• Fixed a crash in the new Ledger Analysis with a large number of breakdown columns
• Asset report addition column fixed
• Diagnostic improvements
• Journal importing no longer gets details don’t match gross errors seemingly at random. These were due to the importer applying a default contra account to newly imported transactions. This would cause problems when importing journals containing the same account
• Fixed formatting of timestamp fields in lists with local files
• Fixed bad error message when deleting validation list items
• Fixed signatures breaking for analysis reports and forms (due to inadvertently including data that can change in normal operation of the form or analysis report). Note this fix may cause signatures applied by recent versions of MoneyWorks to become invalid. Please re-sign any affected forms and re-upload to your server as necessary
• File → Open now includes .mwxml files under “All Readable Files” on Windows
• Fixed SMTP OAUTH2 requiring frequent re-authorisation on Mac
• Fixed potential crash committing a stocktake count update
• Stocktake commit now always executes on the server

Server

• Fixed lingering threads/sockets when broken network connections are reestablished
• The Datacentre REST server now adds a Access-Control-Allow-Origin: * header to support externally-hosted javascript clients

Scripting

• GotoListField function
• The External function now resolves symbolic links on Windows before executing the external. This is because some external commands do not behave properly when executed via a symbolic link
• It is now an error to declare a local variable with the same name as a reserved word (such as let or end)
• Curl_exec and External now invoke cancel event processing immediately after the function call, so that executing these potentially slow/synchronous operations in a loop will not delay window closing animation on Mac quite as much
• Fix GetClipboardText crash when there is no text on the clipboard
• Make InsertVars work with source text bigger than 32KB
• New date format DateFormDateTimeBigEndian YYYY-MM-DD HH:MM:SS
• File_ReadLine removed limit on line length (was 4K)
• File_Open mode parameter may now include a "b" or "u" prefix (e.g. "br" or "ur") to request buffered or unbuffered (i.e. buffered within MoneyWorks as opposed to the OS). Default is currently unbuffered although it may still be buffered in the OS. Buffered can be orders of magnitude faster. It should only be used for sequential access
• Sqlite3 support. See the Sqlite3 developer note
• When sending output to the log via Syslog, the log file is now held open and buffered and only flushed once per second. This greatly reduces the CPU cost (Windows is particularly slow at opening and closing files). The log file will be closed if it has been idle for 20 seconds, which may cause the next logging to go to a new file if there are multiple instances and the log file has undergone rotation
• ParseCSV will now convert quoted newlines to \v (the embedded newlines would otherwise break tab/newline parsing of the result)
• Fixed ReplaceField to work properly for fields that allow newlines
• String functions (Length, Left, Right, Mid, Position, etc) now have a faster and more reliable implementation for strings containing multibyte unicode characters
• The numeric parameter of the Sort function is now an enumeration allowing for a third option SortCaseInsensitive
• Fix script editor cash with very long single-line string constants
• Fixed incorrect autocomplete prototype for Regex_Replace in script editor
• Fixed crash assigning to nonexistent array