Import Data dialog box
This dialog box enables you to import and integrate non-Micro Focus data files into an Analysis session.
Tools > External Monitors > Import Data
User interface elements are described below (unlabeled elements are shown in angle brackets):
|Import data from the following files||
Displays the files that you selected for import.
Select an external data file to import. A dialog box opens to enable you to select files.
Delete an external data file from the list.
Open an external data file using the associated application.
Set the file format options.
Select the time zone where the external data file was recorded. Analysis compensates for the various international time zones and aligns the times in the file with local time zone settings in order to match LoadRunner Professional results. If the times in the imported file are erroneous by a constant offset, you can synchronize the time.
|<Synchronize with scenario start time>||
Time Zone also contains the option <Synchronize with scenario start time>. Choose this to align the earliest measurement found in the data file to the start time of the LoadRunner Professional scenario.
Specify the machine name the monitor runs on. This associates the machine name with the measurement. For example, a file IO rate on the machine
Opens the Advanced Settings dialog box, enabling you to define data format settings that differ from those of the regional configuration.
Select Use custom settings and define your settings:
|Truncate imported data to 150% of scenario runtime||
In certain cases, the external monitor may have collected data over a time period that was larger than the actual load test. This option deletes data that was collected while the load test was not running, limiting the data collection period to 150% of the load testing period.
The following file types are supported:
NT performance monitor (.csv)
The default file type of the NT performance monitor, in comma separated value (CSV) format.
Reported on \\WINTER
Time: 10:06:01 AM
Data: Current Activity
Interval: 1.000 seconds
,,% Privileged Time,% Processor Time,% User Time,
03/06/15,10:06:00 AM , 0.998, 1.174, 0.000,
03/06/15,10:06:00 AM , 0.000, 0.275, 0,000,
Windows performance monitor (.csv)
The default file type for the Windows 2000, 2008 server, Windows 7, etc. performance monitor, in CSV format.
Standard comma separated file (.csv)
This file type has the following format:
date, time, measurement_1,measurement_2, ...
where fields are comma separated and first row contains column titles.
The following example from a standard CSV file shows 3 measurements: an interrupt rate, a file IO rate and a CPU usage. The first row shows an interrupt rate of 1122.19, an IO rate of 4.18, and a CPU busy percentage of 1.59:
date, time, interrupt rate, File IO rate, CPU busy percent
Master-Detail comma separated file (.csv)
This file type is identical to Standard Comma Separated Files except for an additional Master column which specifies that row's particular breakdown of a more general measurement. For example, a Standard CSV file may contain data points of a machine's total CPU usage at a given moment:
However, if the total CPU usage can be further broken up into CPU time per-process, then a Master-Detail CSV file can be created with an extra column ProcessName, containing the name of a process.
Each row contains the measurement of a specific process's CPU usage only. The format will be the following:
as in the following example:
date, time, process name, CPU used, elapsed time used
Microsoft Excel file (.xls)
Created by the Microsoft Excel application. The first row contains column titles. (.xlxs format is not supported.)
Created by Microsoft's Excel application. The first row contains column titles. It contains an extra Master column. (.xlxs format is not supported.)