Download table with consumption data from a M2M SIM card as a .csv file

  1. Data from at least one SIM card are available for the last 12 months (1).
  1. An e-mail with a .csv file is sent to the e-mail address stored in the Tenant:
  3. The .csv file includes the data in a worksheet.
  4. A corresponding confirmation displays in menu 'M2M router' (3).

Note on COV import from an exported .csv file

To ensure the data in the exported .csv file can be read during a COV import, perform the following steps in the .csv file:

  1. A csv file is exported from Climatix IC.
  2. The data in the .csv file is summarized in the first worksheet column.
  1. Separate the values displayed in the table with a comma (',').
    • For example, use the function 'Data > Text to Columns' in Microsoft Excel.
    • Perform this step for each row individually.
  2. Change the preset formatting of the 'ICCID & IMSI' worksheet manually to 'Text'.
  3. Save the modified .csv file.
  1. The COV import can be performed without loss of data.