Introduction

This section will teach you the different ways you can export data from an experiment.

Data Export

Data can be exported from every table that contains data by using the Export… button located at the bottom right on the screen of any analysis module containing data. To export select the Export… button, an export file dialog will appear as shown below:

image alt text

Data can be exported in 2 different ways.

Character Separated Variable (.csv)

Data can be exported as an editable csv file that can be opened with most spreadsheet based programs. When opening a .csv file you will be prompted on how you wish the software to open your file as shown below.

image alt text

The exported data will usually have the exact same columns as the data displayed in the table, with the column header on the first row of exported data. However some tables display multiple items of data in one column on screen - for example the type and quantity of a target. In these cases, a single column on-screen may be exported as multiple columns in the CSV file. These columns will be named the same as the column on screen, but with an additional description in square brackets appended to the end - for example “Type [Quantity]”. All the data is still present in the CSV file.

Opening CSV Data in Excel

The CSV files exported by the software use Tab and/or comma characters to separate data in the file, and use full stops for the decimal separator, for example “3.1415”. On some systems and with some locale settings Excel will not import this data correctly. For example in some regions commas “,” are used as the decimal separator.

Data can be imported correctly by using the following procedure.

In Excel, create a blank worksheet, or open the worksheet you wish to import data into. Now select the “DATA” tab on the ribbon control towards the top of the window:

image alt text

Click the “From Text” button to start importing text (CSV) data, and select the CSV file you wish to import. The following dialog will be displayed:

image alt text

Make sure that the “Delimited” option is selected as shown, then click “Next >”:

image alt textMake sure that the “Tab” and “Comma” checkboxes are ticked, and other checkboxes are not ticked, then click “Next >”:

image alt text

Make sure that the “General” option is selected, then click the “Advanced…” button:

image alt text

In the smaller dialog that is displayed, make sure that “Decimal separator” is set to a full stop “.”, and leave “Thousands separator” blank. Click “OK”, then “Finish” in the larger dialog. A final dialog will be displayed:

image alt text

Select where you would like the data to be imported and click “OK” to complete the import process.

The next time you import, the settings should already be correct, and so you will just need to click “Next >” until you reach the final dialog, then click “OK” to complete.

Portable Document Format (.pdf)

Data can also be exported as an un-editable .pdf format that can be opened using a .pdf reader.

Real-time PCR Data Markup Language (.rdml)

The Real-time PCR Data Markup Language (RDML) is a structured and universal data standard for exchanging quantitative PCR (qPCR) data. The data standard should contain sufficient information to understand the experimental setup, re-analyse the data and interpret the results.

The data standard is a compressed text file in Extensible Markup Language (XML) and enables transparent exchange of annotated qPCR data between instrument software and third-party data analysis packages, between colleagues and collaborators, and between authors, peer reviewers, journals and readers.

See http://www.rdml.org/

Note that part of this data export is handled by the analysis modules:

the sample setup and thermal profile is always exported, but if you want to export amplification data you should add an auto quant analysis, and if you want to export melting data you should add an auto Tm calling analysis.