Once you have created an aggregated list of test results, you can generate an Excel spreadsheet by using commands in the Windows PowerShell session on the Controller or test server. Generate an Excel spreadsheet from the aggregated results Instead, use a different name for each test pass. Additionally, because all test results are merged, running multiple test runs with the same TestPassIdentifier attribute name value could create inconsistent results reporting. Because of this if any of the required tests were never run, the aggregated list of tests results will show that a required test was not run.
#How to get data analysis on excel lab report full#
The aggregated list of test results (C:\temp\merged.xml) includes information for the full list of tests, not just the filtered list of tests. dir -s "c:\temp\*.hlkx" | Merge-HwCertTestCollectionFromPackage -ValidationXmlPath "C:\temp\master.xml" | Export-HwCertTestCollectionToXml -Output "C:\Temp\merged_1.xml" -TestPassIdentifier "TP003"ĭir -s "c:\temp\*.hlkx" | Merge-HwCertTestCollectionFromPackage -ValidationXmlPath "C:\temp\master.xml" | Export-HwCertTestCollectionToXml -Output "C:\Temp\merged_2.xml" -TestPassIdentifier "TP004" hlkx output files from the Windows PowerShell session that is open on your Controller or test server is shown. dir -s "c:\temp\*.xml" | Merge-HwCertTestCollectionFromXml -ValidationXmlPath "C:\temp\master.xml" | Export-HwCertTestCollectionToXml -Output "C:\Temp\merged_1.xml" -TestPassIdentifier "TP003"ĭir -s "c:\temp\*.xml" | Merge-HwCertTestCollectionFromXml -ValidationXmlPath "C:\temp\master.xml" | Export-HwCertTestCollectionToXml -Output "C:\Temp\merged_2.xml" -TestPassIdentifier "TP004" In both examples, the use of the master.xml file is optional. An example of how you can merge XML-based test results from the Windows PowerShell session that is open on your Controller or test server is shown. There are two ways to aggregate the list of test results for a project. You can then analyze the aggregated results in Excel. Using Management Tool PowerShell command, you can generate the aggregated list of test results for the project.