Is it possible for a PowerShell script to read the .tclogx file (TestComplete's output file)

Question

I have multiple Jenkins jobs which trigger TestComplete test scripts which generates the .tclogx files. Each test have sub-tests within them. I'm working on consolidating the results of these tests in an excel sheet.&nbsp;&nbsp;Is it possible for a PowerShell script to read the .tclogx file (TestComplete's output file)? Or is there any other application which can do that?&nbsp;My requirement is to read the TestComplete test script execution log after script completes. I need few details from the file's log statements and then I want to put those values in an excel file. Please provide your valuable suggestions.&nbsp;Example:If my testcomplete log contains below statements:Validation1: PASSValidation2: FAIL&nbsp;Then I want to read this file and generate an excel report:Test Scenario&nbsp; &nbsp; Test Case&nbsp; &nbsp; &nbsp; &nbsp; Status1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Validation1&nbsp; &nbsp; &nbsp;PASS1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Validation2&nbsp; &nbsp; &nbsp;FAIL2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Validation1&nbsp; &nbsp; &nbsp;PASS2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Validation2&nbsp; &nbsp; &nbsp;FAIL

nish_b · Answer

Thank you Emma and Marsha for your suggestions and responses. I will work on these ideas and come up with the best one suitable for my project's needs. If I have any further query, I will start another thread 🙂&nbsp;

ebarbera · Answer

Hi&nbsp;nish_b&nbsp;-&nbsp;
&nbsp;
I dont believe that powershell would be able to read the&nbsp;&nbsp;.tclogx file because this is specific to TestComplete. That being said - I would suggest exporting your results to a more generic format, the available option for TestComplete would be JUnit.&nbsp;
&nbsp;
Here is some information on how to save the test results to a specific format from a script:&nbsp;https://support.smartbear.com/testcomplete/docs/reference/project-objects/test-log/log/saveresultsas.html
&nbsp;
Let me know if you have further questions.&nbsp;
&nbsp;
Cheers,&nbsp;
Emma

ebarbera · Answer

nish_b&nbsp;
&nbsp;
On further thought - you could also use the write to excel operation and skip a middle step all together, during your test you could write the values to the excel file so there would be no post processing required.&nbsp;
&nbsp;
https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/write.html
&nbsp;
Cheers,&nbsp;
Emma

marsha_r · Answer

nish_b&nbsp;Here are all the different formats that you can export a log to and examples of how to do it.&nbsp; Hopefully one of this will be useful for you.
&nbsp;
https://support.smartbear.com/testcomplete/docs/testing-with/log/working-with/exporting/index.html

sonya_m · Answer

Thanks for helping, everyone!
&nbsp;
Hi nish_b! Could you let us know which approach you used?&nbsp;

Forum Discussion

Is it possible for a PowerShell script to read the .tclogx file (TestComplete's output file)

Related Content

How to run a powershell script from TestComplete with parameters ?

Powershell Get-ItemProperty

Running powershell file as admin from JS

Execute a Powershell using Groovy test step

Getting PowerShell Return Code

Recent Discussions

Onscreen Object Selector Slowness

aqObject.CheckProperty() slowness

Problem with generated data table and keyword test

WebView2 support does not work

System checks for Object for every test