Rain data YTD showing wrong

[mchd17]

My rain data block YTD is showing wrong amount. Yesterday it was showing right at 18.78 inches, now today is showing 4.94, And i dont think this month is acurite either. I checked inside the Station Data block, and it's showing the wrong value as well. YTD rainfall should be close to 19 inches. I have checked my database and all seems good there. Any thoughts?

[mchd17]

Well this sucks. It was showing correctly on wed or Thursday this week. Noticed different values yesterday. Upon further investigation, my database allData is missing 4 months. From 5-23-18 to 9-7-18. The allDataExtra is all there and the indoor is all there. That sucks. Any ideas what happened? I contacted my host to see if they have backups, no response yet.

[tjh]

I experienced the same problem yesterday. The rain block indicated we had no rain for the last several months. I ended up repopulating the table with weather data I collect from the same station but in a different dB table. Everything is working again. I thought the table was corrupted when my server burped so I accepted the problem as my doing. Perhaps it is something else. If you push data to WU, perhaps you can use that to repopulate the database. Then make sure you copy (export)it regularly.

[mchd17]

I do push data to WU. Any suggestions on how I can repopulate the data? Doesn't sound fun to me lol.

[mchd17]

ok, using the Data Import template function. I have everything correct, but it fails on date/time format. Tried importing for one day, May 13 to May 13 both 2018. I get the following error

Record number 1 has incorrect date/time format, this data row is completely ignored...
Date parsed as: 1969-12-31 18:00
Skipping...

Record number 1 has incorrect date/time format, this data row is completely ignored...
Date parsed as: 1969-12-31 18:00
Skipping...

[mchd17]

Think I fixed my datebase. After trying and trying to get the import from WU to work, I ended up using csv from ambient weather Network. It worked good once I learned the fields.