Export Options

Contents Previous Next

Use the Options/Export page to set up the way ASCII files are saved. There are also options to determine whether you are prompted for an export filename, and whether you are prompted before an existing export file is overwritten. These options can be found with the general options.

Temprecord can also export directly to a Microsoft Excel spreadsheet. See the topic Copying data to Clipboard and Excel for more information.

Field Delimiter

This determines the character used to separate items on each line when the file is written. You can choose from a space, a comma, a tab character, or a semicolon. Choose whichever option suits the application that will be reading the ASCII file. If you will be importing the file into a spreadsheet such as Excel or Lotus 123, comma-separated values are normally used. If you will be importing data into a Microsoft Word table, use tabs.

ASCII Filetype

Use this option to set the default filetype used when the temperature data is written to a file.

Columns

Use this option to specify how many columns are written to the ASCII file. If this value is set to 1, the file will consist of a single column of values, one per line. If you do not want any line breaks in your file, set this to 99999.

Averaging

Use this option to specify how many samples are averaged before a value is written to the ASCII file. If this field is set to 1, no averaging is performed, and the 'raw' temperature values are written to the file. If this field is set to (say) 10, then a set of 10 temperatures is averaged and the mean value written to the file. In this case, there would be one tenth the number of values in the exported file - i.e. if the original .TRX file contained 2000 samples then the exported file would contain 200 values.

Temprecord always rounds the exported values to 2 decimal places. This means the average temperature may not agree with the average as calculated by other means, e.g. a spreadsheet.

As an example, if you have a sample record of 8 samples and Temprecord is set up to average every 2 values :

Sample	Value	Actual Average	Value Exported
1	30.31	30.315	30.32
2	30.32
3	30.32	30.33	30.33
4	30.34
5	30.35	30.355	30.36
6	30.36
7	30.37	30.38	30.38
8	30.39

Here, the values for the first 2 samples are 30.31, and 30.32. The actual average is 10.315 but Temprecord exports the value rounded to 2 decimal places, i.e. 30.32.

The averaging functions built into Temprecord exporting make it relatively easy to generate a report of daily temperature averages. See Exporting daily average temperatures for more information.

Date Format

Use this option to specify how the date is written to the ASCII file, if at all. The format chosen will depend on how your application requires date and time information to be formatted.

•'No date' specifies that no time or date information is to be written. The temperature values will be written to the file without any preceding time and date information.

•'Use local setting' specifies that the date and time are to be written in the format as selected with the 'International' settings in Windows' Control Panel.

•'MM:SS' specifies that the time is written in that format, e.g. 12:34. The date is not written.

•'HH:MM:SS' specifies that the time is written in that format, e.g. 11:12:34. The date is not written.

•'Seconds since 1980' specifies that the time and date are written as an integer being the number of seconds that have passed since midnight on January 1, 1980.

•'Days since 1900' specifies that the time and date are written as an floating point value being the number of days that have passed since midnight on January 1, 1900. The integer part of this value gives the number of days, the fractional part gives the time as a fraction of a day. This format is normally the one most suitable for exporting data to spreadsheets such as Microsoft Excel or Lotus 123.

Quoted Text

Check this option if you want all text in written annotation to be surrounded by quotes. Some applications require that text be differentiated from numerical data in this way when they import data.

Summary

Check this option if you want the summary written to the ASCII file as well. The summary includes information such as the user data, the comment fields and their associated labels, the number of samples etc.

Values

Check this option if you want the individual sample values to be exported. If this option is checked, the sample values corresponding to the specified sample range are written to the file.

Turn this option off if you want the sample values and nothing else in the exported file.

Markers

Check this option if you want the those data values with associated markers to be indicated as such when they are exported. If this option is checked, those samples with associated markers will be written to the file with an appended ‘*’ character.

Turn this option off if the application you are using to analyse the exported data has trouble with the extra characters appended to the sample values.

General Statistics

Check this option if you want the general statistics to be exported. The statistics exported always pertain to those between the start and end samples. It is not affected by the sample range setting described below.

TTV Statistics

Check this option if you want the results of the Total Temperature Value (TTV) statistics calculations to be exported. If this option is checked, the TTV results as displayed in the statistics view are written to the export file.

Turn this option off if you do not want the TTV statistics in the exported file.

The ‘Show TTV Statistics’ option (on the Statistics Options tab) must be checked in order for the TTV statistics to be exported.

When the field delimiter is set to a non-space character, extra delimiters are inserted when the TTV totals are exported. This is so that the totals will align properly with the individual TTV period data and column headers when the exported file is imported into a spreadsheet

MS Access TTV Statistics

Check this option if you want the results of the Total Temperature Value (TTV) statistics calculations to be exported in a format more suitable for importing into Microsoft Access or Microsoft Excel.. If this option is checked, the TTV results as exported as a series of rows as shown in the following example:

"Serial No","Sample Period","Start Sample","Start Sample DateTime","TTV Period","Periods Specified","Periods Shown","Period Number","TTV Below","TTV Above"

"S2222849","60","1","4/03/1997 17:20:36","0.041667","5","5","1","0","186"

"S2222849","60","1","4/03/1997 17:20:36","0.041667","5","5","2","0","663"

"S2222849","60","1","4/03/1997 17:20:36","0.041667","5","5","3","10","0"

"S2222849","60","1","4/03/1997 17:20:36","0.041667","5","5","4","0","990"

"S2222849","60","1","4/03/1997 17:20:36","0.041667","5","5","5","0","861"

The first line is only exported if the Include Header Row option is checked. To import in MS Access you should have a table defined with field names the same as those shown above. Each line will then be imported as a single record in the table.

The ‘Show TTV Statistics’ option (on the Statistics Options tab) must be checked in order for the MS Access TTV statistics to be exported, and the Show Brief TTV Statistics option must not be checked.

PHI Statistics

Check this option if you want the results of the PHI (Process Hygiene Index) statistics calculations to be exported. If this option is checked, the PHI results as displayed in the statistics view are written to the export file.

The ‘Show Growth Statistics’ option must be checked in order for the PHI (Process Hygiene Index) statistics to be exported.

Rate of Cooling Statistics

Check this option if you want the results of the Rate of Cooling (ROC) statistics calculations to be exported. If this option is checked, the ROC results as displayed in the statistics view are written to the export file.

The ‘Show Rate of Cooling Statistics’ option must be checked in order for the ROC statistics to be exported.

Sample Range

Use this option to specify what samples are written to the ASCII file. This option only has an effect when the Values export option is checked.

'Entire Record' specifies that all samples read from the currently loaded Temprecord file or the logger are to be written to the ASCII file (or averaged and then written to the file, if Averaging is set to a value other than 1).

'Visible Window' specifies that only those samples displayed in the current Temprecord data graph view window are to be written to the ASCII file (or averaged and then written to the file, if 'Averaging' is set to a value other than 1).

'From Start to End Markers' specifies that only those samples between the start and end samples are to be written to the ASCII file (or averaged and then written to the file, if 'Averaging' is set to a value other than 1).