Retrieval of Blynk data

[Riddho]

Hii all. I am working on a few sensor values obtained from DHT 11 and MQ 135 sensors and can see the readings obtained from virtual pins on my android through the Blynk cloud. But how can I record or store the set of data for a certain interval of time in Blynk app when my microcontroller will be powered on? I need to retrieve the values obtained preferably in csv file format. Help guys.

[Gunner]

Courtesy of those pesky documentation pages that was recommended you read before posting

SuperChart and CSV export… from there you can analyze the data however you want.

http://docs.blynk.cc/#widgets-displays-superchart

[Dmitriy]

@Gunner and new reporting widget. Those menu will be removed soon.

[Riddho]

Thanks for your reply @Gunner but in the excel sheet apart from physical values abnormally large metric values such as 1.25E+12 are also getting printed. Way out?

[ldb]

LOVE THE CSV EXPORT! Two Things needed, Request From Hardware and Time Range

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…

[Dmitriy]

In reports you can choose any format you need.

[marvin7]

@Dmitriy

In reports you can choose any format you need.

Hey, really well done! Now the (MY) problem is: I’m not using device tiles…

[Dmitriy]

@marvin7 this is fixed and will be available in the next update.

[Gunner]

@Dmitriy

@Gunner and new reporting widget

Oh right… I am not a tile user, my attempts so far have left me unimpressed, so I was unfamiliar with that new reporting option.