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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/6d9880ef-558a-4299-91a4-56b431e5a0acn%40googlegroups.com.
