MoneyWorks support
Using Sqlite3 with MoneyWorks
MoneyWorks 9.2 introduces bindings to the Sqlite3 API. This means you can: Create and use temporary in-memory sqlite databases in MWScript for data analysis and tabulation (as a more powerful alternative to TableAccumulate etc) Create and/or open local sqlite databases … Continue reading
Running a scheduled task in MoneyWorks
Sometimes you want to run a process in a MoneyWorks database on a schedule to happen whether people are logged into MoneyWorks or not. Usually this will involve connecting to a remote server and exchanging information one way or the … Continue reading
Using sftp or scp from MoneyWorks to transfer files to/from a remote server
SFTP is a nice and easy protocol for secure transfer of files to/from other servers. It's much easier and more secure than FTP. However, the Curl library in MoneyWorks does not include SFTP (which requires the entire OpenSSH library). However, … Continue reading
PreviewXMLtoPDF and merging output documents
MoneyWorks Gold 9.1.7 has a new function for converting the "xml" output format (from DoReport and DoForm) to PDF. On its own, this isn't especially useful, since you can just output to PDF in the first place. However, it is … Continue reading
Web views in the MoneyWorks Navigator
You have long been able to add your own panels to the MoneyWorks Navigator. Custom Navigator panels can be implemented using custom invoice forms or custom reports and are loaded from a folder named Navigator Extras in your custom plugins … Continue reading
New web views in MoneyWorks 9.1 and later
WKWebKit on Mac MoneyWorks 9.1 and later on Mac uses WKWebView instead Webview for embedded web controls. This change should be entirely transparent to existing scripts that use webviews. You get the newer out-of-process javascript engine. WebView2 on Windows MoneyWorks … Continue reading
Communicating with Javascript in a Web View
MoneyWorks 9.1 provides modernised web views on Mac and Windows (see New Web Views in MoneyWorks 9.1). MoneyWorks 9.1 and later also provides new functionality for communicating with the content of web views (requires WebView2 Runtime on Windows). Calling out … Continue reading
Server change notifications
External system notification has been implemented in MoneyWorks Datacentre 9.0.2. This allows another server to be notified whenever a change is made in a MoneyWorks database. This will remove the need for external systems to poll for changes (a practice … Continue reading
XOR handler
MWScript doesn't have a bitwise XOR function, but it does have an AND with ones-complement function in ClearFlag, which provides a bitwise NOT, which can be used with TestFlags (which is bitwise AND) to do a NAND. Thus you can … Continue reading
SendSMTPMail
SendSMTPMail is a script handler you can implement that takes over the job of sending SMTP mail. The handler signature is: SendSMTPMail(recipients, attachmentPath, subject, message, attachmentFileName) When MoneyWorks 9 has an email + attachment to send and the preferences are … Continue reading