DCMMS User Guide

Changes introduced by the latest DCMMS version.

The history of changes introduced by older versions is available in Chapter 5, History.

The following changes in version 2.0.4 are relevant to the users:

A consistent navigation structure guides through the application. Through the "DCMMS" link in the navigation bar at the top it is always possible to return back to the main page (main menu).

Logoff, workorder and landmark search and help functions are available at the top of each page.

The DCMMS application is fully internationalized. You can switch to the language of your choice using the select box at the top of the page.

DCMMS is currently available in the following languages:

Additional languages can be easily added. If the language you are looking for is missing, please contact the DCMMS developers.

Ask your DCMMS administrator to enable one of the above languages if necessary.

The find tool in the navigation bar allows to search for workorders and landmarks.

Workorder number or landmark name have to be entered to the text field. Pressing Enter or clicking on the Find button next to the data entry field will start the search for the landmark or workorder number.

	Tip
	DCMMS administrators can extend the find tool through plug-ins. One such plug-in is the customer search plug-in that allows to zoom to customer locations using their subscription number. See Section 3.15.1, “Customer Search Plug-In” for details.

The DCMMS application helps you to fill in the forms correctly by providing an intuitive help: If you leave the mouse cursor without movement over a field, a help message will be displayed.

Where database queries return too many results to display on the screen, DCMMS will offer a pager navigation that allows to browse through all the records. This concept is used for example in the zoom (Section 3.4, “Zoom Page”) and workorder list (Section 3.6, “Workorder”) pages.

A pager looks like the following:

Displaying [11 - 20] of 22
<< Back1 2 3 Next >>

Context sensitive help is available on every page by clicking on Help link in the navigation bar.

The user guide will be opened in the language that is currently selected in the DCMMS application.

	Note
	If no documentation is available in the language that is selected in the application, an error message might be displayed by the browser. Try to switch to another language in this case (Section 1.3.2, “Languages”). Then click on the help link again.

The chapter describing the current page will be opened in the DCMMS user guide.

Dates and timestamps are as defined in the ISO format: YYYY-MM-DD HH:mm

For example: 2006-01-23 09:14

Wherever fields are mandatory in forms, they are marked with a red *.

These fields have to be filled in order to submit the form successfully.

Problems operating the DCMMS system have to be documented by filling in a DCMMS Downtime Monitoring Sheet.

The following information has to be recorded:

	Important
	The DCMMS Downtime Monitoring sheet has to be submitted to the DCMMS administrator on a weekly basis.

Instead of using specific terms like "On main pipe", one should use "On pipe" and enter the diameter that is involved. This allows much better analysis of the data and is much less error prone. Your field personnel may have a different understanding what a main pipe is. But they'll all know the diameter of the pipe.

Another example would be a maintenance type like "Main Valve Repair". Instead of such a specific term, the maintenace type "Repair should be used in combination with the valve diameter and the leak location "On Valve".

	Tip
	The flexible combination of several generic terms in the application allows to cover highly specific cases.

Newer DCMMS versions use more generic terms like "On Pipe" or "On Valve" because they are more flexible.

See Section 3.2.1, “Why are there so many generic terms (I would like to see more specific terms) ?” for details.

This depends on the browser version.

For Mozilla Firefox, follow the steps below:

The application is "recycling" workorder numbers where the data entry process was not completed.

It would also be possible to have completely sequential workorder numbers, but this would lead to gaps in the sequence and thus misleading workorder numbers that are higher than the total number of complaints recorded.

The reports make it easy to sort the workorders by any criteria including the date they were received.

Yes of course. All reports are HTML reports than can be easily opened in Excel for further processing.

Just create the report that contains the information you are interested in, save it in the browser and open it in Excel.

The following map tools are available:

Zoom In Use this tool to decrease the map extent.

Zoom Out Use this tool to increase the map extent.

Pan Use this tool to recenter the map. The map will be centered around the click point.

Identify use this tool to see information about features on the map. Your administrator might use plug-ins to deliver custom information (e.g. images) for the identified features.

Landmark use this tool to add landmarks to the map. The tool is also used to view detailed landmark information and edit landmarks (See Section 3.12, “Landmark”).

Workorder (Center) Use this tool to select the workorder's area of interest (See Section 2.2, “Create a Workorder”.

	Note
	The tools work without double-click and rubber-banding. Select a tool and click one time on the map. Depending on server, internet connection and complexity of the map, loading the new map might take a few seconds.

Lists all the currently pending (open) workorders.

If necessary, pager elements (Section 1.3.5, “Pager Navigation”) are displayed on the page to allow to browse through all records.

In the Action column of the table, links allow to view detailed information related to the workorder:

The Map link should be used to complete a workorder after the maintenance team has returned from the field.

A list of all workorders that have been completed.

Use the links next to the workorders in order to retrieve additional information (See Section 3.6, “Workorder”).

Allows to record the working hours of different types of staff that completed a given workorder.

Allows to record quantities and diameters of different materials that have been used to perform a maintenance activity.

