I'm sorry but I don't see what a wind plot has to do with wee_import.
Looking at the sample data you posted earlier your wind direction data
appears to be in degrees so you would be using something like the following
in your field map:
windDir = xxxxxx, degree_compass
windGustDir = yyyyyy, degree_compass
substituting the field names you wish to use from your source data for
xxxxxx and yyyyyy.
Or are you asking something completely different?
Gary
On Tuesday, 1 March 2022 at 09:26:02 UTC+10 Artvd wrote:
> @Gary. Thanks again. I am almost getting there thanks to your help
> I am stuck however with the Wind direction units. Have you any idea what
> this should be for the attached windvector ?[image: 7vg24yyo.png]
> Op maandag 28 februari 2022 om 21:54:44 UTC+1 schreef gjr80:
>
>> The 'timestamp' error indicates that wee_import is looking for date-time
>> data for each record in a field named timestamp, your source data has no
>> such field so the import fails. What is in the field map in your import
>> config file? I am guessing that date-time wise it is still uses the example
>> import config file entry:
>>
>> [[FieldMap]]
>> dateTime = timestamp, unix_epoch
>> interval =
>> barometer = barometer, inHg
>>
>> In your case (based on the sample data provided) the dateTime entry
>> needs to be something like (untested):
>>
>> dateTime = "Date & Time", unix_epoch
>>
>> In addition you will need to tell wee_import what format your date-time
>> data uses. You do that by setting the raw_datetime_format option in your
>> import config file. Again, based on your sample data, something like:
>>
>> raw_datetime_format = %Y-%m-%d %H:%M
>>
>> %m and %d may need to be transposed, I cannot tell from your data whether
>> it uses year-month-day or year-day-month.
>>
>> One other thing you will need to do, if you have not already done so, is
>> to ensure the import config file field map contains the names of the source
>> data fields you wish to import. Taking the barometer line from the
>> default [[FieldMap]] extract I provided above you will need to change it
>> to read:
>>
>> barometer = "Barometer - hPa", hPa
>>
>> Gary
>> On Tuesday, 1 March 2022 at 05:25:02 UTC+10 Artvd wrote:
>>
>>>
>>> @Gary Thanks for your reaction. The offending character is likely the
>>> degrees sign in the title row. But after removing them I faced another
>>> problem: TypeError: "delimiter" must be a 1-character string
>>> I have tried many changes and used a one row testfile but the error
>>> remained. Finally i copied the data from the davis site to excell. When
>>> using these data there is no error. However the timestamp can not be found.
>>>
>>> This is the tile and a line of the data.csv file
>>>
>>> Date & Time;Inside Temp - C;High Inside Temp - C;Low Inside Temp -
>>> C;Inside Hum;High Inside Hum;Low Inside Hum;Inside Dew Point - C;Inside
>>> Heat Index - C;Barometer - hPa;High Bar - hPa;Low Bar - hPa;Absolute
>>> Pressure - hPa;Temp - C;High Temp - C;Low Temp - C;Hum;High Hum;Low Hum;Dew
>>> Point - C;High Dew Point - C;Low Dew Point - C;Wet Bulb - C;High Wet Bulb -
>>> C;Low Wet Bulb - C;Avg Wind Speed - m/s;Prevailing Wind Direction;High Wind
>>> Spe7ed - m/s;High Wind Direction;Wind Chill - C;Low Wind Chill - C;Heat
>>> Index - C;High Heat Index - C;THW Index - C;High THW Index - C;Low THW
>>> Index - C;Rain - mm;High Rain Rate - mm/h;Heating Degree Days;Cooling
>>> Degree Days
>>>
>>> *2022-01-01 00:00*
>>> ;21,5;21,7;21,4;53,1;53,3;52,9;11,6;20,8;1026,7;1026,7;1026,7;971,8;9,5;9,6;9,5;95,9;96,1;95,9;8,9;8,9;8,9;9,2;9,2;9,2;0;;0;;9,5;9,5;9,8;9,9;9,8;9,9;9,8;0;0;0,092;0
>>>
>>> This is the output
>>> sudo wee_import --import-config=/var/tmp/csv.conf --dry-run
>>>
>>> Using WeeWX configuration file /etc/weewx/weewx.conf
>>> Starting wee_import...
>>> A CSV import from source file '/var/tmp/data.csv' has been requested.
>>> 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.
>>> Starting dry run import ...
>>>
>>>
>>> ***** Unable to map source data.**** Field 'timestamp' not found in
>>> source data.**** Nothing done, exiting.*
>>>
>>> Op maandag 28 februari 2022 om 02:38:26 UTC+1 schreef gjr80:
>>>
>>>> You have two things going on here.
>>>>
>>>>
>>>> ***** Unable to decode source data for period 1.**** 'utf-8' codec
>>>> can't decode byte 0xb0 in position 29: invalid start byte*
>>>> **** Period 1 will be skipped. Proceeding to next period.
>>>> **** Consider specifying the source file encoding using the
>>>> 'source_encoding' config option.
>>>>
>>>> This is a warning that you have characters in your source data, in this
>>>> case the degree symbol, that wee_import cannot process. Consequently
>>>> the first period of data was skipped. The warning suggests specifying the
>>>> encoding using the source_encoding config option but you really need
>>>> to remove the offending character(s).
>>>>
>>>> The 'readonly database' error is likely due to permissions on your
>>>> sqlite database file and the user that was running wee_import having
>>>> insufficient privileges to write to that file. If WeeWX is run as the root
>>>> user you may need to use sudo to run wee_import, eg:
>>>>
>>>> $ sudo wee_import <rest of wee_import options>
>>>>
>>>> Gary
>>>> On Sunday, 27 February 2022 at 23:03:52 UTC+10 Artvd wrote:
>>>>
>>>>> I am trying to import a monthly csv file to weewx using the weewx
>>>>> import guideline .Unfortunately i get a error. I wonder if someone could
>>>>> help me to solve the problem. Below is weewx output of the dry run
>>>>>
>>>>> wee_import --import-config=/var/tmp/csv.conf --dry-run
>>>>> Using WeeWX configuration file /etc/weewx/weewx.conf
>>>>> Starting wee_import...
>>>>> A CSV import from source file '/var/tmp/data.csv' has been requested.
>>>>> 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.
>>>>> Starting dry run import ...
>>>>>
>>>>> ***** Unable to decode source data for period 1.**** 'utf-8' codec
>>>>> can't decode byte 0xb0 in position 29: invalid start byte*
>>>>> **** Period 1 will be skipped. Proceeding to next period.
>>>>> **** Consider specifying the source file encoding using the
>>>>> 'source_encoding' config option.
>>>>> Traceback (most recent call last):
>>>>> File "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
>>>>> return fn(*args, **kwargs)
>>>>> File "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
>>>>> return sqlite3.Cursor.execute(self, *args, **kwargs)
>>>>> sqlite3.OperationalError: attempt to write a readonly database
>>>>>
>>>>> During handling of the above exception, another exception occurred:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *Traceback (most recent call last): File
>>>>> "/usr/share/weewx/wee_import", line 899, in <module> main() File
>>>>> "/usr/share/weewx/wee_import", line 829, in main source_obj.run()
>>>>> File
>>>>> "/usr/share/weewx/weeimport/weeimport.py", line 435, in run
>>>>> self.dbm._write_metadata('lastUpdate', str(int(new_last_update))) File
>>>>> "/usr/share/weewx/weewx/manager.py", line 1494, in _write_metadata
>>>>> _cursor.execute(DaySummaryManager.meta_replace_str % self.table_name,
>>>>> File
>>>>> "/usr/share/weewx/weedb/sqlite.py", line 44, in guarded_fn raise
>>>>> weedb.OperationalError(e)weedb.OperationalError: attempt to write a
>>>>> readonly database*
>>>>>
>>>>
--
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/72e80b9f-54fb-4008-8206-150f0dc5347fn%40googlegroups.com.
