ThingSpeak_Help.txt

pw T~5.
by D4CC@g
on 2023JOct07

How to Reconnect:
Goto https://thingspeak.com/
SignIn
Select submenu: Channels
Then               : Data Import / Export

Elevation (from lat/long) https://latlongdata.com/elevation/

EpochTime: https://www.epochconverter.com/

at Web Site: https://thingspeak.com/
I created a Channel Named PiR2_ON621
   was assigned Channel # 2295475
                        Author mwa0000031572083
                        Device WQTT
                        Access Type: Private

Used Latitude: 45.338
        Longitude: -76.524
        Elevation: 81.48 (meters)

                 MyName	TS name
with Field1: AmbTempc	ambtc
       Field2: KFridgeC	kfc
       Field3: KFreezeC	kfzc
       Field4: KHum	khum

At: 1696736724
Uploaded: E:\E\2023\DocsE\Suppliers\PiR2-ON621\2023JOct07B.csv
Uploaded: E:\E\2023\DocsE\Suppliers\PiR2-ON621\2023JOct07C.csv
feeds Back: E:\E\2023\DocsE\Suppliers\PiR2-ON621\feeds4.csv

2023JOct07C.csv was:
created_at,field1,field2,field3,field4,latitude,longitude,elevation,status
1696736734,27,37,2,45,45.338,-76.524,80,Reading003:2023JOct07C.csv

2023JOct07E.csv was:
created_at,field4,latitude,longitude,elevation,status
1696736725,45,45.338,-76.524,80,Reading004:2023JOct07E.csv

Actual Feed (Back) 7 was
created_at,entry_id,field1,field2,field3,field4,latitude,longitude,elevation,status
2023-10-07T23:45:24-04:00,1,27,37,2,,,,,
2023-10-07T23:45:34-04:00,2,27,37,2,45,45.338,-76.524,80,Reading003:2023JOct07C.csv
2023-10-07T23:45:25-04:00,3,,,,45,45.338,-76.524,80,Reading004:2023JOct07D.csv

Issues
1. Timestamp already in channel.
2. It is possible to "Clear all data"
3. It is possible to "Delete the channel"
4. Channel Stats (graphs) are available

Questions
1. Q: Can I cite the field names instead of "field1" when submitting?
    A:
2. Q: Can I edit the uploaded data?
     A: Download Everything, Edit, Clear the Channel, Upload Everything
3. Q: How to use Write API Key & Read API Key?
     A:
4. Q: How to get a Python program to automatically upload the data?
    A:

Comments:
Note 01 Feed Said Created at:  2023-10-08T03:45:24+00:00
Note 02 Humidity in feed was 0  Doh    caused by missing comma
Note 03 It refused to accept a set of reading at exactly the same Unix Epoch Time
                 Timestamp already in channel.
Note 04 I added 10 seconds to the Unix Epoch Time of the second reading sent.
Note 05 created at format eg: 2023-10-07T23:45:24-04:00  so GMT - 4
Note 06 Readings were allowed with timestamps out of sequence
Note 07 Missing field names produce null entries for the missing readings.
Note 08 A second field was added, nmed "entry_id"
Note 09 There is no known way to edit the uploaded data. Doh!
Note 10 Missing lat/long/elev/status did not cause any error.
Note 11 The system functioned flawlessly. Congrats!
Note 12 It sent valid error messages when it didn't accept a data file.
Note 13 Users with a free license can share a channel with only three other users.

Saved In: article 206

/ThingSpeak_Help.txt