Offline Data Analysis with TSW1200 GUI

Hi,

The read CSV file option is there to allow you to import data from some external capture into the TSW1200 User Interface, but the feature must be used with careful attention to detail.  Any error in the format of the CSV file and the feature will not work. 

The best way to make sure the CSV file is constructed properly is to save a CSV file from the TSW1200 and look at the contents of the file.  Then edit this file to put *your* sample data in place of the sample data that was there and leave everything else alone.

The TSW1200 User Interface was written in Labview, and all the noise analysis revolves around an internal cluster of data types that define what the software needs to know, such as sample frequency, input frequency, number of points, the sample data, the device type and format of the data, and what channel is being looked at.  The TSW1200 user Interface was written to support up to eight-channel ADCs, and therefore there are 8 arrays of sample data in the cluster.  When the software saves a binary file, this whole cluster is saved to a file which can be read back again later.  But when saving a comma-separated value, only the eight data arrays are saved. 

if you open a saved CSV file (such as the sample csv file i have attached) with a simple text editor like Wordpad or Notepad, you will see data saved in offset binary decimal format, as in something like:

Channel 1, 131

889

132

(bunch of lines of sample data, followed by)

130

891

131

890

Channel 2,

Channel 3,

Channel 4,

Channel 5,

Channel 6,

Channel 7,

Channel 8,

In this example, the saved data was in the first array of data for channel 1 and the other 7 data arrays have no sample data.

To edit in *your* sample data, replace the sample data in the CSV file only and leave the other text alone.  Keep all the Channel n, text, where n is for channel 1 through 8.  Keep the comma after the Channel n text, and don't add any other commas, either.  The Labview code for reading inthe CSV file is doing a pattern match to look for the text strings and commas that you see in the CSV file.

Since the csv file does *not* save things like sample rate or device type, you would want to open the TSW1200 software, preset the device selection, sample frequency, input frequency, number of samples, and channel selection to the desired values, and *then* load the properly edited CSV file.

So again, as you can see, this process is not user-firendly but it is possible.  In the future, we will try to make this process easier to do but for the moment this is what must be done to make it work.

Regards,

Richard P.

Hi Richard,

thanks for your reply. the answer you suggested is *exactly* what i did yesterday. I added "Channel 1, [first value] in the first line of a csv file and i got it working.

but is it right, that you have to have the TSW board connected to the software to import any data? somehow it doesn't work without connecting the tsw1200 ...

(sorry the software *does* work without the TSW1200 board connected - i just made a mistake).

But:

are there any drivers for windows 7? although everyone here could install the software but no one was able to find a working driver for the tsw1200 board up to now (for windows 7). This makes data capture hard on windows 7.

regards, mikael