Export Chromatogram as CSV (time vs. response - not peak reports)

Hello,

Unfortunately, this functionality has not yet been added to the OpenLAB CDS 2.x software product. It has already been logged as a feature request for upcoming revisions.

I am not sure if this will be helpful to you, but there is an add-on available for OpenLAB CDS 2.2 that will allow you to export the data in an AIA or .ch format.

How might I get this add-on to export to AIA and/or CH files?

From my understanding, one of them (or both) will have everything I need to accomplish my goal. 

You should have access to this add-on in your lab's subscribenet account. It will be listed under 'OpenLAB Add-ons' as the 'Data Export Add-on for OpenLAB CDS 2.2 Download Only'.

And yes, both an AIA or .ch file would contain the raw x,y data. You would just need an appropriate software product to export send that to a .csv file.

Hello, we have the exact same question about exporting raw chromatograms as .csv files for data analysis. However, our OpenLAB CDS version is 2.3 instead of 2.2, so we couldn't install the add-on mentioned in your post (the installation gave an error saying that the add-on is only for OpenLAB CDS 2.2). Could you suggest an alternative way to convert from .d to AIA or .ch file? Thank you very much.

Hello,

These features are actually built-in with the 2.3 release. You just need to select the appropriate export plug-in in your processing method, like shown in the below screenshots:

Let us know if you have any questions.

Thanks for your quick reply! We will give it a try.

Hi,

I am currently facing the same issue, can export the data as AIA or .ch and was wondering if you could maybe point me to a software that could now convert an AIA or .ch file into .csv? That would be of immense help!

Thank you!

Hi,

I use a tool I found online, netcdf4excel, and did a little programming on it. The installer will add a DLL to your system (VbNc.dll) and copy some files into the installation directory (normally C:\Program Files (x86)\CDF4Excel), after that you can run the Excel file, CDF4Excel.xlsm. It is a macro-containing Excel file and you need to enable macros.

In the Add-Ins section you will find a drop-down with the name "CDF Tools".

Click "Open CDF File" and do just that, there is an example.cdf file in the installation directory. A new Excel file will open and on the first tab you will find some general information, especially the actual_run_time_length and the actual_sampling_interval.

You will need that to generate the time coordinate (X), the signal or ordinate_value (Y) is on the tab "point number".

It works for me and I hope it will for you too.

Regards

PS: Sorry a DLL wasn't installed, I fixed the installer

Hi,

I use a tool I found online, netcdf4excel, and did a little programming on it. The installer will add a DLL to your system (VbNc.dll) and copy some files into the installation directory (normally C:\Program Files (x86)\CDF4Excel), after that you can run the Excel file, CDF4Excel.xlsm. It is a macro-containing Excel file and you need to enable macros.

In the Add-Ins section you will find a drop-down with the name "CDF Tools".

Click "Open CDF File" and do just that, there is an example.cdf file in the installation directory. A new Excel file will open and on the first tab you will find some general information, especially the actual_run_time_length and the actual_sampling_interval.

You will need that to generate the time coordinate (X), the signal or ordinate_value (Y) is on the tab "point number".

It works for me and I hope it will for you too.

Regards

PS: Sorry a DLL wasn't installed, I fixed the installer

Hi noreuter. I am trying to get data from ".ch" files and your post is perfect for me. The question is: How do I load a ".ch" instead of the ".cdf" file or how do I convert ".ch" file into ".cdf" file? because the macro only reads ".cdf" files. Kind regards.

Hi dubang69,

unfortunately you cannot, at least with this tool. The .CH format of a FID channel and the open netCDF format are totally different.

There are two way to do the conversion: number one is load the .CH in Chemstation software and export it as CDF or use the open source software OpenChrom, that can read multiple file formats and export them directly to xy files.

There is a discussion in Reddit where someone offers a Matlab script to do the conversion, but I never tried it. Maybe the discussion helps.

And finally there is a Python script that might be able do it at PyExpLabSys (PyExpLabSys.file_parsers.chemstation), but I didn't try that either.

Success.

PS: Here are two Matlab scripts for .D/.MS/.CH and .CDF import I just found.

Hi dubang69,

Im also using export to CDF in OpenLAB 2.3 and OpenLAB 2.2 (with Data Export Addon).

Unofrtunatelly second step for these revisions is to open CDF in some open source software as noreuter recommends. Im using lightweight utility UniChrom and export to .CSV

For 2.2 it works for FID and DAD data

For 2.3 it works for FID, DAD and MS TIC data as well.

If you would like to export MS Spectra to XY, you can send spectra from OpenLAB CDS to NIST MS SEARCH and export it to .jdx format which contains abundance for masses.

Reagrds,

Majkee