EC Express: Setup Manager Overview
Posted by Matthew Heinz on 06 June 2012 11:10 AM

Setup Manager Overview

The new Setup Manager provides an easy way to import multiple Vendors, Rates, Places, Organizations, Accounts/Meters and Cost Centers into EnergyCAP.

All imports are accomplished using spreadsheet templates provided by EnergyCAP. The process is simple. First, download (export) the appropriate template. Then add the organization setup data to the spreadsheet using the columns provided. When done, save the spreadsheet and then upload (import) the data to the EnergyCAP database using the Import Wizard. This method greatly speeds and simplifies the initial organization setup process.

NOTE: The EnergyCAP-generated setup spreadsheets may contain data from the current database. Always download a new template each time the Setup Manager is used, so that the most current information is provided.

Suggested Import Order

The import process is similar, regardless of what type of setup data is being imported. However, to avoid problems associated with missing data, EnergyCAP recommends that setup information be imported in the following order:

  1. Vendors
  2. Organizations & Buildings
  3. Rates
  4. Cost Centers
  5. Accounts & Meters

Always download a new import template each time the Setup Manager is used; this will ensure that spreadsheet import columns will have pre-populated data available for selection when preparing the spreadsheet.

Import Process

  1. Login to EnergyCAP.

  2. Select Administration>Setup Manager from the Main Menu.

  3. Select the type of item (Vendors, Cost Centers, etc.) to be imported, using the drop-down list provided.

  4. Generate and export the template by clicking the Generate Template button.

  5. From the Export window, select the desired radio button option:

    • Open with ... will open the exported spreadsheet in the specified application.

    • Save File will save the template to the default download directory.

  6. Add the required/desired data to the template.

  7. When done, save the file and return to the EnergyCAP Setup Manager.

  8. Click the Launch Import Wizard button. The Setup Sheet Importer window will open.

  9. Click the Browse button. The Select file... window will open. Locate the prepared template file and click to select it. Then click Open.

  10. Click Continue from the Setup Sheet Importer. EnergyCAP will attempt to import the spreadsheet data and will display the import results.

IMPORT NOTES: The Setup Importer observes the following rules:

  • If a row of data representing an item is complete and can be created, it will be.

  • If a row of data representing an item has errors, that item will be added to a new Excel file containing all errors, and the problem cells will be highlighted; cell notations will be provided specifying the errors.

  • Once the import process has been completed, the application will display how many items were successfully created and how many items failed to be created.  These failed items can be saved to a new spreadsheet template, corrected, and and re-imported.

To accept the import results, click Finish.  To cancel this import attempt (including all items that were successfully created), click Cancel. All items that were created will be deleted.

If the import is canceled, modify the original setup spreadsheet to correct any errors and try the import again. Or accept the successful import items and then fix error results using the Import Error Template (see below).

Created items cannot be deleted using the setup manager.

Template Fundamentals

All EnergyCAP-generated Setup templates have a few things in common:

Row 1: This row contains the EnergyCAP description for the data to be imported.

Row 2: This row indicates if the data is required for that column, as well as any default values that will be populated during the import if no value is provided.

Row 3: This row indicates the format and limits for the data that is expected.  If the data does not match what is indicated, that item will not be created and an error file will be returned at the end of the import with error details.

Some columns in templates contain pre-populated dropdown lists based on data from the existing database. This helps ensure that the correct data is imported.  A value can either be selected from the dropdown or typed directly into the cell. However, if the entered value is not contained in the provided list, an error will result.  In cases where there is a relationship between multiple columns (e.g. Vendors and Rates), the drop-down selection options will change based on available data.

Imports that provide hierarchical structure (e.g. Buildings and Organizations) have a few nuances that need to be understood before filling in the spreadsheet.  Those details are discussed in the Importing Hierarchical Setup Items topic.

Most items are identified by a Name and a Code. A Name is usually the friendly text that is the 'common name' of the item (e.g. Recreation Building). The Code is typically an abbreviated form that is a unique identifier for that item. Every Code in EnergyCAP must be unique. Whenever a Name is required in the setup template, the Code is required as well, and vice versa.

The Import Error Template

Any items that could not be created because of errors in the spreadsheet data are saved to a new file and made available at the end of the import process.  This file contains ONLY rows that did not import correctly.  Any cell in each row that had problems is highlighted in red, and text notes are provided in the first column of the spreadsheet and as cell notes for each problem cell.

When the errors have been corrected, the new file can be saved and imported using the Setup Manager. If there are any remaining errors, a new file will be provided, and the process can be repeated.

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: