Well you already have the data in a file - weewx.sdb - the database file!!!
You can convert the archive table inside the database to a .csv file just by using the SQLite commands http://www.sqlitetutorial.net/sqlite-tutorial/sqlite-export-csv/ should tell you how to do this. Your best starting point is to just start querying the database, extract the data columns you are interested in, and convert the result of the query to a .csv file by exporting the query results...... There are many sites on the web that can help you with sql queries. On Monday, 25 February 2019 11:44:28 UTC+2, Mohamed Al-Sabri wrote: > > Thanks for the replay, what I'm trying to do is basically collecting > accumulated data from the weather station and storing it into an excel file > (or text file), it doesn't matter the way of creating the data file as long > as the results contain the basic weather variables (OutTemp, InTemp, OutRH, > InRH, Wind speed and direction, etc....). I hope I could express what I'm > trying to do. > > > > Regards, > > > > On Monday, February 25, 2019 at 1:13:03 PM UTC+4, Andrew Milner wrote: >> >> It would help if you were much more specific!! >> >> Yes, a csv file can be created instead of a .html file by adding a new >> 'report' using a template for example called newreport.csv.tmpl and have >> cheetah create the file every archive interval. Note - every archive >> interval will keep overwriting the previous .csv however!! >> >> The database can be queried whenever you wish to create whatever file you >> want by using any programming language or exprting the results of a query >> issued using sqlite3. >> >> It really depends on exactly what you are trying to achive, and you are >> being extremely vague. There is more that one way to create files - using >> weewx is one way, writing additional programs and scripts provide more >> methods. Which is more appropriate depends on the real requirement end >> expectations. >> >> >> >> >> On Monday, 25 February 2019 10:51:49 UTC+2, Mohamed Al-Sabri wrote: >>> >>> Guys you are awesome!! I was able to generate the reports (see >>> attachments). It was the time interval and the double instances issues! Yes >>> I have lost data, but it worked eventually! >>> >>> However, is there anyway to store the data into a text file or excel >>> sheet for analysis directly without going to the website step? >>> >>> >>> Thank you so much all!!! >>> >>> On Saturday, February 23, 2019 at 12:22:46 PM UTC+4, gjr80 wrote: >>>> >>>> Ok, let's see if we can get that 1st para to make a bit of sense: >>>> >>>> This part of your log extract shows two different processes (1393 and >>>> 1338) trying to communicate with your station, it happens if you start >>>> WeeWX again without stopping it first or doing a restart: >>>> >>>> Gary >>>> >>>> 2.6.0.0 >>> >> 2.6.0.0 > -- 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.
