Page 1 of 1
Data Error with ecowit gw1103 ( 3.17.0 b3184 )
Posted: Sat 27 Aug 2022 11:11 am
by Carbonara
good morning, suddenly i found a lot of wrong datas in my noaa archive, in mx diag i've read there is an error in dayfile , how can i fix the data ?
Thanks in advance for the support.!
data error.png
MXdiags.zip
Re: Data Error with ecowit gw1103 ( 3.17.0 b3184 )
Posted: Sat 27 Aug 2022 12:24 pm
by mcrossley
It looks like you changed the locale CMX was running under from one that uses a dot decimal to a comma decimal at some point.
You will have to edit all the lines in the dayfile that use a dot decimal, and change the separator from a "," to ";", then change all the decimal "." to ",".
Do that with CMX stopped, and restart it after the edit and you should be OK.
Take a copy of the dayfile first!

Re: Data Error with ecowit gw1103 ( 3.17.0 b3184 )
Posted: Tue 30 Aug 2022 11:13 am
by Carbonara
dayfile.txt
ok, i've done it via excel but it add a " at start and to end of string. What i'm wrong?
screen.png
Re: Data Error with ecowit gw1103 ( 3.17.0 b3184 )
Posted: Tue 30 Aug 2022 1:44 pm
by philpugh
Excel thinks that some of the data is text. Is there a " at the end of each line? Not a real problem eitherway - with a text editor you should be able to replace all " with nothing.
Take care with which editor you use - Notepad is very good at messing up 'simple' text files.
I use ATOM under Windows
https://atom.io which is overkill for what you want to do - but is very useful for lots of other jobs!
If using UN*X like OS then the normal editors (e.g. nano) will do the job.
Cheers
Re: Data Error with ecowit gw1103 ( 3.17.0 b3184 )
Posted: Tue 30 Aug 2022 2:11 pm
by mcrossley
I would not use Excel to edit the file, as Phil says a good text editor is the way to go. With Excel (or any spreadsheet) there are too many ways for you to get it wrong.