Help Exporting to csv

Hello,
Looking for guidance on how to export to csv… I have tried py recording but that is only for v1?? I tried right-click export and changing filename to .csv but this provides no useable data. Any assistance would be appreciated.
Thank you,

Hi @cherkey and welcome to the Joulescpoe forum! The Joulescope UI currently does not have a way to export full-rate sample data to CSV. We used to have this feature, but it was a support problem. Too many peaple saved long full-rate data captures to CSV and attempted to open with Excel. Unfortunately, Excel only supports 1,048,576 rows, or about 1 second of full rate JS220 data (0.5 seconds of JS110 data).

The proprietary but open-source JLS binary file format is specially designed to handle Joulescope data rates for long captures while allowing for super-fast read navigation including pan and zoom. The JLS file format is definitely not compatible with CSV text format.

You can record statistics data (defaults to 2 Hz, but the UI allows you to select up to 100 Hz) to CSV. Here is how:

Is statistics data fast enough for your application? If so, great!

If not, I have a few questions:

  1. How long of snippets are you looking to export?
  2. At what sampling frequency?
  3. What are you looking to do with this data?
  4. Why CSV file format?

Note: we also received issue report 20240206_154725_7852075.

Hi, @mliberty ,

I will look at the statistics method - I was recording at 100Hz anyway so this should be sufficient.
I’m doing several runs of various scenarios and I’m going to incorporate the data into one chart for visual comparison.
I’ll reply back with how it went with statistics.

Thank you

How are you generating the chart? Do you plan on using Excel?

If you are using python to generate the chart, you can load the JLS files directly using our pyjls package. See the pyjls.Reader.fsr method.

100 Hz is reasonable to what to export to CSV. You will be limited to:

1024 * 1024 / (100 * 60 * 60) => 2.9 hours

You can convert signales from your existing jls files to csv, too. After installing Python and pyjls, type:

python -m pyjls export --help

For example:

python -m pyjls export --signal current infile.jls outfile.csv

Hi @mliberty ,
The statistics output will provide what is needed.
Thank you,

1 Like