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
DART (Direct AXIOM Reporting Tool)
Sometimes the standard AXIOM exports are just not enough.  CART cannot report on data if an AXIOM export does not generate it.  DART provides an easy way to execute ODBC calls without programming.  Simple edit a table and create a Windows Scheduled Task to execute DART at the desired frequency.  The resultant DART files can be used stand-alone, or automatically merged with AXIOM exports to enhance CART reports.
One starts by assuring the AXIOM ODBC driver is properly installed on the computer running DART.  Then one completes a table in DART with the ODBC parameters.    
Next, one simply adds records to the main table:                        
Column A contains either the name of the database to query or the word "Update".  If "update" is present, DART opens the file in column F and executes an "Update" macro located in that file.  These are typically customized reports that need periodic updating.
Column B lists the SQL code to execute.  Column C specifies how often the SQL code is to be executed.  Column D lists the last time the SQL code was executed.  Column E lists when the next execution is due.  If the background color of column E is pink, then the execution is overdue.  Column F is the output file.  Column G if not blank lists the Post Query Routine to execute to further massage the data.  Column H lists the start time of the most recent execution.  Column I lists the duration of the execution.  
Note Cell (I10).  This query takes over 2 hours to execute!  The cis.mfg-invh table is quite large and the Progress indexes on that table are not very useful.  One ongoing project I have is to determine how to better extract information from this table.  Stay tuned.
A log file tracks the duration of each DART cycle.  In this case, DART fires every 30 minutes.  Note row 8, the DART queries took longer than 30 minutes because several were due simultaneously.  Also not row 4, where DART only ran for 45 seconds because there was not much to do at that time.                      
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