SpireAssists is ringing in the new year with lots of new content. New apps, both free and paid, and host of new Tips & Tricks.
Breeze Signature
This new Android app is now available as a demo to everyone in the Google Play Store. Breeze Signature lets you find and select an order or invoice from Spire and let a customer review it, and apply a signature. This signature is applied to a PDF of the order\invoice which is saved as a Spire communication. The app can also email the document to one or more of the email addresses associated with the record in Spire. This completely stand-alone app requires no Spire Server or PC configuration and as such is a Breeze to setup.
Tools, Tips & Tricks
Breeze Excel Query: Spire Data Linked To Excel
Linking live Spire data to Excel is a powerful combination. This simple tool automates the process so it can be reproduced reliably in multiple spreadsheets. As a bonus, the sample SQL statements illustrate some lesser known features of the Spire SQL world.
Auto Create Spire ODBC Datasources
Some Spire solutions require a PostgreSQL ODBC datasource to be created for every user. This simple batch file makes creating these datasources a single click.
Automate Customers Color Based on AR Aging
This may seem like just a tool to make sure customers with balances over x days always appear in red in Spire customer or order lists. But it represents a powerful concept that can be modified to do many useful things. Essentially it is a Spire database update command in a batch file, scheduled to run automatically. It includes an easy to modify batch file and a tool to automatically set it up as a scheduled task.
Currency Rate Updater
This free tool will sync your foreign exchange rates with the bank of Canada web site. You can either run it manually or use the included tool to automatically create a scheduled task.