On Wednesday, July 31, 2019 at 2:29:49 AM UTC-7, Richard Rosa wrote: > > > > > *sqlite3 wview-history.sdb SQLite version 3.28.0 2019-04-16 19:49:53Enter > ".help" for usage hints.sqlite> .schemaCREATE TABLE **dayHistory** ( date > INTEGER ,barometer REAL ,pressure REAL ,altimeter REAL ,inTemp REAL > ,outTemp REAL ,inHumidity REAL ,outHumidity REAL ,windSpeed REAL ,windDir > REAL ,windGust REAL ,windGustDir REAL ,rainRate REAL ,rain REAL ,dewpoint > REAL ,windchill REAL ,heatindex REAL ,rxCheckPercent REAL ,ET REAL > ,radiation REAL ,UV REAL ,extraTemp1 REAL ,extraTemp2 REAL ,extraTemp3 REAL > ,soilTemp1 REAL ,soilTemp2 REAL ,soilTemp3 REAL ,soilTemp4 REAL ,leafTemp1 > REAL ,leafTemp2 REAL ,extraHumid1 REAL ,extraHumid2 REAL ,soilMoist1 REAL > ,soilMoist2 REAL ,soilMoist3 REAL ,soilMoist4 REAL ,leafWet1 REAL ,leafWet2 > REAL ,txBatteryStatus REAL ,consBatteryVoltage REAL ,hail REAL ,hailRate > REAL ,heatingTemp REAL ,heatingVoltage REAL ,supplyVoltage REAL > ,referenceVoltage REAL ,windBatteryStatus REAL ,rainBatteryStatus REAL > ,outTempBatteryStatus REAL ,inTempBatteryStatus REAL ,PRIMARY KEY (date) );* > > > The weewx schema is at https://github.com/weewx/weewx/blob/master/bin/schemas/wview.py if you want to do a visual comparison.
You'd have to check the schema for both your wview databases I think. It's been so many years I don't remember any more what Mark's software evolved to. My thought is you could get there with a dump/hand-edit/restore of your old data as the worst case, but I'd have to defer to somebody who has run wview in the last few years who has done the process you're trying to accomplish. I just can't remember any more whether I had any touch labor when I switched to weewx a long time ago. -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/41f84e8c-76e4-4e06-8668-ac03daf49226%40googlegroups.com.
