Troubleshooting Data Imports

Created by Sanders Lazier, Modified on Wed, 8 Feb, 2023 at 3:36 PM by Sanders Lazier

When importing data it is important that you've got the formatting, file type, and data correct. Here are some easy steps you can take to simplify the import process as well as troubleshooting for some common problems.

TABLE OF CONTENTS

Data Import Types
Common Errors
Deleting a Data Import

Data Import Types

There are a few different types of data imports that you will see within the app, the reason there are different types is because the data structure varies from one emission source to another.

If you are ever unsure what is required for your import you can always download the template to double check you have formatted it correctly.

Energy Data Import

Energy Data imports require 5 columns to be completed:

Energy Type (Electricity, Natural Gas, Diesel, Propane Gas, Heavy Gas Oils)
From Date (mm/dd/yyyy)
To Date (mm/dd/yyyy)
Energy Usage
Energy Unit (KWH, BTU, GJ, MJ, MWH, M3, MMBTU)

If the column titles aren't formatted this way your upload will be unsuccessful. To make it easier we have attached a template within each modal that you can utilize.

Business Travel Import

Business travel has two different types of uploads within it, the reason for this is that flights require a class in order for them to be processed (different classes use different emission factors!)

Business Travel Flight Required Fields:

Traveller Email (This must be a user who has been added to your account)
Travel Departure
Departure Airport Code
Destination Airport Code
Travel Class (First, Business, Economy)
Round Trip?

Business Travel Other:

Traveller Email
Travel Type (Car, Motorbike, Bus, Train)
Travel Date (mm/dd/yyyy)
Total Distance
Distance Unit (km, mi)
Round Trip? (yes, no)

If the column titles aren't formatted this way your upload will be unsuccessful. To make it easier we have attached a template within each modal that you can utilize.

Custom Source Import

Custom sources have specific templates depending if you have created it to require a date range or not.

Custom Source Requirements (no range)

Date (mm/dd/yyyy)
Activity
Unit (KWH, KM, etc.)

Custom Source Requirements (range)

Start Date (mm/dd/yyyy)
End Date (mm/dd/yyyy)
Activity
Unit (KWH, KM, etc.)

Common Errors

Template Mismatching

Often times the most common error is that they template you have uploaded doesn't match what the system is expecting, resulting in it being unable to process your data. To troubleshoot this you can always double check that you are using the right template by downloading it and entering your data that way.

Missing Lines

If you are missing data points (all columns are required) you will have to complete them in the missing data step

Empty Lines

Sometimes you will see errors if there are many empty lines.

Your browser needs an update

Very rarely it can happen that your browser has a new updated version and needs to be restarted. When this happens your "Upload" button will not trigger the file selector and you will not be able to drop files into the Carbonhound Data Import modal. Here is how you check for software updates for your browser:

Deleting a Data Import

Once your data import has been processed you can delete it at any point. The delete for data imports exists on the data import details, that you can access by clicking into the data line item and clicking the delete button.

This will remove all of the data associated with that data import.