Meter Reading Exports

availability

Platform:	WebMobile
Plan Type:	BasicEssentialPremiumEnterprise
User Type:	RequesterFull UserAdministrator

This article explains how to export meter reading data to CSV (Excel), and provides detailed descriptions of how MaintainX exports data.

Export Meter Reading Data

1. From the sidebar, select Reporting.

2. In the Reporting module, go to the Export Data tab.

3. Select Meter Reading.

4. In the Export Reading List section, set the following options:

   Option	Description
   Date Range	Use the date picker to set the date range for the export.
   Export Format	Select CSV (Excel).
   Meter Type	Select one of the following meter types: Manual: for meter readings entered manually. IoT Device: for meter readings captured automatically from connected IoT devices and sensors.
   Columns	Select the columns to include in the export file. For details about each column, see List of Meter Reading Export Columns.

5. Do one of the following:

   • Select Schedule to export the data on a regular schedule. For details, see Scheduled Data Exports.
   • Select Export to export the data right away. MaintainX saves the exported file to the download center, and a download notification appears.

6. If you selected Export in the previous step, from the download notification you can do any of the following:

   • Download the exported file.
   • Select View in Download Center to open the download center. The exported file appears in the Export Request History section.

List of Meter Reading Export Columns

Manual

Column	Description
Meter Name	The name of the meter in MaintainX.
Meter ID	The meter's unique identification number in the MaintainX organization.
Asset Name	The name of the asset associated with the meter.
Location Name	The location associated with the meter.
Unit of Measure (U/M)	The unit of measure of the meter. For example a room temperature in Celsius or Fahrenheit.
Reading	The meter reading value.
Entered On	The date and time of the meter reading.
Entered By	The name of the user who entered the meter reading.
Work Order #	The work order number attached to the meter reading for the organization.
Work Order Title	The title of the work order attached to the meter reading.
Work Order URL	The URL of the work order attached to the meter reading.

IoT Device

Column	Description
Meter Name	The name of the meter in MaintainX.
Meter ID	The meter's unique identification number in the MaintainX organization.
Asset Name	The name of the asset associated with the meter.
Location Name	The location associated with the meter.
Unit of Measure (U/M)	The unit of measure of the meter. For example a room temperature in Celsius or Fahrenheit.
Count	The number of readings performed during the date range.
Minimum	The minimum value recorded during the meter reading.
Average	The average value recorded during the meter reading.
Maximum	The maximum value recorded during the meter reading.
Median	The median value recorded during the meter reading.
Since	The starting date and time of the meter reading.
Until	The completion date and time of the meter reading.