AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
TART (Total AXIOM Reporting Tool)
The AXIOM/Progress database is an industrial-strength database with many positive attributes.  Easy accessibility to the data is not one of them.  TART allows us the ability to periodically replicate whatever fraction of the database we desire and export the data into Excel, text files and DBF files.
TART also solves another vexing AXIOM problem. When you are building a report, there are times when you just can't find where AXIOM is storing a particular data field. AXIOM does some clever things with the compression of multiple data fields into one by the use of "pipes" (the symbol "|").  As a result, it is not always clear where something is being stored.  After replication, TART will search the entire replicated data bases (axs, cis,fin mdw) for a particular data string so one can pinpoint where it is being stored. 
TART now comes in two "flavors".  TART Version 2 works as well as it always has.  TART Version 2 is written in Microsoft's Visual FoxPro.  Microsoft has chosen to stop developing FoxPro and will stop support in 2014.  TART Version 3 is Excel 2007 based and replicates the Progress tables in SQL Server and Excel 2007 files.  Excel 2007 supports over 1 million records so almost all of the AXIOM tables can fit.  Also, TART 2 allows the user to selectively chose what fields in what tables are to be replicated in SQL Server, thus minimizing processing time.
TART Version 3.0 places all Progress tables into one SQL Server database, eliminating the problems created by the current AXIOM structure of 3 separate databases (axs, cis, fin).  
The cis.mfg-invh table is a particularly valuable table that contains millions of records and is sparcely indexed.  It is very difficult to extract information from this table in a timely manner if the information desired cannot take advantage of the mfg-invh or mfg-invx indexes.  TART Version 3 includes a dedicated mfg-invh updater program that extracts only "yesterday's" transactions and appends them to the SQL Server replicated copy of mfg-invh.  Once there, other SMART programs can use this replicated data in a properly indexed table and extract information in seconds instead of hours.
Also, the companion CodeFiler software collects all of the AXIOM/Progress code into one Visual FoxPro (VFP) table for easy searching of character strings there.  This solves a similar problem of trying to locate what information on an AXIOM screen matches with a field in a Progress table.  CodeFiler is scheduled to be folded into TART to result in one utility that can search both the data and/or the code for desired text strings. 
TART Version 3 is under rapid development.  The rest of this document discusses features of TART Version 2, which is a fully mature product.
TART can be assigned a Windows Scheduled Task for fully automatic operation.  Upon launching, TART presents to the user:
Ignoring this message will allow TART to begin automatic replication of the selected AXIOM/Progress tables.
The main TART screen is:
The 4 database screens allow the user to specify what tables and fields are desired, and at what frequency (daily, weekly, monthly updates).  Simply turn the appropriate button red by clicking on it to enable that choice.                        
You can add an unlimited amount of indexes to the generated VFP tables to speed lookup and retrieval of data:
The CodeFiler utility puts all of the AXIOM source code at your fingertips for easy searching:                      
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 
This web page was last updated at 02/21/2014 07:43 AM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach