User Tools

Site Tools


data_template

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
data_template [2015/02/09 00:35]
120.150.160.101
data_template [2020/09/25 09:53] (current)
Line 59: Line 59:
 3. The Emission Profile source must be "Active" and "Visible" (to change to to Manage Emission Profile Details and tick them on) 3. The Emission Profile source must be "Active" and "Visible" (to change to to Manage Emission Profile Details and tick them on)
 </code> | | </code> | |
-^ Start_Date | Period Start Date | ''i.ethe first day of the period the data relates to'+^ Start_Date | 15/01/2014 <code> 
-^ End_Date | Period End Date | ''i.ethe last day of the period the data relates to'+1. Must be in the date format specific to the user's profile 
-^ Contribution | Usage ''i.e. the consumption amount'' +2Commonly, most users are set up with a date format of DD/MM/YYYY. To check/change the user's date format, go to Admin > Users > Manage Users. Click "Edit" the user's account and check/change the "Date Format" dropdown then "Save".  
-^ Contribution_Unit | Unit ''i.e. the unit of measure the consumption amount is reported in'' |+3. Start Date must be an earlier date than End Date.  
 +</code> 
 +^ End_Date | 14/02/2014 <code> 
 +1. Must be in the date format specific to the user's profile 
 +2Commonly, most users are set up with a date format of DD/MM/YYYY. To check/change the user's date format, go to Admin > Users > Manage Users. Click "Edit" the user's account and check/change the "Date Format" dropdown then "Save".  
 +3. End Date must be a later date than Start Date.  
 +</code> 
 +^ Contribution | 1000 <code> 
 +1This is the amount of electricity/fuel/water/etc consumed for the date period specified,  
 +2Must be a numerical value, 
 +3. Must align with the consumption unit selected 
 +</code> 
 +^ Contribution_Unit | KILO_WATT_HOURS <code> 
 +1This is the unit of measure the contribution amount is to be reported in (e.g. Kilo Watt Hours).  
 +2. Only Contribution Units available for an Emission Source can be used (e.g. you cannot report data in a unit of measure that has not been set up for that emission source).  
 +3. For a list of all unit of measures, refer to 4.1. List of Contribution Units. 
 +4. For all custom emission sources, the unit of measure must match exactly the "Contribution Unit" nominated when set up. To check, go to Admin > Emission Profile > Manage Emission Profile > Select the emission source in question and check the "Contribution_Unit" field,  
 +</code>|
  
  
 OTHER COMMON NON-MANDATORY FIELDS OTHER COMMON NON-MANDATORY FIELDS
  
-G. Asset +^ CSV Header Column ^ Example ^ Rules | 
- +^ Asset | NMI0023412911 | <code json> 
-HCost +1Must match exactly the spelling of the Asset's AssetID, 
- +2. The AssetID is found in the Manage Asset page (Admin > Setup > Manage Assets > Select the asset.  
-I. Currency +3. The Asset must be assigned to both the Entity and the Emission Source you are loading data for.  
- +4. To assign an Asset to an Entity, go to the "Assign Asset" tab within the Manage Entity page.  
-J. Provider +5To assign an Asset to an Emission Source, go to the "Asset Asset" tab within the Manage Emission Profile page.  
- +Tips: If the AssetID is not being recognised, sometimes there is a 'space' at the end that needs to be removed or the Asset has been de-activated in which case it needs to be re-activated in the Manage Asset section''
-H. Contributor_ID +</code> | | 
- +^ Cost | 3545.22 | <code json> 
-I. Comment +1. Must be a numerical value 
- +</code> | | 
-J. Country +Currency | AUSTRALIAN_DOLLAR | <code json> 
- +1. This is the currency you are reporting cost in.  
-H. Flex Fields+2If you are reporting cost, you must also identify the currency.  
 +3. The currency must match the currency nominated for the Entity. To check/change the currency set for the Entity, go to Admin > Set up > Manage Entity and select the relevant Entity. Here you can check/change the Currency field in the Manage Entity form and hit save.  
 +4. The format for entering Currency in the CSV template must be in the correct naming convention. For a list of all currencies, refer to 4.2. List of Currencies. 
 +</code> | | 
 +Provider | Energy Australia | <code json> 
 +1. This is the field to input your supplier / provider name.  
 +2This is free text.  
 +</code> | | 
 +Contributor_ID (i.e. Bill/Invoice Number) | INV09832 | <code json> 
 +1. This is the field to input your Bill/Invoice Number 
 +2This is free text.  
 +</code> | | 
 +Comment | Per 09-Sep-14 Statement | <code json> 
 +1. This is the field to input any comments to describe the amount.  
 +2This is free text.  
 +</code> | | 
 +Country | AUSTRALIA | <code json> 
 +1. Some Emission Profile sources require the Country to be specified to calculate carbon emissions.  
 +2This field is to be completed if you've received an error message requiring Country to be specified.  
 +3. All Countries need to be entered in the template in the naming convention specified in 4.3 List of Countries.  
 +</code> | | 
 +Flex Fields | "Kilometers Travelled" | <code json> 
 +1. Some Customers would like to upload specific information for each row of data. In CarbonView, customers can use Flex Fields to add additional fields to the data entry template.  
 +2. To set up Flex Fields, please refer to the Setting up Flexible Fields section.  
 +3. Fields that use Flex Fields 1-5 allow for numerical data only.  
 +4. Fields that use Flex Fields 7-15 (i.e. all the rest) allow for any text. 
 +</code> | |
  
  
data_template.1423442119.txt.gz · Last modified: 2020/09/25 09:53 (external edit)