eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       "Once you know it, it's Easy!" autosoft@aol.com
Commercial and custom computer related products spanning the areas of data acquisition and control, simulation and modeling, numerical analysis, chemical process design and manufacturing management information systems design. 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
Quality Specification Report
AXIOM provides you with great power in the definition of quality specifications for all parts.  However, as with many features in AXIOM, it is nearly impossible to generate a user-friendly report of your quality specifications.  As many of you already know, in order for AXIOM to provide the flexibility to store user defined data, AXIOM incorporates a technique that is clever, frustrated and convoluted.  AXIOM stores user defined data in open-ended character fields, where individual data is separated with pipes "| and carrots "^".  Generating meaningful reports is elusive. A simple ODBC call reveals fields that look like this:
2536^.151^.167^.159^702|1969^^^LH^702|503^^^2.29^702|2515^^^PPFAM^702|541^^^PPF^702|2541^^^PARA^702|2546^25^^^701|2540^^^AM^702|2544^^^HELI^702|2523^^^RH^702|2548^25^^^702|2552^^^OUT^702|3355^^^^702
YUCK!  AutoSoft has mastered the art of deciphering AXIOM's cryptic storage technique and a simple mouse click generates a comphrehensive and legible Quality Specifications Report:
                             
                             
                             
                             
                             
Configuration could not be any simpler. Database Query Information
Parameter axs cis fin
Simply enter the ODBC settings for your site to configure this program.  The ODBC table on this report is identical to the ODBC tables used on any SMART report. DSN DSNaxis DSNcis DSNfin
HOST axiomcmc
Port axssql cissql finsql
And away you go! DB axs cis fin
UID sysprogress
As with all AutoSoft solutions, source code is included. Password blank
                               
                             
                             
                             
                             
                               
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 04/27/2010 06:58 PM 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