...
For CSV Upload, the data format is critical for the functionality to work. Please review the instructions and example data provided on the page to ensure your data is formatted correctly. For the Beta release, Sighten only supports the common format provided by UtilityAPI. Here are the current instructions:
...
Note that there are four formatting options we currently support for CSV uploads: UtilityAPI, PG&E/SCE, SCE, and SDGE.
| Info | ||
|---|---|---|
| ||
To request additional formats, please send the following to support@sighten.io:
|
How do I upload a CSV file?
- Open the job,
- Go to the Usage ,phase
- Scroll down to Annual Usage Section
- Select CSV Upload on the Edit Usage by dropdown menu, as shown above
- Via the Format dropdown menu, select the one of the four available CSV formatting styles (see below)
- A quick guide will then show, it would look like the below. It show based on your formatting selection (see 3 bullet points above) - it is very important to ensure your CSV follows the instructions and has the correct format as displayed .
in the table to the right - Select Upload Usage CSV
- You'll then be prompted to upload a file. Once a file is selected, you'll see a spinning wheel on the Upload Usage CSV Button.
- Note that you can redownload the uploaded file anytime by clicking on the file name as highlighted below:
...
- If any the required columns (per the format you've selected) are missing on the CSV file you're trying to upload, it will fail.
- If any rows are missing on the CSV, Sighten will automatically extrapolate this missing data to ensure a successful upload. If too much data is missing and we are unable to extrapolate accurately, the upload will fail.
- If the CSV contains more than a year's worth of data, then the most recent year of data is used to calculate usage and bill information.
...