ERROR WHILE UPLOADING CSV FILE MANUALLY(BY IMPORT METHOD)

The file was not uploaded because it contains duplicate timestamps. See Channel Data Import for more information.

[vrushika SHAH]

ANS PLZ................ITS URGENT

[vrushika SHAH]

PLZ...........................................................................................................

[vrushika SHAH]

plz....................................................................................

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/29922-why-your-question-is-not-urgent-or-an-emergency

Answer 1

[Mathieu NOE]

hello

no issue found with your file . Could load it with readtable

T = readtable('feed.csv');

T = 12×3 table

C_Time TEMPERATURE BPM

_________________________ ___________ ___

{'12-02-202107:12:38 PM'} 106.71 86

{'12-02-202107:12:44 PM'} 108.46 86

{'12-02-202107:12:49 PM'} 99.68 86

{'12-02-202107:12:54 PM'} 163.84 75

{'12-02-202107:12:59 PM'} 141.86 69

{'12-02-202107:13:04 PM'} 95.28 69

{'12-02-202107:13:09 PM'} 127.8 69

{'12-02-202107:13:14 PM'} 91.77 69

{'12-02-202107:13:19 PM'} 105.83 69

{'12-02-202107:13:24 PM'} 82.98 69

{'12-02-202107:13:29 PM'} 79.46 69

{'12-02-202107:13:34 PM'} 147.14 101

[Walter Roberson]

But then you need to datetime() it with an 'InputFormat' to get it into datetime format, and set the Format to something that ThingSpeak can use. Then you need to create a new csv file that Thingspeak is willing to accept.

[vrushika SHAH]

From where i have to write that code sir??

Answer 2

[Walter Roberson]

The timestamps are not in any of the permitted format. You have no space between the year and the time, and in all the recognized formats, the year must be first. AM/PM is not permitted.

https://www.mathworks.com/help/thingspeak/channel-data-import.html

[vrushika SHAH]

can u plz share the exact code so that my problem will solve its urgent today is last day of my project

[vrushika SHAH]

PLZ YAR KOI TOH SUNO

[Walter Roberson]

T = readtable('feed.csv', 'VariableNamingRule', 'preserve' );

T.(1) = datetime(T{:,1}, 'InputFormat', 'dd-MM-yyyyhh:mm:ss a', 'Format', 'yyyy-MM-dd HH:mm:ss')

T = 12x3 table
          C-Time           TEMPERATURE    BPM
    ___________________    ___________    ___

    2021-02-12 19:12:38      106.71        86
    2021-02-12 19:12:44      108.46        86
    2021-02-12 19:12:49       99.68        86
    2021-02-12 19:12:54      163.84        75
    2021-02-12 19:12:59      141.86        69
    2021-02-12 19:13:04       95.28        69
    2021-02-12 19:13:09       127.8        69
    2021-02-12 19:13:14       91.77        69
    2021-02-12 19:13:19      105.83        69
    2021-02-12 19:13:24       82.98        69
    2021-02-12 19:13:29       79.46        69
    2021-02-12 19:13:34      147.14       101

writetable(T, 'fixed_feed.csv')

[Walter Roberson]

its urgent today is last day of my project

I should stay up very late because you left something to the last minute??