Hallo Günther, On Sunday, April 12, 2020 at 10:35:24 AM UTC-4, Meteo Oberwallis wrote: > > Hello Gary. > > First of all, thank you for exploring the cvs file. Sounds good that you > can import and save them. Now I have to know something else. you talk about > adapting the wee_import? How does that work? I also wanted to ask because I > didn't quite understand it with rain. Weewx needs the cumulative amount of > rain. Wouldn't it be easier if I simply deleted all other rain data from > the table? And the last question. You wrote that (--dry-run) can be used to > test whether everything is ok. How should I do that? Sorry for the many > questions. But is not quite clear ;-) >
See the instructions at http://www.weewx.com/docs/utilities.htm#wee_import_utility for the wee_import utility. >From your WeeWX install location such as /home/weewx, copy the file utils/import/csv-example.conf and use as a template to make the changes. Hope this helps, -Bill > > Many thanks and best regards > > Am Sonntag, 12. April 2020 01:12:08 UTC+2 schrieb gjr80: >> >> Hallo Günther, >> >> A few observations on your data: >> >> 1. The column names can be whatever you want, the only requirements are >> they are unique and you can enter them in the [[FieldMap]] >> <http://weewx.com/docs/utilities.htm#csv_fieldmap> portion of the import >> config file. In theory, your German field names should work but all we need >> is some sort of unicode failure somewhere in the processing chain and the >> import will fail. If it were me I would remove the units in brackets and >> try the import with your fields names via a dry run (using --dry-run). >> That will show you if it will fail without affecting your WeeWX data. >> >> 2. You will need to remove the 'M' from the Intervall field. >> >> 3. WeeWX records rain on a per-interval basis whereas your rain data is >> cumulative. That is fine, wee_import can do the calculations but you >> need to tell wee_import your rain data is cumulative and you need to >> select one of the rain fields to use (you have five). I would use the >> longest period rain field, in your case Gesamter Niederschlag. So in your >> import config file you will need (untested): >> >> rain = cumulative >> >> and in your field map: >> >> rain = 'Gesamter Niederschlag', mm >> >> 4. Your Zeit (date-time) field format is fine, no need for a unix epoch >> timestamp, wee_import will do that provided you come up with a suitable >> date-time format string that wee_import can use to recognise the >> different portions of the date-time. This is covered by the >> raw_datetime_format setting in the import config file, the wee_import >> section <http://weewx.com/docs/utilities.htm#csv_raw_datetime_format> of >> the Utilities Guide explains it's use. in your case I suspect that >> '%d.%m.%Y %H:%M:%S' will do the job (untested). Again the dry run should >> be used to check. >> >> Gary >> >> On Saturday, 11 April 2020 16:57:00 UTC+10, Günther Wrana wrote: >>> >>> Hello, >>> >>> I would have my .csv file here that I would like to import. How should >>> it look like? Do I have to insert the column names listed in the >>> documentation in the header? >>> >>> >>> Time,Temp,Dewpoint,Press,WindDir,WindSpeed,WindGust,Hum,dailyrain,SolarRad >>> >>> Date and time are in one column, do they also have to have this UNIX >>> date format? >>> >>> Thank you Günther >>> >> -- 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/dced6a05-bff3-4bbf-b4bf-f9b5532c4545%40googlegroups.com.
