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 ALM / Mercury Quality Center

Pages: 1 | 2 | >> (show all)
min2
Member


Reged: 05/30/08
Posts: 25
I have developed excel based QC report generator
      #587000 - 08/21/09 09:28 PM

I have just finished developing an excel based tool which will generate report after fetching the data from QC,You just need to provide few information like QC URL, username,password, database,project and the test script path. A detailed report will be generated after that with pie graphs showing the number of pass and fail test cases and along with that a Bar graph showing number of test case executed by each user....

Just let me know will this tool be really useful in solving many of the purpose in testing and will act as a innovation in testing?... Please respond


Post Extras: Print Post   Remind Me!   Notify Moderator  
SurajJ
Advanced Member


Reged: 01/30/06
Posts: 496
Loc: Bengaluru
Re: I have developed excel based QC report generator [Re: min2]
      #587114 - 08/24/09 04:00 AM

Currently, we can generate Reports/Graphs using QC UI. So I just wanted to know what is the extra feature this tool have that QC doesn't have.

--------------------
Suraj


Post Extras: Print Post   Remind Me!   Notify Moderator  
mithuncts
Newbie


Reged: 08/24/09
Posts: 4
Re: I have developed excel based QC report generator [Re: min2]
      #587221 - 08/24/09 09:41 AM

Hello dear frnd,

i wanted to know more details on the excel based QC report generator. can you please share some information on this about how to do it, wat kind of report and how it will be benefecial for a Tester?

please do the needful...


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


Reged: 05/30/08
Posts: 25
Re: I have developed excel based QC report generator [Re: mithuncts]
      #588103 - 08/27/09 11:13 PM

The only advanatge of this tool is that you can get the recent status for all the test cases you wish too on a just single mouse click, so everytime for a new release you need not have to open the QC and select the test cases to find it's status, rather you can just on a mouse click this will give you the recent status of a test script like tester,time & date of execution,pass/fail and a graph also...

I think it can be useful for tester and they will be spared from opening QC everytime on their machine...

Let me know if you have any other queries on this.


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


Reged: 01/26/09
Posts: 33
Re: I have developed excel based QC report generator [Re: min2]
      #588524 - 08/31/09 10:01 AM

Hello,

I have seen above comments and i am interested in your tool can be please upload the tool in the forum so that i can download this and i can use the same.

And also do u have the same kind of tool which can upload the files (I mean do upload attachments to QC automatically after running the marco or by pressing a button in excel or word applicatons) to a selected test plan in execution grid > in the test lab module in Quality center. If so please provide me the tool.


Thanks in Advance
Thanks,
Krishna


Post Extras: Print Post   Remind Me!   Notify Moderator  
margani
Newbie


Reged: 01/12/07
Posts: 1
Re: I have developed excel based QC report generator [Re: min2]
      #588561 - 08/31/09 03:09 PM

I am interested in the tool .How can I download it?

Thanks
Marg


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


Reged: 05/30/08
Posts: 25
Re: I have developed excel based QC report generator [Re: margani]
      #588885 - 09/02/09 03:37 AM

If you want i can upload the tool here but I am not sure whether you can run it on your machine or not bcoz you need to add few libraries for it and currently i have protected the code using password, Just let me know if i can help you in anyway..

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


Reged: 05/30/08
Posts: 25
Re: I have developed excel based QC report generator [Re: min2]
      #588888 - 09/02/09 03:55 AM Attachment (494 downloads)

I have uploaded the screen shot of that tool, just take a look...

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


Reged: 05/30/08
Posts: 25
Re: I have developed excel based QC report generator [Re: min2]
      #588889 - 09/02/09 03:56 AM Attachment (356 downloads)

uploaded Screen shot of the Graph Tab of the tool.

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


Reged: 01/26/09
Posts: 33
Re: I have developed excel based QC report generator [Re: min2]
      #589431 - 09/04/09 11:54 AM

Hello there,

The tool looks great if u can upload the tool it would be very helpful and please mention what files need to be added for my library. And also do u have a automatic tool which can upload the files to test plan in the test lab module.

If so please help provide me the that tool also.


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


Reged: 01/26/09
Posts: 33
Re: I have developed excel based QC report generator [Re: uchihachaitu]
      #589477 - 09/06/09 11:39 AM

Hello,

I am waiting for ur attachment and also i forgot to ask that u whether this tool will work in office 2003 or not And please if u have a automatic tool which will upload the attachments to selected test plan in the test lab module.

Please do the needful thanks in advace.


Post Extras: Print Post   Remind Me!   Notify Moderator  
luv_mickey505
Newbie


Reged: 09/08/09
Posts: 8
Re: I have developed excel based QC report generat [Re: uchihachaitu]
      #589777 - 09/08/09 12:11 PM

hi min2,

can you also unprotect your code or copy code snippet to forum... It would be really helpful for us to modify/update the code as per our needs and formats which we use.

Regards,
Mickey


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


Reged: 05/30/08
Posts: 25
Re: I have developed excel based QC report generat [Re: luv_mickey505]
      #590274 - 09/10/09 08:35 AM

Okie friends i have jolt down everything here on this page:-

http://excelreportgeneratorusingqc.blogspot.com/


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


Reged: 01/26/09
Posts: 33
Re: I have developed excel based QC report generat [Re: min2]
      #590307 - 09/10/09 10:29 AM

Thanks for the URL but why dont u upload the Addin so that we can download. I think it will be easy for us other wise if we create the tool i think we might mess up with something wrong.

So please upload the Excel tool.


Post Extras: Print Post   Remind Me!   Notify Moderator  
luv_mickey505
Newbie


Reged: 09/08/09
Posts: 8
Re: I have developed excel based QC report generat [Re: uchihachaitu]
      #590571 - 09/11/09 12:42 PM

gr8 work...

Can you upload the tool too??? (with code unprotected so that we can customise it)

regards,
mickey


Post Extras: Print Post   Remind Me!   Notify Moderator  
QAAutomation
Advanced Member


Reged: 02/12/03
Posts: 542
Re: I have developed excel based QC report generat [Re: min2]
      #592850 - 09/24/09 09:23 AM

Quote:

Okie friends i have jolt down everything here on this page:-

http://excelreportgeneratorusingqc.blogspot.com/



Can you please upload this tool and instructions how to install & run it. Thanks!


Post Extras: Print Post   Remind Me!   Notify Moderator  
DeyanEnchev
Newbie


Reged: 09/24/09
Posts: 1
Re: I have developed excel based QC report generat [Re: QAAutomation]
      #593253 - 09/28/09 01:07 AM

Hi all,

I am amazed, so important topic, so many visitors had read about the Excel tool, and yet there is no straight answer to the most recent question - How we, the non developer trained, QAs will ever use it?

It is good that you mim2 have done that by yourself, but feel free to share with us also the details on how to work with it.

So many questions had come up, I believe that you don't want an e-mail spam, so why you don't explain more about it here or in your blogspot.

Have a nice day all ! And kill some bugs today


Post Extras: Print Post   Remind Me!   Notify Moderator  
DadoZu
Newbie


Reged: 02/27/08
Posts: 13
Re: I have developed excel based QC report generat [Re: min2]
      #596844 - 10/16/09 12:14 AM

Hi min2,

Could you please post or send the excel-file?
Thanks

Regards DamirSQA


Post Extras: Print Post   Remind Me!   Notify Moderator  
fzuriekat123
Newbie


Reged: 10/24/07
Posts: 13
Re: I have developed excel based QC report generat [Re: DadoZu]
      #623741 - 04/25/10 10:21 AM

Wonderful!

Would you please share a portion of the VBA code involved?

We might contribute with additional code or ideas.

fzuriekat


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


Reged: 11/09/08
Posts: 206
Re: I have developed excel based QC report generat [Re: fzuriekat123]
      #623857 - 04/26/10 10:46 AM

Hi.

As I understand, you have only one hardcoded filter? It will be usefull to get possibilities to setup user's filters to make report (for example by simple editing of some cells li8nked with Tests fields).


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1 | 2 | >> (show all)



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

Moderator:  Rich W., AJ, jgottlieb 

Print Topic

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

Rating:
Topic views: 10683

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5