Generating SumoLogic friendly Text log file (or informative XML files)

Question

Hi,
We are planning to automate our test runs and reporting.
We will be running our test in commandline and exporting the logs.
We will be using SumoLogic to display all our logs.
SumoLogic needs the logs to be in.log format. (or XML)
I have used to /ErrorLog:"C:\ErrorLogs\ProjErrors.log" command to generate an error file whenever there is any error.
However, Sumologic is unable to read this log file as it does not contain timestamp.
Appreciate if someone can help me how to get timestamp on the errorlog.
Also if I can generate any other error file(.log or .xml format) which would be able to give a proper informative log in the SumoLogic dashboard, that would be great !
&nbsp;
Thanks a lot in advance

alexkaras · Accepted Answer

Hi,
&nbsp;
https://support.smartbear.com/testcomplete/docs/testing-with/log/working-with/from-tests.html might provide some useful info/code samples.
&nbsp;

baxatob · Answer

Hi,
&nbsp;
The standard TestComplete log file contains datestamp, but in Unix (Epoch) format. So you&nbsp;should&nbsp;perform some conversions to use it for your needs.&nbsp;
&nbsp;
Anyway your requirement looks like&nbsp;rather complex task to the moment. You need a script, which will find a proper xml data among all log files, parse data, make all required conversions, make correct structure etc...

tristaanogre · Answer

Rather than generating from a commandline, consider using Log.SaveResultsAs.&nbsp; Add that code to the very end of your project and indicate to save the file as XML.&nbsp; Reference.&nbsp;https://support.smartbear.com/testcomplete/docs/testing-with/log/working-with/exporting/about.html#xml

tristaanogre · Answer

As for containing errors, the Log.SaveResultsAs generates ALL the data that is in the TestComplete log.&nbsp; So, if there is an error logged, it will contain that error.&nbsp; Again, you will need to parse the information out as it doesn't show up "neat" as strictly errors.&nbsp; You will need to look for that information.&nbsp;&nbsp;AlexKaras&nbsp;link might help with that.

shantlk · Answer

Hi Alex,
Thank you for the link. I was able to generate a customized log by modifying the given sample code.
Thanks a lot everyone for their help too.
&nbsp;
below is a peice of my script which I used to get the timestamp and the log message for each row of the test log.
&nbsp;
&nbsp;# Checks the data type of the log data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if LogDataType == ldtTable:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Obtain the total number of rows in the dataset&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Num = DataSet.RowCount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for i in range(0, Num):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Row = DataSet.Rows[i]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Obtai the time of the current row &amp; write this to the log file&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TimeVal = Row.ValueByName["Time"]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ExportFile.WriteLine(aqConvert.VarToStr(TimeVal)) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Obtain the message of the current row &amp; write this to the log file&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgVal = Row.ValueByName["Message"] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ExportFile.WriteLine(aqConvert.VarToStr(MsgVal))
&nbsp;

alexkaras · Answer

shantlk:
&nbsp;
Hi,
&nbsp;
Thank you for sharing your solution here. Hopefully, it will help others who may have similair question.
&nbsp;

Forum Discussion

Generating SumoLogic friendly Text log file (or informative XML files)

8 Replies

Related Content

Generate JSON Schemas

How to hide Model Information

Generating a schema for a generic list in c#

Upload Test Cycle Information

Generating report

Recent Discussions

Searching for mapped object took too much time msg

Multiple execution of a test plan with different values from an Excel table

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support