CarbonView

User Tools

Site Tools

Trace:
upload_data

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
upload_data [2015/03/02 23:45]
120.150.160.101 [Overview] 		upload_data [2020/09/25 09:53] (current)
Line 6: Line 6:
   * This section allows you to upload multiple rows of data using a CSV spreadsheet.    * This section allows you to upload multiple rows of data using a CSV spreadsheet. 
   * The CSV spreadsheet must be in the specific format set up for your organisation.    * The CSV spreadsheet must be in the specific format set up for your organisation. 
-  * Admin Users can add fields & customise the organisation's CSV format in the "Manage Data Template" section.+  * Admin Users can add fields, customise and download the organisation's CSV template in the "Manage Data Template" section.
  
-==== I'm trying to upload a csv file but get a "Bad File" message. What am I doing wrong? ====+ 
 +===== Preparing the CSV Spreadsheet ===== 
 + 
 +1. Obtain a copy of your organisation’s custom CSV template from your CarbonView Admin user or account manager.  
 + 
 +2. Complete the fields in accordance with the guidance provided in the "[[data_template|How to use the data template]]" 
 + 
 +3. Save the spreadsheet on your computer as a ".csv" file.  
 + 
 +4. Ensure the file has a unique file name. e.g. "18 Parkes St Electricity Data FY14".  
 + 
 + 
 +===== Uploading the CSV Spreadsheet ===== 
 + 
 +1. Navigate to Emission Data > Manage Upload Data 
 + 
 +2. Click “Upload Emission Data” button 
 + 
 +3. Choose your file from your desktop/computer 
 + 
 +4. Change Template type to “Custom” (i.e. "Custom" should be highlighted Green)  
 + 
 +5. Add a File Description (optional) 
 + 
 +6. Click “Upload” 
 + 
 +7. Wait for the file to upload and for the “Status” to become “Processed”. 
 + 
 +8. You have now successfully added this data.  
 + 
 +9. You can check by going back into the “Manage Emission Data” table and seeing your data there.  
 +  
 +===== What happens if I don't get a "Processed" status. ===== 
 +  
 + 
 +==== Instead, I get a "Bad File" message. What am I doing wrong? ====
  
 The CSV File that you are using needs to match your organisation's Data Template. If the file you are uploading is not in the same format, you will get a "Bad File" error message.  The CSV File that you are using needs to match your organisation's Data Template. If the file you are uploading is not in the same format, you will get a "Bad File" error message. 
Line 19: Line 54:
 If you continue to get an "Bad File" message if all of these are in place, please log a ticket with http://support.acresta.com/home.  If you continue to get an "Bad File" message if all of these are in place, please log a ticket with http://support.acresta.com/home. 
  
-==== When I upload a csv file, the status is "Processed with Errors". What does this mean? How do I correct these? ====+==== My status says "Processed with Errors". What does this mean? How do I correct these errors? ====
  
 If all data in your CSV file uploads successfully, you will receive a "Processed" Status.  If all data in your CSV file uploads successfully, you will receive a "Processed" Status. 
Line 45: Line 80:
 ^ Contribution is required for this type of Emission Profile Source. [ "" ] | You cannot leave any contribution field blank. | Replace all blank Contribution fields with a 0 or delete the row | ^ Contribution is required for this type of Emission Profile Source. [ "" ] | You cannot leave any contribution field blank. | Replace all blank Contribution fields with a 0 or delete the row |
 ^ Column "Cost" must be a number consisting of one or more digits | A non-numercial symbol has been entered in this column. Alternatively, a Currency has been specified by no Cost data has been inputed (i.e. field left blank) | Look for and remove any commas, currency symbols or dashes from this column. Change any dashes (i.e. "-") that may represent zeroes to 0. If you do not wish to add Cost data, remove the Currency specified in the Currency column.  | ^ Column "Cost" must be a number consisting of one or more digits | A non-numercial symbol has been entered in this column. Alternatively, a Currency has been specified by no Cost data has been inputed (i.e. field left blank) | Look for and remove any commas, currency symbols or dashes from this column. Change any dashes (i.e. "-") that may represent zeroes to 0. If you do not wish to add Cost data, remove the Currency specified in the Currency column.  |
-^ Line does not match expected pattern | TBC | TBC | 
  
upload_data.1425339959.txt.gz · Last modified: 2020/09/25 09:53 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki