The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP Functional Testing / Mercury QuickTest Pro / QTP

Pages: 1
arifur
Member


Reged: 08/02/11
Posts: 33
How to export QTP print log into Excel
      #682933 - 08/23/11 01:18 PM

Hi,
I wanted to export the QTP "PRINT" log (used for debugging) into Excel and use specific color for the failed operation. Can anyone please help?

Thanks


Post Extras: Print Post   Remind Me!   Notify Moderator  
EAGLES
stranger


Reged: 08/15/06
Posts: 603
Loc: Other side of the Computer
Re: How to export QTP print log into Excel [Re: arifur]
      #682937 - 08/23/11 01:29 PM

have you tried anything? next time play around a bit.

so in Print Screen, Right-click and [Select All]
Then Right-Click and [Copy]
now paste into Excel

for specific color, Write a macro or do a Find & Replace with a format.

--------------------
===========================================


Post Extras: Print Post   Remind Me!   Notify Moderator  
chikki
Super Member


Reged: 12/12/05
Posts: 1283
Loc: USA
Re: How to export QTP print log into Excel [Re: EAGLES]
      #682997 - 08/24/11 05:15 AM

check in the your Temp folder the print log file resides
from where you can copy the contents and paste it to excel.

--------------------
------------
Chikki
when things gets harder ,the harder gets going


Post Extras: Print Post   Remind Me!   Notify Moderator  
arifur
Member


Reged: 08/02/11
Posts: 33
Re: How to export QTP print log into Excel [Re: chikki]
      #683048 - 08/24/11 08:40 AM

Hi,
Thanks for the reply. Actually I want to do it using QTP through script...not manually...Please suggest


Post Extras: Print Post   Remind Me!   Notify Moderator  
EAGLES
stranger


Reged: 08/15/06
Posts: 603
Loc: Other side of the Computer
Re: How to export QTP print log into Excel [Re: arifur]
      #683051 - 08/24/11 08:43 AM

instead of doing print write to a file.

so open file using filesystem object and write.Line message

make it as cvs and you have different column in excel

--------------------
===========================================


Post Extras: Print Post   Remind Me!   Notify Moderator  
arifur
Member


Reged: 08/02/11
Posts: 33
Re: How to export QTP print log into Excel [Re: EAGLES]
      #683053 - 08/24/11 08:53 AM

Hi,
Actually the scenario is: there are like around 50 checkpoint in one single application and I have more than 10 different Applications. When I'm running those in batch all the print logs appear together. I want to export all those print logs and export in excel.


Post Extras: Print Post   Remind Me!   Notify Moderator  
mehlerr
Member


Reged: 08/27/08
Posts: 152
Re: How to export QTP print log into Excel [Re: arifur]
      #683059 - 08/24/11 09:18 AM

I don't think it can be exported programmatically. Try adding the window to your OR and use "GetRoProperty("text")" You can then write it into a csv file...color coding you'd need to do within excel.

Post Extras: Print Post   Remind Me!   Notify Moderator  
arifur
Member


Reged: 08/02/11
Posts: 33
Re: How to export QTP print log into Excel [Re: mehlerr]
      #683064 - 08/24/11 09:43 AM

Hi,
QTP does not allow to add print log in OR. When I ity to add it, it dissapears...


Post Extras: Print Post   Remind Me!   Notify Moderator  
EAGLES
stranger


Reged: 08/15/06
Posts: 603
Loc: Other side of the Computer
Re: How to export QTP print log into Excel [Re: arifur]
      #683106 - 08/24/11 01:45 PM

try this.

strPrint = Window("regexpwndtitle:=QuickTest Print Log").WinEditor("nativeclass:=Edit").GetROProperty ("text")

Save to filesystem object.

--------------------
===========================================


Post Extras: Print Post   Remind Me!   Notify Moderator  
Tarun LalwaniModerator
Veteran


Reged: 07/21/05
Posts: 15329
Loc: Milwaukee, Wisconsin
Re: How to export QTP print log into Excel [Re: EAGLES]
      #683989 - 09/02/11 11:32 AM

As Eagles pointed you can use that code to get the text and then use FSO and write it a file with XLS extension. Then you need to open it with Excel COM API and later post-process the same to add colors as well

--------------------
Regards,
Tarun
** First ever technical novel - And I thought I knew QTP! **
** Download QTP Unplugged 2nd Edition eBook for FREE **

KnowledgeInbox RSS


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 64 anonymous users are browsing this forum.

Moderator:  IanFraser, Rajkumar_Rajangam, thorwath, TReddy, AJ, Tarun Lalwani, mwsrosso 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 3477

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5