import raindata problem

[Franky]

Hi,

I want to import data from a netatmo station into the weewx database. Weewx Version is 5.2 with sqlite database.

I used for import:

weectl import --import-config=/etc/weewx/tmp/import.conf --verbose

The import works so far, but when I look in the database I found a missing value for the first Rain value. All other values in the first row are OK, also all values in the following rows. Only the first Rain value is zero but should be 1,8 inch!? Rebuilding the database has no effect.

The csv-file is:

datetime,Pressure,Temp,Humidity,WindAngle,Wind,Gust,GustAngle,Rain
2025/01/01 12:00:00,998.6,7.3,97,211,29,121,227,46.5
2025/01/02 12:00:00,1004.9,2.7,87,242,7,40,304,0.1
2025/01/03 12:00:00,1007.8,0.4,89,243,9,40,232,0.2
2025/01/04 12:00:00,1013.9,-0.4,95,218,11,33,227,0.7

.....

This is the database query:
echo "select datetime(dateTime,'unixepoch','localtime'),windSpeed,barometer,rain from archive WHERE dateTime>unixepoch('2025-01-01 00:00:00', 'utc')  ORDER BY rowid ASC LIMIT 31;" | sqlite3 /var/lib/weewx/weewx.sdb
(last value in the first row should not be zero)

2025-01-01 12:00:00|18.0198093628444|29.4886455175|0.0
2025-01-02 12:00:00|4.34960915654865|29.67468443875|0.00393700787401575
2025-01-03 12:00:00|5.59235462984826|29.7603214025|0.00393700787401575
2025-01-04 12:00:00|6.83510010314787|29.94045432625|0.0196850393700787

The conf file is:

source = CSV
[CSV]
file = /etc/weewx/tmp/import_01_25.txt
raw_datetime_format = %Y/%m/%d %H:%M:%S
calc_missing = True
ignore_invalid_data = True
solar_sensor = False
UV_sensor = False
interval = derive
delimiter = ','
qc = False

[[FieldMap]]
[[[dateTime]]]
        source_field = datetime
        unit = unix_epoch
    [[[outTemp]]]
        source_field = Temp
        unit = degree_C
    [[[outHumidity]]]
        source_field = Humidity
        unit = percent
    [[[windSpeed]]]
        source_field = Wind
        unit = km_per_hour
    [[[windDir]]]
        source_field = WindAngle
        unit = degree_compass
[[[windGust]]]
        source_field = Gust
        unit = km_per_hour
    [[[windGustDir]]]
        source_field = GustAngle
        unit = degree_compass
   [[[barometer]]]
        source_field = Pressure
        unit = mbar
    [[[rain]]]
        source_field = Rain
        unit = mm
        is_cumulative = True

Whats going wrong there?

Thanks for help

Frank