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
- Download the “Meters Data Import” Sheet (or check out the GIF below)
- 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
- Below are instructions for filling out each column.
- Save the CSV file
- 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
|
C - Frequency | 14 | Number value only
|
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
|
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
|