Hi, I would save your data in csv format and import as a csv import via wee_import <http://weewx.com/docs/utilities.htm#Importing_from_CSV_files>. A few suggestions:
1. On first glance it appears there are no significant gaps in your data so I would let wee_import derive the WeeWX interval field from the data being imported. A few missed records won't make any great difference. 3. You have two distinct fields with date and time for each record, you will need to massage this into a single field (a simple search and replace post csv conversion should work) and then come up with an appropriate date-time format string that wee_import can use to decode this combined date-time. This is covered briefly in the Importing from CSV files <http://weewx.com/docs/utilities.htm#Importing_from_CSV_files> section in the Utilities Guide. 3. Work out what fields you wish to map to which WeeWX fields then use this info to produce your [[FieldMap]] stanza in your import config file. Remove the unused fields from the Excel/csv file. 4. Once you have your import config file setup up make sure you do a dry run import first. There is an issue with the wee_import calc-missing functionality included in WeeWX 3.x that means that some missing derived observations that rely on historical data are skipped (this largely only affects calculating WeeWX field pressure). This issue will be fixed in wee_import included with WeeWX v4.0 so if this issue affects you you might want to wait for the soon to be released WeeWX V4. Gary On Thursday, 12 December 2019 12:35:17 UTC+10, rich T wrote: > > What would the best way to import data into the weewx db from Mesowest. > > Thanks > Rich > -- 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/7e026526-93dc-473a-9676-408004aed1ec%40googlegroups.com.
