A grid is shown of the file you uploaded (only the first 10 lines are shown).\
To do a manual import, you can follow these steps:\
[LIST]\

  • First step is to find the correct delimiter.\
    Most csv files separate their data with commas, however some use semicolons and some use tabs.\
    Go through the Delimiter dropdown right above the grid until you find a\
    delimiter that breaks up the data in the grid into one value per cell.\
    Hint: If you see everything pushed into one long column in the grid,\
    you should choose another delimiter.\
  • Second step is to choose the correct type of data contained in each column.\
    Above every column is a dropdown.\
    Go through each column in the grid and select the type\
    of data from the dropdown that best matches the column.\
    At minimum you must specify:\
      \
    • P1 Active Energy\
    • Date\
    • Time You can also specify:\
    \
    \
    [LIST]\
  • Q1 Reactive Energy\
      \
    • P2 Active Energy\
    • Q2 Reactive Energy\
    • Q3 Reactive Energy\
    • Q4 Reactive Energy\
    • Apparent Energy Notes:\
    \
    Note 1: The most common billing energy types for import are P1 Active (kWh) and Q1 Reactive Energy (kvarh).\
    Note 2: Sometimes the date and time are split into separate columns in the grid, and other times they are both in one column.\
    Please make sure you select the value from the dropdown that best matches the date and time in the column.\
    Note 3: Only active and reactive energy data is stored.\
    Apparent energy is used only when P1 is also given, to calculate Q1.\
    Note 4: If your data contains Watt Hours and not Kilowatt Hours, please make sure you select Wh and not kWh.\
    Same applies for varh and kvarh and VA and kVA.\
    Note 5: If your data contains Kilowatts and not Kilowatt Hours, please make sure you select kW and not kWh.\
    Kilowatts will be divided by 2 to get Kilowatt Hours, since there are 2 half hours in an hour.\
    Same applies for kvar and kvarh.\
    Note 6: All readings have only one time associated with them.\
    That is the time the half-hour period ended.\
    e.g. If I have a reading of 3 kWh for the period 1:00 to 1:30, the time is specified as 1:30.\
    If the file to be imported has a \"Start Time\" column then ignore the \"Start Time\" column.\
    We can only use an \"End Time\" column.\
    Specifying the \"Start Time\" may make all imported readings 30 minutes earlier.\
    [LIST]\
  • Third step is to select the line in the file where the data starts.\
    The first few lines usually contain header information and does not form part of the data to be imported. The first column in the grid contains radio buttons where you can choose the line where data starts.\
    Note: If you are unsure, leave the top radio button selected.\
    The importer will skip lines that do not contain parsable data.\
    Number of lines imported and not-imported will be shown after an import.\
  • The last three steps are to\
      \
    • click the Import button (below grid),\
    • check for error and success messages and\
    • browse the data with the graph and check that it looks correct.\
    \