Problem exporting CVS file History Graph

Solved
1

Hello, when I ask CSV export from History Graph in the blynk application the file will arrive in the email.

I was expecting to see de values in the excel with the format:

Data, Time (in unixtime).

The thing is that Time variable sometimes is present and sometimes not.
The Data shoul be

1825
1698
1482

but appear a huge number like this:

18.250.267.647.058.800,00
16.981.783.529.411.700,00
1.482.645.625,15

Any hint ?

Many Thanks
Leandro

2

Hello. Please show attachment you get in email

3

This is the content of the attachment

17.070.761.249.999.900,00
18.250.267.647.058.800,00
16.981.783.529.411.700,00
1.482.645.625,15
17.620.967.058.823.500,00
7.075.620.000.000.000,00
6.070.085.624.999.990,00
15.626.277.647.058.800,00
15.111.960.000.000.000,00
17.242.654.166.666.600,00
14.986.178.571.428.500,00
17.579.806.666.666.600,00
16.727.665.999.999.900,00
16.449.690.769.230.700,00
17.341.035,15
15.500.504.999.999.900,00
11.295.816.363.636.300,00
17.765.060.833.333.300,00
17.734.820.000.000.000,00
1.822.731,15
2.306.337.529.411.760,00
23.346.322.666.666.600,00
239.468.375,15
19.089.259.375.000.000,00
5.618.906.000.000.000,00
6.164.575,15
18.865.274.444.444.400,00
21.901.327.777.777.700,00
287.250.405.882.353,00
26.664.337.647.058.800,00
25.152.202.222.222.200,00
26.608.131.666.666.600,00
2.731.788.388.888.880,00

This is a print screen from the app

Screenshot_2017-06-20-20-10-07.jpg478×677 55.9 KB

4

@lsobrino please attach file itself.

5

@lsobrino csv you sent me is correct. Look like you have the problem in representing it. Here is what you sent me:

1707.0761249999998,1497996960000
1825.0267647058824,1497997020000
1698.1783529411766,1497997080000
1482.645625,1497997140000
1762.0967058823533,1497997200000
6

Dmitry thanks for your help. You are right!!!
I had a bad script uploading the data. It works perfect now !

Regards,
Leandro

1 Like
7