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.24Dazu 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
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren Anmelden