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
On Wed, Sep 13, 2023 at 9:13 AM Karl Napp <nurfuersoftw...@gmail.com> wrote:
> 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 ?
>
> --
> 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+unsubscr...@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
> <https://groups.google.com/d/msgid/weewx-user/6495e247-a027-48d2-91da-544affbaaf15n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/CAPq0zEBxJf4icL5dMfYCF65Pz4nt4UUrWXc2YcotPUD1TRf7CA%40mail.gmail.com.
