Subject: Conversion of FASER datasets
Issue: Converting FASER datasets to EnergyCAP database format
Follow this checklist to convert FASER data to EnergyCAP.
1. The FASER data must be in FASER 5.0 or later format. To check the version of FASER, run FASER and then Help/About.
2. In FASER Setup, click on Accounts, then click on the Account Number list box. Scroll down the list of accounts and ensure that every account has a Vendor ID. If any account is missing a vendor, select that account and assign vendor to it.
3. EnergyCAP has a special Site field, but FASER does not. A normal practice has been to assign each Account to a Division, and use the Division to identify each site. If this is how your dataset is set up, you will not get a clean conversion to EnergyCAP if there is any Account in FASER that has a blank Division field. Check this in FASER. Go to Setup/Accounts and quickly step through each Account and verify that no Division fields are blank.
IMPORTANT - We have found several instances of duplicate Vendor, Account, Meter and Building Id Codes in FASER, probably as a result of prior upgrades from early DOS versions of FASER. The duplicates do not affect FASER but they will cause the conversion to EnergyCAP to crash. Check for duplicate codes before proceeding!
ALSO - EnergyCAP Pro 2003/2004/2005 adds several new building type codes. If, by coincidence, you have already added the exact same code to FASER, the conversion will fail. This can be corrected byÂ downloading the file labeled "Updated Pro 2003 Database Upgrade File" and copying this to the "Scripts" subfolder under your EnergyCAP program folder under "Program Files." It will replace an older file of the same name.
5. Print the CA08A (Building Savings Comparison) Graph in FASER Cost Avoidance with all filters set to ALL. This will be used later to cross-check the converted dataset.
6. In Cost Avoidance, go to Weather/Enter/Edit Weather and verify that each station has an entry in the Station Code field, especially if the data entry method is electronic import.
7. Run EnergyCAP. It is recommended that you run the DemoData database. Select File/Convert FASER Data. This launches the FASER conversion wizard.
8. After the introduction screen, you must select the method to establish Sites. Option #2, Divisions, is used most frequently when the FASER Division is used to identify each site.
9. On the Data Sources tab, select the FASER dataset name, then click Create a New Database and enter a name for the new database. The name cannot have any spaces or special characters.
10. DO NOT click on Use the Current Database. This merges databases together and it not normally used. (It can be used to continue a conversion if it was interrupted in some way.)
11. Click Next. Then click Start. Allow the conversion to continue. It will take a minimum of 10 minutes, and up to several hours for large databases with many years of history. When prompted, enter the user initials, enter the full organization name and make any other changes to Global default values.
12. You'll want to set the correct base year dates on the CAP tab of the Global properties. Click OK when done with Global. (You can always change this later in Setup/Global.)
13. DO NOT click any other buttons until BOTH blue status bars are completely filled in. At this point, the Stop button will be disabled. Click Finish.
14. Exit EnergyCAP.
15. Re-enter EnergyCAP.
16. From Reports/Cost Avoidance, print report CAP01B, settings=ALL. Compare this report with the FASER CA08A to ensure that both the actual cost and cost avoidance are the same.
by Administrator last modified by Barry Kroeker 06/305/2009 EnergyCAP Professional Rel. 2003 and newer