Creating custom average-data factors

Create custom average-based factors by uploading new ones and prioritizing them over defaults. Complete this process during the initial setup or as necessary.

Before you begin

Download the following CSV template and enter your company's data. Verify that all the required values are entered.

CSV template link: Envizi-SCI-custom-factor-Category-average.csv
Important: If you use Microsoft Excel to edit the CSV file, verify that you save it in the UTF-8 CSV file format. If you do not save the CSV file in the UTF-8 format, some special characters may be skipped or incorrectly interpreted during the data import process.

The following table outlines the required headers and associated information for preparing the CSV file. You have the flexibility to ignore recommended and optional values, as needed.

Table 1. Custom factors category CSV template headers
Column header Requirement Sample Description
Factor code Required Fabricated metal products A classification code that identifies the emission factor. For the list of allowed values, see Factor codes.
Factor value Required 1.8477 The metric or value of the product used in computing score, in kgCO2e.
Unit Required kg Unit of measurement associated with the emissions factor. Use Unified Code for Units of Measure (UCUM) unit codes. For example, kg.
Country code Optional USA Geographical region to which the emissions factor applies. 3-char ISO 3166 country code
Precedence Required 2 Suggests which emissions factors take priority. For the list of allowed values, see How factors are prioritized and applied?.
Source ID Required Ademe Reference to the organization that established the emissions factor.
Note: Average data calculations require that the Product has the Measurement and Measurement unit fields populated. The Measurement unit on the product must match the Unit on the custom factor.

Procedure

  1. From the side navigation menu, select Data management.
  2. On the Data management, select Import data.
  3. Click Add file and upload the Envizi-SCI-custom-factor-Category-average.csv file.
  4. From the list of data mappings, select Custom factor - Category (customFactorCategory).
  5. Optional: If your CSV file includes additional delimiters such as comma (,), colon (:), semicolon (;), or pipe (|), select the appropriate option from the Delimiter list to ensure the structured data is read correctly.
  6. Click Next and review the information.
  7. Click Import.
    The following message appears.

    New import job created Job {Job ID} has been successfully created.

    You might notice that uploading a single file results in the creation of multiple jobs in the Job Manager. This occurs because the mapping is linked to multiple business objects, which in turn triggers the submission of multiple jobs. To confirm that the upload completed successfully, you must verify that each job is completed without any errors.

  8. See the status of your import job on the Job Management page.
    Note: Depending on the size of the file, the import process might take some time to complete.

    If the status of your import job is Completed, then your data import job is successful.

    If the status of your import job shows CompletedWithErrors or Rejected,complete the following steps:
    1. Click the Job ID and check the errors in the Job details section.
    2. If errors are listed, then correct the highlighted errors in your CSV file and upload it again.
    3. If errors are not listed, then click Retry the import and check the status after a brief period.