Bulk Asset Creation
Last updated
Last updated
To import and create multiple new assets in Brightest via a .csv file upload, visit the "Assets" tab in the Sustainability section of your Brightest dashboard, and navigate to .
There, you can download our .
Fill out your asset data correctly in the file.
In the csv importer, use the "Choose File" button to select the file you want to upload, and then click the green "Upload File" button to complete your upload.
If your upload is successful, you'll see a green notification and your assets will be visible in the "Assets" tab in the Sustainability section of your Brightest dashboard. If there's an error, you'll receive a notification your upload needs to be corrected.
The import template includes the following fields by default:
Uuid: Enter a unique ID for your asset that can be made of any unique combination of numbers, letters, or characters. We recommend making the "Uuid" the same as the "Name" of the asset (optional, but highly recommended)
Name: Enter the name of your asset (ex: Brightest NYC HQ Office) (required)
Description: Enter a description of your asset (optional)
Asset type: Enter one of the following asset types (required)
Fuel type: Enter one of the following fuel type. (optional) Only for transportation, equipment, or mobile equipment assets.
Workers: Enter the number of employees or workers who work at or with the asset (optional)
Space: Enter the number of square feet or meters your asset, site, or building has in terms of gross floor area. You will enter the unit (square feet or square meters) in another field of the form (optional)
Location type: Enter one of the following location types (Optional)
Utilities purchased: Does the asset purchase electricity from a third party? Enter "TRUE" if yes. Otherwise, enter "FALSE"
Heating purchased: Does the asset purchase heating from a third party? Enter "TRUE" if yes. Otherwise, enter "FALSE"
Clean power: Enter a number between 0 - 100 to represent the percentage of clean or renewable energy powering your asset relative to its overall energy use. For example, if you have a solar PV installation that generates 50% of your asset's annual electricity, enter "50" in this field. Ignore any net metering arrangements (optional)
Clean power electricity: Enter "TRUE" if the asset has on-site clean or renewable electricity (ex: solar PV, wind, water, etc.) of "FALSE" if the asset does not. (optional)
Clean power heating: Enter "TRUE" if the asset has on-site clean or renewable heating (ex: solar hot water heater, geothermal, etc.) of "FALSE" if the asset does not (optional)
Clean power water: Enter "TRUE" if the asset is on-site, natural water consumption (without a municipal or other water source) or closed-loop or circular water re-use, of "FALSE" if the asset does not (optional)
Clean power start date: Enter the start date of your clean power usage or contract (optional)
Clean power end date: Enter the end date of your clean power usage or contract (optional)
Is remote: Enter "TRUE" if workers in this office work remotely. If everyone works on site, enter "FALSE" (optional)
Owned: Enter "TRUE" if the asset is owned by your organization of "FALSE" if the asset is leased or under third party control. (required)
Remote percentage: Enter a number value to represent the percentage of employees at this asset who work remotely. For example, if 15% of your employees work remotely and the other 85% work on-site, enter "15" (optional)
Office days per week: Enter a number between 1 - 7. If this asset or office has a flex day or partial remote work policy, indicate the average work days in-office (not remote). (optional)
location_street: Enter the street address of your asset (optional)
location_city: Enter the city where your asset is located (optional)
location_state: Enter the state, region, province, or territory your asset is located in (optional)
location_country: Enter the country your asset is located in (optional)
location_zip: Enter the zip code or postal code of your asset (optional)
Google place id: Brightest will use the address information entered in the previous fields to generate this (optional)
Managers: Enter the email address of the Brightest user(s) who will be in charge of entering data for this asset (optional)
Real estate asset: Enter "TRUE" if this asset is part of a real estate portfolio. If not, enter "FALSE" (optional)
Tenant occupancy: Enter a number to represent the % of your space that's being used by tenants or other parties (i.e., 50 = 50%), if applicable. Otherwise, set this value to 0 or leave this field blank. This field is only a necessary field if this is a real estate asset (optional)
Tenant use waste: Enter "TRUE" if the tenant uses this resource. If not, enter "FALSE." This field is only a necessary field if this is a real estate asset (optional)
Tenant use water: Enter "TRUE" if the tenant uses this resource. If not, enter "FALSE." This field is only a necessary field if this is a real estate asset (optional)
Tenant use heating: Enter "TRUE" if the tenant uses this resource. If not, enter "FALSE." This field is only a necessary field if this is a real estate asset (optional)
Tenant use electricity: Enter "TRUE" if the tenant uses this resource. If not, enter "FALSE." This field is only a necessary field if this is a real estate asset (optional)
Include embodied carbon: If you want to account for Scope 3 embodied carbon, enter "TRUE," if not enter "FALSE" (optional)
Construction date: Enter a date. If you don't know or aren't sure, please enter a rough estimate. If you don't want to account for Scope 3 embodied carbon, you can also leave this blank (optional)
Real estate status: Enter one of the following options (optional)
Acquired date: Enter the date your organization acquired or started leasing the asset. Please format like: 2023-01-20 (for January 20, 2023) (optional)
Sold date: Enter the date your organization sold or terminated leasing the asset. Please format like: 2023-01-20 (for January 20, 2023) (optional)
Occupancy: Enter a number representing the percentage of asset space that is currently occupied by your organization (e.g., occupancy rate). For example, if 50% of a building (site) asset is empty, set to "50." This field is only visible if you do not own or control an asset. (optional)
Is partner: Does this asset belong to a third party like a supplier, partner, or portfolio investment? If so, enter "TRUE." If not, enter "FALSE" (optional)
Partner: Enter the name of your Brightest partner that owns or controls this asset (optional)
Capacity allocation: Enter a number that represents the percentage of the third party asset's capacity and environmental footprint your operations represent or claim (optional)
Space measurement: Unit for gross floor area measurement. Enter either "ft^2" for sqaure feet or "m^2" for square meters (optional)
Auto-Estimate Environmental Footprint: If you can't collect data for an asset like an office or site, Brightest can auto-estimate it for you using average commercial building data ("Space," "Space measurement," and "Construction date" information are necessary for this). If you would like Brightest to do this enter "TRUE." If not, enter "FALSE" (optional)
Default Invoice Currency: Enter one of the following currency abbreviations to set a default currency for invoices that are OCR scanned for this asset (optional)
Amount : Only for Investment assets. Enter the number representing the amount in reporting currency if associated with an investment (i.e., 1000000 for $1,000,000)
Investment Currency: Only for Investment assets. Enter the one of the currency abbreviations Currency for designated amount
Transportation type: Only for Transportation assets. Enter one of the following transportation types:
Investment or Asset Class Type: Only for Investment assets. Enter one of the following Investment types:
Meta tags: Enter the name of the meta tags that you would like to associate with the asset. If you would like to associate multiple tags with an asset, separate the name of the tags with a comma. Make sure the tags are created in the "Tag Management" area of the Settings Module prior to import. (optional)
If you're familiar with GHG Protocol, you'll notice several of the asset types map or correspond to a specific Scope 3 emissions carbon accounting category. This is designed for cases where you need to represent an emissions value in a specific carbon accounting category, such as historical Scope 3 emissions data or other environmental data that falls outside of an operational boundary. In most cases, it's more efficient to use the Brightest "Transit" asset to represent Scope 3 areas like transportation and travel without necessarily creating an asset for it, however we want to give you the flexibility to account for carbon and other sustainability data in the way that makes the most sense for your organization.
Possible issues and troubleshooting
When you're importing data via .csv file, it's important to check that your data is clean and accurate before uploading. Because it's a .csv (comma separated value) file, make sure there aren't any extra commas in your fields that might be mistaken as a field divider.
If you see an error like "varchar is too long," that means the character count in the field you're uploading exceeds the limits of our database, and you should try to find particularly long fields or names and try to shorten them if possible. However, just because you see a red error message doesn't always mean your upload wasn't successful. Always be sure to first check your assets table to see if your new assets uploaded correctly. If they did, you can likely ignore the error.
Above all, make sure you don't create the same assets twice and duplicate your data.
Finally, take care to manage the size of your file. We typically recommend bulk uploading assets 100 or less at a time. Trying to create hundreds or thousands of assets at the same time may run into performance issues. If you need to upload a lot of assets and you're on an Impact, Transform, or Enterprise plan, it's best to speak with your account manager.
If you have any additional issues or questions, please contact Brightest support (support@brightest.io) for assistance.
