Problem with .INI for timestamp and value reading.

Good morning everyone, I have a problem with a UFL configuration. Specifically, reading a .CSV file (created by the client with field data) through the .INI configurator.

The problem is as follows: the connector does not recognize the date column, this is the error:

"Severity: Error Timestamp: 03/06/2025 12:46:45.266 Message: [Production_TCP] Error parsing line ("2025-02-15 23:15:00","2025-02-16 00:15:00",6368.4476665785): [1, [Error] Invalid time format: "2025-02-15 23:15:00".]"

As you can see, I have 3 columns; I am interested in the first one for the timestamp (UTC) and the third one for the values. The second one must be skipped.

Unfortunately, I also need to convert the third column from string to number (yes, they put the values as string...) and I am not able to do it without directly modifying the .csv (which will no longer be modifiable in production).

Also, I need to skip the first row of both relevant columns, as they do not contain values.

The tag name is created correctly, and the tags themselves are also created (but they are obviously not populated).

P.S: We have tried every kind of date format change.

 

I hope for your help, Fabrizio

Parents Reply Children
No Data