Here this is: 1554008400|2019-03-31 00:00:00|0.0|0.0 1554094800|2019-04-01 00:00:00|-3339.28274090727|6261.74168169673 1554181200|2019-04-02 00:00:00|-527.207793864214|-1272.79220613579 1554267600|2019-04-03 00:00:00|99686.2672084393|-68132.4427018604 1554354000|2019-04-04 00:00:00|7128.37771018501|516.540171393921 1554440400|2019-04-05 00:00:00|46261.6189147235|-25126.8652699868 1554526800|2019-04-06 00:00:00|63230.7329108605|-51540.8971477026 1554613200|2019-04-07 00:00:00|35059.7143768767|8949.85877881586 1554699600|2019-04-08 00:00:00|-19556.6025679435|41813.8151534698 1554786000|2019-04-09 00:00:00|0.0|0.0 1554872400|2019-04-10 00:00:00|85470.8488865917|-88796.8152036324 1554958800|2019-04-11 00:00:00|7118.40400117596|-58941.4270597173 1555045200|2019-04-12 00:00:00|63155.7979022438|6392.98524749766 1555131600|2019-04-13 00:00:00|-8468.37353223031|17004.9874476823 1555218000|2019-04-14 00:00:00|-52810.2350303602|18778.8694645708 1555304400|2019-04-15 00:00:00|20036.7544231703|-58780.734810682 1555390800|2019-04-16 00:00:00|86931.5664756579|-69271.0851084881 1555477200|2019-04-17 00:00:00|152576.786056679|-111662.360885627 1555563600|2019-04-18 00:00:00|926.66056047536|7459.78712373512 1555650000|2019-04-19 00:00:00|-44647.2253454534|38802.3074638745 1555736400|2019-04-20 00:00:00|-4703.62667355496|4703.62667355496 1555822800|2019-04-21 00:00:00|61680.6367237927|-63058.297080307 1555909200|2019-04-22 00:00:00|55385.7950052227|-37873.6195985791 1555995600|2019-04-23 00:00:00|55410.876221022|-51365.9583394431 1556082000|2019-04-24 00:00:00|16478.8768232805|-22134.0782390054 1556168400|2019-04-25 00:00:00|-17156.417882491|12730.5708627542 1556254800|2019-04-26 00:00:00|-10227.5845234789|34943.5059009812 1556341200|2019-04-27 00:00:00|40220.9750697154|-75931.8550903803 1556427600|2019-04-28 00:00:00|84733.3567021994|-65101.99113641 1556514000|2019-04-29 00:00:00|123488.317569976|-79354.8215370818 1556600400|2019-04-30 00:00:00|151935.996387981|-141220.313605086 1556686800|2019-05-01 00:00:00|123544.376900609|-113802.847097978 1556773200|2019-05-02 00:00:00|42730.1379406706|-51696.5280158417 1556859600|2019-05-03 00:00:00|17316.012962064|-18522.7891199587 1556946000|2019-05-04 00:00:00|-1092.33755450833|5963.1024558241
jjs On Friday, July 5, 2019 at 5:03:35 PM UTC-5, Thomas Keffer wrote: > > 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] <javascript:>> > 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] <javascript:>. >> 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/7b9b398e-9712-47b1-bc86-1944e4f73892%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
