Hi, I’m using a superchart widget to collect data (via Blynk server) from a CO2 sensor, and I’d like to export historical data to excel so I can perform some basic analysis. From what I read about CSV in the blynk community, do I must use the local server in order to open the file? I tried to email the CSV file to my PC. When opened with Excel, what I only saw was random characters.
Thanks, I can see that now. The CSV data appears to be showing an average value of the data in an interval of one minute. Is it possible to configure the CSV data such that it records the value and timestamp of whenever a relative maximum value is reached?
By the way, does the third column of zeros mean anything?
says “As Blynk Cloud is free to use we have a limit on how many data you can store. At the moment Blynk Cloud accepts 1 message per minute per pin. In case you send your data more frequently your values will be averaged. For example, in case you send value 10 at 12:12:05 and than again 12 at 12:12:45 as result in chart you’ll see value 11 for 12:12
Should look something like 1521674584 for Wednesday 21 March 2018 kl. 23:23:04 GMT
I think the n … E+12 occurs the column isn’t the correct type in Excel and/or not wide enough to display all numerals. Try format the cells to… Numbers?! (my menus are in Swedish )
EDIT: Had to try for myself… Changed the cell formatting in column B to Numbers (no decimals). Deleted all values in C and used a fairly easy function as @PeteKnight calls it to do the conversions. The cells in C should be formatted as Date, and Date Type as you prefer. Time also works. No highlighting is basic formatting, orange is different Date Type and yellow different Time Type
To display the converted time in a more readable format you can choose Custom formatting and adjust the way that you want the data to appear:
If you go for dd/mm/yyyy hh:mm then it’s easier to read (unless you’re American and insist on totally messing-up the way that dates are written). Going for Year Month Date as @Distans has done means that you can sort the dates into chronological order much more easily.
Edited to add…
The UNIX times in CSV exports are in GMT/UTC timezone format. The formula above contains a calculation which deducts 7 hours from this to convert it to MST/PDT.
If you’re in Europe then you’ll need to add one hour (in winter) or 2 hours (in summer) so the formula for European SummerTime would be:
I’m a new user and very impressed with the superchart widget, which does exactly what I need (monitoring environmental parameters in an experimental solar dryer). However, the CSV download function doesn’t appear to be working for me. I get an e-mail with 4 links (one for each virtual pin). When I click on the links, a tab appears and immediately disappears. When I attempt to open the URL for the links, which is like this: http://22.214.171.124/m…….@ucdavis.edu_973756963_0_v10_1530972438585.csv.gz
I get a message: This blynk-cloud.com page can’t be found.
I see the data fine on the app, and would really like to implement the download function. Any idea what I’m doing wrong?
Thanks… the report widget works, although on my system (MAC, Excel) I have to import the CSV file into Word, then copy and ‘paste special’ into Excel. Direct import into Excel (specifying comma delimiter) gives a single row of question marks in boxes. Don’t know if there’s a simple fix for that?
Google doesn’t show me an ‘unpack’ function for .csv files. Just a lot of information on working with them in Python. If you can steer me in the right direction it would help me (and maybe others). Thanks