Unable to upload a csv file

Im not able to upload a csv file which I have created using rpi. The csv file is as follows

datetime  field1  field2  field3 
2021-04-19-10:59:46  0  0  0 
2021-04-19-10:59:47  122  -1  265 
2021-04-19-10:59:48  123  -1  265 
2021-04-19-10:59:49  115  0  266 
2021-04-19-10:59:50  122  -7  265 
2021-04-19-10:59:51  117  -5  265 

the error I get is invalid csv file or contains duplicate timestamp or missing timestamps. If someone could point out the mistake, it would be helpful.

[Jonas]

i don't know where you want to upload your csv and which program looks at it, but sometimes the way how timestamps are written differ between programs and can then lead to errors

[Aster Anthony]

I want to upload this csv file to my private channel which has 3 fields for x, y and z axis. What format of timestamp should I use?

[Jonas]

if you just want to upload a file to a platform and the file saves correctly I don't see why this should not work. Are csv files allowed in your private channel, can you upload other csv files?

[Aster Anthony]

I created a new channel with my local time zone. it worked. Thank you.

Answer 1

[Christopher Stapels]

Duplicate values are not allowed in the channel. It is possibe that you had already written that data and tried a second time. Creating a new channel solved the problem of duplicate timestamps in the channel.

For the Format, see the channel data import page.

Format Sample Datetime

Epoch1494878628 (seconds elapsed since January 1, 1970) May 15, 2017, 20:03:48 UTC

ISO 860 12017-05-15T20:03:48-05:00 May 15, 2017, 20:03:48 EST

MySQL 2017-05-15 20:03:48 UTC May 15, 2017, 20:03:48 EST