Code to copy a test set from one folder to another in Quality Center



I am sharing this info as I had to do quite a research before i found the solution.

Problem:  Copy a test set from one folder to another in Quality Center test lab using code.

First things first: This cannot be coded in vbscript or QTP as it uses the ISupportCopyPaste interface and the CopyToClipboard method which is part of this interface. Therefore you cannot declare a statement like Dim iscp As ISupportCopyPaste

A simpler way would be to use vba and do the following:

1. Add the following code in excel vba editor.
2. Add the "OTA COM Type Library" as a reference under tools -> references from excel.
3. Run and enjoy the magic :-)

Solution:

Public Function CopyPasteTestSetFolder(sourceFolderPath, destFolderPath)
       
     strServer = "http://xyz/qcbin"
     strDomain = ""
     strProject = ""
     strUser = ""
     strPassword = ""
     
     Set objTDConnection = CreateObject("tdapiole80.TDCONNECTION")
     objTDConnection.InitConnection strServer, strDomain
     objTDConnection.ConnectProject strProject, strUser, strPassword
   
     Set objTreeManager = objTDConnection.TestSetTreeManager
     Set sourceFolder = objTreeManager.NodeByPath(sourceFolderPath)
     Set destFolder = objTreeManager.NodeByPath(destFolderPath)
   
     Dim iscp As ISupportCopyPaste
         
     Set iscp = sourceFolder

     clipboard = iscp.CopyToClipBoard(sourceFolder.NodeID, 0, sourceFolderPath)

     Set iscp = destFolder
     iscp.PasteFromClipBoard clipboard, destFolder.NodeID, 0, -1

     Set treeMng = Nothing
     Set sourceFolder = Nothing
     Set destFolder = Nothing
     Set iscp = Nothing
   
End Function

Happy Testing!

Comments

  1. Unknown23/3/12

    hi,

    Looking for a aladdin.jar file. Please help in providing this jar to work with oracle forms 11g tabbed items

    ReplyDelete
  2. Anonymous25/9/12

    Excellent! Thank you so much for the info!!!

    ReplyDelete
  3. Aditya Kalra (Ady)25/9/12

    Glad that helped!

    Best Regards,
    Ady.
    "Quality cannot be sprinkled onto an application right before it gets exposed to your clients"
    Technology Specific Guide For QTP - My new Book on QTP

    ReplyDelete
  4. summi7/3/13

    Hi Aditya,

    Thanks for your code. But is there any way that we can achieve this through QTP..?

    Regards,
    Suman CH

    ReplyDelete
  5. Anonymous3/4/13

    Hi Aditya,
    On the same note , can we add scripts from test plan to a Test set under test lab of QC V 10 , using VBA code ?

    Regards,
    AD

    ReplyDelete
  6. Aditya Kalra (Ady)3/4/13

    Hi AD,

    I am sure thats very much possible using OTA, will have to dig a little to see if i have some reusable code.
    Let me know if you need help.

    Best Regards,
    Ady

    ReplyDelete
  7. Unknown12/6/20

    Is it possible to copy testcases from one server test plan to another lam server test plan?
    ie: archival

    ReplyDelete

Post a Comment

Popular posts from this blog

Software Testing @ Microsoft

Image
In continuation from my previous  series of posts  targeting testing in top few companies from the technology space. After  Software Testing @Facebook  and @Google  we shall now look at Microsoft: Testing@Microsoft Software Development Engineers in Test (SDETs) are usually just called Test and sometimes Software Testing. SDETs are responsible for maintaining high testing and qualityassurance standards for all Microsoft products. Software Development Engineers (SDEs) are often referred to as Software Development. SDEs write the code that drives Microsoft products and upgrades. Very few teams in Microsoft are still using SDETs to do significant amount of manual testing. Manual testing is mainly outsourced. Actually, as early as in 2004, for example, most of the manual testing of MSN Explorer was outsourced. Think about it this way: it just doesn't make sense for test manager to spend their headcount (SDETs) on something can be easily outsourced.  Until 2005, Microso
Read more

Trim / Remove spaces in Xpath?

Image
If you are wondering how you can trim the spaces in your xpath, this is how: The normalize-space function strips leading and trailing white-space from a string, replaces sequences of white-space characters by a single space, and returns the resulting string. Example : Which one is better? //td[starts-with(normalize-space(),'Text to Trim')] //td[starts-with(normalize-space(text()),' Text to Trim ')] The second option is better as it targets at the specific nodes More string functions in XPATH: Functions Description starts-with( string1 ,  string2 ) Returns true if the first string starts with the second string. contains( string1 ,  string2 ) Returns true if the first string contains the second string. substring( string offset length ) Returns a section of the string. The section starts at  offset (which is a number), and is as long as the value provided at  length. substring-before( string1 ,  string2 ) Returns the part of  string1  up unti
Read more