The error says it all. WeeWX field interval cannot be 0. What is in your source data and your import config file?
Gary On Tuesday, 18 July 2023 at 06:28:10 UTC+1 IceNov wrote: Thank you for the responses. I was able to get the MQTT data into the database by creating a new field in the database as advised. But still no success with importing the CSV. I suspect it is a datetime/interval issue as I noticed lots of these in the logs: Jul 18 13:51:00 newmqtt wee_import[17507] INFO weewx.manager: Non-positive value for record field 'interval': 0 Jul 18 13:51:00 newmqtt wee_import[17507] INFO weewx.manager: *** record ignored Jul 18 13:51:00 newmqtt wee_import[17507] INFO weewx.manager: Added record 2023-07-18 13:44:30 AEST (1689651870) to database 'weewx.sdb' I'll keep trying... Tony On Monday, July 17, 2023 at 3:24:23 AM UTC+10 vince wrote: On Sunday, July 16, 2023 at 12:17:47 AM UTC-7 IceNov wrote: I can see the mqtt data when running weewxd from the command line - it is one of the fields showing up in the terminal output - but it's not being added to the database. I've also tried importing a csv file with timestamp and value - which reported success - but still no new column in the db. How do I get a new measurement into the standard database? Fields don't magically appear in the database. You have to create them yourself somehow. Simplest way is to map the incoming MQTT topic to an existing field in the database. See the example at https://github.com/bellrichm/WeeWX-MQTTSubscribe/wiki/individual-example for help. Notice how topic/temp1 is mapped to extraTemp1 in the db ? -- 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/416dd0e1-dd44-4c94-a10f-a8ec97371795n%40googlegroups.com.