Allows to record which type of equipment has been used to perform a maintenance activity (including working hours and cost center).

Re-establishing broken seals is a priority. For this reason, the seal page together with Section 3.9.2.6, “Broken Seals Report” provide all relevant information for this topic.

Reports related to the workorder records.

3.9.1.7. Query Workorder Status

Query a specific workorder.

Workorder number or complainant name can be entered to search the workorder.

	Tip
	Use the find tool in the navigation bar to search workorders by number (Section 1.3.3, “Find”).

3.9.1.8. Aging Report

Report workorder aging over a period of time.

Input of the mandatory fields Count (e.g. 7), Interval (e.g. days) and End Date (e.g. 2006-01-25 00:00) should be read like this: Create the aging report for the period of 7 days before January 25, 2006.

The selection of administrative area and workorder type information is optional. If one of them is selected, the report will be limited accordingly.

	Tip
	This report is a useful tool to analyze trends in the maintenance works (E.g.: Are workorders piling up?).

The maintenance team foreman has to fill in the workorder sheet in the field. This includes marking of the pipe on which the maintenance has been performed in case that this is missing on the map.

Printing workorders requires a compact page setup.

To setup the pages using Firefox, select File->Page Setup... from the menu.

In the page setup dialog select "Landscape" and "Shrink to Fit to Page Width" as shown in Figure 3.1, “Firefox Page Setup”.

Figure 3.1. Firefox Page Setup

Then click on the Margins & Header/Footer tab and set all the margins to 0 as shown in Figure 3.2, “Firefox Margin Setup”.

Figure 3.2. Firefox Margin Setup

Set all header and footer items to "--blank--".

Click the OK button to confirm the page and margin setup.

Copyright information for DCMMS and the software packages used by the application.

DCMMS is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

DCMMS is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

The GNU General Public License (GPL) is available from http://www.gnu.org.

Add and edit DCMMS users and their access rights.

A user is able to log on to the application.

Users can be assigned administrator rights. This assigns the PostgreSQL role "dcmmsadministrator" to them through which additional rights are given on the database level. In addition administrator functions are available in the web interface through Section 3.3, “Main Page”.

DCMMS administrators can reach this page through Section 3.3, “Main Page”.

See Section 3.14, “Administration” for the administrator functions that are available through the web interface.

User can be assigned the landmark editor role which allows them to edit and delete landmarks (Section 3.12, “Landmark”).

Add and edit maintenance teams.

Maintenance teams perform the actual maintenance works. Workorders are assigned to them.

DCMMS administrators can reach this page through Section 3.3, “Main Page”.

Allows to delete all files in c:\tmp and c:\tmp\ms_tmp. All files that are older than one hour will be deleted.

Administrators can reach this page through Section 3.3, “Main Page”.

Allows to delete a workorder and all related records (maintenance, staff, material, equipment, seal, history).

The number of the workorder to be deleted has to be entered to the form.

	Tip
	The PL/SQL function purgeworkorder(int workorderid) is used internally. It can also be used in SQL queries. For example: select purgeworkorder(id) from workorder where id < 1000

DCMMS administrators can reach this page through Section 3.3, “Main Page”.

Allows to spatially analyze the maintenance data.

Three different analysis types are available:

	Important
	The per-pipe density analysis requires the pipe network to be loaded to the PressurizedMain table. Calculation of the per-connection density requires the Connection table. You can use the Gshp2pgsql to load those files.

The functions automatically compress the analysis data by dropping those cells that don't contain any data.

Instead of a fixed cell size for the analysis, the resolution of the analysis data is specified. As a result, cell sizes and alignments that are changing dynamically with the recorded data.

Administrators reach this page from Section 3.3, “Main Page”.

Information on the setup of the DCMMS application.

Displays the languages that have been enabled on the application as well as on the database side.

Displays DCMMS plugins that are configured in identifyplugin.ini.

Displays available PEAR packages including version number.

Administrators can reach this page from Section 3.3, “Main Page”.

Allows to update DCMMS translations on the database side.

Administrators can reach this page from Section 3.3, “Main Page”.

The customer search plug-in extends the navigation bar find tool with functionality to zoom to customer locations based on their subscription number.

The plug-in is executed when a keyword followed by a colon (":") is prepended to the search term entered to the find tool.

The default keyword for the customer search is "customer", however, this might be changed by the administrator. Example 3.1, “Search for customer with subscription number 311” shows an example search using this default key word.

customer:311

If a matching customer is found, the map page will be zoomed to the customer location. In case no matching customer is found, an error message is displayed.

If you encounter an error like in Figure 4.1, “The Page Cannot be Displayed”, the network connection to the server might be lost. Check that the network cable is connected properly to your computer. If the problem is not related to the network cable, contact your DCMMS administrator.

Figure 4.1. The Page Cannot be Displayed

When the workorder are not printed correctly (e.g. the workorder is split across multiple pages or in portrait instead of landscape orientation), make sure that you follow the page setup instructions (see Section 3.10.2, “Firefox Page Setup”).