madavi-api
madavi-api copied to clipboard
CSV data files have more fields in data rows than in header row
Time;durP1;ratioP1;P1;durP2;ratioP2;P2;SDS_P1;SDS_P2;Temp;Humidity;BMP_temperature;BMP_pressure;BME280_temperature;BME280_humidity;BME280_pressure;Samples;Min_cycle;Max_cycle;Signal 2017/10/15 00:02:04;;;;;;;19.23;10.80;;;16.50;79.40;;;;;;592692;242;27774;-61
Header row indicates 20 fields; data rows have 22. The two additional fields are between the SDS_P2 and Temp values, which are adjacent in the header. As a result, a correction is needed to parse the files.
I am not sure where this discrepancy comes from. data_simple.php, which writes the files, looks fine:
Line 35, writing 20 header fields
fwrite($outfile,"Time;durP1;ratioP1;P1;durP2;ratioP2;P2;SDS_P1;SDS_P2;Temp;Humidity;BMP_temperature;BMP_pressure;BME280_temperature;BME280_humidity;BME280_pressure;Samples;Min_cycle;Max_cycle;Signal\n");
Line 60, writing 20 fields per data row
fwrite($outfile,$now.";".$values["durP1"].";".$values["ratioP1"].";".$values["P1"].";".$values["durP2"].";".$values["ratioP2"].";".$values["P2"].";".$values["SDS_P1"].";".$values["SDS_P2"].";".$values["temperature"].";".$values["humidity"].";".$values["BMP_temperature"].";".$values["BMP_pressure"].";".$values["BME280_temperature"].";".$values["BME280_humidity"].";".$values["BME280_pressure"].";".$values["samples"].";".$values["min_micro"].";".$values["max_micro"].";".$values["signal"]."\n");