Whether you're uploading data to manual points or backfilling gaps and historical data for other integrations, this app will help you upload data to your points faster than adding a single reading.
👍 This article will help you:
Learn how to upload data to your points using a CSV file
Understand the formatting and required fields for a successful data upload
📘 There are two ways to upload data to Points:
From the Points page (recommended)
This method lets you select the specific points to which you are uploading data, so that the generated template already includes the associated Atrius IDs needed for the upload.
From the Batch Point Data Upload app
This method doesn't let you select points beforehand, but instead provides a generic template, so it is best used if you already have a file ready for upload.
Find your points
You'll first want to figure out which points you'd like to upload data to. Our data upload templates allow you to upload readings for a single point type, or for multiple point types in the same file. If you are including more than one point in the file, be sure that all the data use the same timestamp intervals and format. (ex. If your gas data are in monthly intervals and your electricity data are in 15 min intervals, you will need a separate upload template for each.)
From the Points page:
Use the Filter and/or Search field to narrow down the list of points to which you'd like to upload data
Use the checkbox at the top of the Points table to 'select all,' or select checkboxes at individual rows
Click the Actions button, and select "Upload data" to view the Upload Point Data modal
Generate your CSV template
Depending on the rows you selected on the Points page in the previous step, the Point type field will auto-populate. Verify the field is as you'd expect, and then fill out the remaining fields for Unit, Reading type, and Date/time format to create a new custom data upload template.
If you have a previously downloaded template, you may skip these steps, and scroll right down to the "Browse for CSV" button.
Download and complete the CSV
On the modal, below the formatting instructions, click the "Download CSV" button
For Templates that contain a single point type:
Open the CSV file and enter your timestamps and readings
The first two rows, Building and Point name, are for reference only
The important column headers start at row 4. The first 1-2 columns (depending on the date/time format selected) should contain your timestamps. See instructions below.
All subsequent column headers should contain an Atrius ID, which will tie the data in the column to your point.
📘 Instructions
If the data you upload overlaps with existing data in Atrius, the existing data will be overwritten. It is recommended that you export existing data before overwriting it.
Unless you've selected the template for 'Multiple point types,' all points in the CSV template must have the same point type, reading type, and unit.
All points are identified by their Atrius ID, located on each point's Profile.
Timestamps must be in the building’s local time zone.
Timestamps must be in chronological order (oldest reading at top, newest reading at bottom) and consecutive. If there are any gaps between timestamps, then those gaps may override any existing data.
The following date formats are supported:
MM-DD-YYYY
MM/DD/YYYY
MM.DD.YYYY
DD-MM-YYYY
DD/MM/YYYY
DD.MM.YYYY
The following time formats are supported:
09:30:00
09:30
9:30
09:30:00am
09:30am
9:30am
09:30:00 am
09:30 am
9:30 am
21:30:00
21:30
For templates that contain multiple point types:
CSV uploads for Multiple point types can be formatted in two ways:
Source unit / Source reading type selections allow you to include data from multiple point types in a single file, so long as the data entered matches the source unit and reading type for each point (set on the point profile page). Column headers identify points by their Atrius IDs.
Custom unit / Custom reading type selections allow you to enter data from multiple point types in any unit or reading type. Column headers must include the Atrius ID, unit, and reading type in the following format:
Atrius ID (unit,reading type)
Units: Full names and abbreviations are accepted
Reading types:
Interval consumption
Interval demand, Totalizer
Bi-Directional totalizer
Instantaneous measurement
Daily consumption
Daily demand
Monthly consumption
Monthly demand
Upload and validate
When you've finished adding timestamps and readings to your file, be sure to save it in the "Comma Separated Values (.csv)" format.
In the last step of the modal, click "Browse for CSV" to find your saved file, and click Save.
You will be taken to the Batch Point Data Upload app, where you should see a new row at the top of the table with your filename.
Verify the Unit, Reading type and Date/time format selections do indeed represent what is in the file, and then select Process at the end of the row.
Your data may take some time to upload. You can monitor the job on the Data Processing Jobs page.
If there are any errors found in the file during the upload process, they will be listed in the table. Click the hyperlink in the Status column to view details about the error.
🚧 Daylight Savings
If you're uploading data (hourly or higher resolution readings) that includes daylight savings time periods, then you may have to adjust the timestamps accordingly. For example in the United States, in March, the file should omit the 2:00-3:00 AM timestamp, but in November, the 2:00-3:00 AM value should be doubled to include the extra hour (do not repeat the timestamp). Daylight savings hours may vary from country to country (Europe occurs at the 1:00 - 2:00 AM timestamp), so be sure to double check the local time changes.
👍 What's next?
Once your data has finished processing, it's always a good idea to spot-check a few points to confirm the upload was successful. Navigate to a point's Data Manager to view the new readings.
Once you've confirmed your data has been uploaded correctly, you can display your data on Dashboards, review and assign Emission factors, set Alerts and more.