File Configuration

Creating folders

In smart-me, you can create a folder structure and assign relevant meters to these folders. You can use the folder structure to map a building with different apartments, for example.

To create new folders:

  1. Log into the smart-me website: https://www.smart-me.com
  2. Click on ‘Configuration’ in the top right-hand corner
  3. Click on ‘Meter/folder configuration’
  4. Select ‘Add node’ to create a new folder.
  5. To assign a meter to a folder, use the mouse to drag it into the folder. You can also use the mouse to move folders.

Automatically creating folders with a CSV file

smart-me allows users to automate the process of creating folders as well as assigning and renaming meters using a CSV file. You will need a smart-me Professional subscription to use this function.

CSV files contain tabular data that is stored in text form. They can be edited with a text editor (e.g. notepad++).

PLEASE NOTE: Using this function will cause existing folders to be deleted. This means that any functions used with these folders will no longer work, e.g. if-then actions, smart-me billing configurations, etc.

The following columns (do not change the order) are contained in a configuration CSV file:

Spalten der Konfigurations-CSV-Datei

The separators ‘;’ and ‘//’ must not be used in names. They are reserved for separating columns and folders in paths.

If the four columns – ‘MeterPointId’, ‘ExportFormat’, ‘UploadType’ and ‘ExportInterval’ are present – the meter is also registered for auto export.

A sample configuration without auto export:

MeterSerialNumber;MeterName;FolderPath
102177;Büro 100;Wohnung 1. Stock Links // Büro
636731327420929937;Wohnzimmer 101;Wohnung 1. Stock Links // Wohnzimmer
101163;Schlafzimmer 102;Wohnung 1. Stock Links // Schlafzimmer

A sample configuration with auto export:

MeterSerialNumber;MeterName;FolderPath;MeterPointId;ExportFormat;UploadType;ExportInterval
102177;Büro 100;Wohnung 1. Stock Links // Büro;CH100;CSV_1;FTP_2;Weekly
636731327420929937;Wohnzimmer 101;Wohnung 1. Stock Links // Wohnzimmer;CH101;CSV_1;FTP_2;Daily
101163;Schlafzimmer 102;Wohnung 1. Stock Links // Schlafzimmer;CH102;CSV_1;FTP_2;Monthly

Editing CSV files in Excel

Excel also supports the editing of CSV files. There are two points to consider here:

  1. Excel must be prevented from rounding the meter serial number or displaying it in an exponential form, e.g. by treating numbers as text in Excel.
  2. The CSV file must be in the UTF-8 character set. Excel does not display umlauts correctly. However, these characters are displayed correctly in a text editor (e.g. notepad++).

The recommended workflow is as follows:

  1. Log into the smart-me website: https://web.smart-me.com/login/
  2. Click on ‘Configuration’ in the top right-hand corner
  3. Click on ‘Meter/folder configuration’
  4. Click on ‘Node configuration via CSV’
  5. Click on ‘Download node configuration’ to download the current configuration as a CSV file
  6. Edit the configuration
  7. Check the configuration in a text editor that supports the UTF-8 character set to check whether meter serial numbers and names are displayed correctly
  8. Click on ‘Browse’ and select the edited CSV file
  9. Click on ‘Upload node configuration’ to apply the configuration (caution: the resulting changes cannot be undone)