Products overview

This guide covers how to export data from ReCalc.
File format: CSV. A maximum of 40,000 rows can be downloaded at a time.

1. Log in to ReCalc.
2. In the menu on the left, under Data analysis, click Export data.
   
3. First, choose what to export. Read more about the different data types at the bottom of the page.
   
4. Then choose which period you want data from.
5. Select which Units to export.
6. Click the Export button at the bottom.
7. After a while, a CSV file named exportData.csv will be downloaded.
8. Open the file in a program that supports CSV files (Excel, Google Sheets, etc.)

Data Types:
Raw: This is the raw data from the sensor.
5 Minutes: Here all Raw data are added together within 5 minutes.
Hour: Raw data within an hour is added together.
Day: Raw data within a day is added together.
Solved Alarms: This is a list of the alarms that have been resolved.
Gateways: A list of the Gateways registered in the account.
Sensors: List of the sensors registered in the account.

NOTE: This guide is made in Excel version 2101 for Windows and may not work on older versions. How to find the version number: Link.

This guide covers how to get data into Excel from the ReMoni API, using a URL string created on the ReMoni API page. See the guide to how it will be made: Link.

1. Open Excel
2. Select the Data tab and then click From Web.
   
3. Insert the URL string from the ReMoni API and click OK.
   
4. Select “basic” and use your email and password from ReCalc.
   
5. Now the Power Query Editor opens. On the Transform tab, click “To Table”.
   
6. Click OK for this dialog box.
   
7. Then click on the small icon of two arrows in the right corner of the column. Click OK for the next window that appears.
   
8. Select the Transform tab and click on Detect data type.
   
9. If it does not convert the Timestamp column to Date/Time itself, this is necessary to do yourself.
   
10. First click on the column with Timestamp and then select the Transform tab and click on Reverse Rows.
    
11. Select the Home tab and click Close & Load.
    
12. In order to make a graph of Timestamp and Value, you have to convert the top timestamp to a Time. Click on the top Timestamp then select the Home tab and then click on the dropdown where it says Custom. Select Time.
    
13. Select the entire Timestamp and Value column at the same time. On the Insert tab, Select curves.
       
14. To update data, click on the small update icon on the right side.
    

This guide covers how to get a URL string out of ReMonis API. With the URL string, you can retrieve data from the API, e.g. in Excel or just by inserting it into a browser’s address bar.

Find the Unit from which to retrieve data.

1. Login to ReCalc.
2. Under Installations, click Units.
   
3. Find the unit from which to retrieve data. The “ID” column contains the Unit ID to be used later in this guide.
   
4. To find the type of unit created, click the View button of the unit in which you want to retrieve data.
   
5. Here is the Unit type.
   

API step by step.

1. Open the page api.remoni.com.
2. Click Authorize in the upper right corner.
   
3. Login with the same login information as on ReCalc.
4. Locate and click Get /Data.
   
5. In the unfolded tab, find the following fields:
   Timestamp: The starting point from which data is to be retrieved. Year-month-day.
   UnitId: The ID of the unit from which data is to be retrieved. Unique 4 digit number from ReCalc.
   AggregateType: The type of aggregate to retrieve data in. Raw, Minutes5, Hour, Day.
   DataType: The type of data to be retrieved.
   UnitTypeInputId: Consists of two numbers put together, e.g. 3001. The first 2 digits are the unit type ID, e.g. is 30 a Generic PowerMoniMain. The last two digits are the channel number 01, 02, 03, etc.In order to retrieve data, UnitId, DataType and UnitTypeInputId must match. In the table below you can see the connection between the three parameters. First, find which UnitType is created in ReCalc, then select which type of data to retrieve and then which channel to retrieve from. 

    

   UnitType	DataType	UnitTypeInputId
   		Channel 1	Channel 2	Channel 3	Channel 4
   Generic PowerMoniMain	Power	3001	3002	3003
   	Current	3001	3002	3003
   Generic PowerMoniSpot	Uncalibrated-current	2801
   	Apparent-power*2	2801
   Generic TempMoniSpot	Temperature	4301	4302	4303
   Generic TempMoniDC	Temperature	5201	5202	5203
   	Analog-voltage	5204	5205	5206	5207
   GatewayAir	Temperature	5801
   	Humidity	5801
   	CO2 concentration		5802

   * 1 The summed value for all three channels.
   * 2 To be able to retrieve apparent power, a PowerMoniSpot must be calibrated to level2.

