hello sorry, I add more info. I have sqlite. In User's Guide it says:
"Because of this, unless you have a special purpose application, there is really no good reason to change from the default, which is US" I want to keep the installation as default as possible. But on the other hand if I want to export sqlite as metrics, should we think this is a special purpose enough to start with (or convert to) metrics? And, if I choose to use metrics in database, will there be any problems in future upgrades like should I always make changes in conf-files after upgrade? Janne tiistai 21. huhtikuuta 2020 23.53.12 UTC+3 Tom Keffer kirjoitti: > > If you want the results in metric, it would be best to convert the > database first, then dump it to CSV. For how to convert the database, see > the section *Changing the database unit system > <http://www.weewx.com/docs/customizing.htm#Changing_the_unit_system>* in > the Customizing Guide. > > You didn't say what kind of database, but if you use sqlite, the utility > sqlite3 can export to CSV. You may need to download it first > > *sudo apt install sqlite3* > > Then > > *sqlite3 weewx.sdb* > sqlite> *.headers on* > sqlite> *.mode csv* > sqlite> *.output weewx.csv* > sqlite> *select * from archive;* > > This will create a file weewx.csv with the data. It will be in whatever > unit system your database is in. Hence, the need to convert first. > > Documentation for sqlite3 <https://sqlite.org/cli.html>. > > > > On Tue, Apr 21, 2020 at 12:24 PM Janne Prokkola <[email protected] > <javascript:>> wrote: > >> hello >> >> I'd like to export my database to csv. Is there any easy way to export US >> format database to metrics units? >> >> I'm building my weather station set up. I'm thinking should I have the >> database in metrics format or should I stay in US. In Finland I have no use >> for imperial/US units. >> >> best regards >> Janne Prokkola >> >> -- >> 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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/ba6c819d-a9c5-406e-9854-60af09e81b9b%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/ba6c819d-a9c5-406e-9854-60af09e81b9b%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/79f911de-a153-4968-9dd7-0e35b4c19ba6%40googlegroups.com.
