Navigation: Maintenance > Equipment > Update Counts |
Access
Maintenance / Counts - Update Counts
Explanation
Services (PMs) can be scheduled and tracked for each unit on a number of periods such as weeks, days and months. In addition, the services can be scheduled based on a count field such as miles, kilometres or Hours. The Count field in the units screen is used to track preventative maintenance in these situations. Actually, the count can be based on anything that involves a simple counter.
Counts - The counts tab section at the bottom of the equipment dataview page, shows each instance of someone updating the unit counts in the "Updates Counts" area. This is a read only section that does not allow editing. To enter counts use one of the three methods below.
However, unlike dates, ExpressMaintenance has no direct way of knowing the latest count of a particular unit and therefore cannot determine or list services due in the Services Overview screen. The solution for this is to periodically update the Current Count field in the Units (Equipment) screen. This can be done in three ways as outlined below:
Three Ways To Update Unit Counts
Option 1- is done by editing the "current count", and "count date" fields in the upper section of the equipment dataview page manually.
Enter the count number in the "current count" field, then choose the dropdown button in the "count date" field to open the date/time stamp popup. Set the time stamp data and press the "post edit" button (green check mark) in the data navigator at the top of the page to save your selections.
Options 2 and 3- are the more efficient ways to keep counts current and are accessed in the Maintenance/Work Order/Update Counts section. See WO Update Counts
Importing From Datasource
Option 3 is helpful in situations where your equipment is linked to some type of automated systems and the current count is readily available in digital format. The user is assumed to have some knowledge of ODBC database setup in Windows to utilize this feature. You must have a table of spreadsheet which contains at least the following three fields:
Name - The name of the unit being updated.
Count - The current count of the unit.
Date - The date that corresponds with the count being imported.
You will be prompted for a user login name, password and ODBC DSN. Once the ODBC DSN is entered and connected, you should select a table from which the import will come. Next, click Ok and the data will be imported into the Update Counts screen. Be sure to click the Update button to save all new counts imported.