OK, the next step is to see if the daily summaries are OK. *select dateTime, datetime(dateTime,'unixepoch','localtime'), xsum, ysum from archive_day_wind limit 20;*
-tk On Fri, Jul 5, 2019 at 1:50 PM shvman <[email protected]> wrote: > > > > > > > > Thanks Tom. > > Yes, good point!! > > Yup, the data are there.... > > 1554078600|2019-03-31 19:30:00|0.0| > 1554080400|2019-03-31 20:00:00|0.0| > 1554082200|2019-03-31 20:30:00|0.0| > 1554084000|2019-03-31 21:00:00|0.0| > 1554085800|2019-03-31 21:30:00|0.0| > 1554087600|2019-03-31 22:00:00|0.0| > 1554089400|2019-03-31 22:30:00|0.0| > 1554091200|2019-03-31 23:00:00|0.0| > 1554093000|2019-03-31 23:30:00|0.0| > 1554094800|2019-04-01 00:00:00|0.0| > 1554096600|2019-04-01 00:30:00|0.0| > 1554098400|2019-04-01 01:00:00|0.0| > 1554100200|2019-04-01 01:30:00|0.0| > 1554102000|2019-04-01 02:00:00|0.0| > 1554103800|2019-04-01 02:30:00|0.0| > 1554105600|2019-04-01 03:00:00|0.0| > 1554107400|2019-04-01 03:30:00|0.0| > 1554109200|2019-04-01 04:00:00|0.0| > 1554111000|2019-04-01 04:30:00|0.0| > 1554112800|2019-04-01 05:00:00|0.0| > 1554114600|2019-04-01 05:30:00|0.0| > 1554116400|2019-04-01 06:00:00|0.0| > 1554118200|2019-04-01 06:30:00|0.0| > 1554120000|2019-04-01 07:00:00|0.0| > 1554121800|2019-04-01 07:30:00|0.0| > 1554123600|2019-04-01 08:00:00|0.0| > 1554125400|2019-04-01 08:30:00|0.0| > 1554127200|2019-04-01 09:00:00|0.0| > 1554129000|2019-04-01 09:30:00|0.0| > 1554130800|2019-04-01 10:00:00|1.0|315.0 > 1554132600|2019-04-01 10:30:00|1.0|337.5 > 1554134400|2019-04-01 11:00:00|1.0|337.5 > 1554136200|2019-04-01 11:30:00|1.0|337.5 > 1554138000|2019-04-01 12:00:00|0.0| > 1554139800|2019-04-01 12:30:00|0.0| > > I also see windGust and gustDir in the DB too! Everything looks like it's > there. > > jjs > > > On Friday, July 5, 2019 at 2:21:11 PM UTC-5, shvman 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/9ae1bc0d-6a3c-4352-a494-5e664a9efaaa%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/9ae1bc0d-6a3c-4352-a494-5e664a9efaaa%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/CAPq0zECtPvom0rtTHEbCbs81AJS6B%3DhvW_3Ux3fGjNSKP8gfYw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
