Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Downloading data from database

Downloading data from database 1 year 5 months ago #2866

  • daviesrv
  • daviesrv's Avatar
  • Offline
  • New Member
  • Posts: 7
  • Karma: 0
Just managed to get your ds18b20 temperature logger to work.
Which is fairly amazing as I'm just skimping through your Easyiot Cloud interface.

I'd like to extract the db logged data, for further processing.
Is that possible?

Roger
The administrator has disabled public write access.

Downloading data from database 1 year 5 months ago #2867

  • NightOne
  • NightOne's Avatar
  • Offline
  • Premium Member
  • Posts: 81
  • Thank you received: 26
  • Karma: 5
Yes getting data is super easy.... all data is save in SQLITE file in the root directory, the file is called EasyIoTDatabase.sqlite,
I use a free tool called sqlitebrowser (sqlitebrowser.org/)....

Just look at the address is your node in the address table and then all data is in raw values.

Hope this helps
The administrator has disabled public write access.
The following user(s) said Thank You: daviesrv

Downloading data from database 1 year 5 months ago #2868

  • EasyIoT
  • EasyIoT's Avatar
  • Offline
  • Administrator
  • Posts: 833
  • Thank you received: 258
  • Karma: 24
daviesrv wrote:
Just managed to get your ds18b20 temperature logger to work.
Which is fairly amazing as I'm just skimping through your Easyiot Cloud interface.

I'd like to extract the db logged data, for further processing.
Is that possible?

Roger

If you are talking about EasyIoT Cloud and not server. Next week we will add powerful REST API to access your data with more than 25 new API functions.
The administrator has disabled public write access.
The following user(s) said Thank You: ArneiO, NightOne, daviesrv

Downloading data from database 1 year 5 months ago #2871

  • NightOne
  • NightOne's Avatar
  • Offline
  • Premium Member
  • Posts: 81
  • Thank you received: 26
  • Karma: 5
ooops... didnt see the word "cloud" in the question..... Looking forward to the new api, thanks for all your hard work.
The administrator has disabled public write access.

Downloading data from database 1 year 4 months ago #2969

  • daviesrv
  • daviesrv's Avatar
  • Offline
  • New Member
  • Posts: 7
  • Karma: 0
Noticed that there is a download .csv file below my temp graphical display. the .csv file gives the temp, with an idex, which I can't work out. (I presume it should be time). I also can't work out why only a limited amount of data is download.... when I have loads....
Hope you can provide a bit of advice.
Should I be using the REST API somehow.

THanks for doing the work and providing the service. Excellent.

Roger
The administrator has disabled public write access.

Downloading data from database 1 year 4 months ago #2970

  • NightOne
  • NightOne's Avatar
  • Offline
  • Premium Member
  • Posts: 81
  • Thank you received: 26
  • Karma: 5
I could be wrong...but at the top of the graph there are buttons that say Day, Week, Month, All..... If I click All and then click download to csv I get all my data.... but then again I dont have a lot of data yet.
The administrator has disabled public write access.
The following user(s) said Thank You: daviesrv
  • Page:
  • 1
  • 2
Time to create page: 0.350 seconds
Powered by Kunena Forum