Download Daten vom pro 3EM

martin.b07

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.027

Kann mir bitte jemand helfen, was die einzelnen Spalten beinhalten?

Danke.

Grüße

Martin

apreick

Wilkommen im Forum 🤗

Die Suche bringt viele Ergebnisse 😎

Ein Beispiel

Beitrag

RE: Keine graphische Darstellung

na, wenn ihr meint

CSV download direkt in Excel öffnen

Der Inhalt kann nicht angezeigt werden, da Sie keine Berechtigung haben, diesen Inhalt zu sehen.

Ergebnis:

Der Inhalt kann nicht angezeigt werden, da Sie keine Berechtigung haben, diesen Inhalt zu sehen.

Vielleicht habe ich ja ein anderes Excel

apreick

9. März 2023 um 21:37

Oder mal mein Filter zum Suchen

https://shelly-forum.com/search/?q=Csv+…goryIDs%5B%5D=*

Krauskopp

Leider ist das nicht das Gleiche, würde ich sagen.

Zuerst mal wurde vergessen, die erste Zeile mit den Überschriften mit auszugeben.

Dann fängt hier das Ganze mit dem Timecode an. Dann folgen ca. 50 weitere Spalten.

Wie und wo wurden denn hier die Daten "geholt"?

Beim guten alten 3EM wurde das direkt in der Shelly-Weboberfläche gemacht. Jede Phase für sich.

Datum Zeit, Energie vorwärts und rückwärts. Monate waren und sind wild gemischt. Beginnt bei mir im Dezember 23 und endet im Juni 23. Alles andere gemischt dazwischen.

Code

Date/time UTC,Active energy Wh (A),Returned energy Wh (A)
2023-12-27 07:30,1.20,0.00
2023-12-27 07:40,0.20,0.80
2023-12-27 07:50,0.00,4.20
2023-12-27 08:00,0.00,4.30
2023-12-27 08:10,0.00,3.40
2023-12-27 08:20,0.70,3.60
2023-12-27 08:30,0.00,6.30
2023-12-27 08:40,1.50,6.80
2023-12-27 08:50,1.30,6.40
2023-12-27 09:00,7.70,0.00
2023-12-27 09:10,1.20,6.20
2023-12-27 09:20,11.40,1.10
2023-12-27 09:30,2.30,2.50
2023-12-27 09:40,14.80,1.50
2023-12-27 09:50,5.40,0.10
2023-12-27 10:00,35.00,7.30
2023-12-27 10:10,11.60,0.00
2023-12-27 10:20,1.80,4.40
2023-12-27 10:30,12.20,0.00
2023-12-27 10:40,17.50,1.70
2023-12-27 10:50,15.10,0.90
2023-12-27 11:00,19.50,0.50
2023-12-27 11:10,11.70,0.00
2023-12-27 11:20,11.40,0.60
2023-12-27 11:30,2.70,2.30
2023-12-27 11:40,0.00,10.30

Alles anzeigen

Beim TE steht aller Müll drinnen, den keiner braucht. Wahrscheinlich der komplette Unsinn, wie er auch in der App zu sehen ist. Min, Max, Durchschnitt, teuer, billig und das von allen Messgrößen. Da muss man mal mit der App ein paar Zahlen vergleiche, dann bekommt man das mit Excel schon in eine Tabelle. Kann man auch dann ein wenig minimieren.

apreick

ich mach ja schon

Der Inhalt kann nicht angezeigt werden, da Sie keine Berechtigung haben, diesen Inhalt zu sehen.

ein mal komplett und ein mal 10Tage

dauert wohl etwas

apreick

also der für 10 Tage kommet mit der ersten Zeile

da ist also die Zuordnung

Der Inhalt kann nicht angezeigt werden, da Sie keine Berechtigung haben, diesen Inhalt zu sehen.

Download Daten vom pro 3EM

RE: Keine graphische Darstellung

Ähnliche Themen

EM: Stundenwerte aus der Vergangenheit in einem Rutsch auslesen

Keine graphische Darstellung

Phase 2 (B) zeigt Daten in anderer Reihenfolge als Phase 1 (A) und 3 (C)