The Spire Desktop program spire.exe supports command line parameters that allow you to automatically log on to a specific company from a single short-cut. It should be noted that this does reduce the security of your Spire system in that anyone with access to your desktop can not only run Spire as you, but they […]
This project will demonstrate a simple application that allows a user to create and post a journal entry into Spire. This is far from being a complete application. It is to demonstrate proof of concept and how the API can be used and how to go about doing it. It should be considered more of […]
This Excel example shows how to retrieve the net change in a GL account between certain dates. It introduces some concepts not covered in this blog yet such as building complex criteria with JSON and pagination – retrieving records in batches when there are expected to be many. The net change code uses the API […]
This post demonstrates a simple Excel function to retrieve a customer’s balance using the API. You can easily use it in any spreadsheet where you have a customer number. While convenient, it is not ideal for very large lists of customers, as an individual API call is made for each customer. For very large lists […]
Perhaps the most requested automation for Spire is the ability to add sales orders to the system. The Spire API makes this very easy. Only the bare minimum of information is required to add an order. For any information not provided, the Spire API adds the correct data automatically as if you were typing the […]
The post is going to show how you can use Excel to import data into Spire. Although Spire has extensive importing ability, there are a few reasons why you might want to do it yourself. Spire may not support the import you need. Spire is an “all or nothing” import. You may want to just […]
This article shows you how to output Spire reports without using the Spire application. You will still need Spire installed, but won’t need to log in. The password required will be secured inside a compiled MS Access application. This solution requires the following to implement: Spire Microsoft Access A copy of Crystal Reports. 2008 onward […]
This post shows a fairly easy way to setup a VBScript that will email you a CSV file of the days sales. It requires no special programs to be installed. It does not require an ODBC DSN to be created. It can be run as a scheduled task so you get an email every day […]
Automate the creation of Spire PostgreSQL ODBC Datasources with a batch file.
Today I am launching SpireAssists. Check out Spire Functions
