Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-05 Thread Glenn McKechnie
Gary, That one works a treat. On 05/03/2022, gjr80 wrote: > Apologies Glenn, try this version. I'm in between moving from linux to Mac > on my desktop and my test environment is not quite complete so that last > version had some cursory testing only. Not a problem. And thanks for your time

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-04 Thread Glenn McKechnie
Gary, closer but... could not convert string to float: test of wee_import text updates = full terminal output... 12:19 PM $ sudo bin/wee_import --import-config=/home/weewx/csv.conf --config=/home/weewx/weewx.conf --verbose Using WeeWX configuration file /home/weewx/weewx.conf Starting

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-04 Thread gjr80
Glenn, could you try the attached weeimport.py, it should support text imports and be compatible with v4.5.1. Gary On Friday, 4 March 2022 at 14:51:33 UTC+10 gjr80 wrote: > Ah, didn't notice you were on 4.5.1. There was a change to units.py under > 4.6.x that forced a change in weeimport.py,

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-03 Thread gjr80
Ah, didn't notice you were on 4.5.1. There was a change to units.py under 4.6.x that forced a change in weeimport.py, consequently the weeimport.py version I provided does not get on with WeeWX 4.5.x. Let me get you a 4.5.x compatible version. Gary On Friday, 4 March 2022 at 13:16:57 UTC+10

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-03 Thread Glenn McKechnie
On 04/03/2022, gjr80 wrote: > Glenn, > > Have you had a chance to try the revised wee_import? I am working on a > number of other changes to the same piece of wee_import code and I would > prefer to do them all at once if possible. Whoops. Sorry about that. It slid down the Todo list a little

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-03-03 Thread gjr80
Glenn, Have you had a chance to try the revised wee_import? I am working on a number of other changes to the same piece of wee_import code and I would prefer to do them all at once if possible. Gary On Saturday, 22 January 2022 at 16:08:27 UTC+10 Glenn McKechnie wrote: > Thanks Gary, > >

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-01-21 Thread Glenn McKechnie
Thanks Gary, I'll give it a test drive as soon as I get a moment or three. On a related note (ie:- related to using TEXT fields in the database) I went and checked out wee_database and found that it baulked at the TEXT field in the database. Details are in the attached file, which should keep

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-01-21 Thread gjr80
Glenn, I have created a new branch wee_import_text off development for this and have modified the wee_import code to import text to a WeeWX TEXT field. There are a dew conditions: 1. text import only works with CSV imports 2. import source fields that are to be imported as text must use

Re: [weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-01-17 Thread Glenn McKechnie
Thanks Gary, I appreciate it. Hopefully UPDATE won't raise any serious weewx issues. I look forward to seeing it raised as an issue :) On 18/01/2022, gjr80 wrote: > Correct, wee_import will not accept text only fields. When we put together > wee_import we only included support for numeric

[weewx-user] Re: Storing Text as a record, wee_import and mysql UPDATE

2022-01-17 Thread gjr80
Correct, wee_import will not accept text only fields. When we put together wee_import we only included support for numeric fields; text fields were omitted, perhaps not intentionally, but more likely because no real consideration had been given to including them in the schema. That being said,