OK, I suspect the problem is when you added field lakeSurfaceLevel to WeeWX you didn't tell WeeWX what unit group the field belongs to. Consequently, when you attempt to import data into lakeSurfaceLevel weectl import conducts some checks to see if any source field unit conversion is required. That is what is causing the KeyError error.
The simple fix is to tell WeeWX what unit group is used by the WeeWX field lakeSurfaceLevel. There are a number of ways to do this, the most common is to add a few lines to ~/weewx-data/bin/user/extensions.py. You could try adding the following to ~/weewx-data/bin/user/extensions.py: import weewx.units weewx.units.obs_group_dict['lakeSurfacelevel'] = 'group_altitude' save extensions.py and try the import agin. Gary On Wednesday 24 July 2024 at 06:50:28 UTC+10 Zach wrote: > Sorry, I should have clicked reply all. ;) > > Here is the output > > Using configuration file */Users/zach/weewx-data/weewx.conf* > > This is a dry run. Nothing will actually be done. > > Starting weectl import... > > A CSV import from source file '/Users/zach/Downloads/Untitled.csv' has > been requested. > > The following options will be used: > > config=/Users/zach/weewx-data/weewx.conf, > import-config=/Users/zach/weewx-data/csv.conf > > source=/Users/zach/Downloads/Untitled.csv, from=None, to=None > > dry-run=True, calc_missing=False, ignore_invalid_data=True > > tranche=250, interval=derive, date/time_string_format=%Y-%m-%d > %H:%M:%S > > delimiter=',', wind_direction=[-360.0, 360.0] > > UV=False, radiation=False > > Using database binding 'wx_binding', which is bound to database 'weewx.sdb' > > Destination table 'archive' unit system is '0x01' (US). > > The following imported field-to-WeeWX field map will be used: > > source field 'datetime' in units 'unix_epoch' --> WeeWX field > 'dateTime' > > source field 'lakeSurfaceLevel' in units 'foot' --> WeeWX field > 'lakeSurfaceLevel' > > Imported records will not overwrite existing database records. > > 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 ... > > Obtaining raw import data for period 1 ... > > Raw import data read successfully for period 1. > > Mapping raw import data for period 1 ... > > Traceback (most recent call last): > > File "/Users/zach/weewx-venv/bin/weectl", line 8, in <module> > > sys.exit(main()) > > File "/Users/zach/weewx-venv/lib/python3.9/site-packages/weectl.py", > line 67, in main > > namespace.func(namespace) > > File > "/Users/zach/weewx-venv/lib/python3.9/site-packages/weectllib/__init__.py", > line 90, in dispatch > > namespace.action_func(config_dict, namespace) > > File > "/Users/zach/weewx-venv/lib/python3.9/site-packages/weectllib/import_cmd.py", > line 85, in import_func > > weectllib.import_actions.obs_import(config_dict, > > File > "/Users/zach/weewx-venv/lib/python3.9/site-packages/weectllib/import_actions.py", > > line 58, in obs_import > > source_obj.run() > > File > "/Users/zach/weewx-venv/lib/python3.9/site-packages/weeimport/weeimport.py", > line 406, in run > > _mapped_data = self.map_raw_data(_raw_data, self.archive_unit_sys) > > File > "/Users/zach/weewx-venv/lib/python3.9/site-packages/weeimport/weeimport.py", > line 976, in map_raw_data > > weewx.units.obs_group_dict[_field]) > > File > "/Applications/Xcode.app/Contents/Developer/Library/Frameworks/Python3.framework/Versions/3.9/lib/python3.9/collections/__init__.py", > > line 941, in __getitem__ > > return self.__missing__(key) # support subclasses that > define __missing__ > > File > "/Applications/Xcode.app/Contents/Developer/Library/Frameworks/Python3.framework/Versions/3.9/lib/python3.9/collections/__init__.py", > > line 933, in __missing__ > > raise KeyError(key) > > KeyError: 'lakeSurfaceLevel' > > > On Tuesday, July 23, 2024 at 3:45:46 PM UTC-5 gjr80 wrote: > >> Thanks, can you post the complete and exact output to the console when >> weectl >> import is run. Also, what does the weectl log show? >> >> Gary >> On Wednesday 24 July 2024 at 06:40:53 UTC+10 Zach wrote: >> >>> I'm trying to track the water level of a lake so I added a new column to >>> the database (lakeSurfaceLevel), created a service to populate the data, >>> and modified my skin to display it. All of that works great, however when I >>> try to import data for that new observation using weectl, I get a error >>> "KeyError: 'lakeSurfaceLevel' >>> >>> Any help would be greatly appreciated! >>> >>> Attached are the csv.conf and a data file >>> >> -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/9f2742d6-7569-42f1-a13e-fd8c0cad8114n%40googlegroups.com.
