Sonoff smart plug with power monitor data went missing

Ideas & Suggestion Free discussion
1

I have 4 Sonoff smart plugs with power monitor model S40TBP.
On March 1, 2024 most of the data for January and February went to 0’s in the downloaded history.csv file.
Looking at the yearly trend in the app, the data bars for January and February are gone.
I manually record the data to a spreadsheet after 12:00 am daily, so I’m sure the consumption information for every day was there yesterday.
Has anybody else had this happen? I can’t help but think that it has something to do with the leap year.

On a side note, why would they make an app that you can’t scroll back and forth in the monthly data trend? Just seems odd to me.

2

Would you please let me know one of the device ID which met the data lost issue?
Let me check and get back to you once I have any clue.

3

I submitted feedback and included the device id’s affected.
I figured out the data is not lost. The dates have been shifted.
I started using the smart plugs on December 2 2023. Yet the app yearly trend and the CSV files downloaded show data recorded in October and November 2023. For instance…
In the history.csv the October 5 2023 data is actually the data for December 2 2023
In the history.csv the January 3 2024 data is actually the data for February 29 2024.
The data shown in the history.csv file for October 24 and 25 repeated for some reason (I deleted the October 25 data.)
The data then matches up exactly with the daily numbers I entered in to my spreadsheet every day.
Data is recording correctly since March 1 2024. This is why I wonder if a programming error around February 29 2024 may have caused the issue.

4

Thx, we got your ticket, will update u when we diagnose the cause

5

Awesome, thanks

1 Like
6

Hello there,

Our team has conducted a detailed investigation of the device logs and found that during the specified time frame you provided, the device’s history field data displayed as “00000”, which caused the app to fail in accurately parsing it.

The Sonoff team is currently investigating the reason behind the device reporting this data in such a manner. If a solution is identified, I will ensure to keep you updated accordingly.

Thank you for your patience and understanding as we work towards resolving this issue.

8

Thanks Erin,
Remember, not just 1 device has this issue, but all 4 of this same device model that I have is affected.
All 4 devices show data recorded in October and November when I didn’t even have them. I installed them on December 2.
Since I identified the error and how the data somehow got out of sync. Could someone put the database back in the correct order for all 4 devices? As I detailed in previous post.
Then proceed to find the root cause.
Like I said in my ticket, I enter this data to a spreadsheet every day. On February 29 everything was correct, On March 1, the data went out of sync.
I hope somebody fixes this.

9

I guess this is a problem unsolved and left without a solution. Even though the simplest solution is to put the data back in order in the database and hope it doesn’t get corrupted again.

10

I hope somebody reads this…
So the end of the month happened, monthly graph switched to April. Since I can’t look back at March in the bar graph, have to download the csv for each of my 4 devices to get data for March 31. I’m attaching the csv files downloaded for the first 2 devices. The other 2 devices had the same issue when I downloaded the csv’s for them.
First device was downloaded fine, Here is the March part of the file…
2024/03/01,27.37,4.8
2024/03/02,21.74,3.81
2024/03/03,7.46,1.31
2024/03/04,7.72,1.35
2024/03/05,13.05,2.29
2024/03/06,6.81,1.19
2024/03/07,11.15,1.96
2024/03/08,19.95,3.5
2024/03/09,12.35,2.17
2024/03/10,15.01,2.63
2024/03/11,9.6,1.68
2024/03/12,8.49,1.49
2024/03/13,8.64,1.52
2024/03/14,7.4,1.3
2024/03/15,6.5,1.14
2024/03/16,8.23,1.44
2024/03/17,8.31,1.46
2024/03/18,6.64,1.17
2024/03/19,9,1.58
2024/03/20,7.32,1.28
2024/03/21,9.47,1.66
2024/03/22,14.86,2.61
2024/03/23,12.65,2.22
2024/03/24,7.89,1.38
2024/03/25,8.44,1.48
2024/03/26,11.55,2.03
2024/03/27,10.09,1.77
2024/03/28,3.16,0.55
2024/03/29,1.79,0.31
2024/03/30,2,0.35
2024/03/31,7.06,1.24
total,311.7,54.67
2024/04/01,5.17,0.91
total,5.17,0.91

when I downloaded the second device the data was corrupted. Here is the March part of that file. Seems to be mixing the csv’s together, repeating part of the first file in to the second file. See the tail end where March 30, 31 and April 1 repeat in second file. This is likely what caused the issue that prompted me to start this thread.
History_2023.09.29-2024.04.01_UTC -4.csv (3.7 KB)
History_2023.09.29-2024.04.01_UTC -4 (1).csv (3.7 KB)

2024/03/01,6.2,1.09
2024/03/02,4.5,0.79
2024/03/03,2.8,0.49
2024/03/04,0.82,0.14
2024/03/05,1.02,0.18
2024/03/06,0.39,0.07
2024/03/07,0.36,0.06
2024/03/08,0.77,0.14
2024/03/09,1.55,0.27
2024/03/10,0.37,0.06
2024/03/11,0.52,0.09
2024/03/12,0.03,0.01
2024/03/13,0,0
2024/03/14,0,0
2024/03/15,1.12,0.2
2024/03/16,1.51,0.26
2024/03/17,6.26,1.1
2024/03/18,0.03,0.01
2024/03/19,1.78,0.31
2024/03/20,1.81,0.32
2024/03/21,1.44,0.25
2024/03/22,4.58,0.8
2024/03/23,3.3,0.58
2024/03/24,1.37,0.24
2024/03/25,0.89,0.16
2024/03/26,1.16,0.2
2024/03/27,0.61,0.11
2024/03/28,0.79,0.14
2024/03/29,0,0
2024/03/30,0.66,0.12
2024/03/31,1.98,0.35
total,48.62,8.54
2024/04/01,0.93,0.16
total,0.93,0.169,0.31
2024/03/30,2,0.35
2024/03/31,7.06,1.24
total,311.7,54.67
2024/04/01,5.17,0.91
total,5.17,0.91
I don’t know how this happens, can someone fix it so it doesn’t happen again?
I see the filename has been changed since the last time I needed to download them. I wonder if the filename needs to be unique for each device?

11

Compare the end of the 2 csv files. This data from the end of the first csv, somehow got added to the end of second downloaded file from a different device …why. You should be able to go to each device and download its csv and get only it’s data but you can’t. Please get someone on the tech team to fix the issue.
2024/03/30,2,0.35
2024/03/31,7.06,1.24
total,311.7,54.67
2024/04/01,5.17,0.91
total,5.17,0.91