07-19-2012 02:42 PM
Is it possible to convert HTML sequence reports to other formats?
07-20-2012 11:48 AM
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.
07-23-2012 08:44 AM - edited 07-23-2012 08:49 AM
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
07-23-2012 08:59 AM
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
07-23-2012 09:13 AM
@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...
07-25-2012 11:12 AM
The desired format is XML.
07-25-2012 11:15 AM
Configure>>Report Options..
Set the Report Format: to XML Document
Change the Stylesheet: to report.xsl
Regards,
07-27-2012 02:28 AM
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