Answer: Occasionally, users desire to interface ExpressMaintenance with accounting programs and other software applications. This can be easily accomplished with most applications using commonly available tools. While ExpressMaintenance does not interface directly with any specific applications, simple programs can be developed to accomplish the interfacing of data.
ExpressMaintenance is based on Microsoft SQL Server as it’s database engine. This means that all data is stored in a MS SQL Server database. MS SQL Server is the most accessible (open) database platform available (with proper security access of course). You can use virtually any type of development tool or utility to access data in MS SQL Sever. You can even use simple applications such as MS Access and Excel to develop ODBC or ADO interfaces to the ExpressMaintenance data.
Utilities and applications can read and write data to and from the ExpressMaintenance database tables. We also furnish ExpressSQL which allows you to view and print the ExpressMaintenance database table schemas. You can download ExpressSQL and begin examining the table schemas at any time – click here to download ExpressSQL. You can also use ExpressSQL to examine data to see how it is stored in each field and relationships. In addition, our technical support personnel will answer any specific questions you have about table relationships.
You will need to use an in-house or external developer to develop the interface to read / write data between ExpressMaintenance tables and the desired third party application. Once the utility is tested and working, the Windows scheduler can be used to automatically trigger the utility to run at the desired intervals and times.
Often developers will add fields to the ExpressMaintenance tables to indicate transactions have been transferred. Such fields are usually flagging fields such as dates or character fields. There is no harm in creating additional fields in the ExpressMaintenance table but they should be named in such a manner they are not likely to interfere with the maintenance software. Several tables already include Link fields for such a purpose.
Common applications include parts receiving / ordering, purchase orders and work order expenses. Because each customer’s desires and accounting programs are different, the interface utility must be custom developed to meet the unique needs. This is best accomplished by an in-house or local developer who can further enhance and expand the program as needed. Such interfaces do not require a large amount of time to develop and can be easily accomplished by a junior programmer.