Update and Install

Express Maintenance

Click the dowload links below to install or

update your Express Maintenance products.

Product
Version
Size
Date
Express Maintenance Update
9.7.7.52
205 MB
07/08/21
Express Request Update
9.7.7.53
40.4 MB
07/15/21
Mobile App for Windows
9.7.7.51
103 MB
07/07/21
Mobile App for iOS
1.12.16
11.3 MB
07/07/21
Mobile App for Android
20.7.7.53
21.1 MB
07/07/21
 
Express Maintenance CMMS

Update your software

Read First:

Update to the current version of
Express Maintenance and Express Request

PASSWORD REQUIRED: request password via support ticket

Express Maintenance: Software Release Notes

Version 9.7.7.52  – 07/08/21

Express Maintenance

Installers Changing

As we continue to provide more back-end services, we have decided to separate these into their own installer. This puts all the backend programs that will likely be installed by an IT person on the server in one installer and all the client-side programs in one main installer.

We now have four main programs (Express Maintenance, Express Request, Mobile Application, and Backend Server Services) that need to be installed on the server. This is outlined in our “Installing and Managing Service” documentation. In addition, we continue to enhance our EM Services Management Dashboard to make it easier for your IT personnel to install and manage these new backend services.

New Features

EM Services Management Dashboard

EM Services Management Dashboard is a utility for installing, configuring, and maintaining EM server services. This utility is not for end-users but for IT support personnel.

  • The dashboard configuration screen was completed
  • The Mobile Service configuration form was successfully moved from the old “Server” mobile system to the Services Management Dashboard.
  • The file name for the Middle Tier configuration (which includes Express Analytics, Dashboards, and ERO) is now kept in an INI file. This will automatically load the last JSON config file used.
  • The data directory for the Mobile Service is now kept in an INI file. This will automatically load the last configuration data used.

EM Dashboard

Dashboards (not to be confused with the Services Management Dashboard), allows you to display a snapshot of your data in a web browser.

  • Design templates with 1 to 6 dashboards on them at the same time.
  • Pick from our built-in dashboards: Machine Status, Submitted Requests, Open Work Orders, Open Purchase Orders, Scheduled Service Past Due, Employee Service and Time Summary, and Downtime.
  • Easily set the template you want to use and drag and drop the dashboards you want to display on the screen.
  • Easily open the template in EM to verify your design and then copy the URL and past it into any browser to display in public places.

HTML Report Designer and Reporting System

  • Design in HTML with a robust implementation of CSS.
  • Converting the two most popular Work Order Reports
  • Prints HTML notes flawlessly
  • Ability to strip out unwanted @Page settings from MS Word

Service Category for Service Grids

  • Added Service Category to Equipment | Services (PMs) grid.
  • Added Service Category to Service Overview grid.
  • Added Service Category to Work Order Overview Services grid.
  • Added Service Category to Work Order Services grid.

Ruler for HTML Notes Editor

  • Added a 10-inch ruler to the notes editor.

Help Button for Archiving Form

  • Added button to access help for archiving.

Mobile Application Equipment Attachments

  • Added an additional tab with a grid to the equipment form to display the location of items attached to each unit. Attachments can be opened in the Mobile Client for Windows by clicking on the open button. The attachments cannot be opened when using the Mobile Clients for Android and iOS.

Issues Fixed

The Status for Equipment Services (PMs) Was Not Updating to the Correct Value When Work Orders Were Completed.

  • The update SQL for Work Order Services had a database name hardcoded in the code. The database name was removed.
  • The mobile application was also updated and fixed.

Fix Inconsistencies with Employee Labor Rates

  • Corrected the way labor rate and labor cost were uses in work orders.
  • Fixed the permissions for labor rates in the work order form

Mobile Application Lookup Lists

  • Changed the value of Code Type parameter used for Work Orders Group to ‘Groups – Work Orders’.
  • Changed the value of Code Type parameter used for Work Orders Work Group to ‘Work Groups’.

Fix Null Values for Unit Cost and Quantity in Work Order Services and Parts

  • Set the value of Unit Cost and Quantity to 0 for all existing records that had a value of NULL.
  • Modified Unit Cost and Quantity fields in the database. Set allow NULL values to False.
  • Added a default constraint to set the default value of Unit Cost and Quantity fields to 0 when a new record is inserted.
  • Added code to Express Maintenance to set the values of Unit Cost and Quantity to 0 when a record is inserted.
  • Added code to EMMobileClient to set the values of Unit Cost and Quantity to 0 when a record is inserted.

