Creating Simple and Complex Jasper Reports for your MA CMMS

Getting Started

Before you start, it is encouraged that you do the following:

• Download and install iReport, a free application provided as the Jasper Reports template builder, from: http://sourceforge.net/projects/ireport/

• Learn more about Jasper by going to: http://jasperforge.org/website/jasperreportswebsite/trunk/documentation.html?group_id=252

With the iReport application installed. double click on the iReport icon from your desktop to start it. When running iReport for the first time, you will want to set it up to access your MA CMMS database. (note: it is not advised that you templates against a production version of MA CMMS, but rather a test copy running in your staging environment. This will ensure that it does not in any way interfere with your production CMMS. To set up a staging environment, or learn more about MA Installation best practices, go to the Best practices for MA CMMS installation on any Computer or Server Environment forum post).

Add Derby libraries to your iReport ClassPath (Only for first time setup):

1. go to Tools -> Options, and click on iReport button at the top of the dialog box

2. Under ClassPath tab, you will be adding libraries from your Maintenance Assistant CMMS library, these include ("derby.jar", "derbyclient.jar"). To add each of these, click on "Add Jar" button to the right, and browser to your MA CMMS installation folder (By default in windows, this is c:\Program Files\Maintenance Assistant CMMS V#.#.# build ####\. You will then locate the ".jar" files above by going to the .\app\ folder.

Attaching iReport to MA CMMS Database (Only for first time setup)

1. Add a new datasource for your MA CMMS database by clicking on the "Add Datasource"

button at the top left of your iReport application 2. Select "New" datasource connection, of type "Database

JDBC Connection" and click "Next" 3. Name your Connection "My MA CMMS DB", enter

"org.apache.derby.jdbc.ClientDriver" as the JDBC Driver, and enter your MA CMMS database connection information as outlined in the How can I use Reports, or access my database in MA CMMS FAQ. To test this connection click "Test". (note: if the connection fails, then you a) do not have your MA CMMS running at this location, b) your MA CMMS database is running on a different port.)

4. click "Save" and close your Connections / Datasource window

Now that you are connected to your MA CMMS database, you will be able to run queries against it in order to build out and test your Jasper Reports template using iReport.

Creating Simple Jasper Reports

Why Simple Jasper Reports?

Simple Jasper Reports allow you to build robust report templates which can be deployed quickly to give a rich and organized overview of your MA CMMS Data. Simple Jasper Reports have the following benefits:

• You can query any combination of data from your MA CMMS database through one SQL Query • You can generate rich reports with charts, graphs, and any custom layout for your data • Your report will generate as a PDF file when deployed in MA CMMS

Simple Jasper reports do not support:

• embeded images (logos, images, icons, etc) • creation of complex queries and sub reports (see Jasper Reports website for more information)

If the above capabilities satisfy your requirements, then follow the steps below to begin creating your Jasper Report template, and installing it into your MA CMMS.

Using iReport to generate your Jasper Reports template

Build the input SQL Script that will pull content from the MA CMMS Database:

