Auto Export TestSuite Results to an External File
Hello,
I am attempting to automate the export of result data from test suite runs to a file. I am realy only interested in the Test Step OK or failure and the response time that gets output to the TestSuite Log. Really all I need is to know whether the test step passed or not and what the response time for each test step was, and log that data to an external file, preferably .csv or .xls.
The following log output is really all im looking for:
[findItemsAdvanced] finished with status [FINISHED], time taken = 747
[findItemsByCategory] finished with status [FINISHED], time taken = 162
[findItemsByKeywords] finished with status [FINISHED], time taken = 468
In Fact, Ideally I want to log two columns for each test Case, 1 for the status (Finished or failed) and the second for the timeTaken
I have explored the possibility of achieving this by using a DataSink and Property Transfer, but unless I am completely missing some point, it seems as though this will only gather the "Response" data returned from the request, and does not provide a method to export the result and response results from the log window.
Of course I could manually run off a report, but then I would have to manually perform this task for each test suite, then manually harvest the data from that report and publish it to my target location, which would not work for my situation. Ive tried to find some way to add reports sirectly into the suite as test steps to run automatically but have come up short on that as well.
Am I just missing something in the DataSink PropertyTransfer method or is there some other method best suited for this task?
Any help is greatly appreciated.
Thanks.
I am attempting to automate the export of result data from test suite runs to a file. I am realy only interested in the Test Step OK or failure and the response time that gets output to the TestSuite Log. Really all I need is to know whether the test step passed or not and what the response time for each test step was, and log that data to an external file, preferably .csv or .xls.
The following log output is really all im looking for:
[findItemsAdvanced] finished with status [FINISHED], time taken = 747
[findItemsByCategory] finished with status [FINISHED], time taken = 162
[findItemsByKeywords] finished with status [FINISHED], time taken = 468
In Fact, Ideally I want to log two columns for each test Case, 1 for the status (Finished or failed) and the second for the timeTaken
I have explored the possibility of achieving this by using a DataSink and Property Transfer, but unless I am completely missing some point, it seems as though this will only gather the "Response" data returned from the request, and does not provide a method to export the result and response results from the log window.
Of course I could manually run off a report, but then I would have to manually perform this task for each test suite, then manually harvest the data from that report and publish it to my target location, which would not work for my situation. Ive tried to find some way to add reports sirectly into the suite as test steps to run automatically but have come up short on that as well.
Am I just missing something in the DataSink PropertyTransfer method or is there some other method best suited for this task?
Any help is greatly appreciated.
Thanks.