Version 9.7.6.5  – 05/07/2021

Express Maintenance

New feature – Work Order Archiving/Deleting. EM now allows you to move and/or delete old completed Work Orders from the active database. When you move old Work Orders, you can use EM to view them right on the same screens you are used to. These old Work Orders reside in a different table so they no longer slow down selections and reports. When the Work Orders become obsolete, you can remove them altogether from the database. Keeping your data clean and relevant has never been easier.

New feature – The Express Analytics Reports and Exports now include the Source Database.

New feature – The SQL server default password, used for EM (created on new installs only), now exceeds the Windows minimum complexity policy:

·     The password does not contain the account name of the user.

·     The password is at least eight characters long.

·     The password contains characters from three of the following four categories:

§ Latin uppercase letters (A through Z)

§ Latin lowercase letters (a through z)

§ Base 10 digits (0 through 9)

§ Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

New feature – The Reports default font used for printing notes has been changed to Arial 8 points. This popular request is now built into EM.

Fixed – Express Analytics Reports exports now include all the selected data.

Fixed – Express Analytics database updated.

 

Fixed – Issue with Equipment that has the same Service Name. You can now schedule a single Service without effecting the others.

 Express Mobile Windows Service

New feature – EM Mobile Windows Service. The EM Mobile Server application has been replaced with a new Windows Service.  The EM Mobile Windows Service will automatically start when the computer starts and will run without a user signed on. You get the same functionality with improved security. The new Service is backwards compatible with the existing setup, just install it in the same folder and start it.

Express Configuration

The EM Configuration application has been updated to use more secure encryption algorithms. 

EM Services Management Dashboard for Internal I.T.

New application – The new internal I.T. Express Services Management Dashboard application allows your I.T. personnel to install and configure the new EM windows services. This includes:

·   EM Middle Tier Service – The new hub of our server-based services

·   EM Analytics Windows Service: Select which databases to include and automatically install the SQL scripts required. 

·   Soon: The EM Mobile Windows Service and additional capability and services.

Version 9.7.5.15

04/05/2021

Express Maintenance

·     New feature – Express Analytics. This feature provides data analytics and reporting for customers who have more than one site and database. Users can select which databases to include and generate reports that contain information from all the selected databases.

 

·     New feature – Added the ability to Duplicate Work Orders. The user can specify how many and what sub-items to duplicate.

·     New feature – the Sub Requestor field is now available on the Work Orders tab.

·     New feature – Added new Help and Close buttons to Metrics tab.

·     New feature – Added three ‘Default Days Back‘ options to the Configuration page under the Scheduling section.

·     New feature – Security Enhancements: Added Database Password mask. Removed option for writing unencrypted INI file.

 

·     Fixed the WO Notes Text so it updates after a Work Order is created.

·     Fixed the Request Notes update after a Work Order is created.

·     Fixed the Subtotal Calculation on Work Orders parts.

·     Fixed the web link for Check for Update so it uses the correct web site.

·     Fixed “Quantity on Hand not found” when editing Service Parts.

Express Mobile Client and Server

·    New feature – Sub Requestor field is now available on the Request and Work Orders tabs.

Express Configuration

·    New feature – Security Enhancements: Added Database Password mask. Removed option for writing unencrypted INI file.

Express Middle Tier Windows Service

·     New feature – As part of our ongoing software improvements Manufacturing Asset Solutions is moving many Express functions to Windows Services. Our first phase includes the new Middle Tier Service which is included in this release. The Middle Tier Service will run all the time without the need to have a user signed on. This Service is the backbone of many new features you will see in the future.

 

Version 9.7.4.12  – 03/02/2021

 Express Maintenance

·    New feature – Management of Change.

·    Added 2 new Management of Change reports.

·    Fix assignment of WO request when assigned to a work order.

·    Import Parts from a CSV file for receiving and consumption by work orders.

·    Remove RTF processing from Notes Utility. The Notes Utility can be used to find oversized notes.

·    Fixed printing issues where notes lost data after a check box.

·    Fixed printing issues with check boxes showing as question marks.

·    Fixed printing issues with notes table column width and table row height..

·    Added button on Help tab to view End User License Agreement.

·    Added button on Help tab to view Express Maintenance Service Agreement.

·    Added new high contrast theme for yellow font on black background..

 

Express Request

·    New feature – Management of Change.

·    Software checks for required ODBC Driver 17 for SQL Server driver on startup.

·    Fix email From setting so emails work.

 

Express Mobile Client and Server