1. in iReport go to File -> New 2. Select any desired template from the list of templates (this UserGuide will outline using a "Blank

Letter" template), and click "Launch Report Wizard" 3. In steps 1 and 2, select the desired location for this to run (make sure you place the templates in a folder

where no spaces exist in the folder name. i.e. "c:\My Report\" will not work, instead use similar to "c:\MyReport\").

4. in step 3 of the wizard use your "My MA CMMS DB" Connection / Datasource, and enter the SQL Statement: SELECT * FROM "tblUser" WHERE LENGTH("dblHourlyRate") > 0, or use "Design Query" to design your query visually. Click Next to proceed to step 4

5. In step 4, select the Fields that you wish to make available from this query. In this example, choose "id", "strFullName" and "dblHourlyRate". Click Next

6. In step 5, you can choose to group content together, we will not group by anything here. Click next. 7. Click finish to load the designer and build your template design

Now we will build a simple template with header, chart and footer (note: your report layout can be more complex than the example). At this stage, you will now be shown the designer view for your report template. design your template as follows:

1. First make sure the Palette is displayed by going to Window -> Palette from the main menu

2. Next we will add a title by clicking and dragging the "Static Text" from the Palette. double click on the box that appears in the Title area and type "Hourly Rate by Technician". Resize the box, and adjust the font size and style accordingly. Add the report run date as a sub-title so that it always shows the date that the report was run. To do so, drag "Current Date" from the Palette to the title area of your Designer view, and position this underneath your main title.

3. Now add Column Headings by again dragging the "Static Text" from the palette into the "Column Header" area in your Designer view of your report template. Create two column headings titled "Technician Name" and "Hourly Wage". Add a line under these headings if desired by dragging the "Line" item from the palette into the Column Header area.

4. Next we will add 2 "Text Field"s in the Detail 1 area of the Designer view of your report template. The first under the column heading "Technician Name" and the other under the column name "Hourly Wage" (column names created in step 3 above). right click on the Text Field under the Technician Name, and select "Expression Editor", Select "Field" -> "strFullName" and click "Apply". Next do the same for the second Text Field, select "dblHourlyRate", and click "Apply".

5. Lastly, we will add a page footer to track the report page number. To do so, drag "Page Number" from the Palette on to the Page Footer of the Designer view of your report template. Position this at the bottom right of the page.

When completed, your report template will look as follows:

Now test your report template to make sure that it runs properly against your MA CMMS data. To run the preview of this report and test it, simply click on the "Preview" action at the top of the Design view of your report template. When the Report is displayed, it should look as follows:

Install Jasper Report Template in your MA CMMS

You are now ready to import your report template into MA CMMS. To do so, follow the steps below:

1. Go to the XML view of your report template in your iReport. Copy all the text that is displayed in this view

2. Log into your MA CMMS web interface, and go to CMMS -> Business Intelligence -> Reports from your CMMS main menu.

3. Click on New from the top right on the action menu. In the new screen that is presented, select "Report Type" as "Jasper Reports", and click Save.

4. Add a Name, Description (helps to describe your report), Any instructions for running the report, and Paste all the contents from Step 1 above into the Definition Field. Save the report template.

5. Now you are ready to run your report. At the top right of your page, click on "Run". A new window will open, and automatically display your report as PDF in a new browser window (note: if a the report does not show, you may have PDF files blocked in your browser)

Creating Complex Jasper Reports

Why Complex Jasper Reports?

Using the Jasper Reports engine, you are able to run complex multi-query and multi-facet reports within your MA CMMS. Typically complex Jasper Reports would be used when you have a combination of data that you wish to format and display on one report that cannot be achieved through by one query, or simple layout. An example of a complext report would be showing sub-charts within a main chart, graphs that aggregate to top level query information, or adding images or icons to your report template.

Complex Jasper Reports have the following benefits:

• You can query any combination of data from your MA CMMS database through multiple individual or associated SQL Queries

• You can generate rich reports with charts, graphs, and any custom layout for your data • Your reports can include an unlimited number of complex queries and sub reports • Your report will generate as a PDF file when deployed in MA CMMS • You can embeded images (logos, images, icons, etc)

Using iReports to generate your complex Jasper Reports templates

1. Using the final template from Creating Simple Jasper Reports above, make sure you are in your Designer view of our Jasper Report template. From the Palette, drag the "Subreport" item to the "Detail 1" area of your Jasper Report template, underneath the two text fields for "strFullName" and "dblHourlyRate". You should automatically be prompted with the "Subreport wizard dialog". For this example, we will continue using the Subreport wizard.

2. on Step 1, select the "Create a new report" option, and click next 3. on Step 2, choose "Blank Letter" layout and click next 4. on step 3, select the "My MA CMMS DB" datasource, and add the query as SELECT * FROM

"tblAsset" AS A INNER JOIN "tblAssetUser" AS AU on A."id"=AU."intAssetID". Click next. 5. on step 4, choose "strCode", "strName", "intCategoryID" from the list of available columns. Click next.

on Step 5, group by "intCategoryID". Click next. 6. on step 5, accept the default settings and click next. 7. on step 6, choose "Use the same connection...", and click Finish to generate your Report Template.

You should now have 2 tabs at the top of your screen. The first tab is titled "report1.jrxml", and the second is titled "report1_subreport1.jrxml". click on the "report1.jrxml" tab to switch to your main report. You will see in the middle of your report template that the sub report item exists. Resize this so that it fits right/left edge just under your "strFullName" and "dblHourlyRate" items.

Now you will want to specify the inputs to your subreport, which will come from your main report. For this example, we will want to send in the id value of the technician, so that we can match it to a specific piece of equipment for which they are associated. To do this proceed as follows:

1. Ensure your "Report Inspector" is visible in iReports by going to Window -> Report Inspector, from your iReports menu

2. Under "Detail 1" in your "Report Inspector", select "$P{SUBREPORT_DI...", which will bring up the properties window directly below

3. In your properties window, scroll down to "Parameters" and click on the "..." to the right, this will bring up the Parameters dialog

4. In the Parameters dialog, click on the "Add" button and add a parameter as follows: "Parameter Name: USER_ID", "Value Expression: $F{id}", click "OK" to save this

5. In your properties window, scroll to "Subreport Expression" and click the "..." button to the right. The Connection expression window will be

presented. In this window remove the expression "$P{SUBREPORT_DIR} + " and click "OK" to save this.

6. From the tabs at the top of the page, switch to "report1_subreport1.jrxml" 7. From your Report Inspector select "report1_subreport1.jrxml". 8. In the Properties window, scroll to Query Text, and click on the "..." button to the right. Edit the query

and replace it with SELECT * FROM "tblAsset" AS A INNER JOIN "tblAssetUser" AS AU on A."id"=AU."intAssetID" WHERE AU."intUserID"=$P{USER_ID}. Click "OK" to save this.

9. From your Report Inspector, right click on "Parameters" and add "USER_ID", as parameter class "bigDecimal", with default expression -1

10. To your Subreport, add column headers for "Asset Code" and "Asset Name" 11. Add the text fields for both "strAssetCode" and "strAssetName" 12. Save your Subreport to the same directory as your "report1.jrxml" file

13. Compile your report by clicking on the Compile Button at the top of the page

Your report template should now look something like:

You have now finished creating your subreport template, you are now ready to Preview both reports together. Switching back to the "report1.jrxml" tab, click on Preview. Your preview report should look something like:

Install Complex Jasper Report Template in your MA CMMS

You are now ready to package and import your report template into MA CMMS. To do so, follow the steps below:

1. In your Windows Explorer, or Finder window, traverse to the directory where you have saved your reports templates.

2. Once located, select all report files: "report1.jrxml", "report1.jrpxml", "report1.jasper", "report1_subreport1.jrxml", "report1_subreport1.jasper", "report1_subreport1.jrpxml" (repeat for any other files / images included in the report), and create a zip file called: report1.zip

3. Log into your MA CMMS web interface, and go to CMMS -> Business Intelligence -> Reports from your CMMS main menu.

4. Click on New from the top right on the action menu. In the new screen that is presented, select "Report Type" as "Jasper Reports (Complex)", and click Save.

5. Add a Name, Description (helps to describe your report), and any instructions for running the report. Next browse and locate the "reports1.zip" file, and upload it to MA CMMS.

6. Now you are ready to run your report. At the top right of your page, click on "Run". A new window will open, and automatically display your report as PDF in a new browser window (note: if a the report does not show, you may have PDF files blocked in your browser)

Getting Started with Maintenance Assistant V3

Maintenance Assistant version 3 represents a significant leap forward in the Maintenance Assistant CMMS software. MA v3 sports a completely re-designed user interface, a new enterprise level backend, and much more advanced maintenance options. With all these advances, users of the MA v2.X series will find that things are a bit different, nevertheless MA v3 remains just as easy to use as earlier versions. If you are new to MA, then this guide will also be of great use in getting your organization started with the most powerful CMMS software available.

This guide will help familiarize you with MA v3, and will go over the basics. For more information on specific topics click on the "Help" button within the MA application to view the usage guide for that page.

Content Guide

1. Notes for v2.X Users 2. Getting Started 3. Users 4. Locations and Facilities 5. Assets 6. Work Orders 7. Scheduled Maintenance 8. Inventory and Supply Management 9. Further Information

Notes for v2.X Users

As mentioned earlier, MA v3 represents an entirely new release of our software, it has been redesigned from the ground up. There are a few things to note when upgrading from version 2 to 3.

Significant Changes

• MA is now powered by a Java backend, this allows us to employ industry leading open source frameworks, such as the Apache Derby database server, and the Apache Tomcat HTTP server. Moving to Java now allows MA to be run on any Java compatible system provided that server computer has the latest version of Java installed.

• MA now launches as a service on system startup. This means that MA will continue to run in the background, without any GUI or user logged in. This allows MA to be deployed on enterprise level servers.

• All functions have been moved to a web-based interface. The server admin / web interface dichotomy no longer exists. MA can now only be accessed using a web browser. This makes administering and using MA much easier, as everything can be found in one place.

• MA now supports completely customizable facility and asset management. Assets refer to any physical object that is entered into the MA system. MA groups assets into four broad categories, these are: Facilities, Equipment, Tools, and Parts & Supplies. Users can now create unlimited hierarchical structures for assets, for example you may create as many categories within tools as you desire.

• There are a few items to make note of when installing v3. To begin, MA v3 will install as a completely separate application, it will leave your MA v2.X installation intact and install to a new

directory. After installing v3 for the first time you will need to go through the setup, and register for a new business account. The need to do this reflects large, and upcoming changes we are making to our community model. After signing up for a new account with our community, you will also be required to create an administrator account. This is the account that you will use to login to your new MA v3 server. Once you have competed setup you may login with your new account and import data from v2.x. Importing data will be covered in a subsequent section.

There are a few items to make note of when installing v3. To begin, MA v3 will install as a completely separate application, it will leave your MA v2.X installation intact and install to a new directory. After installing v3 for the first time you will need to go through the setup, and register for a new business account. The need to do this reflects large, and upcoming changes we are making to our community model. After signing up for a new account with our community, you will also be required to create an administrator account. This is the account that you will use to login to your new MA v3 server. Once you have competed setup you may login with your new account and import data from v2.x. Importing data will be covered in a subsequent section.

Getting Started

This section will overview the basics of using Maintenance Assistant. Your MA server can only be accessed using a web browser - to get started with MA navigate to http://(IP of the server you are running on):8080/. The first time you access your Maintenance Assistant Server you will see an essentially empty page. To get started mouse over the "Account" tab, and click "Log on". Enter the username and password you created during setup, and push login. If you login was successful you will be at the "Dashboard" page.

The Maintenance Assistant User Interface and Dashboard The dashboard is a customizable page that contains an overview of your MA server. Below is a screen shot of what your dashboard page will look like the first time you login. We will take this opportunity to briefly familiarize you with the MA interface. When using MA, try not to think of the interface as individual web pages, instead try to picture an application running within your web browser (this is exactly what is happening!). As such, avoid using the back, and refresh buttons; they will not behave as expected. As well, do not attempt to bookmark individual pages when using the interface.

The screenshot above shows a first time login to the MA interface. Items of interest are numbered. Area 1

shows the main MA navigation bar, from here you can access administrative and maintenance related pages. Mousing over any of the tabs will bring up a menu. Area 2 shows the navigation bar, this is present on all MA pages and shows you where you are, refer to this if you ever need to know how you got to a page. Area 3 is the dashboard status bar, from here you can change your status from in to out, and quickly view pending work orders, or new messages. Area 4 is the dashboard area, which can be customized. By default work orders assigned to you, and unread messages will be shown on the dashboard. You may change the contents of your dashboard by going to "Account" -> "Preferences" -> "Layout and System" -> "Dashboard Preferences". Each user's dashboard is unique, and can be customized to meet the needs of that user. When you are done using MA make sure to logoff. You can do this by mousing over the "Account" tab, and clicking "Log off". Browsing Records Although you may not have needed to browse records yet, it is good to get to know how records are displayed in MA. By default 25 records are shown on a page, subsequent records over 25 can be accessed by scrolling to the bottom of the page and clicking the next page button. You can change the number of records displayed per page by going navigating to "Account" -> "Preferences" -> "Layout and System" -> "Layout Preferences", and changing the records per page field. You can sort records by clicking on the column headings, as you would in any other application. You may search for records by clicking the "Find" button in the top right bar. The "Action" button contains a menu of actions that is specific to the list of records being browsed. For example, this menu may contain items to create or delete a selected record. Finally the view menu allows you to customize which columns are shown, or show/hide the additional navigation boxes.

Editing Records Regardless of what you are editing most pages have the same general layout. Push the save button often to save any changes you have made while editing the record. Pushing the save button will not remove you from the record being edited. Pushing the close button will exit from the record being edited; note that any unsaved changes will not be saved. Finally you can print the contents of any record page by clicking the print button.

Users

The first thing you will want to do after installing MA is to create accounts for all the necessary users. Each person using MA should have their own account, this allows tracking of user activity, and assigning tasks to specific people. It is not advisable for people to share accounts.

Creating a New User To create a new user navigate to "Admin" -> "Users". You will see one user in the list, this is your administrator account. Click the new button in the top right corner to begin. MA will begin by creating a new user with an assigned personnel code, you can either choose to keep the generated code or create a new one. Note that each user must have a unique personnel code. Enter basic information for the user, you will need to give them a username and password, this is what they

will use to login to the system. The "Reports To" tab allows you to create user relational hierarchies, this is good in scenarios where there are multiple managers, each with a different set of users reporting to them. You can add a new link by clicking the new button and choosing a user to report to. The "Layout and System" tab contains options for customizing the user interface. The messaging tab allows you to specify if you would like alerts and/or messages forwarded to the user's email address. Note that you must have entered an email address for the user to make use of this option. Any item in MA can have files associated with it, even user accounts. Under the files tab you can choose to upload files that will be associated with this user. An example of files a user may want to upload might be documents such as PDF or Word files. You can also upload a picture for the user by creating a new file and selecting default image as the file type. It is mandatory that you assign each user a user role. The user role determines what permissions the user will have on the system. By default MA has the roles: Guest, Technician, Coordinator, and Administrator. See the section on user roles for more information. You must select at least one role for the new user. Finally, the community tab specifies what role, if any the user will have within the MA community.

Once you have completed filling in the information for this user click the "Save" button in the top right bar, then click the "Close" button to return to the user list. Repeat this process for all users that will require access to the system. User Roles Maintenance Assistant v3 allow you to create groups called user roles. A user role is a defined set of permissions that let the system know what pages a user can view. You can view all user roles by clicking on navigating to "Admin" -> "User Roles". From here you can edit, create, or delete existing user roles. The "Guest" user role applies to any user who accesses the MA server without logging in. Generally, with respect to the default user roles, administrators may edit any setting within the server, coordinators may edit maintenance related settings but not server settings, and technicians may edit and complete work orders, and view but not edit most other maintenance items.

Locations and Facilities

After adding all the necessary users the next step is to organize the locations and facilities within MA to match your organization's needs. A facility represents a category in which assets may be placed, and scheduled maintenance will take place. Facilities by default are divided into three categories: inventory storage, buildings, and plants. Facilities can have physical locations assigned to them (IE an address), and can have child items. Whenever you give an asset a physical location, that location will get added to the locations list, and when adding any other assets you may specify the location from this list, or create a new location. For example, if the layout of an organization was as follows: Main Plant: Located in Toronto, Ontario, contains production lines, offices, and shipping departments. Auxiliary Plant: Hamilton, Ontario, contains offices and production lines. In this scenario you would create two facilities of type plant, and assign each a respective location. Two locations: Toronto, and Hamilton, would get added to your list of locations. If in future if you wish to create additional facilities at either location you can assign them to the "Hamilton" or "Toronto" locations without re-

entering the addresses. Facilities themselves are also considered "Assets", if this is confusing just try to keep in mind that any item entered into the system is essentially an asset (plant/tool/equipment/inventory). To begin navigate to "CMMS" -> "Facilities", and click the new button. It is advisable to add at least one "facility" to MA so that you may assign locations to other assets. Like other items in MA you can assign files to a facility. These files may include: an image to represent the facility, maps of the facility, or any miscellaneous associated items. All assets in MA may also have meter readings assigned to them - we will cover this later. Finally, you may associate personnel with a given facility. This is helpful if you would like to classify users based on where they are located, in cases where there may be multiple facilities.

Assets

Once you have entered all the necessary facilities you may move on to entering assets. Assets include: inventory, equipment, and tools. An asset represents an item that can have work order performed against it, have its inventory depleted (in the case of inventory), or be used in the completion of another work order (tools and inventory). We will work off the following example to guide you through creating assets: My organization has a truck which will have maintenance performed on it. The truck has an engine, which will also need to be entered. Oil and tires are inventory items that the truck will use. A wrench is often used for maintenance on the truck. The truck is located at the Toronto plant. Working off this example, the first asset we would add would be the truck itself. To begin navigate to

"CMMS" -> "Equipment" and push the new button. The "General" tab might look something like this:

The purchasing tab contains information from the purchase of the asset. As per other records in MA, you may associate files, including images, with the asset. The meter reading tab is new at this point. A meter reading represents any quantitative reading that can be made on the machine, and may be used in generating preventative maintenance. Appropriate for our truck example would be to add a meter reading based on the odometer:

To add a meter reading, select the meter reading units, enter a value and click "Add Meter Reading". We will revisit meter readings later. The next tab, "Personnel", allows you to associate specific users with the piece of equipment. These may be users of the equipment, or technicians responsible for performing maintenance. The "Warranties" tab allows you to keep track of any warranties associated with the piece of equipment. The warranty for our example may look as follows:

Finally the "Businesses" tab allows you to associate any business you have entered into your system with the asset. See the inventory and supply management section for more details. When you are finished entering details for your asset click save. By default when an asset is created it is set to offline. Take this opportunity to set the asset's status to online, this indicates that the piece of equipment is functioning properly and can have work orders created for it.

Now that we have added the truck, we can move on to adding other assets that are associated with the truck. Next we will enter another piece of equipment - the engine of the truck. When entering the information for this piece of equipment we would choose "This equipment is part of: " instead of a location. We would then choose the Ford 150 item as the parent. This lets MA know that the engine is a part of the truck. Other than this detail, filling out the information for this piece of equipment is the same.

Now that we have added both the engine and the truck it is time to move onto other assets associated with the truck - the oil and tires. These items are consumable meaning that more than one of them is likely to exist in inventory, and that they are going to be used up in work orders. To enter these assets navigate to "CMMS" -> "Parts and Supplies". Again, click new to create a new asset. All tabs here will be the same with the exception of one, the "Stock Levels" tab. The first category "Inventory Stock Levels" allows you to view how much of the inventory item is in stock, and what the minimum stock level is. Once the minimum stock level has been reached, you will be notified, and a request for quote (RFQ) can automatically be made. We will return to

RFQs in the inventory and supply management section. To let the system know how much of an inventory item remains you can add a new stock level under the "Inventory Stocking and Purchase Records" section. This allows you to keep track of how much inventory is in the system, how much the supplies cost, who sold them, and when they expire (if applicable). Going with our motor oil example, an entry might look like this:

You can choose any unit you would like when entering inventory levels. Since this item is a fluid I could define the quantities in liters, or alternatively I could specify the amount in bottles. Just make sure to always enter inventory levels in the same units. When you are finished click save, and then close the record. Since tires are consumable items, they would also be added in the inventory category. The last asset we will be adding for this example will be the wrench. The wrench should be added under the tools category, access this by navigating to "CMMS" -> "Tools". Click new to create a new tool. Tools are defined as items that are used in completing maintenance or a work order, but are not consumed in the act of doing so. For example, the wrench may be used during truck maintenance, but unlike a tire, or oil, it does not have inventory associated with it. Adding tools into MA will allow you to keep track of what tools will be required by different users for maintenance. This type of asset does not have any new fields. We have now gone over the basics of adding assets. While this may seem simple, it illustrates the breakdown of how assets should be entered into MA. Meter Readings Any asset entered into MA can have meter readings entered for it. Meter readings can be used simply to keep track of usage - such as miles traveled in the case of our truck, they can be used to determine when a warranty has expired, or they can be used to generate scheduled maintenance. For example, maybe general maintenance needs to be done on the truck every 20,000 kilometers. Meter readings can be entered for an asset through either asset details page, or when updating / completing a work order assigned to that asset. MA keeps a log of all meter readings, when they were entered, and who entered them. You can add new types of meter readings, in addition to the defaults, by navigating to "Admin"-> "Meter Reading Units" while logged in as an administrator.

Work Orders

A work order is a request for maintenance on an asset that can be created manually, or by the system itself based on a set of criteria. Setting the system up to automatically make work orders will be covered in the scheduled maintenance section. There are a few ways to create a work order:

1. As a guest, without being logged into the system, by navigating to "Account" -> "Submit Work Order Request".

2. When logged into the system, as a technician, by navigating to "CMMS" -> "Work Orders" -> "New".

3. Created by a scheduled maintenance item, automatically by the system.

Submitting a Work Order Request We will first go over the simplest way to create a work order, submitting a work order request. The work order request system is designed for users to request maintenance on an asset who are not necessarily in the system as a technician (IE they have no username/password). These may be users of a piece of equipment, as opposed to the people who perform maintenance on that equipment. The work order request page presents a very simple page, with minimal options:

Users need only enter a description of the problem, the asset, type of maintenance, priority and suggested time. Notice that the work order status is locked in as "Requested", this means that the work order will not be assigned to a technician, or appear in the work order list until it has been accepted by an administrator. Now we will login as an administrator and navigate to the "CMMS" -> "Work Orders" page. In the left hand column you will see a list of work order statuses: requested, assigned, open, work in progress, on hold, completed, and draft. These provide you with the flexibility to categorize exactly what phase of completion a work order is in. By default we are brought to the requested work orders. In the list you will see the work order that was just requested, double click it to open the work order. You will now be presented with a much more detailed work order page. This is the administrator's view. Here administrators may edit any information associated with the work order. For this example we will simply change the status of the work order to open,

and assign a technician. To change the status, simply click the work order status menu, and select open. Next click on the "Technicians" tab, and under "Associated Technicians" click "New". Here you may assign a technician to the work order, and select notification options. Clicking save will apply the changes. Creating a Work Order as an Administrator When creating a work order as an administrator you will find that there are many more options than simply submitting a request. The "General" tab is the same, however you may change the work order status - it is not locked into requested. As before, select an asset, maintenance type, etc... New here you will notice the "Tasks" tab. This allows you to assign specific tasks that a technician must perform when completing the work order. Upon completion of the work order, the technician will be required to report on the status of each task - whether they were completed or not. To create new tasks simply click the new button. You can choose to assign individual tasks to a technician, or leave the field blank. You will notice that the tasks are presented in a specific order. This is the order in which the tasks should be completed. Clicking the up/down arrows in the list allows you to change the order of the tasks.

You can now add technicians to the work order, as you did previously. Next you can add any parts and supplies that you thing will be required for the work order. Click the "Parts and Supplies" tab. Adding a suggested part will not actually deplete inventory, it is just a way of letting the technician know what parts will be required for the maintenance. When completing the work order the technician will report the actual parts, and amounts used. The notes tab allows you to enter additional information for the technician. Notice that there is also a "Completion Notes" field, this will be populated by the technician when completing the work order. The "Files" tab allows you to attach files to the work order, and works similarly as it does throughout the application. Finally, the "Work Log" tab displays a list of all activity involving the work order. At this stage this is irrelevant, however once the work order is opened, it will display when it was edited, updated, or completed, and by what user. Click save to create the work order. Updating and Completing a Work Order Your dashboard will inform you of any work orders that have been assigned to you. You may receive a message, and you will see the work orders in the assigned work orders list. You can view all work orders that are assigned to you at any time by navigating to "Account" -> "Assigned Work Orders".

Double clicking an assigned work order will bring up the work order details. You will notice that this page looks different from the admin work order creation / editing page. This is because this page is designed to be used by technicians who will be completing the work order, not administrators. The top of the page gives a brief overview of information:

In this example we are going to complete the work order by setting the work order status to "Completed". If we only wanted to update the work order, for example by completing only half the tasks, we could set the status to "Work in Progress". Next we can move onto reporting progress on the tasks that were assigned to the work order.

The checkboxes can be marked if the task was completed, and the amount of time required to complete each task can be entered. If additional tasks above and beyond the assign tasks were performed, they can be added using the "Additional Tasks Completed" section. After reporting the progress on assigned tasks, a meter reading may be entered for the asset which maintenance was performed on. In this case we may want to include the odometer reading in the work order. Next parts and supplies used during maintenance can be entered. First, parts that were suggested for the maintenance can have actual consumption values assigned. This is done by filling in the edit field beside the part name in the list, under the "Actual Quantity Used" heading. Entering a value here will deplete inventory levels for the part. Additionally, parts not suggested in the work order itself can be added by clicking the new button. Here you may select a part, and the quantity of it that was used. As mentioned earlier, the notes field allows the technician to enter completion notes, these will be saved with the work order. As per usual, files can be added. The work log is also visible. Clicking save will update inventory levels, and move the work order from open to completed. It will no longer show up in the assigned work orders list. Viewing Previously Completed Work Orders Administrators may view and edit previously completed work orders, just as they can view and edit work orders that are in progress. To edit the details of a work order login as an administrator and navigate to the "CMMS" -> "Work Orders" page. You can then click the "Completed" item in the left hand menu. This will give a list of completed work orders, double clicking a work order will allow you to edit it.

Scheduled Maintenance

A scheduled maintenance item will create a work order based on a given set of conditions. These conditions can be based on a time interval, or a meter reading interval. To create a scheduled maintenance item navigate to "CMMS" -> "Scheduled Maintenance", and click the new button. You will notice the "General" tab is identical to creating a work order. When a work order is made from the scheduled item it will inherit all the settings entered here. The only new tab is the "Scheduling" tab. The schedule for a scheduled item is defined by a list of criteria entered here. You can choose to have the work order created when any of the criteria are

met, or when all of the criteria are met. To create a new criteria click the new button. The scheduling can be based either on a time schedule or a meter reading interval:

If a scheduled item is created based on a time schedule then you may choose the interval: daily, weekly, monthly, or yearly. You may also choose a start and end date. If it is to be based on a meter reading then the units, interval, and number of triggers must be selected. When you have filled out all other fields as you would a work order click save and close. This scheduled maintenance item will now be active, and will create work orders based on the schedule. By default scheduled maintenance items are created 2 days ahead of schedule at 9AM. This option can be changed by navigating to "Admin" -> "CMMS Settings" -> "Maintenance and Work Order" while logged in as an administrator.

Inventory and Supply Management

Maintenance Assistant v3 includes advanced inventory and supply management features. MA can keep track of inventory, and even send out request for quotes (RFQs) when your inventory is low. The first step to setting up automated inventory management is to add businesses that you order inventory from.

Businesses You can add businesses that you order inventory from, need to contact, or hire technicians from into maintenance assistant. To get started navigate to "CMMS" -> "Businesses", and click the new button. Enter the general information for the business, and select the roles the business plays: Manufacturer, Supplier, and/or Service Provider. You may then specify a location for the business, and add any schematics or diagrams provided by the business. For supply management the most important setting is the "Associated Assets" tab. Here you can add any assets that may be supplied by the given business.

Start by selecting an asset that will be associated with the business. Next choose the role the business plays for this asset, in the example above Ford is selling tires. If applicable you may enter an asset number specific to that business. This is helpful if the business has their own codes that they use to refer to items. If checked, "Send RFQs" will automatically email the supplier with an RFQ when the inventory of the asset runs below the specified minimum value, which is defined in the asset details. The economic batch quantity is the number of items for which an RFQ will be requested. For example, in the case above, when the tired inventory ran below the defined minimum an RFQ would be emailed to Ford requesting 4 tires. The personnel tab allows you to associate users with the business. This is helpful if for example the business is a service provider - thus technicians from the company may be using your MA, and can be appropriately associated with the business. Finally the "Supply Management" tab allows you to specify advanced RFQ settings, and a billing currency.

Further Information

We have gone through the basics of setting your organization up with Maintenance Assistant. For more information please visit our website. The website contains a wealth of tutorials and knowledge base articles. In addition, you may click the help button in MA at any time to get more information on the page you are working in.

Setting up your Network for the MA CMMS

To open up your MA CMMS for full functionality, and take advantage of the MA Community enabled features, you will need to ensure that the MA CMMS has proper access to our secure Community Servers over SSL default port (443). The MA Community connection is secured using 128 bit SSL encryption (the same level of encryption as your online banking or favorite shopping website), ensuring that any data that is transferred between your CMMS and our servers remain secure.

Background: Most Corporate and individual networks will be locked down tight against internet access from outside, and sometimes access from within your network out to the internet. Having these "Firewall" protections in place ensure that you do not get applications or people running potentially dangerous applications across your network, comprimising your corporate security.

Content Guide

1. Base Network Requirements 2. Set up your Firewall for Community Connection 3. Set up your Firewall for (Remote) INTERNET Workstation Access

Throughout the guide, refer to the diagram below for an understanding of the network layout of your MA CMMS solution. This diagram outlines the network activity that would be expected within a typical installation with a MA Community connection:

Base Network Requirements

If you intend to run the MA CMMS within your local network, whether registered or unregistered, you should follow the following installation guidelines. Most of items listed below will be standard network setup within many organizations:

• Install your MA CMMS on a central server computer that will remain on at all times. (if your MA CMMS installation machine is off, your MA CMMS Server will not be running)

• Ensure that all workstation computers within your network have access to the server computer where the MA CMMS Server will install, and that they can connect on their webbrowser to the MA CMMS at (http://<Server_Computer_IP>:8080/ OR https://<Server_Computer_IP>:8443/)

• Ensure that you are using a Standards Compliant browser within your organization. (Firefox 3+, Chrome, Safari, IE7+*) *-note: IE7 is not fully standards compliant

For more Installation Best Practices, review: Best practices for MA CMMS installation on any Computer or Server Environment

Set up your Firewall for Community Connection

By default, many firewalls will be closed to applications accessing the internet as a security precaution. If this is the case you may receive a warning message when attempting to connect your CMMS to the Community.

If you are unable to connect to register your CMMS, you will need to ensure the following is true, before attempting to Connect and Register. For these steps it is advised that you consult with your Network Administrator, as it assumes a certain level understanding of Network Solutioning.

• The MA CMMS Server running on your Corporate Network Server must have access to connect to the MA Community Servers at https://wsv3.maintenanceassistant.com/

One test, to check if there is connectivity available between the MA CMMS and the MA Community Servers for this is from Corporate Network Server, where MA CMMS Server is installed, open a web browser and navigate to https://wsv3.maintenanceassistant.com/. If you can see the MA website, then chances are your MA CMMS will have access.

If you still do not have access from your MA CMMS, then most likely your firewall will be blocking MA CMMS Server specifically from contacting this URL. You will need to add a rule to your corporate firewall, allowing the MA CMMS Application Server to connect to https://wsv3.maintenanceassistant.com/.

Set up your Firewall for (Remote) INTERNET Workstation Access

If you intend to allow staff to access your MA CMMS from outside your network, you may need to configure your Corporate firewall to allow access from the INTERNET to your MA CMMS Server. By default, many firewalls will be closed to users accessing your network from the Internet as a security precaution. If this is the case you may receive an error message in your web browser when you attempt to connect from outside your network. If you wish to access to your MA CMMS Web Interface from outside your network, you will need to ensure the following is true, before attempting to Connect:

• You have registered your MA CMMS to a Community Connection. Review this under Admin » Your Business

• Your MA CMMS Administrator has issued a User Community Account to each user who will be

connecting from the internet. A User Community Account can be issued to each user in the CMMS from Admin » Users

• Your corporate firewall is set to allow external connections on port (8080 / 8443), or to route any external connection you wish on your firwall to the MA CMMS running on your internal network (http://<Server_Computer_IP>:8080/ OR https://<Server_Computer_IP>:8443/)

Normal Scenario

Once the above requirements are satisifed, you can do the following to connect to your MA CMMS from outside your network:

1. Log into your MA CMMS from within your network to ensure that you have been issued a Community User account. Go to Account » Preferences » Community Tab

2. Next, go to the MA Community Login, and log in. To log into the MA Community, simply go to our website at http://www.maintenanceassistant.com, and go to Community » Login

3. When you login, you will see your company CMMS listed on your dashboard. If your CMMS is online, the heartbeat should indicate its accessibility. If your CMMS is online, click on the link that relates to your business, and you will immediately be connected to your MA CMMS.

Advanced Scenario

If you have a corporate url, or subdomain that you wish to assign to your MA CMMS, you can do so by ensuring that this URL forwards appropriately on your corporate network. The following example will outline how to accomplish this:

• Your Corporate Domain is www.yourcompanyurl.com • You wish to use macmms.yourcompanyurl.com as your MA CMMS url

1. On your web-server or external company server, ensure that your Firewall allows connectivity and your proxy server forwards all network connections on http://macmms.yourcompanyurl.com -> http://<Server_Computer_IP>:8080/

2. It is always recommended that you connect to your CMMS over a SSL connection, to ensure that your data is always secure while using your MA CMMS. By default the MA CMMS Server is SSL enabled, however if you are setting up an external domain, you will need to purchase a SSL certificate from your desired CA (i.e. www.entrust.com), and install it on your external server tied to the url:macmms.yourcompanyurl.com. Once this is completed, you can then ensure that your firewalls allow connectivity and your proxy server forwards all network connections on https://macmms.yourcompanyurl.com -> https://<Server_Computer_IP>:8443/

Once this is set up, you can direct all CMMS users to connect to your CMMS directly by going to either http://macmms.yourcompanyurl.com / https://macmms.yourcompanyurl.com, or by connecting to the MA Community as follows:

1. Log into your MA CMMS from within your network to ensure that you have been

issued a Community User account. Go to Account » Preferences » Community Tab 2. Next, go to the MA Community Login, and log in. To log into the MA Community, simply go to our

website at http://www.maintenanceassistant.com, and go to Community » Login 3. When you login, you will see your company CMMS listed on your dashboard. If your CMMS is online,

the heartbeat should indicate its accessibility. If your CMMS is online, click on the link that relates to your business, and you will immediately be connected to your MA CMMS.