getting an error when trying to open .xml file in the report

[General-D]

We recently upgraded to TestStand 2012, and we are having trouble with the creating a readable report.   We have the results set to .xml.   Previously we were using TestStand 4.2 and we were able to convert the .xml to .xls using a stylesheet.  But this doesn't work now.   I’m getting an error – doesn’t have a top level element.   We installed TestStand 2012 using a new enterprise site license, and I wondering if we are missing something on the install.  I don't see any TestStand 2012 folder in the C:\Program Files\National Instruments\TestStand xxx.   Also is there a better way to create reports that are already converted to .xls, so that anyone can read the reports using excel?

Thanks, Dale

[snowpunter]

If you're using Win7 x64 then the folder will be in Program Files (x86) and not Program Files.

[dug9000]

---

@General-D wrote:

We recently upgraded to TestStand 2012, and we are having trouble with the creating a readable report.   We have the results set to .xml.   Previously we were using TestStand 4.2 and we were able to convert the .xml to .xls using a stylesheet.  But this doesn't work now.   I’m getting an error – doesn’t have a top level element.   We installed TestStand 2012 using a new enterprise site license, and I wondering if we are missing something on the install.  I don't see any TestStand 2012 folder in the C:\Program Files\National Instruments\TestStand xxx.   Also is there a better way to create reports that are already converted to .xls, so that anyone can read the reports using excel?

Thanks, Dale

---

I do not think TestStand ships with a stylesheet to do any such conversion, so I am assuming this is a custom stylesheet that you have either written or gotten from a 3rd party. It's possible something is formatted differently in the xml in TestStand 2012 that your stylesheet is not expecting. You might need to debug and modify your stylesheet to make it work with TestStand 2012.

There should be a TestStand folder. Perhaps you are on a 64-bit OS in which case the folder would be located at:

C:\Program Files (x86)\National Instruments\TestStand xxx

Hope this helps,

-Doug

[General-D]

My main question is:  Is there a way to create a report from TestStand that can be read from excel, and have the same formatting as the .xml report?   Every time we run a test, we have convert the .xml report to .xls using a stylesheet.  

[dug9000]

In TestStand 2012 you can write a result processing modelplugin which does this. There are some model plugin examples located in: <TestStandPublic>/Examples/ModelPlugins/

And there is documentation on the process models and model plugins.

A result processor can be written which directly processes teststand results into an .xls format. TestStand does not ship with a plugin that supports .xls though, you would need to write your own.

Hope this help,

-Doug