Data Import not forking | ThingSpeak API | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





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

sp_Feed sp_TopicIcon
Data Import not forking
No permission to create posts
August 4, 2018
9:52 am
Avatar
wadevcamp

Silver
Members
Forum Posts: 11
Member Since:
July 30, 2018
sp_UserOfflineSmall Offline

(Title should be "Data Upload not Working")

I tried to upload the following, but got msg "The data in the file does not contain values for the datetime column. Do you wish to continue?". Strange, since it's the same format I used a few days ago!!

datetime field3
2018-08-02T15:04:09 1

If I say "yes" to the "continue?" question, I get "The uploaded file is not in a supported format."

Also, an error banner says "The uploaded file is not in a supported format. See Channel Data Import for more information.", but the hotlink (on Channel Data Properties) takes me to a page titled "Channel Properties", which doesn't address the format issue.

Any help would be greatly appreciated! (I either need to get this working soon or switch to another IoT platform with more consistently reliable functionality. Except for this problem, I like the TS functionality!!)

August 4, 2018
12:28 pm
Avatar
wadevcamp

Silver
Members
Forum Posts: 11
Member Since:
July 30, 2018
sp_UserOfflineSmall Offline

Here I am a few hours later... I uploaded the exact same file, but this time the uploaded file format was accepted!! I'd love to know why it was not accepted before -- as I said above, I need to be convinced that this functionality is consistently reliable before committing to go into production with TS -- any help in understanding this apparent inconsistency would be appreciated.

Unfortunately, the upload did not result in getting the field values assigned.

I uploaded the following...

datetime field3
2018-08-02T15:04:09 1

...and the result was this...

created_at entry_id field1 field2 field3 field4 field5
2018-08-02 20:04:09 UTC 1

Anyone know what's going on here?? I need to know how to get field3 to have a value of 1. (The result has the entry_id=1, and all the data fields are blank.)

August 6, 2018
8:23 am
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 510
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

Are you using commas in your data file?
The Channel properties page has a section on Data import at the bottom.
Here is a csv file, created in excel, opened in notepad that results in successful data written to field 3.

datetime,field3
2018-08-01T19:03:48-05:00,20
2018-08-02T19:03:48-05:00,21
2018-08-02T08:56:13,22

Can you try my file and see what happens? I've found it to be very consistent, once you get the format correct.

Do you need to upload a lot of csv data? The csv upload requires gui interface, which is harder to use programatically. If you are considering commercial use, you might think about the REST API Write data or bulk write Data .
https://www.mathworks.com/help/thingspeak/writedata.html
https://www.mathworks.com/help/thingspeak/bulkwritejsondata.html

data_import.pngImage Enlarger

sp_PlupAttachments Attachments
August 6, 2018
1:31 pm
Avatar
wadevcamp

Silver
Members
Forum Posts: 11
Member Since:
July 30, 2018
sp_UserOfflineSmall Offline

SOLVED!

I had a (non-obvious) space leading the "field3" header. ----- It's the little things that always get you.........

I want to be able to upload so that I can set/change parameters from any web browser (i.e., with no program interface).

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online: SGDamiano1
34 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:

petersevruk, SGDamiano1, seanoz60, Beverlytreta, MartaKah, genevievecu69

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457