·    New feature – Management of Change.

·    Added buttons to MA to be able to jump to a WO or Part record, used to be read only.

·    Fixed keyboard down button error.

·    Fixed services filter so Work Orders can use all Services.

Version 9.7.3.12 01/22/2021

Express Maintenance

·    Software checks for required ODBC Driver 17 for SQL Server driver on startup.

·    Software checks for supported version of SQL Server on startup.

·    Fixed issue with missing “Do you want to print” question after creating work orders.

·    Fixed issue with Request notes not updating to include the new work order number.

·    Fixed issue with Rolodex grid not showing data.

·    Fixed issue inside the Notes fields where some tables would not print the lines.

·    Fixed issue with notes containing embedded images not printing on reports.

·    Fixed issue with Requests staying on the grid after a Work Order has been created.

·    Removed obsolete email configuration options.

 

Express Request

·    Software checks for required ODBC Driver 17 for SQL Server driver on startup.

·    Fixed issue inside the Notes fields where some tables would not print the lines.

·    Fixed email settings.

·    Added email test page for testing emails.

·    Use Note Pad to display the conversation between Express Request and the Email Server when emails fail to send.

 

Express Mobile Client and Server

·    Fixed Android issue with Done key closing the current page.

·    Fixed Android issue with access violation upon accept of a bar code scan.

·    Fixed Android issue with drop down controls have Java errors.

·    Fixed Android/IOS issue with date/time controls defaulting to 12 AM for the time.

·    Removed obsolete email code from the Mobile Server.

Version 9.7.2.26 12/23/2020

Express Maintenance

·    Failure Metrics (MTBF) and Mean Time To Repair (MTTR) statistics and graphs.

·    Converted all Notes fields from using a Rich Text Format (RTF) to a Hyper Text Markup Language (HTML) format. This gives users more options to customize their documents. This includes the ability to insert working checkboxes.

·    Added enhanced Spell-Checking features.

·    Added a Spanish (Mexico) Spelling Dictionary.

Express Request

·    Converted all Notes fields from using a Rich Text Format (RTF) to a Hyper Text Markup Language (HTML) format. This gives users more options to customize their documents. This includes the ability to insert working checkboxes.

·    Added enhanced Spell-Checking features.

·    Added a Spanish (Mexico) Spelling Dictionary.

·    Fixed Email send issue.

 

Express Mobile Client and Server

·    Converted all Notes fields from using a Rich Text Format (RTF) to a Hyper Text Markup Language (HTML) format. This gives users more options to customize their documents. This includes the ability to insert working checkboxes.

·    Fixed Access Violation issue when adding many Work Orders.

 

 

Version 9.7.1.36 10/09/2020

Express Maintenance

·    Units Tab – Service History Sub Tab: The grid was modified to allow changes. This reverts the change that was made in 9.7.1.34 ‘Units Tab – Service History Sub Tab: The grid was changed to read only. No changes on past items.’

 

Version 9.7.1.35 10/02/2020

Express Maintenance

·    Modified the Configuration setting for ‘Allow Edit of PO Number’ to ‘Allow Edit of PO and ALT PO Number’.

·    When the Allow Edit of PO and ALT PO Number is enabled you can now edit both values.

·    Added the ALT PO Number to the Search By list. Searches on the ALT PO Number allow for partial value searches. If any part of the ALT PO Number matches what you enter then it will be selected and displayed on the grid.

Version 9.7.1.34 09/11/2020

Express Maintenance

·    Added support for entering non-numeric Purchase Order numbers. You can now enter numbers and text. The existing auto-generation of PO numbers continues to work.

·    The Codes table has a new Codes Site Limit Filter. This is used to limit what Codes an employee can view based on their Site Limit setting.

·    The Companies table has a new Company Site Limit Filter. This is used to limit what Companies an employee can view based on their Site Limit setting.

·    The Cost Center table has a new Cost Center Site Limit Filter. This is used to limit what Cost Centers an employee can view based on their Site Limit setting.

·    The Services table has a new Services Site Limit Filter. This is used to limit what Services an employee can view based on their Site Limit setting.

·    Updated the End User License Agreement (EULA).

·    Locations Tab – Added a new field called Report Group. This will be used in the future for creating consolidated reports.

·    Work Orders Tab -Fixed issue with services disappearing.

·    Units Tab – Service History Sub Tab: The grid was changed to read only. No changes on past items.

·    Work Orders Tab – Service Overview Sub Tab: The Technician drop down was sometimes showing employees who were not Technicians. The selection was modified to work the same as the Technician drop down on the Work Orders Overview tab and the Work Orders Data tab.

