import csv thinspeak | General | Forum

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.
Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —





— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
Go to Bottom
sp_RankInfo
sp_Feed sp_TopicIcon
import csv thinspeak
No permission to create posts
April 21, 2019
9:44 am
Avatar
k
New Member
Members
Forum Posts: 1
Member Since:
April 21, 2019
sp_UserOfflineSmall Offline
Go to Top
1sp_Permalink sp_Print

when i upload the csv file the file contains one datetime and 4 fields. when i download to see what has been uploaded i see that there is created_date , entry_id and field1 ..
where are my other fields ?

April 22, 2019
11:45 am
Avatar
Vinod

MathWorks
Members
Forum Posts: 342
Member Since:
May 1, 2016
sp_UserOfflineSmall Offline
Go to Top
2sp_Permalink sp_Print

Your other fields are not enabled in the channel settings. Try enabling them and re-downloading the file.

December 19, 2019
6:02 pm
Avatar
pacoberto
New Member
Members
Forum Posts: 1
Member Since:
December 19, 2019
sp_UserOfflineSmall Offline
Go to Top
3sp_EditHistory sp_Permalink sp_Print

Hello
I am trying to import data to thingspeak with csv file format from excel but I received the following message
the uploaded file was not louded because it contains invalid timestamps
this is my data csv format

datetime,field1,field2,field3,field4,field5,field6,field7,field8,latitude,longitude,elevation
2019-11-01T13:01:01-04:00,30.000,2.500,85,90,88,88,75,60,10.3581138,66.8980416,1263

Where is the trouble here

January 10, 2020
10:41 am
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 885
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline
Go to Top
4sp_EditHistory sp_Permalink sp_Print

There are some time format examples in the doc page. https://www.mathworks.com/help/thingspeak/channel-data-import.html Can you check to be sure your format matches?

No permission to create posts
sp_Feed
Go to top
Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
30 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

estebanmateo93, mikewrite, onlinebusiness, winzy99, Zark_zeugan, StefanWi

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457