Here's the context. My weakness is understanding databases in general. For almost 4 years, I have been weewx on a CentOS system capturing data from a Vantage Vue Console. My weewx.sdb file has nearly 4 years of historical data. That's the workhorse and is chugging along nicely.
A week ago, I set up a parallel system on a Raspberry Pi 4 with a second Vantage Vue Console. That works well. The goal is to replace the CentOS system with the Pi. Two days ago, I renamed the weewx.sdb file on the new system, and replaced it with a copy of the one from the CentOS setup. The idea was to start adding data from the logger to the original database. I am getting the following error: "**** Unit system of incoming record (0x01) differs from 'archive' table in 'weewx.sdb' database (0x10)" I note that in 2018 someone else had the same error and asked the group for help. Tom's response was,* "Here's the most likely explanation: When you first started weeWX, you used a database in US units. Then you tried to change it to Metric. As explained in the **User's Guide <http://weewx.com/docs/usersguide.htm#StdConvert>, 'Once chosen, [the unit system] cannot be changed! WeeWX does not allow you to mix unit systems within the databases. You must choose a unit system and then stick with it.' If you did not try to change unit systems, then it must be something else."* I know I set up the Pi a week ago as metric. I don't remember how I set up the original CentOS instance. I may well have used US units because I was a weewx newbie at the time. I *think* one can do that and still display them as metric if you configure the skin.conf and/or weewx.conf file accordingly. All of my display data is metric. I have spent a couple of days reading the documentation. The database sections aren't clicking with me. If there's a way out of this, I can't see it (or understand it.) That's the situation. My questions are: (1) How can I find out which units the original weewx.sdb is using? (2) If they are US, is there a utility or way to export them and then import them into a metric system? (3) If there is no way, is the best way out of this to set up the Pi again using US units? I assume if the old system is US and working and displaying metric units, I can do the same on my new installation. While I'm hesitant to ask what may be a questions with obvious answers, for the life of me I can't find them in the documention or on the Internet. Paul VE1DX -- 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/58de53f1-f8a4-4bbb-97c2-a4dabc949f46%40googlegroups.com.
