Unable to upload a csv file

4 views (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
Jonas
Jonas on 19 Apr 2021
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
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

Categories

Find more on ThingSpeak in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!