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!


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.

[tip] 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![/tip]


Guide

Column Notes
A – Meter Name Enter in a name for the Meter

  • Ex: Oil Temperature Husky 7
B – Unit Enter in a unit of measurement for this Meter

  • Ex: Fahrenheit
C – Frequency Enter in the frequency (in days) of when readings will be collected for this Meter (the max is 730 days)

  • Ex: 7
D – Location Assigned ID Locate the Location ID via the URL Address. This is the last ten characters after the forward-slash. Please see the example below:

This can also be found by exporting your Locations in Column A

E – Asset ID Locate the Asset ID via the URL Address. This is the last ten characters after the forward-slash. Please see the example below:​

This can also be found by exporting your Assets in Column A

F – Assigned User ID  Select the user in the People & Teams section. This is the last ten characters after the forward-slash. Please see the example below

 G – Category ID  Define what type of Meter it is. You can find the Meter Categories and Category ID in the Categories Tab of the Application.

​[tip] 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.[/tip]