Strange number format in my csv file | General | 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
Strange number format in my csv file
No permission to create posts
February 5, 2014
1:17 am
Avatar
acarre

Silver
Members
Forum Posts: 6
Member Since:
January 22, 2014
sp_UserOfflineSmall Offline

Hi All,

Wasn't sure if anybody else had seen this...

Am getting a strange 'double decimal' in my csv dumps from thingspeak. Looks like it's mixing up data across the fields. Here's what I get when i dump csv from field3:

created_at entry_id field3
2014-02-05 04:02:40 UTC 32002 50464.0369.00
2014-02-05 04:03:40 UTC 32003 113284.369.00
2014-02-05 04:04:40 UTC 32004 80743.0369.00
2014-02-05 04:05:40 UTC 32005 20545.0369.00
2014-02-05 04:06:40 UTC 32006 177545.369.00
2014-02-05 04:07:40 UTC 32007 110674.369.00

Notice the double decimal in field 3. Any ideas what could be going wrong?

All the other fields format correctly.

Cheers,

Andrew

February 5, 2014
1:05 pm
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi Andrew,

I'll take a look at this, what channel number is this data for?

lee

February 5, 2014
11:23 pm
Avatar
acarre

Silver
Members
Forum Posts: 6
Member Since:
January 22, 2014
sp_UserOfflineSmall Offline

Hi Lee,

It was channel 9585, but I've fixed it. It wasn't Thingspeak at all, but rather the data I was posting to it. I was posting from an Arduino a floating point number. Unfortunately I had done a bodgy job of converting it from an integer causing a strange memory overflow (multiple decimals) .

A silly mistake, but all good now.

Cheers,

Andrew

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
26 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:

Team_mafia, icXu, emorphistechno, VTVMART, manimozhi, adamhebrew

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457