save spreadsheet data to every row

[Steven69]

I have developed a vi that receives pollution data from sensors for monitoring vehicle exhaust emissions.  Every thing seems to be fine except when I try to save the data to spreadsheet (using Write Characters To File.vi), the data is witten to every other row when I open my .csv file .  Can anybody shed any light as to why this is happening as I have been pulling my hair out for over a week now to no avail.

[Dennis_Knutson]

duplicate post

[Steven69]

Sorry Dennis,

You can imitate the sensing device using data1.csv and COM1 Serial WriteA.vi , the data is then saved to DATARECORD.csv

OK I had problems sending .csv so I have converted to .txt

[Dennis_Knutson]

I think that what is happening is that with every other iteration, the shift register that you have wired to the Append True/False String is passing an empty string to your GET RELEVENT String Data.vi and you are getting an array with that in it. The Array to Spreadsheet will then just generate an EOL character.

[Steven69]

Hi Dennis,

I removed the shift register but the problem persisted,  however I have overcome the problem by saving the entire data set (elements)  transmitted by the sensors from the output of the Append True/Faslse String. 

I shall investigate further why the problem happens when I try to save only the relevent elements from the data set.

Thanks for your help

Steven