Nothing wrong with this approach, although it involves a lot of shuffling the database around. Why not use DB Browser directly on Linux? It will run there.
Either way, as you say, blanks are a problem. The reason is that DB Browser interprets blanks as null strings, rather than the value NONE, which violates the type system in the schema (which expects a number, not a string). -tk On Wed, Oct 31, 2018 at 7:13 AM Phil Owers <[email protected]> wrote: > I downloaded DB Browser for SQLITE windows edition on to my laptop. > Stopped weeewx throughout the process. Took a copy weewx file.sdb ,opened > it up in the above software and made the changes and then WRITE then to the > database. Took the new copy back to weeewx ,start weeewx and wait till it > adds all the new records. Once that's done I used wee_database --drop-daily > and rebuild-daily so the new data is seen, then delete the NOAA reports > that were affected so weeewx can create the new NOAA reports. Also take a > copy of the original weewx.sdb just in case. Have used this method several > times but be carefully with adding new data and don't leave blanks as weewx > didn't like it. > Phil > > On 31 Oct 2018 13:00, "Thomas Keffer" <[email protected]> wrote: > > Not all versions of Linux include the utility sqlite3. You may have to > install it. How to do so depends on your operating system. If you use > Debian, > > sudo apt-get install sqlite3 > > will generally do it. > > -tk > > On Wed, Oct 31, 2018 at 5:41 AM Jules <[email protected]> wrote: > >> Hi, >> >> I'm seeing database is malformed errors. I've searched and found post on >> how to fix this by running sqlite3 and dumping to ascii and re-importing. >> >> My problem is running sqlite3 ! My weewx Pi doesn't respond to sqlite3 >> as a command (I thought weewx used sqlite3?). Do I install sqlite3 on my >> weewx Pi or will that cause problems? >> >> I've tried installing the sqlite3 utilites on my windows machine. I can >> make it dump my weewx.sdb to my screen but can't work out how to make it >> send it back to a new file - it doesn't chcuk an error but also doesn't >> create the file. >> >> Can anyone point me in the right direction? >> >> Thanks, >> >> >> Jules >> >> -- >> 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]. >> For more options, visit https://groups.google.com/d/optout. >> > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
