cancel
Showing results for 
Search instead for 
Did you mean: 

Reporting and automation

Highlighted
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
Highlighted
Community Hero

Re: Reporting and automation

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

Highlighted
Occasional Contributor

Re: Reporting and automation

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

Highlighted
Community Hero

Re: Reporting and automation

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
================================
Highlighted
Community Hero

Re: Reporting and automation

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
Highlighted
Community Hero

Re: Reporting and automation

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
================================
Highlighted
Community Manager

Re: Reporting and automation

Thanks for the help, Leaders!

 

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

 

 

---------
Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
A new challenge is here!

Create a function to drag one element to another for the TechCorner tag!

Will you dare to take the challenge?


Scripts created in July:
- Passing custom command-line arguments as a test parameter
Top Kudoed Authors