NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to convert HTML sequence reports to other formats?

Is it possible to convert HTML sequence reports to other formats?

0 Kudos
Message 1 of 8
(3,187 Views)

Once the report is created and the execution completed then all you have is what you see: an HTML document.  You could create some sort of parser to read it back into TestStand and have TS create some dummy results that will populate another report but you would be on your own with that.

 

I am not aware of a converter that is out there.

 

Anyhow, it doesn't look like there's an easy way to do this.

jigg
CTA, CLA
testeract.com
~Will work for kudos and/or BBQ~
0 Kudos
Message 2 of 8
(3,169 Views)

I had a project a few years ago where I converted 10s of thousands of TestStand HTML files from TS 1.0 and 3.0.

 

Most of what I did is specific to our internal data structures, but I'll try to help get you started.

 

The general idea is to pick out the report header and data sections from each file, then eliminate the HTML formatting.

 

The attached file will extract the Report Header and data sections.

 

To use this, you will need to download this additional VI that I posted here in the regex board a few years ago.

 

http://forums.ni.com/t5/BreakPoint/Regular-Expressions-Board/m-p/1269088#M14343

 

Here is one more file that will parse out each data record and dtermine it's Name, status, type value, limits and duration/timestamp info


 

 

 

 

 


Now is the right time to use %^<%Y-%m-%dT%H:%M:%S%3uZ>T
If you don't hate time zones, you're not a real programmer.

"You are what you don't automate"
Inplaceness is synonymous with insidiousness

Download All
0 Kudos
Message 3 of 8
(3,154 Views)

While it is good to post file parsing code here, i just want to ask the OP:

What is the desired file format?

 

The simplest answer would look like: Hey, reconfigure TS to create exactly the desired file format (e.g. XML).....

 

Norbert 

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
Message 4 of 8
(3,150 Views)

@Norbert_B wrote:

While it is good to post file parsing code here, i just want to ask the OP:

What is the desired file format?

 

The simplest answer would look like: Hey, reconfigure TS to create exactly the desired file format (e.g. XML).....

 

Norbert 


Great point! This was the first post to the NI forums by the OP, guess I should have looked closer at the profile.

 

Selecting an appropriate report format is the obvious choice; customizing / modifying one of the 'out of the box' is not a trivial thing...


Now is the right time to use %^<%Y-%m-%dT%H:%M:%S%3uZ>T
If you don't hate time zones, you're not a real programmer.

"You are what you don't automate"
Inplaceness is synonymous with insidiousness

0 Kudos
Message 5 of 8
(3,146 Views)

The desired format is XML.

0 Kudos
Message 6 of 8
(3,116 Views)

Configure>>Report Options..

Set the Report Format: to XML Document

Change the Stylesheet: to report.xsl

 

Regards,

jigg
CTA, CLA
testeract.com
~Will work for kudos and/or BBQ~
0 Kudos
Message 7 of 8
(3,113 Views)

Please that XML in TestStand reports only contain the information for the report. The layout (formatting) information is contained in the "style sheet". NI is providing three different style sheets as examples, "Report.xsl" being one of them.

 

If the display doesn't look as desired, the first step is to verify/change the style sheet.

 

Norbert 

Norbert
----------------------------------------------------------------------------------------------------
CEO: What exactly is stopping us from doing this?
Expert: Geometry
Marketing Manager: Just ignore it.
0 Kudos
Message 8 of 8
(3,095 Views)