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

Posted in Uncategorized | Comments Off on Running a scheduled task in MoneyWorks

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

Posted in Uncategorized | Comments Off on Using sftp or scp from MoneyWorks to transfer files to/from a remote server

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

Posted in Uncategorized | Comments Off on New web views in MoneyWorks 9.1 and later

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

Posted in Uncategorized | Comments Off on Communicating with Javascript in a Web View

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

Posted in Uncategorized | Comments Off on Server change notifications

MoneyWorks Now login gateway API

If you are implementing a service that will access a MoneyWorks database via its REST interface hosted on a MoneyWorks Now server, you can retrieve the necessary login credentials by querying the MoneyWorks Now login gateway. A MoneyWorks Datacentre REST … Continue reading

Posted in Uncategorized | Comments Off on MoneyWorks Now login gateway API

Interfacing with a mail client on Windows

By default. MoneyWorks uses SimpleMAPI to create a new email message in the system mail client (assuming the default system mail client supports SimpleMAPI). The drawback with SimpleMAPI is that it is modal (you must send or discard each message … Continue reading

Posted in Uncategorized | Comments Off on Interfacing with a mail client on Windows

Optimising a report

Some time ago I had the need to find a pair of transactions that added or subtracted to a particular number. In fact when you are chasing down a problem in a set of accounts this is not an uncommon … Continue reading

Posted in Uncategorized | Comments Off on Optimising a report

GetLastErrorMessage

GetLastErrorMessage() Retrieves the last logged error message. When a script gets an error from the Import() function, you can use GetLastErrorMessage() to get more information about the last error that occurred. Important: The last error message will only be updated … Continue reading

Posted in Uncategorized | Comments Off on GetLastErrorMessage

Importing over high latency network

Ideally, importing to a cloud server would always be done via cloud APIs (i.e. the REST API provided by MoneyWorks Datacentre). However, one of the advantages of MoneyWorks over browser-based cloud solutions is that you can integrate seamlessly with other … Continue reading

Posted in Uncategorized | Comments Off on Importing over high latency network