When your team is looking to keep track of the usage of your Assets, you can go to our Meters section. This way you can track historical usage over time. You also have the ability to use Meters to set-up Work Order Triggers.

If you already have your list of Meters that you want to set-up, you can import these into UpKeep quickly!

Here is a video tutorial on importing meters. You can also find this at 29:27 of our general Data Importing Webinar!


How to Import Meters

  1. Download the Meters Data ImportSheet (or check out the GIF below)
  2. Open the CSV file in Excel/Google Sheets
  3. Do not add, remove or change any headers in Row 1
  4. Add in your data beginning with Row 2
  5. Below are instructions for filling out each column.
  6. Save the CSV file
  7. Upload new CSV under the Meters tab > Import > Upload CSV.

NOTE: You can only import 1000 meters in a CSV file at a time, but there is no limit to the total number of meters in your UpKeep account!


Guide

NOTE: The ID refers to a unique, UpKeep assigned ID. You can find each 10-character ID in the URL when clicking into the location/asset/part/etc. All IDs can also be found when exporting each data set in Column A of the CSV!

Column Header

Example Entry

Acceptable Value/Format/Notes

A- Meter Name

Truck #1 - Mileage

Name of this meter

B - Unit

Miles

The unit of measurement for this meter

  • NOTE: No special characters

C - Frequency

14

Number value only

  • NOTE: This is already in days so do not type in days/months

D - Location Assigned ID

BD9nFKP0pi

This is the 10-character unique ID of the location that this meter is assigned to

E - Asset ID

PM0VMSNWkL

This is the 10-character unique ID of the asset that this meter is assigned to

  • TIP: You can assign multiple meters to an asset but you can only create each meter for one asset at a time.

F - User Assigned ID

RGtkbMqJrl

This is the 10-character unique ID of the user that will be assigned to the meter

G - Category ID

Mileage

This is the 10-character unique ID of the meter category that you will add this reading to

Did this answer your question?