Define External Format Dialog Box

This dialog box enables you to define a new file format for external data files not supported by Analysis.

The Define External Format dialog box is divided into mandatory and optional information.

To access

Tools > External Monitors > Import data > File Format > <Custom File Format>

Relevant tasks

How to Define Custom File Formats

Mandatory tab

User interface elements are described below:

UI Element Description
Date Column Number

Enter the column that contains the date. If there is a master column (see Supported File Types), specify its number.

Time Column Number

Enter the column that contains the time.

Use Master Column

Select this if the data file contains a master column. A master column specifies the row's particular breakdown of a more general measurement.

File Extension

Enter the file suffix.

Field Separator

Enter the character that separates a field in a row from its neighbor. To select a field separator character, click Browse and select a character from the define Field Separator dialog box.

Back to top

Optional tab

User interface elements are described below:

UI Element Description
Date Format

Specify the format of the date in the imported data file. For example, for European dates with a 4 digit year, choose DD/MM/YYYY.

Time Zone

Select the time zone where the external data file was recorded. LoadRunner Analysis aligns the times in the file with local time zone settings to match LoadRunner results. (LoadRunner does not alter the file itself).

Machine Name

Specify the machine name the monitor runs on. This associates the machine name with the measurement.

Exclude Columns

Indicate which columns are to be excluded from the data import, such as columns containing descriptive comments. When there is more than one column to be excluded, specify the columns in a comma-separated list. For example, 1,3,8.

Convert file from UNIX to DOS format

Monitors often run on UNIX machines. Check this option to convert data files to Windows format. A carriage return (Ascii character 13) is appended to all line feed characters (Ascii character 10) in the UNIX file.

Skip the first [] lines

Specify the number of lines at the start of the file to ignore before reading in data. Typically, the first few lines in a file contain headings and sub-headings.

Back to top