You are doing too many things with too many changes and I cannot keep up with what your data is, what your import config file contains and what console output you provide.
Your last post includes double quote marks at the start and end of each line so the date-time field name is not Date & Time but rather "Date & Time (yes it includes the double quotation mark). Similarly you have a double quotation mark at the start and end of each data line, that will cause problems as well. You also have a comma as the decimal separator; as I said earlier that simply will not work. If you are having problems fixing the formatting of your original source data file I am more than happy for you to email me the original source data file from weatherlink and I will format it for you. My email is gjroderick at gmail dot com. Alternatively I suggest you go back to my earlier post where I gave you the steps you need to take to import your data and carefully work through the steps one at a time. Gary On Friday, 4 March 2022 at 18:21:53 UTC+10 Artvd wrote: > "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/54835b23-4aac-4772-83c1-973e5511e7d8n%40googlegroups.com.
