Interfacing with a mail client on Mac

MoneyWorks supports sending mail on Mac via Apple Mail or Microsoft Outlook automatically (or direct via an SMTP server). But you may want to customise the way mail is sent. In MoneyWorks 7.1.6 there is an additional (simpler) way to … Continue reading

Posted in AppleScript | Comments Off on Interfacing with a mail client on Mac

WriteToTempFile(text)

WriteToTempFile (text) Creates a new text file in the temp directory and writes the given text to it. Return value is the path to the temp file. Availability MWScript scripts in MoneyWorks Gold v7.1.5 and later

Posted in Functions | Comments Off on WriteToTempFile(text)

Statement Optimisation

Name.DBalance Generating statements involves quite a lot of database requests per statement. Statement (and invoice) forms are generated on the client, so it pays to try to eliminate unnecessary processing when statements will be generated for data that is hosted … Continue reading

Posted in Uncategorized | Comments Off on Statement Optimisation

Sending SMTP email with TLS on Windows

The standard MoneyWorks install on Windows includes a tool called blat (http://www.blat.net) for sending emails via an SMTP server. This is used when you select and configure the SMTP email option in MoneyWorks Preferences. While it is light weight, blat … Continue reading

Posted in Esoterica, Tip du Jour | Comments Off on Sending SMTP email with TLS on Windows

Sorting Filters

In MoneyWorks Gold 7.1.4, it is now possible to use CreateSelection() with the "*Found" and "*Highlight" metasearches to access more tables and list windows than were previously possible (e.g. department, offledger, filter). Access to the transaction selection in the Creditor … Continue reading

Posted in Sample Code | Comments Off on Sorting Filters

Make the Bank Transfer dialog remember the From and To accounts

If you are doing a lot of bank transfers, you might want to have one or both of the bank account popups remember their settings, at least for the session. Here's a script that does that. constant meta = "Cognito … Continue reading

Posted in MWScript, Tip du Jour | Comments Off on Make the Bank Transfer dialog remember the From and To accounts

Script Editor automatic backups

When you activate a script in the script editor (which compiles and loads the script), the script editor first saves a backup of the script's text into the standard plugins† Scripts folder. In the event that your script goes into … Continue reading

Posted in MWScript, Tip du Jour | Comments Off on Script Editor automatic backups

Base64 encoding

Connecting to the REST service on a Datacentre requires Authorization headers that need to be base64 encoded. As of v7.1.3 there is no built-in intrinsic function to do base64 encoding, so here's a utility routine to do it in MWScript … Continue reading

Posted in MWScript, Sample Code | Comments Off on Base64 encoding

Datacentre 7.1 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

Posted in Networking, Servers | Comments Off on Datacentre 7.1 SSL

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

Posted in MWScript | Comments Off on MWScript