3digit comma values evaluated as 1000s

[motsumipower]

CSV data is :

Current,2023-06-19 14:57:32.418625,0.619
Current,2023-06-19 14:57:34.951757,0.606
Current,2023-06-19 14:57:37.637850,0.606
Current,2023-06-19 14:57:40.307085,0.636
Current,2023-06-19 14:57:42.857076,0.582
Current,2023-06-19 14:57:45.479023,0.601
Current,2023-06-19 14:57:48.088373,0.583
Current,2023-06-19 14:57:50.722451,0.607
Current,2023-06-19 14:57:53.399883,0.673
Current,2023-06-19 14:57:56.053952,0.62
Current,2023-06-19 14:57:58.608875,0.598

it becomes

Current 2023-06-19 14:57:34 606
Current 2023-06-19 14:57:37 606
Current 2023-06-19 14:57:40 636
Current 2023-06-19 14:57:42 582
Current 2023-06-19 14:57:45 601
Current 2023-06-19 14:57:48 583
Current 2023-06-19 14:57:50 607
Current 2023-06-19 14:57:53 673
Current 2023-06-19 14:57:56 0,62
Current 2023-06-19 14:57:58 598

Can any-one shed light please ?

These are amperage readings. 0.62 amp is correct.

If it changed them all, no problem, then it's milliamps.
But it only changes some.

Decimal 'comma' ? Decimal 'period' ?

But why not all ?

[Rello]

Hi,
I will check. I think the logic gets confused with a comma and thousand separator

[motsumipower]

Thanks.

[Rello]

Realtime datasource on the csv file - correct:

Dataload from csv file - wrong:

I will fix the value parser here...

but one thing to add: the analytics reporting currently only uses 2 digits when storing the data in the internal database...

[motsumipower]

Thanks. Noted. about the two digit value.

Observation :
Yes, it seems the only one that came in correctly was the two digit decimal
Current,2023-06-19 14:57:56.053952,0.62
Current 2023-06-19 14:57:56 0,62

I will try to get logging to round up.
Current,2023-06-19 14:57:40.307085,0.636
to
Current,2023-06-19 14:57:40.307085,0.64

[motsumipower]

Success.

CSV as follows : (with 2 digit decimal)
successfully autoloads and refreshes.

Current,2023-06-21 05:13:36.533009,0.64
Current,2023-06-21 05:13:39.461932,0.66
Current,2023-06-21 05:13:42.041935,0.64
Current,2023-06-21 05:13:44.150528,0.65
Current,2023-06-21 05:13:46.245683,0.68
Current,2023-06-21 05:13:48.344914,0.67

[Rello]

Hi,
yes, its a workaround. nevertheless the dataloader needs some correction here. it will do the rounding automatically then

[Rello]

parser was corrected to deal with 0,xxx values and not treat them as 1000-separators