Page tree
Skip to end of metadata
Go to start of metadata

See also: Overview: Importing RouteSTAR Meter Readings

Data is imported into Energy CAP Enterprise using a series of dialog boxes that provide instructions based on options chosen to guide the user through the import process. In order to import any data file into the system, a profile must be created. The profile lets EnergyCAP  know how the data file is set up in order to determine which database fields to populate with what data. Once the profile is created, it is important that any future files for import are formatted the same way. If the format of the data file changes, be sure to modify the profile in Energy CAP Enterprise accordingly. If the profile is not altered to match the new format of the import file, fields may be populated with incorrect data.

NOTE: Each import profile is associated with the EnergyCAP user who created it. Profile information is stored on the user's computer hard drive. See Import Odds & Ends, below, for more information.

An import ID is required for a successful import. All logical devices (meters, counters, and weather stations) in Energy CAP Enterprise have import IDs.

When importing meter data, the data used is associated with meters having the same import ID as the import ID used in the import file. The import ID can be entered into EnergyCAP during meter creation, and can be viewed from the Specific tab in Meter Properties.

You can import meter data using the following file formats:

  • Text files. A file containing only text characters, usually ASCII characters; contrast with graphics file and binary file. (*.txt, *.dat, *.csv, *.prn)

  • MDEF files. A file format that defines the file for exchanging data with other systems. The format is designed to support current meter and recorder technology as well as new devices to be developed. (*.imp, *.mde, *.dat)

  • Modified MDEF files (*.imp, *.mde, *.dat)

  • Meter Exchange files (*.imp, *.csv, *.txt, *.dat)

Data Import Procedure

To import meter/counter data into EnergyCAP:

  1. Select Setup | Facilities. The Facility Manager appears.

  2. From the File menu, select Import. The Open window appears.

    1. In the Look in field, select the directory location of the file.

    2. Make certain the File type is correct; then select the appropriate file from the File List. The filename you selected will be inserted in the File name: field.

    3. Click Open. The Import Wizard window appears.

  3. If a previous profile exists that satisfies this import, select the default setting Use an existing profile.

    1. Select a profile name from the drop-down list.

    2. Go to step 5.

  4. If a previous profile does not exist, select Create a new profile.

    1. In the Profile Name field, enter the desired name.

    2. Go to step 5.

  5. Click Next. The Import Wizard File Formatting page appears.

    1. In the Delimiters section, select the data delimiter.

    2. In the Text Qualifier drop-down list, select the text qualifier (if any)

    3. In the Start Row field, enter the row of data which should start the import.

    4. If the data file has a header row contained within its file format, select the Previous row is a header check box.

    • The Preview section updates with each selection.

  6. Click Next. The Import Wizard Field Definition Format page appears.

    1. In the Fields section, select a field.

    2. In the Format drop-down list, select a format.

      TYPE

      ADDITIONAL SELECTIONS

      UNKNOWN

      Use if the data is unknown or is not defined

       

      TIMESTAMP

      Provides formats for time stamps located within the data file. Contains both pre-defined time stamp formats as well as the ability to enter custom formats.

      Either:

      • In the Picture drop-down list, select a date and time format.

      • Type the date and time format exactly as set in the import file. Be sure to include any placeholders used in the date and time format.

      1. If the time format is known to be GMT, select the Times are in GMT check box.

      DATE

      Provides formats for dates located within the data file. Contains both pre-defined date formats as well as the ability to enter custom formats.

      Either:

      • In the Picture drop-down list, select a date format.

      • Enter the date format exactly as set in the import file. Be sure to include any placeholders used in the date format.

      TIME

      Provides formats for times located within the data file. Contains both pre-defined time formats as well as the ability to enter custom formats.

      Either:

      • In the Picture drop-down list, select a time format.

      • Type the time format exactly as set in the import file. Be sure to include any placeholders used in the time format.

      If the time format is known to be GMT, select the Times are in GMT check box.

      INTERVAL

      Defines data within the file as an interval of time which will be known prior to import.

      Expressed in minutes

      DEVICE

      This is the import ID code for the device/meter.

       

      DATA

      Defines data within the file as the data associated with the device.

      1. In the Commodity drop-down list, select the appropriate commodity.

      2. In the Type drop-down list, select the appropriate type.

      3. In the Unit drop-down list, select the appropriate unit.

      UNIT

      Defines data within the data file as a unit. This field will usually have a unit identified within the data file and have to be handled as such.

       
  7. Click Next. The Import Wizard Finish page appears.

  8. Click Finish to complete the process. The Log window appears, notifying you of the status of the import process, the file import path, and if any errors occurred during the process. If errors did occur, they are listed and you will need to go back and correct these errors in order to successfully import the file into the database. If the import was successful, the log informs you appropriately.

    1. Save the log file by clicking . The Save As window appears.

      1. In the Save in field, select the directory location for the file.

      2. In the File name field, enter a name for the file.

      3. After making your selections, click Save.

    2. Print the log file by clicking . The log file display is printed to your default printer.

    3. Exit the Log window by clicking Close.

 

 

Import Odds and Ends (Q & A)

Question: Where in EnergyCAP is the import profile information stored?

ANSWER: Import profiles are actually stored on the user hard drive. The location depends on the operating system:

Windows XP:
C:/documents and settings/[username]/local settings/application data/EnergyCAP enterprise

VISTA/Windows 7:
C:/users/[username]/Appdata/Local/EnergyCAP Enterprise

If you change computers or operating systems, you may discover that your import profiles are missing. To restore them, copy the import folder contents from the older computer/operating system to the appropriate folder/path that corresponds to your new computer/current operating system. If you encounter difficulties, contact customer support (http://support.energycap.com) through the EnergyCAP Support interface.

Question: Can you provide a sample of what the import file would look like for meter data?

ANSWER:

File:

ESI_ID  INTV_REC_DT INTV_BEG_TM  KVAR_QT  KW_QT  POWER_FACTR_PC  KVA_QT  Estimated  Note

12435-A     08/17/2007              0                     796               4426                          98               4497         E           Test

12435-A     08/17/2007              15                   816               4369                          98               4445         E           Test

Column 1: Import ID for the meter. Can be viewed from the Specific tab in Meter Properties. Required field.

Column 2 or 2/3: Time stamp. Either a single column containing a Timestamp, which contains both the date and time values (ie – 2010-05-13 15:00), or separate columns for both Date and Time.  Required field(s).

Data: (will vary with type of data imported. Required field.

Estimated/Actual: Can be A/E or 0/1. This is a true/false, Boolean field so there is a 1-character limitation. Not a required field.

Note: Not a required field.

Question: I have a file of weather channel data that only has 1 observation. When I try to import it I get a message saying that the interval cannot be determined. How can I import this data?

ANSWER: The observation interval can be added to the import file as a fourth column. The sequence of columns would be:

  1. Import ID
  2. Date Stamp
  3. Time Stamp
  4. Observation Interval (expressed in minutes)
  5. Observation Value

 

EXAMPLE: A column of comma-delimited daily interval data might appear as follows:

ABC12,20080909,11:00,1440,68

 

Question: Why is the default time stamp for mean daily weather data assumed to be 11:00 a.m.?

ANSWER: Statistical weather data suggests that this is the point where the mean daily temperature is most often achieved.

  • No labels