Probe Software Users Forum

Hardware => JEOL => Topic started by: Dominik on June 10, 2021, 10:02:19 PM

Title: JEOL Qualitative Spectra Export (bin conversion)
Post by: Dominik on June 10, 2021, 10:02:19 PM
Hello,

the JEOL software stores qualitative spectra in .qlw binaries that I can only read with the xqlw software. Is there a way to convert the files so I can import them to e.g., Excel?

 Thanks,  Dominik
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: NicholasRitchie on June 11, 2021, 10:05:05 AM
This GitHub repo has code to decode JEOL data files.

https://github.com/Bob620/xes_converter

I don't know who Bob620 is but Anette von der Handt might know.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Probeman on June 11, 2021, 10:08:04 AM
I don't know who Bob620 is but Anette von der Handt might know.

That would be Noah Kraft, who indeed works with Anette.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Brian Joy on June 11, 2021, 11:29:59 AM
Hello,

the JEOL software stores qualitative spectra in .qlw binaries that I can only read with the xqlw software. Is there a way to convert the files so I can import them to e.g., Excel?

 Thanks,  Dominik

Hi Dominik,

It's very easy.  Just open the wavelength scan (or set of scans) in xqlw, then select File > Export, choose an output folder, select the format you want (e.g., "Data & Axis [mm]"), and check the "all" box.  This will give you output as a csv file (or set of csv files).

Brian

P.S.  You can add the deadtime correction prior to exporting by selecting Operate > Calculate > Correct Dead Time.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Dominik on June 12, 2021, 12:52:29 AM
This GitHub repo has code to decode JEOL data files.

https://github.com/Bob620/xes_converter

I don't know who Bob620 is but Anette von der Handt might know.

Thanks. I'll check this.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Dominik on June 12, 2021, 12:53:33 AM
Hello,

the JEOL software stores qualitative spectra in .qlw binaries that I can only read with the xqlw software. Is there a way to convert the files so I can import them to e.g., Excel?

 Thanks,  Dominik

Hi Dominik,

It's very easy.  Just open the wavelength scan (or set of scans) in xqlw, then select File > Export, choose an output folder, select the format you want (e.g., "Data & Axis [mm]"), and check the "all" box.  This will give you output as a csv file (or set of csv files).

Brian

P.S.  You can add the deadtime correction prior to exporting by selecting Operate > Calculate > Correct Dead Time.

Hi Brian,

thanks – I've seen that, but I have quite a lot I want to export which would make this quite a tedious way.

 Best,  Dominik
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: glennpoirier on June 14, 2021, 07:42:16 AM
Hi Dominik,
You can open the qlw files in ImageJ (import raw, 64 bit, little-endian ) and save them as text images. You can get the size and conditions from the cnd file associated with each spectrum.
If you're handy with imageJ macro language it shouldn't take a huge amount of work to export a pile of spectra. You can start with the batch processing macro https://imagej.nih.gov/ij/macros/BatchProcessFolders.txt (https://imagej.nih.gov/ij/macros/BatchProcessFolders.txt).

Cheers
Glenn
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Dominik on June 14, 2021, 10:52:04 PM
Thanks, Glenn, for the idea. I know only a little ImageJ, but some Python and would prefer to find a solution with this. I'm at it together with a student.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Mia Kraft on June 15, 2021, 01:30:47 PM
This GitHub repo has code to decode JEOL data files.

https://github.com/Bob620/xes_converter

I don't know who Bob620 is but Anette von der Handt might know.

Thanks. I'll check this.

That is correct, I am Bob620 (My old internet Username). I have recently changed my name from Noah to Mia though that is a different conversation.

The primary aim of the code in that repo is to export SXES data, that includes the QLW files you are looking at. I assume these file formats are the same because the majority of SXES software adapts existing spectrum software and formats that JEOL already had in place.

The `Next` branch has the most up-to-date code in it and it has a fairly complete `--help` function. Since it is written in Javascript it should work on any operating system as well. I am still doing active development on this code, though it has been slow as of late.

I am always open to providing help as needed, though the code is very incomplete it should do what you want. I can also provide a more detailed setup of the data structure of the QLW file.
Title: Re: JEOL Qualitative Spectra Export (bin conversion)
Post by: Dominik on June 17, 2021, 12:31:33 AM
That is correct, I am Bob620 (My old internet Username). I have recently changed my name from Noah to Mia though that is a different conversation.

The primary aim of the code in that repo is to export SXES data, that includes the QLW files you are looking at. I assume these file formats are the same because the majority of SXES software adapts existing spectrum software and formats that JEOL already had in place.

The `Next` branch has the most up-to-date code in it and it has a fairly complete `--help` function. Since it is written in Javascript it should work on any operating system as well. I am still doing active development on this code, though it has been slow as of late.

I am always open to providing help as needed, though the code is very incomplete it should do what you want. I can also provide a more detailed setup of the data structure of the QLW file.
[/quote]

That's great, thanks! I'll try and contact you via email though this webpage.