Perl wrapper

Posted on 26 July, 2013 by Rowan

A third party Perl script is available from here. It uses the Command Line Interface to talk directly to MoneyWorks Datacentre. Note: As of v6.1, the recommended way to access MoneyWorks Datacentre is via the REST interface. The REST interface provides … Continue reading →

Posted in CLI | Comments Off on Perl wrapper

CLI Manual

Posted on 26 July, 2013 by Rowan

moneyworks - MoneyWorks command line modes Synopsis moneyworks [options] [file-or-url] On Mac OS X, the short form (moneyworks) is a symbolic link to the actual executable (/Applications/MoneyWorks\ Datacentre Console.app/Contents/Resources/moneyworks). On Windows, a separate command line client, moneyworks.exe is installed in … Continue reading →

Posted in CLI | Comments Off on CLI Manual

MoneyWorks Datacentre REST API

Posted on 23 July, 2013 by Rowan

Synopsis The MoneyWorks Datacentre REST API provides a simple, platform-neutral, stateless network interface to MoneyWorks Datacentre. Description The MoneyWorks REST API is hosted on a MoneyWorks Datacentre server. The server may be self-hosted on-premises, self-hosted on a cloud VM, or … Continue reading →

Posted in REST | Comments Off on MoneyWorks Datacentre REST API

MoneyWorks URL Scheme

Posted on 23 July, 2013 by Rowan

The MoneyWorks URL scheme follows the pattern of the Common Internet Scheme syntax described in RFC 1738. Where can I use it? On both Mac OS X and Windows you can make a shortcut file that will connect you to … Continue reading →

Posted in CLI, Esoterica, Networking | Comments Off on MoneyWorks URL Scheme

Mutexes and Persistence

Posted on 23 May, 2013 by Rowan

To make it easier to store persistent variables, there are some new functions to facilitate the safe updating of data in the User2 table. GetMutex/ReleaseMutex can be used to create any number of named mutexes. GetMutex will fail if another … Continue reading →

Posted in MWScript | Comments Off on Mutexes and Persistence

L.GetBalance() and L.GetMovement()

Posted on 15 April, 2013 by Rowan

This is often forgotten, but since v5, there has been a loop-control-object version of GetBalance and GetMovement, which operate on an already-loaded ledger record in the special case of a report for-loop on the Ledger table. Normally, GetBalance() and GetMovement() … Continue reading →

Posted in Reporting | Comments Off on L.GetBalance() and L.GetMovement()

Embedding a script in a report

Posted on 11 April, 2013 by Rowan

To facilitate scripting the custom report settings UI, and also to allow "library functions" that you can use in a report, there is a new custom control type: Script. Scripts controls are loaded by the report settings dialog and can … Continue reading →

Posted in MWScript | Comments Off on Embedding a script in a report

User2

Posted on 8 April, 2013 by Rowan

Version 7 contains a new script-accessible table for developers' use. It behaves rather like the existing user file except for having a much larger primary key (27 chars) and also a numeric "developer key" intended to prevent data collisions between … Continue reading →

Posted in Database | Comments Off on User2

Delegating Feature-Creep

Posted on 8 April, 2013 by Rowan

This is a feature request that has been on the books for a while. Only requested by one user as far as I know. 0003133: User has requested an Item Picking List on the Order screens. Description: He would like … Continue reading →

Posted in MWScript | Comments Off on Delegating Feature-Creep

Privilege encoding

Posted on 20 December, 2012 by Rowan

MoneyWorks 6 and earlier encodes privileges as a string where each privilege is represented by a character in the range 32-130. This is kind of wasteful and also unfortunate, because the last 3 codes are not valid utf-8. Making them … Continue reading →

Posted in Database, Esoterica | Comments Off on Privilege encoding