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
Community Leader

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

Occasional Contributor

Re: Reporting and automation

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

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 Expert Group]
____
[Community Expert Group] members 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. Postings made by [Community Expert Group] members
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.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================
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
[Community Expert Group]
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
Extensions available
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 Expert Group]
____
[Community Expert Group] members 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. Postings made by [Community Expert Group] members
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.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================
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:
Watch the new Interview
Top Kudoed Authors