M. Importing Degree-Day Data

Exercise purpose:

To become familiar with the import of degree day in EnTrak's Administration mode.

1. Download file.

To download a sample file, click here DegreeDayData, and open it with a spreadsheet program (e.g. Microsoft Office Excel). 

Delete the sample data and input your own data making sure that all the fields are filled up, the dates are in the format (yyyy-mm-dd), the 'dd_code' is 'WS' and 'type_dd' is 'HEM'. Note that the data code WS is listed as ‘West Scotland’ in the Entrak interface.

Other regions codes are listed as below. The Degree-days data are sourced from http://vesma.com/ddd/history.htm where the latest degree-days data are available.

TV	Thames Valley Heating 15.5
SE	South Eastern Heating 15.5
S	Southern Heating 15.5
SW	South Western Heating 15.5
SV	Severn Valley Heating 15.5
M	Midland Heating 15.5
WP	West Pennines Heating 15.5
NW	North Western Heating 15.5
B	Borders Heating 15.5
NE	North Eastern Heating 15.5
EP	East Pennines Heating 15.5
EA	East Anglia Heating 15.5
WS	West Scotland Heating 15.5
ES	East Scotland Heating 15.5
NES	North East Scotland Heating 1
W	Wales Heating 15.5
NI	Northern Ireland Heating 15.5

'Save As' the file in text format (tab delimited).

NOTE: Make sure that you have 'write' permission in the directory you wish to save the file. In the case of network disk drives, you may need to use 'A' drive to save the file.

2. Import text file in Administration mode.

Choose 'Import' from the 'Tools' menu.

Choose 'deg_days' & 'replace' from the 'import data' box.

Choose from 'Browse File' the 'DegreeDayData.txt' created previously and click 'Import into Table'. You can confirm the completion of the importing operation by viewing the imported data. To view the entity data, open the ‘Edit Degree day data’ by selecting ‘Degree Days’ menu under the ‘Edit’ menu, and click the ‘Go & Take’ button. You can find the data records imported in the query list.

Exercise result:

Ability to manage degree-day data importing from a file.

Previous Exercise

Go to Content Page

Next Exercise