Troubleshooting Data Imports

Created by Sanders Lazier, Modified on Wed, 08 Feb 2023 at 03: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: 

Google Chrome

Microsoft Edge 

Firefox 

Safari 


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. 






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article