PreviewXMLtoPDF and merging output documents

MoneyWorks Gold 9.1.7 has a new function for converting the "xml" output format (from DoReport and DoForm) to PDF. On its own, this isn't especially useful, since you can just output to PDF in the first place. However, it is … Continue reading

Posted in Esoterica, MWScript | Comments Off on PreviewXMLtoPDF and merging output documents

Web views in the MoneyWorks Navigator

You have long been able to add your own panels to the MoneyWorks Navigator. Custom Navigator panels can be implemented using custom invoice forms or custom reports and are loaded from a folder named Navigator Extras in your custom plugins … Continue reading

Posted in Esoterica | Comments Off on Web views in the MoneyWorks Navigator

Sending SMTP email with TLS on Windows

this post is obsolete see: Using Gmail SMTP Using Office365 SMTP Using SendSMTPMail 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 … Continue reading

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

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

Posted in Esoterica | Comments Off on Managing Custom Plugins with Datacentre

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

Posted in Esoterica | Comments Off on Suppressing Standard Plugins

MoneyWorks URL Scheme

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

Privilege encoding

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

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

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

Stickies

I shouldn't tell you this, because the knowledge is open to extreme abuse by the irresponsible... Displaying sticky notes in a list column This is for transactions (directly owned sticky notes) Find("Stickies.Message", "FileNum=5 and OwnerSeq="+SequenceNumber, 9) File number 5 is … Continue reading

Posted in Database, Esoterica | 2 Comments