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:
- Log into the smart-me website: https://www.smart-me.com
- Click on ‘Configuration’ in the top right-hand corner
- Click on ‘Meter/folder configuration’
- Select ‘Add node’ to create a new folder.
- 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 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:
- 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.
- 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:
- Log into the smart-me website: https://web.smart-me.com/login/
- Click on ‘Configuration’ in the top right-hand corner
- Click on ‘Meter/folder configuration’
- Click on ‘Node configuration via CSV’
- Click on ‘Download node configuration’ to download the current configuration as a CSV file
- Edit the configuration
- 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
- Click on ‘Browse’ and select the edited CSV file
- Click on ‘Upload node configuration’ to apply the configuration (caution: the resulting changes cannot be undone)