6. In the field, Timestamp write le(2030-01-01). le stands for less than or equal to. This means that all data from before the date will be retrieved. See the example below:
   
7. In UnitId write the 4 digit number we found in ReCalc. Write it like this eq(0002). eq stands for equal / straight and this means that it only retrieves data from this number. See the example below:
   
8. In AggregateType, type eq(Hour). It can be Raw, Minutes5, Hour or Day. See the example below:
   
9. DataType is written as eq(power). See the example below:
   
10. UnitTypeInputId is written as eq(3001). See example below:
    
11. Then click Try it out!
    
12. If everything is entered correctly, the Response Body field should look like this:
    If there is an error in the entry, the Response Body field looks like this:
    
13. If everything is entered correctly, the URL in the Request URL field can be copied and used, for example, in Excel.
    

Examples:
Below are a few examples of a URL string that retrieves data from three demo Units.

1. Temperature:
Here we retrieve the data that is later than 2017-01-01, from Unit 1258 (Generic HeatMoniSpot), it retrieves hourly data, the data type is temperature, it is on the unit channel 3101 and it retrieves the latest 10000 rows.

https://api.remoni.com/v1/Data?Timestamp=gt(2017-01-01)&UnitId=eq(1258)&AggregateType=eq(Hour)&DataType=eq(temperature)&UnitTypeInputId=eq(3101)&top=10000

2. Uncalibrated-current:
Here we retrieve the data that is later than 2017-01-01, from Unit 2343 (Generic PowerMoniSpot), it retrieves hourly data, the data type is uncalibrated-current, it is on unit channel 2801 and it retrieves the latest 10000 rows.

https://api.remoni.com/v1/Data?Timestamp=gt(2017-01-01)&UnitId=eq(2343)&AggregateType=eq(Hour)&DataType=eq(uncalibrated-current)&UnitTypeInputId=eq(2801)&top=10000

3. Power:
Here we retrieve the data that is data that is before 2040-01-01 from Unit 6415 (Generic PowerMoniMain), it retrieves hourly data, the data type is Power, data is on unit channel null (a summation of the 3 channels) and it retrieves the latest 20 rows.

https://api.remoni.com/v1/Data?orderbydesc=Timestamp&Timestamp=lt(2040-01-01)&UnitId=eq(6415)&AggregateType=eq(Hour)&DataType=eq(Power)&UnitTypeInputId=eq(null)&top=20

In order to read data from the Kamstrup sensor, an encryption key must first be generated. This is done through Kamstrup’s website.

1. Go to the Kamstrup login page https://apps.kamstrup.com
2. If you do not have an account, make one.
3. Click on: Krypteringsnøgler.
4. In “Administrer enheder” choose “+ Registrer enhed”.
5. Fill out the form.
   
6. Click on the sensor id in the list and chose “Download fil”.
7. Chose XML from the dropdown list “Filtype” and click on “Download fil”.
8. Open the XML file in Excel or a similar program.
9. Inside the XML file, the encryption key can be found under “EncKeys”, shown here marked in red:
   <EncKeys>
                   <DEK>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</DEK>
   </EncKeys>
10. Save the encryption key for later use.

Register the Kamstrup sensor inside ReCalc.

1. Log in to ReCalc
2. Make sure the GateWay wM-Bus is registered before you register the sensors. See the installation guide above.
3. Click on “External Sensors” in the left menu panel.
4. Press the button “Register new External Sensor”.
5. Fill out the form as shown below:
   1. Choose a name for the sensor.
   2. In the dropdown, select “Gateway”.
   3. In the dropdown, select “Kamstrup”.
   4. Then select which sensor want to connect to.
   5. Enter the Kamstrup device ID (the first part of the serial number before “/”).
   6. Type the encryption keys we retrieved in the first section.

      

6. Wait for the sensor to be created, you may reload the page a couple of times. This usually takes 1 minute.
   
7. To see data from the sensor, it must be created as a Unit. To do that, click on the + sign in the “Units” section.
8. Fill out the form as shown below:
   1. Give the new unit a telling name.
   2. In the Unit type dropdown, select “Generic Unit”.
   3. Under Generic UnitTypeInput 1. Click on the circle next to “External sensor”.
   4. In the drop-down “External sensor”, select the sensor that has just been created*.
   5. In the drop-down “External sensor channel”, select the available channel.
   6. Click “Create”

      

      *It can take a few moments before you’re able to choose sensors.

9. You can now go to “View data” i the menu and choose the new unit you created.
10. Click on “Live” to see live data.