Data Import

QPack Migrator

We have a utility to import the Test cases and their steps which is called Qpack Migrator

STEPS TO DOWNLOAD AND INSTALL THE TOOL

  1. Download the setup and extract it to your local system 
  2. Open the QPackMigrator.exe.config in Notepad++
  3. Search “endpoint address”  (it is at like number 50)

 <client>

            <endpoint address=”https://alm.orcanos.com/Orcanos/qpackserv/qpackserv.asmx” binding=”basicHttpBinding”

                bindingConfiguration=”QPackServSoap1″ contract=”Qpackserv.QPackServSoap”

                name=”QPackSrv1″ />

        </client>

  1. Change endpoint address to your endpoint address i.e. https://app.orcanos.com/xxxxx/qpackserv/qpackserv.asmx
  2. Run QPackMigrator.exe to start importing the Test cases with their steps using CSV
HOW TO CREATE A CSV FILE

Create a CSV file with the Following columns

STEPS TO IMPORT TEST CASES
    1. Login into QPACK Migrator
    2. Select External Tool from the Selection list
    3. Browse the file and its path should be displayed in File Path
    4. Select the Projects from the selection list
    5. Select the Versions corresponding to the selected project
    6. Select the Object type as Test Case
    7. Uncheck the checkbox – Add Timestamp to Description (To add the import timestamp in the test case or step description, check the checkbox)
    8. Select the WorkSheet of the browsed file from where to import the test cases
    9. Press Mapping button
    10. Map the External ID
    11. Map the Parent ID (Parent Node in Orcanos Product tree where you want to add the test cases)
    12. Map the Name (Mandatory Field)
    13. Map the other mandatory fields, if any
    14. Press Next Button (Select some other cell in grid to enable the Next button)
    15. Browse the same file again and its path should be displayed in File Path
  • Select the WorkSheet of the browsed file from where to import the test cases
  1. Press Mapping button
  2. Map the Order
  3. Map the Step Description
  4. Map the Step Expected Result
  5. Map the Test Id
  6. Press Next Button (Select some other cell in grid to enable the Next button)
  7. Press Validation Button
  8. Press Migration Button

 

The Test cases with test steps gets imported to Orcanos System.

Related Articles