1. File Types Supported
Below are the compatible file types and the CSV templates available for consumption upload. We will continue to add more file types. If you have a file you would like us to consider, please email it to support@helioscope.com.
- Green Button XML Files - Green button Website, List of Participating Utilities
-
CSV File must have the following:
- interval data at 60-minute, 30-minute, or 15-minute intervals
- Date and time information
- Power or energy information
- Example files:
- Example US format (comma separated values and "." for decimal indicator)
- Example European format (semicolon separated values and "," for decimal indicator)
2. Step-by-step Instructions: How to Upload Consumption Files
1. Open a Project, then click Energy Usage and click Consumption
2. On the Consumption File dropdown, select the Upload New option
3. Choose the consumption file from your computer
4. For XML files, the upload will occur automatically (jump to step 6). For CSV files, choose formatting based on the formatting of your file:
a. Date Format: choose the appropriate date format based on your CSV (Y = year, M = month, D = day, H = hour, m = minute; be sure to select the correct order and number of digits)
b. Interval Length (options are 60 minutes, 30 minutes, and 15 minutes)
c. Column (the column where the data is found; A would be column 1, B would be column 2, etc.)
d. Energy Units (options are energy and power)
e. Energy Scale (options are kWhs and Whs if energy was chosen; options are kWp and Wp if power was chosen)
f. Column (the column where the data is found; A would be column 1, B would be column 2, etc.)
g. Number of Header Rows (the number of rows before the interval data starts; in the below example, there would be 3 header rows):
h. Timezone: Select the correct time zone for the location.
5. You will not be able to upload until the formatting is correct. The parser will provide details on any differences between the file selected and the configuration specified (in the below example, no data was found in the specified row, meaning that the incorrect number of header columns was chosen):
6. Once the configuration specified matches the formatting of the CSV file (or if you have uploaded an XML file), you will see a snapshot of the monthly consumption (daily available in the daily tab):
7. Confirm the consumption looks accurate, then click Save.