It will need a bit of fiddling to get a timestamp out of the individual date-time fields so will not work directly with any of the existing wee_import sources without further massaging. But otherwise will be OK. That looks very much like the mYYYYlg.txt files I am working with, I have wee_import extracting the data from the mYYYYlg.txt log files, just need to pickup a few of the other log files and sort out some units and we should be ready for a trial. I'll drop you a line when I have something ready.
Gary On Tuesday, 8 January 2019 09:52:26 UTC+10, monmul wrote: > > I can get the data into this CSV format.....how would that work? > > On Mon, Jan 7, 2019 at 12:22 PM gjr80 <[email protected] <javascript:>> > wrote: > >> WeeWX stores its data in the archive table in your weewx database, one >> archive record per row. A summary table is created for each observation >> field that records daily highs/lows/sums, counts and times etc. These >> summary tables are used as an optimization strategy when aggregates are >> sought from the historical data. There are a couple of ways to import data. >> the first is the use of the weeWX utility wee_import >> <http://weewx.com/docs/utilities.htm#wee_import_utility>, this is the >> preferred way to import data but it only supports importing data from a CSV >> format file, Cumulus monthly log files and Weatherunderground. The other >> approach is to manually add rows to the archive table and then rebuild the >> daily summaries. Rebuilding the daily summaries is easy using >> wee_database <http://weewx.com/docs/utilities.htm#wee_database_utility>, >> adding rows to the archive will be a slow manual process. You may think >> that adding highs/lows to the daily summaries is a solution, it is not. >> >> In terms of importing your WD data I guess the options are limited, I >> have little WD knowledge but if you can get the data into one of the >> formats supported by wee_import that would work (if you google the weewx >> forums this has come up once or twice before, not sure if there was a third >> party utility that converted WD data into a format that wee_import >> supports). Manually adding data is going to take a long time considering >> you have 5 years of data. I have had a task to add WD support to wee_import >> for some time now, there has been little call for it so it has taken a back >> seat. I am happy to look into this again, it won't happen today or tomorrow >> but then again that is the beauty of importing historical data, the data is >> not going anywhere so the time imperative is not there. If I have some >> details about the data structure and format I can look at what be done with >> wee_import. >> >> A word of warning, manipulating the weeWX database manually can be >> hazardous to the continued good and proper operation of weeWX, do so at >> your own risk and always make sure you have a backup of your database. >> >> Gary >> >> On Monday, 7 January 2019 06:40:23 UTC+10, monmul wrote: >>> >>> Next issue for me is to import historic information (about 5 years >>> worth...or just the highs and lows during that period of each measured >>> item) into weewx? Where is the historic information stored and is there an >>> easy way of importing the data from WeatherDisplay? >>> >> -- 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.
