Data Error with ecowit gw1103 ( 3.17.0 b3184 )

[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

[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!

[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

[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

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