Ich habe seit knapp einem Jahr einen Shelly pro 3EM im Betrieb und nun aus versehen die InfluxDB gelöscht, in die ich die Daten schreibe.
In der Web App habe ich nun die Möglichkeit mir alle Daten vom Gerät zu holen. Hat auch wunderbar funktioniert, nur komme ich mit den Spalten nicht zurecht.
Code
1700092800,16.6373,16.6195,0.0000,0.0000,0.0000,4.3657,1026.8,992.7,1069.6,1034.4,229.505,228.781,229.156,4.674,4.520,4.534,0.8888,0.8957,0.0000,0.0000,0.0000,3.1135,56.1,50.3,214.0,208.9,229.915,229.167,229.539,0.932,0.911,0.919,0.8156,0.8196,0.0000,0.0000,0.0000,2.1381,51.9,44.6,161.1,153.7,230.643,230.061,230.347,0.700,0.668,0.686,0.028,0.026,0.027
1700092860,16.6177,16.6010,0.0000,0.0000,0.0000,4.3645,1007.6,992.2,1047.5,1033.1,229.470,228.816,229.191,4.578,4.515,4.534,0.8871,0.8934,0.0000,0.0000,0.0000,3.1077,55.2,50.7,213.1,209.5,229.597,228.902,229.279,0.930,0.913,0.920,0.8150,0.8190,0.0000,0.0000,0.0000,2.1376,52.4,44.2,160.7,153.8,230.531,229.744,230.183,0.699,0.669,0.686,0.028,0.026,0.027
1700092920,16.5462,16.5295,0.0000,0.0000,0.0000,4.3524,1000.0,987.4,1042.1,1028.7,229.262,228.421,228.726,4.559,4.504,4.519,0.8761,0.8825,0.0000,0.0000,0.0000,3.1094,54.2,48.8,212.1,209.0,229.687,229.134,229.438,0.925,0.911,0.920,0.8156,0.8196,0.0000,0.0000,0.0000,2.1370,51.6,44.0,160.9,153.9,230.307,229.719,230.061,0.700,0.670,0.687,0.028,0.026,0.027
1700092980,16.5601,16.5422,0.0000,0.0000,0.0000,4.3518,1001.2,987.7,1041.6,1029.2,229.351,228.459,228.825,4.551,4.508,4.522,0.8490,0.8548,0.0000,0.0000,0.0000,3.1008,53.3,47.9,212.1,207.5,229.754,228.716,229.402,0.925,0.906,0.915,0.8104,0.8144,0.0000,0.0000,0.0000,2.1353,52.2,44.7,161.0,153.9,230.613,229.739,230.082,0.701,0.669,0.686,0.028,0.026,0.027
1700093040,16.2290,16.2065,0.0000,0.0000,0.0000,4.2446,998.2,984.9,1039.3,1025.0,228.726,228.115,228.404,4.553,4.495,4.514,0.8300,0.8352,0.0000,0.0000,0.0000,3.0218,53.3,47.7,210.2,206.4,229.212,228.449,228.715,0.919,0.903,0.909,0.7948,0.7977,0.0000,0.0000,0.0000,2.0885,52.0,45.0,159.5,153.8,230.042,229.498,229.703,0.694,0.671,0.683,0.028,0.026,0.027
1700093100,16.5370,16.5139,0.0000,0.0000,0.0000,4.3311,1001.8,988.8,1039.8,1029.3,229.249,228.482,228.863,4.542,4.504,4.517,0.8663,0.8727,0.0000,0.0000,0.0000,3.0841,56.5,47.3,213.2,206.7,229.612,228.924,229.202,0.931,0.904,0.915,0.8058,0.8098,0.0000,0.0000,0.0000,2.1306,50.8,45.4,159.1,154.4,230.212,229.662,229.910,0.692,0.673,0.683,0.028,0.026,0.027
1700093160,16.5831,16.5595,0.0000,0.0000,0.0000,4.3415,1000.4,990.7,1040.4,1032.2,229.595,229.069,229.302,4.538,4.506,4.520,0.8709,0.8761,0.0000,0.0000,0.0000,3.0875,57.5,49.5,214.0,208.3,229.627,229.102,229.359,0.933,0.909,0.916,0.8092,0.8127,0.0000,0.0000,0.0000,2.1295,51.7,46.5,159.5,155.2,230.176,229.579,229.906,0.695,0.677,0.684,0.028,0.026,0.027
1700093220,7.1539,7.1614,0.0000,0.0000,0.0000,4.5105,1004.3,146.9,1043.7,333.5,229.436,228.706,229.087,4.556,1.456,2.461,0.8767,0.8831,0.0000,0.0000,0.0000,3.0731,56.0,49.7,210.5,205.4,229.898,228.783,229.402,0.920,0.898,0.908,0.8381,0.8433,0.0000,0.0000,0.0000,2.1468,53.1,46.5,161.4,155.9,229.851,229.100,229.429,0.705,0.680,0.693,0.028,0.026,0.027
1700093280,3.3586,3.3655,0.0000,0.0000,0.0000,3.7947,1429.6,146.0,1375.3,319.0,229.485,228.207,229.135,6.050,1.392,1.503,0.9384,0.9442,0.0000,0.0000,0.0000,3.0766,67.1,50.0,213.6,206.6,229.773,229.092,229.471,0.931,0.900,0.914,0.8208,0.8254,0.0000,0.0000,0.0000,2.1583,53.3,45.0,160.9,154.7,229.554,228.981,229.304,0.703,0.676,0.691,0.028,0.026,0.027
1700093340,3.4324,3.4388,0.0000,0.0000,0.0000,3.5247,221.5,201.6,337.1,317.5,229.650,229.053,229.367,1.470,1.386,1.401,0.9194,0.9252,0.0000,0.0000,0.0000,3.0743,57.9,52.7,211.9,207.8,229.976,229.216,229.597,0.923,0.907,0.912,0.8265,0.8300,0.0000,0.0000,0.0000,2.1618,54.4,45.9,162.7,155.8,230.078,229.359,229.664,0.709,0.680,0.694,0.028,0.026,0.027Kann mir bitte jemand helfen, was die einzelnen Spalten beinhalten?
Danke.
Grüße
Martin