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. If you have your list of Meters you want to set-up you can import these in to UpKeep by using our template.

  1. Download Meters Data Import” Sheet
  2. Open CSV in Excel
    • Do not add or remove any headers in row 1)
    • Add in your data starting with row 2)
  3. Below are instructions for filling out each column
  4. Save as a new CSV file
  5. Upload new CSV under the Meters tab > Import > Upload CSV
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.

 

Want to learn more? Join our Data Importing Webinar here.