Ask a Question

Reporting and automation

dagb60bear
Occasional Contributor

Reporting and automation

I am looking at solutions for reporting.  I need to import my test complete checkpoint pass fail results into an existing word .docx format.   I only need to filter out the pass/fail checkpoints and import into the word document.  We are trying to automate our test reporting process.  

6 REPLIES 6
LinoTadros
Community Hero

Implement Events like OnLogError and OnLogMessage and others... to directly report the status of the test to a Word Document using COM Automation "Sys.OleObject(Word.Application")"

From there you can create a document and write to it from your events directly.

 

Hope that helps

-Lino

dagb60bear
Occasional Contributor

I have a word doc could i put those results into my table using odbc

Hi,

 

> using odbc

No, this is not possible because test results in TestComplete are not stored in database tables.

https://support.smartbear.com/testcomplete/docs/testing-with/log/working-with/from-tests.html help article may provide you with some ideas.

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
tristaanogre
Esteemed Contributor

While @AlexKaras  is TECHNICALLY correct, if you want to do the work, you could use direct ADO SQL queries to insert records into SQL tables.  So, it's possible, but you'd have to write the ADO/SQL code.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

Hi,

 

Just to clarify:

I have a word doc could i put those results into my table using odbc

I got this question this way: "Can I get test results out of TestComplete's test log (using ODBC?) and insert them into existing table in the Word document (using ODBC?) ?"

 

My answer was based on the above understanding and for sure may appear to be incorrect if I got the question wrong.

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
TanyaYatskovska
SmartBear Alumni (Retired)

Thanks for the help, Leaders!

 

@dagb60bear, which solution did you decide to use? Please share it with us.

 

 

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager



cancel
Showing results for 
Search instead for 
Did you mean: