"Date & Time;Inside Temp - C;High Inside Temp - C;Low Inside Temp - C;Inside Hum - %;High Inside Hum - %;Low Inside Hum - %;Inside Dew Point - C;Inside Heat Index - C;Barometer - hPa;High Bar - hPa;Low Bar - hPa;Absolute Pressure - hPa;Temp - C;High Temp - C;Low Temp - C;Hum - %;High Hum - %;Low Hum - %;Dew Point - C;High Dew Point - C;Low Dew Point - C;Wet Bulb - C;High Wet Bulb - C;Low Wet Bulb - C;Avg Wind Speed - m/s;Prevailing Wind Direction;High Wind Speed - m/s;High Wind Direction;Wind Chill - C;Low Wind Chill - C;Heat Index - C;High Heat Index - C;THW Index - C;High THW Index - C;Low THW Index - C;Rain - mm;High Rain Rate - mm/h;Heating Degree Days;Cooling Degree Days" "1/12/21 00:00;22,6;22,7;22,4;39,5;40,2;39,0;8,2;21,7;1009,6;1009,6;1009,6;955,5;4,8;4,8;4,7;95,8;95,9;95,8;4,2;4,2;4,1;4,4;4,4;4,4;0,5;W;2,2;W;4,8;4,7;4,8;4,8;4,8;4,8;4,7;0,0;0,0;0,141;0,000"
Op vrijdag 4 maart 2022 om 09:13:48 UTC+1 schreef Artvd: > Tried with delimiter ; and with period and with comma > > sudo wee_import --import-config=/var/tmp/csv.conf --dry-run > Using WeeWX configuration file /etc/weewx/weewx.conf > Starting wee_import... > A CSV import from source file '/var/tmp/data.csv' has been requested. > Using database binding 'wx_binding', which is bound to database 'weewx.sdb' > Destination table 'archive' unit system is '0x01' (US). > Missing derived observations will be calculated. > All WeeWX UV fields will be set to None. > All WeeWX radiation fields will be set to None. > This is a dry run, imported data will not be saved to archive. > Starting dry run import ... > > > ***** Unable to map source data.**** Field 'Date & Time' not found in > source data.**** Nothing done, exiting.* > Op vrijdag 4 maart 2022 om 09:06:57 UTC+1 schreef [email protected]: > >> >> >> On 4/03/22 20:57, gjr80 wrote: >> > You also have a problem in that the delimiter in your data has now >> > been changed to a period rather than a comma. You can try using a >> > period as the delimiter in your import config file, I do not know how >> > well that will work though. >> > >> > Gary >> > >> > On Friday, 4 March 2022 at 17:55:00 UTC+10 gjr80 wrote: >> > >> > The delimiter setting in in your import config file needs to be >> > enclosed in single or double quotes, eg: >> > >> > delimiter = "," >> > >> >> Gary, I've seen this delimiter 'comma' vs 'period' problem before. It >> was not related to Weewx but to >> a totally different DB. In our case the answer turned out to be the use >> of a totally different delimiter. >> >> Can't recall the DB involved but making the delimiter '|' (pipe) fixed >> it. >> >> \Worth a try? >> >> cheers >> john >> >> -- 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/75ca4634-2f6c-4459-b655-9d47116c937bn%40googlegroups.com.
