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;
- Code: Indicates the code of the branches registered in the account you entered. The location code in the first row of the downloaded Excel is already filled. You don't need to fill in the first row, but you should fill the other rows for location code.
- Location: This is the section where the names of the branches belonging to the code are included. The location in the first row of the downloaded Excel is already filled. You don't need to fill in the first row, but you should fill the other rows for location.
- Activity: Shows the activity type of the location.
- 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.
- 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.
- 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.
- 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.*​