You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have installed the latest version of ThingsBoard IoT Gateway, on Linux Ubuntu server.
It is working as expected, however I am having a question about the FTP connector.
I have a "data.csv" file which is populated as follows:
It connects to the file and is able to retrieve the values, however I would like to know, how can I use the "DateTime" field in the CSV file as the "ts" for each row of data being sent to ThingsBoard? If this is possible, without needing to use the rule engine.
The text was updated successfully, but these errors were encountered:
TB-IoT-Junior
changed the title
[HELP] FTP connector not parsing all fields and dont know how to use ts from CSV file itself
[HELP] FTP connector - how to use DateTime from CSV file itself as ts for each row
Sep 28, 2024
I have installed the latest version of ThingsBoard IoT Gateway, on Linux Ubuntu server.
It is working as expected, however I am having a question about the FTP connector.
I have a "data.csv" file which is populated as follows:
,DateTime,Tank1,Tank2,Tank3
,14/09/2024 00:00:00:120,335.1245,333.4578,331.5106
,14/09/2024 00:00:30:1230,335.1245,333.4747,331.5717
,14/09/2024 00:01:00:120,335.1245,333.4768,331.5274
The FTP configuration JSON has the following:
"paths": [
{
"devicePatternName": "ABC123",
"devicePatternType": "Device",
"delimiter": ",",
"path": "fol/data.csv",
"readMode": "FULL",
"maxFileSize": 5,
"pollPeriod": 60,
"txtFileDataView": "TABLE",
"withSortingFiles": true,
"attributes": [],
"timeseries": [
{
"type": "double",
"key": "Tank1",
"value": "${Tank1}"
},
{
"type": "double",
"key": "Tank2",
"value": "${Tank2}"
},
{
"type": "double",
"key": "Tank3",
"value": "${Tank3}"
}
]
}
],
It connects to the file and is able to retrieve the values, however I would like to know, how can I use the "DateTime" field in the CSV file as the "ts" for each row of data being sent to ThingsBoard? If this is possible, without needing to use the rule engine.
The text was updated successfully, but these errors were encountered: