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

Unicode

Posted on 24 September, 2012 by Rowan

MoneyWorks 7 stores all text internally using the Unicode UTF-8 encoding. This allows proper compatibility between Mac and Windows for Roman text outside the ASCII range (which previously was not translated between MacRoman and WinLatin), and also allows for input … Continue reading →

Posted in Database, Esoterica, MWScript, Reporting | Comments Off on Unicode

Connecting to Datacentre

Posted on 30 August, 2012 by Rowan

Datacentre connections must be negotiated through the normal Datacentre port (6699). Some earlier versions of MoneyWorks Datacentre* inadvertently allowed a client to directly connect to the database daemon port (e.g. 6674) without going through the Datacentre login process. i.e manual … Continue reading →

Posted in Esoterica, Networking | Comments Off on Connecting to Datacentre

Crash recovery

Posted on 28 August, 2012 by Rowan

After a crash or power loss, Moneyworks will normally recover unsaved changes from the session file the next time a document is opened. There is a confirmation UI if you open the file directly. If the file is opened in … Continue reading →

Posted in Database | Comments Off on Crash recovery