CSV file format

Need Help With My Project
1

When csv file is transferred to mail via report option the values are not same as it record in blynk.
when we convert it to excel values are changed what it shows in blynk.
plz resolve

2

If you read the documentation for the SuperChart widget it explains about how data is stored within the Blynk server database. What it says is this:

Superchart supports currently 2 types of granularity:

  • Minute granularity - 1h , 6h , 1d ;
  • Hour granularity - 1w , 1m , 3m ;

This means that minimum chart update interval is 1 minute for 1h , 6h , 1d periods. 1 hour for 1w , 1m and 3m periods. 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.

This actually applies to all widget data stored in the database, whether SuperChjart is used or not.

So, what’s happening is that if you send data say every 5 seconds to a widget, it is buffered and averages over a 1 minute period before being written to the database.

Does this explain the results you are seeing?

Another possible issue is how you’ve chosen to display the data in Excel. If you have a value with multiple decimal places then display it in a column that isn’t wide enough to show all of the data then Excel will round the data to however decimal places that van be shown in that width of column.

If none of these things explain the results you are seeing then please provide more information about the values you’re seeing in the app, and provide an example of the raw data you’re receiving by email.

Pete.

3

Thanx mr peteknight for reply

Actually I measure data from 3 sensors namely heart rate, Spo2 and temp.
While sending file to CSV format and then opened it in MS-Excel the value of heart beat temp is changed. In display it shows perfect but in excel it shows some garbage value in decimal.
sending the csv file through “reports” (under other) widget box.

4

I think you need to increase your knowledge of data formatting in Excel.

Pete

5

Dear sir
I tried all sort of formatting techniques but the result remain same

6

Post some raw data here then, just a few lines.

Pete.

7

Dear sir
CSV is not able to attach in this.

8

I know that, which is why I asked you to copy and paste a few lines of the file here.

Pete.