Export to csv from the History Graph works beautifully. If this could be invoked from the hardware side with a specified time range, that would make it ideal!
i.e. BLYNK_EXPORT((V1,V2,V3),UNIXTIMEBEGIN,UNIXTIMEEND)
I love the idea of pushing the data off of your server to other locations for the sake of keeping you total stored data (and therefore operating costs) minimal.
I know you probably would prefer it to get pushed through the app, because then folks need to purchase the history graph widget to accomplish this (and I totally understand that), but I am guessing you guys could figure out how to filter export requests from the hardware side that only works for the history-graphed data… or maybe it is worth it to you to just make it accessible to all data on your server for free… or perhaps a new widget, similar to ‘push notification’ or ‘email’, that would allow the export of any data collected in the project in the previous month that has been written to the blynk server. It is invoked from the hardware, but only works after installing the ‘export’ widget in the app.
Hello. Indeed you already could do that (however without time begin/end filters) via HTTP API. Regarding implementing this on hardware side… I don’t think we will do that because hardware usually are very slow and limited in memory so such request for data may crash it that will happen often I believe.
Hi, getting the data is extremely easy. I am struggling with converting the numeric value of the date to a readable date-time format. I am using Excel 2013. I could use some help on which function to use.
I have an export containing 1 dataset: temperature / date-time
Hi folks, the time provided from the Blynk server is Unix time. Or in other words, the number provided is how many milliseconds have passed since January 1, 1970. Excel’s ‘date’ format is the number of days since January 1, 1900. Therefore to convert the Blynk provided Unix time into the Excel format, enter the following equation into a blank cell: =“UNIXTIME” (select the cell with the unix time) / 1000 (converts to seconds) / 60 (converts to minutes) / 60 (converts to hours) / 24 (converts to days) + DATE(1970,1,1) (excel function that returns the Excel Date for a given real date. This formula without the notes is as follows:
This will return a number that excel will recognize as the actual time of the reading. The formula returned 12/25/2016 2:20 PM for the first line in the table posted by “tonk” above. Tinkering on Christmas day I see! =D