Thank you so much for that howto! Grafana looks pretty awesome.
Maybe anyone tried already to migrate their old data from rrd4j to influxdb by using the rest2influxdb script?
The import is not working as you can see:
:~/rest2influxdb$ ./rest2influxdb.sh Humidity_Kaum_HT
timestamps
item: Humidity_Kaum_HT
10y: 2009-09-24T19:41:15+02:00
1y: 2018-08-27T19:41:15+02:00
1m: 2019-08-26T19:41:15+02:00
1w: 2019-09-17T19:42:15+02:00
1d: 2019-09-23T19:42:15+02:00
8h: 2019-09-24T11:42:15+02:00
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 1838 0 --:â:-- --:â:-- --:â:-- 1836
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 7764 0 --:â:-- --:â:-- --:â:-- 7860
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 10411 0 --:â:-- --:â:-- --:â:-- 10903
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 10147 0 --:â:-- --:â:-- --:â:-- 10562
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 9843 0 --:â:-- --:â:-- --:â:-- 10242
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 338 100 338 0 0 10136 0 --:â:-- --:â:-- --:â:-- 10562
found values: 0
Warning: Couldnât read data from file âHumidity_Kaum_HT-*â, this makes an
Warning: empty POST.
HTTP/1.1 204 No Content
Content-Type: application/json
Request-Id: 82324905-def2-11e9-83c2-b827eb4abb45
X-Influxdb-Build: OSS
X-Influxdb-Version: 1.7.8
X-Request-Id: 82324905-def2-11e9-83c2-b827eb4abb45
Date: Tue, 24 Sep 2019 17:41:15 GMT
Sleep for 5 seconds to let InfluxDB process the dataâŚ
delete temporary files
The xml files that this script produces for the import step do have the following content:
{"error":{"message":"2009-09-24T10:27:25 02:00 is not in a valid format.","http-code":500,"exception":{"class":"java.lang.IllegalArgumentException","message":"2009-09-24T10:27:25 02:00 is not in a valid format.","localized-message":"2009-09-24T10:27:25 02:00 is not in a valid format.","cause":"java.time.format.DateTimeParseException"}}}{"error":{"message":"2018-08-27T10:27:25 02:00 is not in a valid format.","http-code":500,"exception":{"class":"java.lang.IllegalArgumentException","message":"2018-08-27T10:27:25 02:00 is not in a valid format.","localized-message":"2018-08-27T10:27:25 02:00 is not in a valid format.","cause":"java.time.format.DateTimeParseException"}}}{"error":{"message":"2019-08-26T10:27:25 02:00 is not in a valid format.","http-code":500,"exception":{"class":"java.lang.IllegalArgumentException","message":"2019-08-26T10:27:25 02:00 is not in a valid format.","localized-message":"2019-08-26T10:27:25 02:00 is not in a valid format.","cause":"java.time.format.DateTimeParseException"}}}
âŚ
âŚ
âŚ
That means its pretty obvious that there is a problem related to timestamps?
The Data i would like to import is temperature data from the jeelink_lacrosse binding.
i am using openHAB 2.5.0~M3-1 (Milestone Build)
with influxdb 1.7.8 & grafana v6.3.6 installed through openhabian-config
The Script is from GitHub - CWempe/rest2influxdb in the latest master version
Would be really glad if somebody could assist me!
best regards and thanks in advance,
Walter