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
User Data Reports
User data is a tremendously powerful tool. AXIOM stores this user data in a very clever way.  Unfortunately, this storage technique makes it difficult to extract this data in ways other than AXIOM dictates.  This report is an Excel workbook with separate worksheets for the following AXIOM tables:
- UDEF                          
- USRC                          
- UFLD                          
This data in turn is used to build a separate worksheet for each Data Type, with each part in a row and the values for the user data in columns.   In this sample, each Data Type is limited to 25 parts.  The full production version for Parts User Data at C&M is 25 MB!  This approach is valid for all types of AXIOM User Data.  Recently we needed this report for Product User data and had the final report prepared and scheduled to update nightly in less than 30 minutes.
To view a sample report click here. 
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:42 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