Subscribe to SoftLogica
Newsletter to get 10% discount on newly
released products!
New Test Scenario Wizard
CSV Files
You can adjust WAPT to save test results in
CSV format and import them later, any time you wish to Microsoft®
Excel. For this, check the Save results to option in Log
and Report Settings and specify a location for saved CSV files
(or use the default location). Then for each user profile, a file with
test results will be created.
If you haven't enabled the Save results to option before test run,
you can save test results as CSV files manually after test completion.
For this, click the Save Results button
on the program toolbar and select CSV (Comma delimited) (*.csv)
as file type.
CSV reports are raw results of test run.
You can process these results, for example, make graphs in Microsoft® Excel.
CSV reports look as follows:
The number of rows in CSV report is equal to run time/refreshing
time value, where run time is specified in Test
Volume view, and refreshing time is set in Log
and Report Settings. Refreshing time is the period after which WAPT
refreshes generated graphs and reports during test run. As refreshing
time passes, the program adds a new row to CSV report. Each row
shows the data gathered during the previous refreshing time period.
Default value of refreshing time is 10 seconds.
You can change this value in Log and Report Settings.
However, you cannot make it less than 10 seconds; you can only increase it.
If you see that values displayed in columns of CSV report exhibit sharp fluctuations,
most probably refreshing time is small for your test, and the server cannot execute an
adequate number of requests during this time.
You should increase the refreshing time to get correct results.
Note that the less is refreshing time, the more resources of test machine will be
required.
CSV reports are full results of test run. They represent all data
gathered during the test. This differs them from Summary Report
and HTML Report, which store only part of results according to
HTML report dimension value.
(Test duration interval is divided into the number of intervals equal
to HTML report dimension value. The program calculates the averaged data
through these intervals and shows it in HTML Report and Summary
Report.)
on the program toolbar and select CSV (Comma delimited) (*.csv)
as file type. 
