MATLAB Answers

Unable to upload a csv file

1 view (last 30 days)
Aster Anthony
Aster Anthony on 19 Apr 2021
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.
  4 Comments
Aster Anthony
Aster Anthony on 19 Apr 2021
I created a new channel with my local time zone. it worked. Thank you.

Sign in to comment.

Answers (1)

Christopher Stapels
Christopher Stapels on 20 Apr 2021
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

Communities

More Answers in the  ThingSpeak Community

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by