MoneyWorks support
Datacentre SSL
The Datacentre REST service has had SSL (https) support since version 6.1. This is enabled in the DC Console by adding a certificate/key pem block for the REST service. In Datacentre 7.1, the MoneyWorks native networking protocol gains SSL support. … Continue reading
MWScript
MoneyWorks native scripting language Rationale Since v4.1, MoneyWorks has supported customisation via platform-specific attached helper scripts. On Mac, this was via a Helper.scpt Applescript in the Scripts folder, and on Windows via a slightly more convoluted mechanism to invoke a … Continue reading
Command line curl REST authentication
Sometimes you want to test out REST calls from the command line. How to handle the dual realm Authorization headers that Datacentre requires? --user will not work because curl will only accept one such parameter, so you need to specify … Continue reading
Managing Custom Plugins with Datacentre
As of v7, using Upload All to upload plugins to the server will replace the plugins folder on the server rather than merging with what is there. When the custom plugins are downloaded by clients (when they log in), the … Continue reading
Suppressing Standard Plugins
Sometimes you don't want particular clients to see any standard reports (or maybe forms), but if you delete the standard plugins folder, MoneyWorks will recreate it on next launch. You can delete the subfolders and leave the Standard Plugins Checksum … Continue reading
Schema
You can obtain the full MoneyWorks database schema by exporting "xmlschema" to a file. E.g. tell application "MoneyWorks Gold" to export "xmlschema" into POSIX file "/schema.xml" Note that text field usable sizes are general one byte less than the size … Continue reading
Columnar reports
The MoneyWorks report writer makes it easy to make reports where the columns contain time-based values (such as actual year-to-date, or annual budget). But what about where you want something else, such as departments, classifications or different types of general … Continue reading
Interfacing with MS Office
Did you know that MoneyWorks works well with Microsoft Office? You can pull reports directly into Excel, mail merge directly into Word, set your budgets straight from Excel and more. To show you how this works, we've provided some sample … Continue reading
Interfacing to MoneyWorks using COM/VBS
It is possible to attach front-end data entry systems, external data analysis, executive query facilities etc to MoneyWorks using Visual Basic (or other COM/OLE Automation-compliant scripting languages). The commands Open: Open the specified document Usage: Open (path as string) ' … Continue reading
Deimplemented messages in external helper scripts
In MoneyWorks 7, the following messages are no longer sent to external helper scripts. OpenedDocument AllowCloseDocument ClosedDocument AllowSaveDocument SavedDocument The following messages are still sent to an external helper script. The UserLoggedIn/UserLoggingOut are not sent even if password protection is … Continue reading