Change Logged Data Formating

[TonyJ]

Group,

     Below is an excerpt of a logged test we use.  Notice that data is logged from top to bottom.  What I would like to do is create a unique report that lists results much like an Excel file with headings in the top row, limits in the second row and results in the following rows.  Working with data in the current format is very difficult to parse for use in data analysis for process validation and monitoring.  Much of the data provides little or no use for us, like Comparison Type, Module Time etc. Any suggestions on how to address this? 

Tony

****************************************
UUT Report
Test Socket Index:            6
Serial Number:                89WACDM152291090
Date:                         Sunday, November 13, 2005
Time:                         5:51:27 PM
Operator:                     administrator
Execution Time:               355.9513667 seconds
Number of Results:            142
UUT Result:                   Passed
****************************************

Begin Sequence: MainSequence
(C:\DelphiTestSystem\ITS Functional\Models\BlackTie.seq)

Valid Model check:             Passed
Initialize time:               Done
Measure Front Spkr Shield:     Passed
     Measurement:              5.8
     Units:                    ohm
     Limits:
        Low:                   0.0
        High:                  100.0
     Comparison Type:          GELE (>= <=)
     Unit:                     ohm
     Module Time:              0.0005833
Measure Rear Spkr Shield:      Passed
     Measurement:              6.1
     Units:                    ohm
     Limits:
        Low:                   0.0
        High:                  100.0
     Comparison Type:          GELE (>= <=)

     Module Time:              0.0005832

[TonyJ]

I'm using TestStand 3.0.

Tony

[nandini · Accepted solution]

Hi Tony:

You can manipulate the report you are generating using the folloiwng techniques.

1. You can manipulate the reportgen_xml.seq, reportgen_html.seq or the reportgen_txt.seq files. These store information on how the report is configured and formatted. The files are called at run time but can be manipulated at development time. They are located at C:\Program Files\National Instruments\TestStand 3.0\Components\NI\Models\TestStandModels location. In order that the process models use the repoertgen_xxx.seq file of your format choice, you need to set report options. You can do this by going to Configure>>Report Options>>Sequence report generator for generating the report body.

2. If you go to your process model and select the Test Report sequence, you can set a breakpoint at the End Group step at the end of this sequence. You will then see the entire report text being generated in the Parameters.Report section. You can manipulate the text here too using operators and functions in the expression browser.

Please let me know if you have any further questions.

Thank you
Nandini
NI