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:
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 NOTES: The Setup Importer observes the following rules:
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.
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.