Back to Asset Essentials Main Menu

Importing Meter Readings

*Note: The Importing feature is only available to clients who have purchased Asset Essentials Enterprise. Please contact your Sales Representative or Client Services if you are interested in purchasing Asset Essentials Enterprise.

Importing Meter Readings

  • Click on the Assets menu icon, then select Assets.
  • Click the More button and choose Meter Reading Import.
  • If needed, you can click Download Import Template to download a CSV file with all the column headers preloaded. Enter the Asset and Meter information into this template and save it to your computer.
  • Select the import file by clicking the Browse button and choosing the appropriate file from your computer.
  • You can also choose to select the file from your Documents Library by clicking the Select option and then click the image icon ( ).
  • Click Upload to import the file.
  • Once the file imports, the name of the file will be displayed along with some additional options such as indicating whether your file has a header row and choosing a Delimiter.
  • You can choose for Asset Essentials to Ignore existing records in the import file or Override existing records in the import.
  • Select a Mapping from the drop down menu.
    • If no mapping has been created, click New.
    • Asset Essentials will automatically attempt to match the appropriate Asset and Meter fields in the Target column with the import file's column headers found in the Source column. You can change any of the Source fields to match the Target field by selecting the appropriate field from the drop down.

     

     

    • Enter a Name for the Mapping.
    • Choose whether you want this mapping available to other users.
    • Click OK to save the mapping.
  • To determine if there will be any errors with importing the data, click the Validate button. This will display any potential errors.
  • When ready, click the Import button to import your data.

 

Did you find this helpful? 

 

Back to Top