01-26-2015 08:25 AM
Hi All,
Not sure this is the right board for this question but I'm trying to import a TS report in xml format into MS Excel. I'm importing without the stylesheet as an xml table and all appears ok initially but then on closer inspection a lot of the <value> tags are missing from the import, but not all. Anyone got any idea why this might be?
Thanks in advance,
Nick
01-27-2015 03:19 AM
01-28-2015 12:23 PM
Hi Soloman,
Thanks for your quick reply. Any TS report in xml format will show the problem. For example if you run any sequence in single pass mode and then look at the xml report in a text editor you will see the UUT serial number tag and the value tag for this is empty <value></value>. If you then import this into excel there will be no column for the value of the UUT serial number. This may well be what you would expect, but if you now modify the report in the text editor and put any number inside the value tags and import again there will still be no column for the UUT serial number value. You will see value columns further into the report though. It is truley weird.
Thanks,
Nick
01-29-2015 03:38 AM
01-30-2015 01:23 AM
Hi Soloman,
The report I generate is fairly large, in the region of 12500 results, there are various values throughout the report that do not appear but there does not appear to be any pattern to this that I can see. I cannot import with the stylesheet as our IT policy here does not allow us to enable scripts when importing files into excel.
Thanks for your help with this,
Nick
02-06-2015 04:35 AM
Hi NickStorton,
Thanks for explaining the scenario to me, it has cleared up a few things. It seems that it boils down to the fact that certain values do not appear and you want to amend the report so they are apparent and documented correctly. I have found a community example of someone how has developed a call back that can be added to your XML report to get the values you require.
Community Example : https://decibel.ni.com/content/docs/DOC-12617
In this example the person has managed to reference two local variables one of which was Locals.SerialNumber, so I believe you would be able to implement the same concept. There is a more detailed description of the example with relevant knowledge base articles. Please have a read and let me know whether this will be suitable for yourself.
Best Regards,
Soloman