Merged datbase with old Vwiew backup

[Simone Urbani]

Hello,

i had an old database with view data until 2013.

From 2018 i started to use weewx without import old data.

Today i found an old backup and tried merge both db using this:

$ sqlite3 wview.sdb

sqlite> .output wview.dump

sqlite> .dump

sqlite> .quit

Then import the dumped data into the weewx database:

$sqlite3 weewx.sdb

sqlite> .read wview.dump

(this will emit an error "table archive already exists", but then should proceed to import the wview data)

sqlite> .quit

Starting weewx created al NOAA from 2013, but all data are empty until 2018.

There is a solution? is better restore a clean db from 2018 and forget old data?

Thanks in advance!

http://ssai.it/meteo/summary.html

[Thomas Keffer]

(Your link didn't work for me.)

1. Did you try deleting all the NOAA records? WeeWX will automatically regenerate them with what data it has.

2. If you already tried that, or it didn't work, then we will have to see the log. See the Wiki on how to generate a good log.

-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/29ffe4cc-9833-4e59-b257-697a93f0ee39%40googlegroups.com.

[Simone Urbani]

Yes, i try to delete NOAA Records.

Here u are my log!
Thanks in advance

https://pastebin.com/gXAiKyBC

[Thomas Keffer]

Here's your problem:

1. Oct 27 15:25:16 meteo weewx[24450]: cheetahgenerator: **** Reason: cannot find 'cwop' while searching for 'Extras.cwop'
2. Oct 27 15:25:16 meteo weewx[24450]: ****  Traceback (most recent call last):
3. Oct 27 15:25:16 meteo weewx[24450]: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate
4. Oct 27 15:25:16 meteo weewx[24450]: ****      fd.write(str(compiled_template))
5. Oct 27 15:25:16 meteo weewx[24450]: ****    File "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in __str__
6. Oct 27 15:25:16 meteo weewx[24450]: ****      rc = getattr(self, mainMethName)()
7. Oct 27 15:25:16 meteo weewx[24450]: ****    File "_etc_weewx_skins_sofaskin_text_php_tmpl.py", line 146, in respond
8. Oct 27 15:25:16 meteo weewx[24450]: ****  NotFound: cannot find 'cwop' while searching for 'Extras.cwop'

You have a reference to Extras.cwop, but there is no 'cwop' in the [Extras] section of skin.conf for sofaskin.

It always pays to look in the log!

-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/222178d6-d29b-40db-a8f6-06d250c3ad5a%40googlegroups.com.