Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[HELP] FTP connector - how to use DateTime from CSV file itself as ts for each row #1542

Open
TB-IoT-Junior opened this issue Sep 27, 2024 · 0 comments
Assignees

Comments

@TB-IoT-Junior
Copy link

TB-IoT-Junior commented Sep 27, 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.

@TB-IoT-Junior 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants