TEST 1:
check files like /Users/yourid/indigo/INDIGOplotD/sql/1062219179-Temperature
open with any editor !!but DO NOT SAVE or change!!
they should look like:
- Code: Select all
99;20160707164625;23.0
102;20160707164755;23.1
107;20160707164925;23.3
112;20160707165055;23.5
115;20160707165226;23.6
check for gaps
TEST 2
the please check file :
- Code: Select all
/Users/userid/indigo/INDIGOplotD/data/day.dat.formatted
and or minute day ...
is some what better formatted than the real data file in columns...
check if there are data holes.
It should look like this:
- Code: Select all
20180301145500 18;3;0;0;0; 179; 0.5000;no-data; 4074.9; 196598;58140.2; 98.700; 0.0000; 71.600; 92.400; 0.0000; 0.0000; 0.0000; 64.200; 0.0000; 166.00; 3.5250; 636.32; 636.32; 0.0000; 0.0000; 0.0077; 72.500; 72.500; 72.500; 0.0000; 510.84; 0.0156; 13.327; 99.400; 69.800; 1020.0; 1.0000; 73.000; 47.000; 1020.8;-77.000;no-data;no-data; 55.833;-72.500; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301150000 17;3;0;0;0; 180; 0.5000;no-data; 4317.9; 212571;64581.9; 98.700; 0.0000; 71.600; 92.400; 0.0000; 0.0000; 0.0000; 64.500; 0.0000; 150.59; 3.3000; 699.84; 699.84; 0.0000; 0.0000; 0.0077; 72.500; 72.500; 72.500; 0.0000; 508.62; 0.0156; 13.327; 99.400; 69.800; 1020.3; 1.0000; 72.900; 47.000; 1021.0;-77.000;no-data;no-data; 55.833;-72.500; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301150500 17;3;0;0;0; 181; 0.5000;no-data; 2936.9; 138671;40426.0; 99.000; 0.0000; 71.600; 92.500; 0.0000; 0.0000; 0.0000; 64.220; 0.0000; 197.00; 4.3000; 699.84; 699.84; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 508.62; 0.0156; 3.8368; 99.400; 69.800; 1020.4; 1.0000; 72.900; 47.000; 1021.1;-77.000;no-data;no-data; 55.833;-74.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301151000 20;3;0;0;0; 182; 0.5000;no-data; 3721.3; 180624;53857.1; 98.800; 0.0000; 71.600; 92.300; 0.0000; 0.0000; 0.0000; 64.100; 0.0000; 179.75; 3.2750; 643.96; 643.96; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 515.29; 0.0156; 3.8368; 99.500; 69.800; 1020.3; 1.0000; 73.000; 46.000; 1021.2;-77.000;no-data;no-data; 55.833;-74.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301151500 13;3;0;0;0; 183; 0.5000;no-data; 3104.5; 149837;44320.7; 98.800; 0.0000; 71.600; 92.300; 0.0000; 0.0000; 0.0000; 64.467; 0.0000; 188.54; 3.6000; 643.96; 643.96; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 515.29; 0.0156; 1487.3; 99.367; 70.000; 1020.5; 1.0000; 73.200; 46.000; 1021.3;-77.000;no-data;no-data; 55.833;-74.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301152000 14;3;0;0;0; 184; 0.5000;no-data; 2285.0; 106128;29695.9; 98.800; 0.0000; 71.600; 92.500; 0.0000; 0.0000; 0.0000; 64.000; 0.0000; 146.07; 2.9200; 643.52; 643.52; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 509.90; 0.0156; 1487.3; 99.600; 70.000; 1020.5; 1.0000; 73.400; 45.000; 1021.3;-92.000;no-data;no-data; 55.900;-72.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301152500 17;3;0;0;0; 185; 0.5000;no-data; 2567.8; 120459;35060.7; 98.900; 0.0000; 71.600; 92.500; 0.0000; 0.0000; 0.0000; 64.000; 0.0000; 157.29; 3.0600; 643.52; 643.52; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 509.90; 0.0156; 944.70; 99.600; 69.800; 1020.5; 1.0000; 73.200; 46.000; 1021.2;-86.500;no-data;no-data; 55.900;-76.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
20180301153000 21;3;0;0;0; 186; 0.5000;no-data; 2096.0;97861.6;27602.6; 98.933; 0.0000; 71.600; 92.300; 0.0000; 0.0000; 0.0000; 63.740; 0.0000; 149.81; 3.6600; 671.69; 671.69; 0.0000; 0.0000; 0.0077; 72.700; 72.700; 72.700; 0.0000; 1011.1; 0.0156; 944.70; 99.600; 69.900; 1020.7; 1.0000; 73.200; 46.000; 1021.4;-89.000;no-data;no-data; 55.900;-76.000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000; 0.0000;no-data;no-data;no-data;no-data;
a whole rows with" no-data;" would indicate something is wrong .. some fields in-between with "no-data" is ok.
if test 1 is wrong sql export is wrong or there is no data ; if test 2 is wrong something in the plugin is wrong
mine looks fine.. need some more details
Karl