·    Work Orders Tab – The 3 sub tabs for Service Overview, Work Orders Overview and Work Orders Data had a filter problem when either the signed on employee or a Technician employee had specific site limits defined. The filter was modified to do a many to many comparison.

·    Work Orders Tab – Service overview sub tab: the Site drop down was not filtering the list of sites using the employee site limit list when set to <All>. The code was modified to limit the sites to the list the employee has permission to view.

·    After entering a request in Express Request where the user selected a Reference from the new drop down list (see Express Request below), the selected Reference was being overwritten with the request record number when a Work Order was created. The code was modified so the reference flows through correctly. A new read only control was added to the form to show the request number.

·    Company Tab – Adding an Address to a Company was modified so the user will not see data from a non-related item.

·    Parts Inventory Tab – Inventory Notes sub tab – Images inserted into the notes were not being saved. Changed the code to use the correct field names to fix this.

·    Rebuild Views – Modified to prevent an error on dropping the Last Invoice field.

·    Service Overview – Renamed the Parts column to Service Parts.

·    Work Orders Tab – Requests sub tab – The code was modified to display the correct notes in the grid.

·    After upgrading the Express Maintenance software the version number and Company data will display correctly without needing to restart the application.

·    Google Directions now works.

·    During an Upgrade of Express Maintenance if the user says they do not wish to continue the upgrade will stop.

·    Configuration Tab – Work Orders Section. Filter Services List by Category and Filter Parts List by Category are now set to Off as a default. Before it was undefined.

·    Configuration Tab – Work Orders Section. Charges & Auto Apply section. Auto Add Parts Taxable and Auto Add To All Work Orders are now set to Off as a default. Before it was undefined.

·    Fixed issue with the Carbon Copy (CC) option not filling in while sending emails.

·    Work Orders Tab – Corrected an issue with setting the completed date to what the user specified.

 

Express Request

·    The Codes table has a new Codes Site Limit Filter. This is used to limit what Codes an employee can view based on their Site Limit setting.

·    The Companies table has a new Company Site Limit Filter. This is used to limit what Companies an employee can view based on their Site Limit setting.

·    The Cost Center table has a new Cost Center Site Limit Filter. This is used to limit what Cost Centers an employee can view based on their Site Limit setting.

·    The Services table has a new Services Site Limit Filter. This is used to limit what Services an employee can view based on their Site Limit setting.

·    Updated the End User License Agreement (EULA).

·    On the Data View tab, the Reference field was a simple edit control. This was changed to be a drop down so the user can select from a predefined list.

·    On the Overview tab, the grid column for Record Number was renamed to Request Number.

·    On the Overview tab, the Work Order button is now disabled unless the request status is All, Assigned or Completed. Other status do not yet have a work order number.

·    Modified the code to prevent a SQL error related to Employee Definitions.

·    Various memory leaks have been corrected.

Version 9.6.6.1

Released 4/18/19

Express Maintenance

  1. Corrected the Adobe PDF writer issue. The Report writer no longer cuts off the first line of Work Order Notes text when converting to or emailing as a PDF
  2. The ability to turn off the Buttons for SQL Statements and User Activity has added. They are now options under Employee Access Settings.
  3. Inactive Parts will no longer show when searching for Parts in the Purchase Order table.
  4. Webhelp link has been updated.
  5. Registration screen has been updated.
  6. Several Work Order Report Errors have been fixed. “Error from this update”
  7. The Tax now goes to a maximum of 4 decimals in all Tax fields.

Express Maintenance Mobile

  1. A Refresh button has been added to each page that contains a list to update current lookup.

Version 9.6.4.4

Released 3/28/19

Resolved screen overlay and sizing issue

Version 9.6.4.2  

Released 3/20/19

a.       Increased the size of columns from 80 to 100 characters to eliminate insert errors when data was greater the 80 characters.

b.       Masked email test password on email test form and added a Show/Hide button.

c.       Fixed the ownership field in the unit warranty tab. It was clearing when a lease term was selected.

d.       Fixed the inability to change Request email options in Configuration.

e.       Added Tech Notes to Work Orders

Version 9.6.4.1

Released 3/20/19

Increased the size of columns ActivityLog2.OldValue and ActivityLog2.NewValue from 80 to 100 characters to eliminate insert errors when data was greater the 80 characters. Added column Defaults.UpdateServerParams to store encrypted connection parameters for the update server.

