|
|
|
|
|
|
|
|
|
|
|
|
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 |
![MCBS00310_0000[1]](dart_files/index_0000_image004.png)
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
