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
One Report Containing MaximoŽ & TrackwiseŽ Data
TrackwiseŽ is a trademark of Sparta Systems
MaximoŽ is a trademark of IBM
AutoSoft is not affiliated with neither Sparta Systems nor IBM.
Don't you just love it.  Corporations today have software tools for all different functions, however getting them to talk to each other is difficult to say the least.  Recently, Dr. Serdakowski was asked by an existing client to develop one report that would automatically extract data from both the MaximoŽ and TrackwiseŽ databases.  Dr. Serdakowski delivered the finished product in less than one hour.  Here is an outline of how it works:
On the Main Screen, the ODBC connection strings into both the MaximoŽ and TrackwiseŽ databases are entered by the user.  Additionally, the user has the ability to modify the SQL statements into both MaximoŽ and TrackwiseŽ to return the desired fields.  The trick behind this working is the presence of the "TRNUM" field in the MaximoŽ query.  This field links to the "TR_ID" field in TrackwiseŽ.   Note that the TrackwiseŽ query searches both the NC and the CAPA tables for the MaximoŽ TRNUM value. 

This is a slightly modified example of the real life application.  Only the database connection strings and the Maximo location has been modified.  Note the values in the DURATION field.  The MaximoŽ query executed in 3 seconds and the associated TrackwiseŽ query executed in 7 seconds!  10 seconds for the entire report.
The final report looks like this.  Note how the MaximoŽ extraction has a gray background and the TrackwiseŽ extraction has a pink background.  This is a stand-alone Excel document that the user can further modify as required.
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:50 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