NEWS
Vis, Javascript, Json und Tabellen
-
Hallo zusammen,
möchte folgende Tabelle erstellen:
2021 Januar Februar März April Mai Juni Juli August ..... Regen_Max 0,57 mm Regen_Max_Tag 02.02.2021 Regen_Monat 1,2 Tag <= 0 14 Tag <= -10 0 Tag <= -15 2 usw. Tag >= 20 4 Tag >= 25 ´ 0 Tag >= 30 0 Temperatur_Max 23,34 Temp_Max_Tag 25.02.2021 Temperatur_Min -16.88 Temp_Min_Tag 15.02.2021 Wind_Max 7,53 Windboee_Max_Tag 17.02.2021 Windboeen_Max 15.24
Dazu habe ich diese Datenpunkt Struktur angelegt:
Mit diesem Skript versuche ich einen Json String zu erstellen:
var pfad = '0_userdata.0.vis.Wetter.Statistik.2021.'; var monat = [ '01_Januar.', '02_Februar.', '03_März.', '04_April.', '05_Mai.', '06_Juni.', '07_Juli.', '08_August.', '09_September.', '10_Oktober.', '11_November.', '12_Dezember.' ]; var dps = [ 'Regen_Max', 'Regen_Max_Tag', 'Regen_Monat', 'Temperatur_Max', 'Temp_Max_Tag', 'Temperatur_Min', 'Temp_Min_Tag', 'Tag_0', 'Tag_10', 'Tag_15', 'Tag_20', 'Tag_25', 'Tag_30', 'Wind_Max', 'Windboee_Max_Tag', 'Windboeen_Max' ]; var einheit = [ ' mm', '', ' mm', ' °C', '', ' °C', '', '', '', '', '', '', '', ' km/h', '', ' km/h' ]; var tabelle = []; var ausgabe = []; var k = 0; for (var j = 0; j <= monat.length-1; j++) { var dp = pfad + monat[j]; for (var i = 0; i < dps.length-1; i++) { tabelle[i] = {}; tabelle[i].Name = getObject(dp + dps[i]).common.name; tabelle[i].Wert = getState(dp + dps[i]).val + einheit[i]; ausgabe[k] = tabelle[i]; k++; }; } setState('0_userdata.0.vis.Wetter.Statistik.json_tabelle', JSON.stringify(ausgabe), true);
Als "Json "String (?) erhalte ich folgendes:
[{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":" "},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":" "},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":" "},{"Name":"Regen Max","Wert":"0.57 mm"},{"Name":"Regen Max Tag","Wert":"17.02.2021"},{"Name":"Regen Monat","Wert":"1.2 mm"},{"Name":"Temperatur Max","Wert":"23.43 °C"},{"Name":"Temperatur Max Tag","Wert":"25.02.2021"},{"Name":"Temperatur Min","Wert":"-16.88 °C"},{"Name":"Temperatur Min Tag","Wert":"15.02.2021"},{"Name":"Frost Tag","Wert":"14"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"2"},{"Name":"Tag Warm","Wert":"4"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"7.53 km/h"},{"Name":"Windböe Max Tag","Wert":"17.02.2021"},{"Name":"Regen Max","Wert":"0.89 mm"},{"Name":"Regen Max Tag","Wert":"14.03.2021"},{"Name":"Regen Monat","Wert":"1.9 mm"},{"Name":"Temperatur Max","Wert":"25.26 °C"},{"Name":"Temperatur Max Tag","Wert":"31.03.2021"},{"Name":"Temperatur Min","Wert":"-8.65 °C"},{"Name":"Temperatur Min Tag","Wert":"07.03.2021"},{"Name":"Frost Tag","Wert":"16"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"11.1 km/h"},{"Name":"Windböe Max Tag","Wert":"27.03.2021"},{"Name":"Regen Max","Wert":"3.9 mm"},{"Name":"Tag Regen Max","Wert":"12.04.2021"},{"Name":"Regen Monat","Wert":"8.7 mm"},{"Name":"Temperatur Max","Wert":"25.74 °C"},{"Name":"Tag Temperatur Max","Wert":"01.04.2021"},{"Name":"Temperatur Min","Wert":"-5.27 °C"},{"Name":"Tag Temperatur Min","Wert":"06.04.2021"},{"Name":"Tag < 0 °C","Wert":"8"},{"Name":"Tag <= -10 °C","Wert":"0"},{"Name":"Tag <= -15 °C","Wert":"0"},{"Name":"Tag >= 20 °C","Wert":"1"},{"Name":"Tag >= 25 °C","Wert":"2"},{"Name":"Tag >= 30 °C","Wert":"0"},{"Name":"Wind Max","Wert":"19.15 km/h"},{"Name":"Tag Windböe Max","Wert":"05.04.2021"},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""},{"Name":"Regen Max","Wert":"0 mm"},{"Name":"Regen Max Tag","Wert":""},{"Name":"Regen Monat","Wert":"0 mm"},{"Name":"Temperatur Max","Wert":"0 °C"},{"Name":"Temperatur Max Tag","Wert":""},{"Name":"Temperatur Min","Wert":"0 °C"},{"Name":"Temperatur Min Tag","Wert":""},{"Name":"Frost Tag","Wert":"0"},{"Name":"Kalter Tag","Wert":"0"},{"Name":"Eiskalter Tag","Wert":"0"},{"Name":"Tag Warm","Wert":"0"},{"Name":"Sommertag","Wert":"0"},{"Name":"Tag Heiß","Wert":"0"},{"Name":"Wind Max","Wert":"0 km/h"},{"Name":"Windböe Max Tag","Wert":""}]
In Vis habe ich eine Json-Tabelle eingefügt, mit 13 Spalten und max. 15 Zeilen.
DIe Tabelle zeigt aber nur den 1. Monat an.Was ist eigentlich bei meinem Vorgehen überhaupt richtig?
Bitte um Hilfe.
Danke
MfG
Wastl