Remove create “etuser” from Configuration. The code was raising an error and was not  consistent with create “etuser” methods in Databases & connections.

Fixed code to get the SQL Version of the server in Databases & connections.

Began changing the update code to use MAS server.

Masked email test password on email test form and added a Show/Hide button.

Fixed the inability to change Request email options in Configuration.


Version 9.6.1.2

Utilities.pas

Altered the SetViewCount function to now present the record number and number of records (example: 1 of 100).

 

Created a lower tab control and moved Services and Parts to separate tabs. Added a tab for Attachments with standard options such as select, open, etc.

Added Unit Number to upper section of work order with option to select by number or by name. Adjusted Unit Name and Number lookup components to work properly with one another allowing for lookup by either one.

 

Work Orders / Create Work Order

Added Time to the Scheduled Date prompt to allow for Date or Date and Time.

Adjusted to use the Requested DateTime on work orders created from Requests when no Scheduled DateTime is selected per requests from Gary’s list.

Added code to populate the AssignTo field of the request if there is no value and a technician is assigned at the time a work order is created. See item #4 in notes below.

 

Work Orders / Overview

Changed the Status list in overview from Scheduled to ‘Open’.

Changed the Status list in overview to include ‘Created’ as an option to search the date range. Added lookup field on Units table to include Unit Criticality field column in overview.

Changed the date fields in the grid to include DateTime rather than just Date.

 

Work Orders / Service Overview

Changed the column caption from Scheduled Date to Due Date.

 

Parts Inventory / Data View

Changed the Units tab caption from Units to Equipment. Corrected issue of the image menu button not functioning.

 

Units (Equipment) / Data View

Corrected issue of the image menu button not functioning.

 

Admin / Employees

Corrected the issue of the RecordNumber column not being properly linked to the data field. Corrected issue of the image menu button not functioning.

Changed code so that when new user access settings are created, Work Orders / View Pay Rates defaults to ‘N’ for no access. See item #1 in notes below.

Corrected issue of Site Limit and Site Limit Parts columns not being linked to data field in the Employee Overview grid.

 

9.5.3.3
This release fixes an issue with the Backups feature where the name of the Database was not getting saved and was causing a “Zero Value” error.
9.5.3.2
Updated Mobile Licensing to use new support database

9.5.3.1
General – Incorporates new version and features of Report Builder.

General – Imports 5 new reports used by the Mobile App.

General – New fields to accommodate the new Mobile App settings and licensing.

General – Update includes the new Mobile App Server software for communicating with mobile devices.

Administration / Defaults / Configuration – New Mobile App Settings section and fields for Mobile App Setup.

Maintenance / Work Orders – Corrected issue of one of the user defined service fields having the incorrect column heading.

Maintenance / Units – Corrected issue of older attachment hyperlinks not working.

ExpressRequest – Added ability to view notes of a work order services when viewing assigned work order.

Legacy Release Notes

Express Maintenance
Update File | 07/08/21

Express Request
Update File | 07/15/21

The Mobile Application

Download the Express Maintenance Mobile Application for Windows, IOS and Android

PASSWORD REQUIRED – request password via support ticket

Express Maintenance
Application Update File | 07/07/21

Express Maintenance CMMS
Express Maintenance CMMS Apple Store IOS
Express Maintenance CMMS Google Play

Please follow these steps to install and begin using the  Express Maintenance Mobile App.

  1. Click on the link above that is applicable to your mobile device.
  2. Download the app and install on your mobile device.
  3. Run the Mobile app titled ‘Maintenance’.
  4. The first time you run the app the Settings screen will appear.
  5. You must enter the Mobile Server, Mobile Port and Mobile Access Code provided to you by your system administrator.  If you were provided a barcode version of this information, click the ‘Scan’ button and scan the provided barcode.
  6. Once settings are entered or scanned, click the ‘Connect’ button.  You will not be required to enter this data in the future as it is saved by the app.
  7. The app will connect to the designated Express  Maintenance Mobile App Server and you will be presented with a login screen.  If the app fails to connect to the Mobile App Server, first read the Mobile App Setup Guide. If problems persist, you will need to create a ticket or contact the MAS support team.
  8. Enter your login and password and click the ‘Login’ button.

You are now ready to use the Express Maintenance Mobile App.  Go Mobile!

Installation Files

NO PASSWORD REQUIRED

Use these download files if you are new to Express Maintenance and Express Request. You will also need a copy of Microsoft SQL.

 

Express Maintenance CMMS

This function has been disabled for Express Maintenance CMMS.