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
CHART (Change Audit AXIOM Reporting Tool)
AXIOM provides a very comprehensive Change Audit table which can track many different changes in the AXIOM program.  Unfortunately, these changes can accumulate very quickly, resulting in a Change Audit table that grows to such proportions that it impedes performance of the entire AXIOM program.  System Administrators are left with two choices, either live with decaying performance, or purge valuable information from the system to keep the Change Audit table within manageable limits.
CHART retains this valuable historical information off line, allowing for periodic purges of the AXIOM Change Audit table, maximizing AXIOM performance without compromise.  CHART is a two-part system.  The CHARTBuild utility is run weekly to extract information from the AXIOM Change Audit table before the information is purged:                    
CHARTBuild builds a series of Microsoft Visual FoxPro (VFP) tables which contain the extracted information.  VFP tables have a 2 GB limit, so multiple tables have to be built.  This is not a problem because subsequent VFP SQL calls to retrieve the information support the UNION clause, allowing one SQL call to span many tables.                      
If CHARTBuild is fired automatically using the Windows Scheduled Tasks routine, Step 1 above (Retrieve Last Week's Data from AXIOM Chg_audit Table) automatically fires.  One also has the option to run CHARTBuild on any date range as well as recover information from purge files previously made using the AXIOM purge utility.
When users wish to extract information from the VFP tables, the CHART Utility is used.                        
In this example, CHART is configured to extract cost changes.  One simply enters the desired part number to obtain in a few seconds the entire cost change history of a product in reverse chronological order.
The yellow shaded fields indicate a change from the prior record.  The Export button creates a stand-alone Excel workbook:
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:41 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