Export of data

All data exports are done in the CSV format, which can be opened or used in spreadsheet and/or computing software.

Important

Exported data use the , character as separator, and characters are duplicated to prevent escape issues. Depending on the language of your operating system, some software, like Microsoft Excel, may need to be configured in order to correctly parse the CSV files generated from visionCATS.

Note

With the exception of the export of the peaks table, data exports are only available on visionCATS installations having the Export data option.

Peaks table export

You can export the peaks in the Integration tab by clicking on the button exportpeaks. The function always exports the currently detected peaks of the currently selected step/wavelength(s)/track(s) and for the currently configured integration parameters.

Following properties are exported:

  • Wavelength : wavelength or illumination of the track to which the peak belongs

  • Track: track number of the track to which the peak belongs

  • Max Rf: Rf position where the maximum value of the peak is reached

  • Height: maximum value of the peak

  • Start Rf: position where the peak starts

  • Start height: value where the peak starts

  • End Rf: position where the peak ends

  • End height: value where the peak ends

  • Area: area of the peak computed by integrating the values between the start and the end positions

  • Assigned substance (if available)

Substance assignment export

The substance assignment export is similar to the peaks table export, but it only exports the peaks assigned to a substance.

Profile data export

Exporting the selected profile data (single or multi-track, single or multi-wavelength) is possible for Scanner profiles and for profiles generated from a Visualizer image.

The data are ordered by wavelength, by track and then by Rf position.

The following properties are exported:

  • Wavelength: wavelength or illumination of the track (not available in Manual Control)

  • TrackNumber: track number

  • RfValue: Rf position

  • Luminance: raw luminance as measured by a Scanner instrument, or average value of the (R,G,B) channels for profiles generated from a Visualizer image

  • R: Red channel (only for profiles generated from a Visualizer image)(not available in Manual Control)

  • G: Green channel (only for profiles generated from a Visualizer image)(not available in Manual Control)

  • B: Blue channel (only for profiles generated from a Visualizer image)(not available in Manual Control)

Raw profiles export

You can export the raw profiles in Data View and in the Manual Control part of a Scanner instrument with the button exportprofiles.

Integrated profiles export

The data are exported with the application of the parameters currently set (all integration parameters, selected step, wavelengths/illuminations and track(s)). The exported CSV file contains the following header metadata, separated by an empty line:

  • The plate layout parameters of the current analysis,

  • The sequence table with track number, vial, description, volume and application type,

  • The integration parameters defined.

You can export the integrated profiles in Integration with the button exportprofiles , in the expanded part of the Profiles viewer toolbar.

Spectrum data export

The spectrum data export is available in Manual Control tab of a Scanner instrument and in the Data tab.

Following properties are exported:

  • Substance: substance name

  • Track: track number

  • Rf: Rf position

  • Wavelength

  • Center : value measured by the Scanner at the center position

  • Leading : value measured by the Scanner at the leading (start) position (only available when purity is activated)

  • Trailing : value measured by the Scanner at the trailing (end) position (only available when purity is activated)

In the Data tab, the export inserts the following metadata at the beginning of the CSV file:

  • The plate layout parameters of the current analysis,

  • The sequence table with track number, vial, description, volume and application type,

  • The parameters of the spectrum scan step.