CONTENTS OF THIS PAGE

• DISTINCT GAGE REPORTING
• EXPORTING YOUR DATA TO MICROSOFT ACCESS
• CONFIGURATION OPTIONS (button not explained in the help page)
• VIEWING YOUR CERTIFICATES
• UPDATING YOUR GAGE INFORMATION

BUTTON HELP - Explanation of each button; consult this help page to learn the functionality of each button in the grid header.

DINSTINCT GAGE REPORTING

The default setting for this search page is to view only the latest calibration record for each gage.

View all calibration records.

Clicking this link will re-initialize the grid to display all records, not just the latest calibration records. This is handy if you want to view the calibration history of your gages.

View latest calibration records only.

Clicking this link will change the page to display only the latest calibration record in the database for each gage. This is handy for running reports where you only want to see one record for each gage; including Due and Overdue reports.

= Search Button

Gages Due

• You want to know what gages are due for calibration next month.
  • Click the Search Button
  • Specify your Cal Due date range in the form.
    • Select "Between" from the drop-down list.
    • Enter/select a start date and end date in the appropriate boxes.
  • Click the Search button in the search criteria form to activate the change.

Gages Overdue

• You want to know what gages are currently overdue.
  • Click the Search Button
  • Specify the Cal Due date as today's date in the form.
    • Select "Less than" from the drop-down list.
    • Enter/select today's date in the appropriate box.
  • Click the Search button in the search criteria form to activate the change.

   EXPORTING YOUR DATA

Currently, downloading your database into Microsoft Access will require an additional step. You will need to save your displayed grid in Excel, HTML or XML format. Once the file is saved to your hard drive, you can import that file into Access. Importing capabilities may be limited based on your version of Microsoft Access.

IMPORTING INTO ACCESS

1) Save the data file.

• Excel - Once the SAVE button is clicked, you will be prompted to Open, Save or Cancel the Excel file. Click Save.
• HTML & XML - Once the SAVE button is clicked, a new internet browser window will be displayed. Click File then Save As...

...Select the location to you wish to save the file and specify the name of the file, then click Save. It is recommended to save the file to "My Documents" or "Desktop" to make it easy for you to locate the file when you attempt to import it into Access.

2) Import

1. Open Microsoft Access.
2. Create a new blank database.
3. Click File --> Get External Data --> Import
4. Navigate to the directory in which your data file is saved.
5. Select the valid file type from the drop down list at the foot of the Import form.
6. Select the applicable file in the file list.
7. Click the Import button.
   1. Excel & HTML Import Wizard
      1. Ensure "First Row Contains Column Headings" box is checked then click Next.
      2. The remainder of the import wizard options will be tailored to your needs.
   2. XML Import
      1. There are less options and user intervention with this method than Excel or HTML.
      2. Click the Options button to specify if you wish to "Append Data to Existing Table(s)".
      3. Click OK

NOTE: Exporting using XML is the preferred method for beginner Microsoft Access users.

NOTE: Data importing availablity and procedures may vary due to your version of Microsoft Access. Some versions of Access require you to open and save your downloaded Excel file before importing the data to Access.

   CONFIGURATION OPTIONS

• Page Size - Default is 100. You can specify the number of rows to display on the grid.
• Print Type - Default is Enhanced.
• Save Type - Default is Standard.
• Copy Type - Default is Enhanced.
• Filter Type - Refers to drop-down search criteria boxes below the column headers in the grid.
  • Simple (default) - Populates the box values based on distinct data of a given field within the entire database.
  • Composite - Populates the box values based on distinct data of a given field within the displayed grid.

VIEWING YOUR CERTIFICATES

Each record of data in the grid will have a Cert Number associated with it. Click on the displayed Cert Number of the gage you wish to view. The certificate will open in a new browser window. You can scroll through the pages of multiple-paged certificates using the arrows at the foot of the window.

• PDF - The 15-character certificates that start with "C" will open in PDF format. You must have Adobe Reader (with web plug-in) installed on your computer to view these certificates. CLICK HERE to download the latest version from Adobe's website. There are buttons included in Adobe Reader's web plug-in that allow you to print or save the certificate with a single click.
• HTML - Certificates that are not 15-characters long and do not start with "C" will open in HTML format. To print or save these files, you will need to use your browser's File options.

Searching PDFs

Within the PDF web browser plug-in is a toggle button that displays and hides a search text box with options. This funtionality is useful for locating a specific gage number within a multiple-paged certificate.

UPDATING YOUR GAGE INFORMATION

If enabled, you have the ability to modify much of the information displayed on our website yourself. Simply click on the Gage ID of the gage you wish to modify. A form will be displayed with the current information of the gage filled in for you. Once you make the desired modifications, click the submit button and the information will be saved to your website the database. These changes will apply to all records in your database with the selected Gage ID. Applicable certificates (15-characters certs that start with "C") will then be updated within 5 minutes of the change.

Fields you can modify include:

• Gage ID
• Location
• Sub Location
• Make
• Model
• Serial Number
• Status (Active/Inactive)

To have this functionality enabled for your company, contact Ryan or Brian (info above).