Problems importing wview.sdb

[Karl Napp]

I plan to change from wview to weewx. First I started weewx in simulator mode. I copied the database from wview and transferred it to a dump file using sqlitre3 commands. After that I merged the databases of weewx in simulator mode and wview with the .read command. This worked without errors.  And weewx started with the additional data.

After that I changed the driver from weewx to Vantage, connected the Vantage Pro and restarted weewx. After reading all data from the Vantage I closed weewx and tried to merge the data from wview with the database weex.sdb also with read. Unfortunately this did not work I get the error message with the .read command with each line:

Error: near line xxxxx: table archive has 114 columns but 52 values were supplied

No data was added to weewx - does anyone know the cause ?

[Tom Keffer]

Yes. The classic wview database has 52 columns. The "wview-extended" database has 114. You're mixing the two. You're also making this harder than it needs to be. 

1, Stop weewxd.

2. Then simply copy your wview database into place. Don't dump anything, nor read anything. Just copy it.

3. Then, in weewx.conf specify a  classic database. 

[DataBindings]

  [[wx_binding]]

    ...

    schema = schemas.wview.schema

4. Then start weewxd. Because your old wview database will not have a daily summary in it, one will be built automatically. Should take a couple minutes

-tk

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/6495e247-a027-48d2-91da-544affbaaf15n%40googlegroups.com.

[Karl Napp]

Thank you for the help. I have not thought that it is so simple