|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
|
| |
|
|
|
East Greenwich,
RI 02818 |
|
| |
|
|
|
401.885.3631 |
|
| |
|
|
|
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 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
![MCBS00994_0000[1]](chart_files/index_0000_image004.png)
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|