cancel
Showing results for 
Search instead for 
Did you mean: 

Export Message Logs to Excel?

Highlighted
New Contributor

Export Message Logs to Excel?

I want to run a project made up of KTs. Some of these KTs will log a value to a Message Log. I would like to export ONLY the contents of the Message Logs in a format that Excel can use.

 

I've been trying to write all the Message Logs to one location using Append Log Folder, but I can't get this to work. Is this even the right aproach?

 

(Sorry if this seems like a basic question, but I've been scouring the online docs and contacting tech support for a couple days now and I'm not making much headway.)

 

Thanks!

Tags (1)
4 REPLIES 4
Highlighted
Community Leader

Re: Export Message Logs to Excel?

Hi,

 

What you're describing is as possible.


Creating an Excel file with TestComplete is a piece of cake but the operations you write about will be easier for you if you leave the base operations of TestComplete and create the object with logs yourself.

 

For example, when you use Log.Message() t create a new object in the code and save this message to a separate memory unit as well -> then after the test, format the data and display what you want! :)'

 

If you need an example of data formatting, let me know (just give at least a sample of your data)

Highlighted
Community Leader

Re: Export Message Logs to Excel?

use csv, work well with excel and its as simple as a text file

Un sourire et ça repart

Highlighted
Community Leader

Re: Export Message Logs to Excel?

and back to your question.


"with the Append Log Folder, but I can't run it. Is this even a proper aproach?"


I'm using it to organize the results of the SQL query. A single folder for a single query with all information about it... so I think this is a good solution, but not quite good for solving your problem.


What programming language do you use in the script? Have you thought about using .json files before?

Highlighted
Community Manager

Re: Export Message Logs to Excel?

Thank you for advice BenoitB, Wamboo!

 

Hi @CliffYoung ! Please let us know if the suggestions helped.


Sonya Mihaljova
Community and Education Specialist

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
New Here?
Join us and watch the welcome video:
Announcements
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!

Challenge Status

How to execute remote test and obtain results via Test Runner REST API

Participate!

Comparing content of HTML table with Excel file data

Participate!

Compare HTML table with Excel file and correct data in the file

Participate!

Retrieve Data from a Web Page

Participate!