Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

To upload a usage data in a Comma-Separated Values (CSVs) file format, select the option CSV Upload for the 'Edit Usage By' dropdown under Annual Usage. This can be found on the Usage phase of a job.

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:

  1. The following column headers are required: interval_start, interval_end, and interval_kWh. Additional columns will be ignored.
  2. Ensure all information is complete. There should be no rows or cells with missing data. In the event of having any field that is left empty, Sighten will extrapolate the missing data.


Additional Formats

To request additional formats, please send the following to support@sighten.io:

  • The source of the CSV data
  • Sample Data CSV

How do I upload a CSV file?

  1. Open the job,
  2. Go to Usage,
  3. Scroll down to Annual Usage Section
  4. Select CSV Upload on the Edit Usage by dropdown menu, as shown above
  5. A quick guide will then show, it would look like this:
     
  6. Select Upload Usage CSV
  7. 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.
  8. Note that you can redownload the uploaded file anytime by clicking on the file name as highlighted below: 

What happens if data is missing on the CSV file?

If any column is missing on the CSV file you're trying to upload, it will fail. You'll then see an error message like this:

Where else can I access the CSV document on Sighten?

Once uploaded, you can also see the CSV document on Site Documents, this is the Document icon on the right side of every job, as seen below:

What would happen if I upload a CSV file with missing data?

If you upload a CSV file with missing details (a few rows in the CSV file, as long as it's not a full column), we extrapolate and fill in the missing details automatically. 

CSV File Example

Here's an example of a CSV file for PGE (interval data & monthly data)

If you have an excel file for homeowner interval data, you can click Save As and select Comma Separated Values, and then use that version to upload to Sighten.  

Related articles

To learn about usage entry, defaulting, or how to access the monthly electricity usage modal, check out the following article:

  • No labels