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

Recommendations for Training on Automating WinForms Applications Using TC

Unexpected Window Event Handler

TestExecute not able to launch Edge & Chrome browser

Assistance with Handling Print Dialog Overlap in TC

WebView2 support does not work