📥 How to upload bulk data?

  1. Access Batch Data Entry: Select "Data" from the menu and navigate to the Batch Data Entry Tab.​
  2. Download Template: Select the desired data type or scope group for batch data entry. Click the 'Download Excel Template' button to download the template. â€‹
  3. Upload Template: Complete the necessary columns on the downloaded Excel template. Re-upload the filled file by drag and drop.​

Bulk data can only be uploaded for the selected location under the Data tab.

Failed Data Entry

Your browser may not allow downloading the excel file. Please make sure your browser allows downloading files.

If the file downloaded to your computer is loaded with the phrase "Incorrect Data Entry" at the beginning of the name, this statement indicates that the data entry was unsuccessful. To fix the problem;

  • Step 1: Open the excel file that has been reinstalled on your computer. In the file, there will be an explanation of what caused the errors in the line of the state or conditions that caused the error in the data entry.

    The situations that cause the error can be as follows:

  • If there are spaces or errors in the code, location, or location type fields,

  • If the Start or End Date is entered in the wrong format,

  • If some of the columns are left blank and missing data is entered,

  • If a negative value is entered,

  • If the decimal/thousand separator is entered incorrectly,

  • If the dates do not follow each other or overlap,

  • The data will not be successfully uploaded to the system.

For correct data entry formats, you can refer to How to prepare spreadsheet for bulk data upload title.

  • Step 2: When the edits are made according to the errors given above and the saved file is uploaded to the platform again, the name of the document is downloaded to your computer under the title of Successful Data Entry. If there are still errors, the mentioned operations should be done again.

Unless the errors in excel are corrected, no data in excel will be loaded.

📊📉How to prepare a spreadsheet for bulk data upload?

With the batch data entry feature, you can load data of the same data type or scope group with a single file for more than one point.

Bulk data can be uploaded for all locations under the Admin Panel.

  • Step 1: Batch data entry can be accessed from the Batch Data Entry tab on the admin page.
  • Step 2: From this page, the desired data type or scope group for Batch Data Entry is selected by clicking the Download Excel Template button, and the Excel template is downloaded automatically.

You can download the template based on either same data type or scope group.

Data Type: You can download the template for the data type you want to do bulk data entry. You can enter data for more than one date at the same time to more than one location with the batch data entry excel. For this, you should duplicate the rows with location information and enter the relevant data and dates.

Scope Group: You have the convenience of selecting either a single scope group or multiple scope groups to add data to every included source within one Excel file. This streamlined process is made possible by the use of a template that you can download for the type of data you intend to enter in bulk.

  • Step 3: Details of the columns that need to be filled on the downloaded Excel;

     

  1. Code: Indicates the code of the branches registered in the account you entered. You do not need to fill it.
  2. Location: This is the section where the names of the branches belonging to the code are included. You do not need to fill it.
  3. Activity: Shows the activity type of the location.
  4. Start Date (yyyy-mm-dd): Indicates the start date of the consumption data you want to transfer to the platform. When entering the start date, the order should be year-month-day. For example 2021-01-21.
  5. End Date (yyyy-mm-dd): Indicates the end date of the consumption data you want to transfer to the platform. When entering the end date, the order should be in the form of year-month-day. For example 2021-03-19.
  6. Data Type ( kWh, m3, etc.): This column is shaped according to the data type selected on the platform. For example, for electricity consumption data in kWh, water consumption data in m3 can be entered.
  7. Cost: In this column, the cost information of the consumption data of the relevant location is entered.

*The Cost column must not be left empty. If the cost is unknown, please input '0'. A different format cannot be accepted for loading.*​