Tricks with import of Weatherlink data via WVIEW

[Philippe Amram]

Hi Tom,

I have imported data from my Weatherlink station.
I have used the wlk2sqlite utility (supplied with WVIEW).
The weatherlink database has been imùported in wview-archive.sdb, then copied to weewx.sdb.

Two things by now :
1 - the noa reports are note updated
2 - I know that my house is not very warm, but -3600°C, it's a cold...
How can we remove extraordinary data from the weewx database ?

Thanks a lot Tom.
Cheers
Philippe

[vds]

On Wednesday, March 28, 2012 10:27:02 PM UTC-7, Philippe Amram wrote:

How can we remove extraordinary data from the weewx database ?

This has been discussed 'many' times in the google group.
I'd suggest doing a little research.

Try a google search for "delete bad data from weewx database" then read the thread that comes up for me as the second link. It's a discussion I started two years ago entitled "really hot in hood river".  One of Tom's answers points to the sqlite syntax to use.  I posted a pointer to a doc I have on the web.  Jason posted a note about working off a backup database.

If you're just getting started with weewx it might be worth an evening to read all the google group archives.  There's lots of good stuff in there.
 

[Philippe AMRAM]

Thanks Vince,

I'll do that !

Cheers
Philippe

--
You received this message because you are subscribed to the Google Groups "Weewx Weather Station Discussion" group.

To view this discussion on the web visit https://groups.google.com/d/msg/weewx-user/-/N5bD38QflDoJ.

To post to this group, send email to weewx...@googlegroups.com.
To unsubscribe from this group, send email to weewx-user+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/weewx-user?hl=en.

[Thomas Keffer]

The command line tool 'sqlite3' is your friend. It comes with sqlite.

#> sqlite3 /home/weewx/archive/weewx.sdb

sqlite> delete from archive where outTemp < -40.0;

will delete entirely all data records with an outside temperature of less than -40 degrees F.

If you wish to change only the temperature (and leave all other values unchanged), then use:

sqlite> update archive set outTemp=NULL where outTemp < -40.0;

Make a backup copy first!

-tk

Philippe

--

You received this message because you are subscribed to the Google Groups "Weewx Weather Station Discussion" group.

To view this discussion on the web visit https://groups.google.com/d/msg/weewx-user/-/-wCD13GLSb0J.

To post to this group, send email to weewx...@googlegroups.com.
To unsubscribe from this group, send email to weewx-user+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/weewx-user?hl=en.

--
Thomas Keffer

kef...@threefools.org
+1 541-386-8891 (h)
+1 541-490-9507 (c)

Skype: tkeffer