Do most DSOs export CSV files?

Thread Starter

spinnaker

Joined Oct 29, 2009
7,830
Can you post an example of an export of your calibration port when you get a chance? I want to see if it is similar to mine. No rush.


I am considering a SDS1202X-E myself.
 

OBW0549

Joined Mar 2, 2015
3,566
Can you post an example of an export of your calibration port when you get a chance? I want to see if it is similar to mine. No rush.
I'll do it tomorrow. Gotta read the user's manual first to figure out how.

I am considering a SDS1202X-E myself.
So far, after playing around with it for an hour or so, I'm pleased.

EDIT: I found out that even my ancient Tektronix TDS1001B (≈10 years old) scope will save .CSV files. I suspect the capability is near-universal anymore.
 

OBW0549

Joined Mar 2, 2015
3,566
OK, I figured it out. I'm not going to post the entire file (67 MB), here's just the header info and the first few readings. The filename is test.csv.
 

Attachments

Thread Starter

spinnaker

Joined Oct 29, 2009
7,830
OK, I figured it out. I'm not going to post the entire file (67 MB), here's just the header info and the first few readings. The filename is test.csv.

Finally had a chance to look at this.

Was this the file as it was output from your scope? If so, it looks like their CSV file creator is a little buggy. Notice that that CH1 Volt appears over the time column.

upload_2017-11-3_22-47-50.png


Mine is different. I don't have any of that header information at the top. I have negative values for time that is left of the center vertical gradient. It also looks like they are including one time entry for each channel which is really dumb imho. Can you try 2 channels to see if you get similar results with duplicate readings?

upload_2017-11-3_22-56-5.png
 

Thread Starter

spinnaker

Joined Oct 29, 2009
7,830
I think I figured out what is going on with the Rigol. It is actually outputting any noise too.

upload_2017-11-3_23-22-35.png

I did a quick chart in Open Office.

upload_2017-11-3_23-24-12.png
 

OBW0549

Joined Mar 2, 2015
3,566
Was this the file as it was output from your scope?
Yup, other than the fact that I deleted all but the first few data records to reduce the file size.

If so, it looks like their CSV file creator is a little buggy. Notice that that CH1 Volt appears over the time column.
MS Excel on my MacBook renders it correctly:

Excel_view.png

This is the actual contents of the file, as viewed in a plain ASCII text editor (BBEdit):

BBEdit_view.png

I noticed there is a leading space before each data record; maybe that is what's causing your spreadsheet program (OpenOffice?) to insert an extra column?

Mine is different. I don't have any of that header information at the top. I have negative values for time that is left of the center vertical gradient. It also looks like they are including one time entry for each channel which is really dumb imho.
Those aren't duplicate entries for each time point; it only looks that way because of how your spreadsheet is formatting the numbers for display. Try specifying a format with more significant digits.
 

Thread Starter

spinnaker

Joined Oct 29, 2009
7,830
Yup, other than the fact that I deleted all but the first few data records to reduce the file size.


MS Excel on my MacBook renders it correctly:

View attachment 138636

This is the actual contents of the file, as viewed in a plain ASCII text editor (BBEdit):

View attachment 138637

I noticed there is a leading space before each data record; maybe that is what's causing your spreadsheet program (OpenOffice?) to insert an extra column?
Sounds like a bug in Open Office then. What if you wanted a leading space? It should have handled it like a string.


Those aren't duplicate entries for each time point; it only looks that way because of how your spreadsheet is formatting the numbers for display. Try specifying a format with more significant digits.
Yeah pointed out in another thread. I should have looked at the raw data. I feel dumb. But Calc really should have some kind of warning that not all data is displayed.
 

OBW0549

Joined Mar 2, 2015
3,566
But Calc really should have some kind of warning that not all data is displayed.
Excel doesn't have any such warning, either, because it's really not necessary: people usually understand that numbers are displayed according to cell formatting preferences, and generally will NOT be an exact representation of the underlying data. You pick the display format that best suits your purpose, and that may not be the default format.
 
Top