Gary One thing I noticed when looking at the cumulus file was that the decimal separator seemed to be ',' rather than '.', as well as the '-' instead of '/'. Perhaps there should be formatting options in the cumulus file for dates like the csv - and what about the numeric decimal formats - maybe that should be specifiable in both csv and cumulus imports.
Just thoughts!! Andrew On Friday, 27 January 2017 15:28:52 UTC+2, gjr80 wrote: > Hi, > > It looks like I need to add a date delimiter option to cumulus.conf, your > monthly log file uses d-m-y whereas wee_import is expecting d/m/y - first > time I have seen anything other than /. Unfortunately, CSV import is the > only import that currently let's you specify the date-time format used in > the file(s) to be imported. It will be a couple of days before I can fix > that issue, so in the interim attached is a modified cumulusimport.py > that will accept d-m-y (and only d-m-y). If you wish to use it: > > 1. rename your existing cumulusimport.py (it should be in > /home/weewx/bin/weeimport or /usr/share/weewx/weeimport - depending on > your install type) to cumulusimport_orig.py > 2. copy the attached cumulusimport.py in its place. > > Fortunately, I thought I would run a test import with your data and config > file and the modified cumulusimport.py and I discovered another error > when importing from Cumulus (perhaps not too many have importd from Cumulus > since wee_import was released). This time the error is in weeimport.py. I > have attached a modified weeimport.py that fixes the issue. Same process > for installing the modified weeimport.py: > > 1. rename the existing weeimport.py to weeimport_orig.py > 2. copy the attached weeimport.py in its place > > Your import should be error free now (it was for me!). I hope to get both > fixes in the next weeWX release. > > Gary > > On Friday, 27 January 2017 21:49:50 UTC+10, Thomas Olausson wrote: >> >> Hi, >> >> I'm trying to import old archve data from Cumulus and it seems like the >> date and time format in the archive is a problem. >> One monthly archive file and cumulus.conf file are appended. >> I would like to know which datetime formats that wee_import can handle so >> that I, if possible, can edit the time and date in the archives t suit >> wee_import. >> Below is copy of console output. >> >> Best regards >> Thomas Olausson >> >> pi@raspi3:~ $ wee_import --import-config=/var/tmp/cumulus.conf --dry-run >> Starting wee_import... >> Cumulus monthly log files in the '/home/pi/Downloads/cumulus' directory >> will be imported >> 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. >> This is a dry run, imported data will not be saved to archive. >> **** Invalid 'datetime' field. Cannot convert '21-01-10 00:20' to >> timestamp. >> **** Nothing done, exiting. >> >> -- 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]. For more options, visit https://groups.google.com/d/optout.
