Hi Gary, Thank you. I have done as you suggested and now have the, "curiosity factor" data that I was looking for.
Now, I am eagerly awaiting Andrew's response as to how to query the database directly. On Tuesday, September 5, 2017 at 5:09:09 PM UTC-7, gjr80 wrote: > > Hi, > > That will certainly take care of WU from the date you implement these cron > entries onwards but by itself it won't fix anything historical. You will > need to do historical updates manually from the command line using the > --date option. Something like: > > $ /home/weewx/bin/wunderfixer --date=2017-08-21 > > should do the trick. Of course you can add the --test command line option > to make sure you have it right before you actually send data to WU. > Remember with WU once you upload data you cannot change it other than a one > time 'delete'. Wunderfixer details are in the Utilities Guide > <http://weewx.com/docs/utilities.htm#wunderfixer_utility>, but if you > have the cron entries set as you do I expect you have already found that. > > Gary > > On Wednesday, 6 September 2017 09:39:11 UTC+10, TheChoctlab wrote: >> >> As for a cron job, I think I have that figured out. >> >> I am doing it like this: >> >> # Run wunderfixer at 1258pm daily >> 58 12 * * * /home/weewx/bin/wunderfixer --log weewx > /dev/null 2>&1 >> # Run wunderfixer at 1158pm daily >> 58 23 * * * /home/weewx/bin/wunderfixer --log weewx > /dev/null 2>&1 >> >> >> >> On Monday, September 4, 2017 at 7:52:44 PM UTC-7, Andrew Milner wrote: >>> >>> alternatively have you tried running wunderfixer to add in the missing >>> values to WU?? I run wunderfixer twice a day using a cron task and now it >>> never misses any data!! >>> >>> >>> >>> On Tuesday, 5 September 2017 05:48:07 UTC+3, Andrew Milner wrote: >>> >>>> If you are just wanting to see the drop out of curiosity then why not >>>> just directly access the database using sqlite3 eg >>>> SELECT datetime, outTemp FROM archive WHERE datetime > xxxxxxxxxxxxx >>>> and datetime < yyyyyyyyyyyyyy; >>>> >>>> >>>> >>>> On 5 September 2017 at 05:41, TheChoctlab <[email protected]> wrote: >>>> >>>>> Nuts. >>>>> >>>>> What I was after was to see the temperature drop as the solar eclipse >>>>> took place. >>>>> >>>>> Looking at my WU data I know that it dropped at least six (6) degrees >>>>> Fahrenheit. However, WU is missing data for three ten minute records >>>>> right >>>>> at the maximum period of occlusion. >>>>> >>>>> I guess I should have thought about this prior t the eclipse. >>>>> >>>>> >>>>> >>>>> On Monday, September 4, 2017 at 7:31:27 PM UTC-7, Tom Keffer wrote: >>>>>> >>>>>> Querying for specific times is not available. Perhaps it should be. >>>>>> What is your application that you need to do this? >>>>>> >>>>>> -tk >>>>>> >>>>>> On Mon, Sep 4, 2017 at 6:53 PM, TheChoctlab <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Eureka! Thank you Tom. >>>>>>> >>>>>>> Now then, how would I query for a specific date? >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Monday, September 4, 2017 at 6:00:17 AM UTC-7, Tom Keffer wrote: >>>>>>>> >>>>>>>> Almost. You need to iterate over a time period. Also, because the >>>>>>>> results of the iteration will be individual records, there will not be >>>>>>>> a >>>>>>>> minimum and maximum temperature. Just temperature. Something like (NOT >>>>>>>> TESTED): >>>>>>>> >>>>>>>> #for $record in $day.records >>>>>>>> $record.dateTime.format("%B"): $record.outTemp >>>>>>>> #end for >>>>>>>> >>>>>>>> -tk >>>>>>>> >>>>>>>> On Sun, Sep 3, 2017 at 9:36 PM, TheChoctlab <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> On your suggestion, I reviewed the information regarding >>>>>>>>> Iteration. I think that will get me where I want to go. >>>>>>>>> >>>>>>>>> I am more of a hardware guy rather than a software guy. So, >>>>>>>>> please forgive my feeble attempt at the following: >>>>>>>>> >>>>>>>>> Min, max temperatures by record#for $record in $record.days >>>>>>>>> $record.dateTime.format("%B"): Min, max temperatures: >>>>>>>>> $record.outTemp.min $record.outTemp.max#end for >>>>>>>>> >>>>>>>>> Am I, sort of, on the right track? >>>>>>>>> >>>>>>>>> >>>>>>>>> On Sunday, September 3, 2017 at 8:44:30 PM UTC-7, Tom Keffer wrote: >>>>>>>>>> >>>>>>>>>> See the Customizing Guide, section Iteration >>>>>>>>>> <http://weewx.com/docs/customizing.htm#Iteration>. Specifically, >>>>>>>>>> you want suffix .records. >>>>>>>>>> >>>>>>>>>> -tk >>>>>>>>>> >>>>>>>>>> On Sun, Sep 3, 2017 at 4:53 PM, TheChoctlab <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> I have searched the Group but, must not have used the correct >>>>>>>>>>> search terms as I could not find what I am after. >>>>>>>>>>> >>>>>>>>>>> My interest is producing a report similar to the "Monthly >>>>>>>>>>> Summary" but, that displays daily data from each archive record >>>>>>>>>>> (every ten >>>>>>>>>>> minutes). Wview does this but, I much prefer weewx. >>>>>>>>>>> >>>>>>>>>>> Any guidance will be greatly appreciated. >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> 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. >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>> 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. >>>>>>> >>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "weewx-user" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/weewx-user/NcjHMUgGsYs/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> 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]. For more options, visit https://groups.google.com/d/optout.
