It would be useful to see what actually ended up in the database. Use the tool sqlite3 to do this (you may have to install).
*sqlite3 weewx.sdb* sqlite> *select dateTime, datetime(dateTime,'unixepoch','localtime'), windSpeed, windDir from archive limit 20;* -tk On Fri, Jul 5, 2019 at 12:21 PM shvman <[email protected]> wrote: > Hi, > > I'm importing about 11 years of data collected using a Vantage Pro2 > station and WeatherLink software. The WeatherLink files are on my > computer, so my data are exported from the software as text files. I bring > the data into LibreOffice Calc, make changes and save the data as a CSV > file. When making changes, I change all wind and gust directional data > from ordinal/cardinal directions to 'compass degree' numbers (moving around > the compass by 22.5 degrees). N is considered '0' degrees. One such > partial CSV file is attached. > > > When I do this, the export "appears" to go well. After a 'dry run' with > no obvious complaints, I import and data and 'generate' reports using the > wee_reports utility. When I look at the data in my browser, the monthly > climatological summary looks almost correct EXCEPT for the column named > "DOM DIR". The DOM DIR column is '90' for every day of the month. > > I feel like I'm close to getting this done, but I must have something set > wrong. I'm also attaching my import conf file. > > Any help would be greatly appreciated. > > Thanks, jjs > > -- > 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/aad806e1-acc2-47f8-a705-cdd52a29fd61%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/aad806e1-acc2-47f8-a705-cdd52a29fd61%40googlegroups.com?utm_medium=email&utm_source=footer> > . > 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEB-LCNsKK%2BbCqULQzU2LO0MSXcNgV914HU3BsMHsR4z_Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
