EnergyCAP Releases

EnergyCAP 2.9.0 Released with New and Improved Bill Import

10/06/11 at 04:35 PM

EnergyCAP 2.9.0 includes a major overhaul of Bill Processing in the application. In particular, Bill Import has been extensively enhanced to import many bills into the system quickly.  For more information, read below and visit Help in EnergyCAP via Home.

This release is currently available to hosted clients. Clients who host their own databases will be notified when it is available for them.

New Features

Calendarization and Normalization

This release of EnergyCAP Enterprise includes the exciting new features found in release 2.8.0 - previously only offered to our EnergyCAP Express clients.  Please see the announcement here.

New and Improved Bill Import

Importing bills has been significantly enhanced to allow greater flexibility for users to get data into EnergyCAP.  Previously, importing was only allowed via templates that we provided and only on a per-account basis.  Now the Importer allows a significant amount of customization in importing your bills. There is no limit on the number of accounts and meters that can be imported. Also, the cause of bill import failure is displayed so you can correct it without having to re-import the entire file.

The previous bill import feature has been removed in favor of the new, permanent bill import process. Help documentation for the new Importer is available in the Help pages along with a detailed sample file. The sample file can be downloaded through Help documentation or on the first page of the Bill Import Wizard. A Help video will be available soon to provide further details and examples.

Bill Import Errors

A new list in Bill Processing shows all bills that failed to import. It also displays the reason they failed so you can correct and then re-import. Before this enhancement, the procedure was to delete the imported batch, correct the file based on the feedback of the Importer, and try to import the file again. Now the lines of the bill are kept together so they can be corrected and the entire bill can be imported again.

The second advantage to the list of import errors is to identify data that’s not currently in your database. For instance, if an account number changed, but wasn’t updated in your database, you can correct it and then re-import, rather than starting over with the entire import file.

Improved Bill Lists

All bill lists in Bill Processing have been modified to provide consistent features, information, and exporting.

  • Filters: Where applicable, any bill list that provides some kind of filters is now available in the “Filters” tab at the top of the screen. This allows filters to be accessible, but creates space in the interface previously taken by the filters.
  • Details & Actions: This tab of the various bill lists displays the same basic data in all areas in the same places. Data typically includes: Total Cost of all Bills queried, Total number of bills returned and displayed, an Export to Excel button, and an “action” dropdown that displays the list of available options for any bills that are selected in the list.
  • Export to Excel: All Bill Processing lists now allow you to Export data to Excel. Previously the visible rows (up to 1000) could be copied to the clipboard for pasting. This improved export ability provides an Excel file with all bills in the query (not just 1000) in the order you have defined.

New “Kiosk” Permissions Available

EnergyCAP Online now takes advantage of new permissions that hide the display of meter and account level data from users who do not have access. This provides a mechanism to set up a public “kiosk” user for general use. Users logged in with this account only see rollup information in both the Building & Meters and Accounts trees. 

Currently, these permissions are set through the installed version of EnergyCAP Enterprise. In the future, a new user role will be added to EnergyCAP Express, which will enable this type of login permission.

Bug Fixes

Any fixes or features previously announced between your current version and release 2.9.0 are incorporated.  This includes, but is not limited to:

  • [ECO-620] – After moving all meters from a building to new building, the original building could not be deleted.
  • [ECO-623] – On the Buildings & Meters Calendarized Tab, the Use vs Weather chart options has scroll bars.
  • [ECO-629] – Calendarized & Normalized Chart Options displayed more than 10 years.
  • [ECO-632] – EUI Chart ignores use from buildings without floor area. The trend line needs another digit after decimal to avoid flat line.
  • [ECO-626] – Turn off Calendarization and Normalization reports tree nodes if the client hasn’t licensed Cost Avoidance.