Thank you Andrew - my bad for not searching for sqlite3 inline commands. I found what the issue was; I did not have a root privilege when running the import script. There was no any indication that data was not written into database. Script completed and final message was that everything was successful. However, after inspection of the database, number of entries was only few hundred rather than tens of thousands entries (record every 5 minutes for the past few months). Running "sudo wee_import ..." solve the problem.
Thanks again. On Monday, July 10, 2017 at 10:46:14 AM UTC-4, Andrew Milner wrote: > > the 'easiest' way is to use something like phpliteadmin or the other way > is to execute sql statements directly using SQLite. > > More info about both can readily be found on the web. > > You can check for more than one database with > sudo find / -name weewx.sdb -print > > > > On Monday, 10 July 2017 17:23:47 UTC+3, Alex Miler wrote: > >> No, I have not looked at the database. What is the easiest way to display >> the SQL database and poke around? By the way, I can see that database is >> around 180kb big and with time stamp that is advancing every few minutes. >> To me, it seems reasonable to have 180kb big file with around 6 months >> worth of weather data. I have not checked the size before the import >> command so I cannot comment the difference before.after the import. >> >> On Monday, July 10, 2017 at 9:39:12 AM UTC-4, Andrew Milner wrote: >>> >>> Have you tried just looking at the database, or querying the database to >>> see what data is actually in it?? It sounds as though you may possibly >>> have got two different .sdb files being used - one which was used for the >>> import, and weewx has created it's own because it could not find the >>> database specified in weewx.conf for some reason or another. >>> >>> >>> >>> >>> >>> On Monday, 10 July 2017 15:59:22 UTC+3, Alex Miler wrote: >>> >>>> Hello, >>>> >>>> I am planning on moving my Davis Vue station of the PC (running >>>> uploader to WU and other weather databases) to a Rasberry Pi. I was >>>> playing >>>> around with Weewx offline (setup as simulator) and with various skins >>>> available. I have successfully imported data from the past 6 months (just >>>> for testing) from the WU database. Everything seems to work (from import >>>> side, no errors) but no historical data page or any other page is showing >>>> the data that was imported. The only stuff that is been shown is the >>>> semi-random data generated by the simulator. >>>> >>>> Any suggestion on how to debug the issue? Is it possible to see >>>> historical data even if you setup weewx in "simulator mode"? If yes, what >>>> would the reason why data is not shown? Pages are been generated on a >>>> regular basis and with updated data from the simulator but no data that >>>> was >>>> imported. >>>> >>>> Alex >>>> >>> -- 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.
