ERROR WHILE UPLOADING CSV FILE MANUALLY(BY IMPORT METHOD)
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
The file was not uploaded because it contains duplicate timestamps. See Channel Data Import for more information.
4 comentarios
Respuestas (2)
Mathieu NOE
el 12 de Feb. de 2021
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
2 comentarios
Walter Roberson
el 12 de Feb. de 2021
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.
Walter Roberson
el 12 de Feb. de 2021
Editada: Walter Roberson
el 12 de Feb. de 2021
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.
4 comentarios
Walter Roberson
el 12 de Feb. de 2021
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')
writetable(T, 'fixed_feed.csv')
Walter Roberson
el 12 de Feb. de 2021
its urgent today is last day of my project
I should stay up very late because you left something to the last minute??
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!