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

Reference number allocation

We sometimes get queries about gaps in reference number sequences. Why would MoneyWorks be so dumb as to skip reference numbers? In fact, reference number allocation is not that trivial. Consider the situation where you open 5 new invoice windows. … Continue reading

Posted in Database, Esoterica, Networking | Comments Off on Reference number allocation

XML data exchange

MoneyWorks 6.1 and later supports import and export of xml-formatted data. This removes the need to preconfigure an import map when building automated importing scripts (although you will still need to understand import maps). XML is the only import format … Continue reading

Posted in COM/VBS, Database, Esoterica, MWScript, REST, XML | Comments Off on XML data exchange