Downloading data from database

5 years 7 months ago #2866 by daviesrv
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

Please Log in or Create an account to join the conversation.

5 years 7 months ago #2867 by NightOne
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 following user(s) said Thank You: daviesrv

Please Log in or Create an account to join the conversation.

5 years 7 months ago #2868 by EasyIoT

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 following user(s) said Thank You: ArneiO, NightOne, daviesrv

Please Log in or Create an account to join the conversation.

5 years 7 months ago #2871 by NightOne
ooops... didnt see the word "cloud" in the question..... Looking forward to the new api, thanks for all your hard work.

Please Log in or Create an account to join the conversation.

5 years 7 months ago #2969 by daviesrv
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

Please Log in or Create an account to join the conversation.

5 years 7 months ago #2970 by NightOne
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 following user(s) said Thank You: daviesrv

Please Log in or Create an account to join the conversation.

Time to create page: 0.356 seconds