All Articles

How to Import Meters

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!

Once your meters have been imported/created, you can even import your previous historical meter readings.

How to Import Meters

  1. Download the Meters Data Import” Sheet
  2. Open the CSV file in Excel/Google Sheets
    • Do not add, remove or change any headers in Row 1
    • Add in your data beginning with Row 2
  3. Below are instructions for filling out each column.
  4. Save the CSV file
  5. Upload new CSV under the Meters tab > Import > Upload CSV.
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!

Do you have historical meter readings that you’d like to add to UpKeep? If you’ve already created your meters, import your historical meter readings! Click here to learn more.

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 Values/Notes
A – Meter Name Oil Temperature Husky 7 Name of the meter, text+number values
B – Unit Fahrenheit Unit of measurement for the meter
C – Frequency 15 A number value; how often you’d like readings to be recorded for this meter (in days)

  • NOTE: the max is 730 days
D – Location Assigned ID CVtAO9gCDT This is the 10-character unique ID of the location that this meter is assigned to
E – Asset ID P4p0cSNLrF This is the 10-character unique ID of the asset that this meter is assigned to
F – Assigned User ID NOpyNXZ48d This is the 10-character unique ID of the user that this meter is assigned to
G – Category ID zpz3YxdBve What type of meter this is. It can be found in the Meter Categories and Category ID in the Categories Tab.

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