Data Import

HomeKnowledge BaseData Import

Orcanos Migrator Tool

217 views /  0 like /  // Amita Gupta/

We have a utility to import only Test cases and their steps, called the Orcanos Migrator Tool.

STEPS TO DOWNLOAD AND INSTALL THE TOOL

  1.  Email [email protected] to get the latest setup of the Orcanos Migrator Tool.
  2. Download the setup and extract it to your local PC.
  3. Open the QPackMigrator.exe.config in Notepad++
  4. Search “endpoint address”  tag in the config file as shown below.
    <client>            <endpoint address=”https://alm.orcanos.com/Orcanos/qpackserv/qpackserv.asmx” binding=”basicHttpBinding”                bindingConfiguration=”QPackServSoap1″ contract=”Qpackserv.QPackServSoap”                name=”QPackSrv1″ />        </client>
  5. Change endpoint address to your account name –
    The account name appears in the URL. For example, if you are at the hom
    For US clients:   https://us.orcanos.com/[account_name]/web/….
    For all other clients:   https://app.orcanos.com/[account_name]/web/…
    e.g. https://app.orcanos.com/[account_name]/qpackserv/qpackserv.asmx
  6. Run QPackMigrator.exe to start importing the Test cases with their steps using CSV/Excel file.

 

HOW TO CREATE A CSV/EXCEL FILE

Create a CSV/Excel file with the Following columns and recommended to create two sheets one for Test Cases and another one for Test Cases Steps as shown below for reference:

 

STEPS TO IMPORT TEST CASES
    1. Right click on the QPackMigrator application exe and run as administrator.
    2. Login to Orcanos Migrator by entering your credential and click ‘Next’.
    3. Select ‘Other’ from the dropdown of External Tool
    4. Browse the file and its path should be displayed in File Path
    5. Select the Projects from the dropdown list
    6. Select the Versions corresponding to the selected project
    7. Select the Object type as Test Case
    8. Uncheck the checkbox – Add Timestamp to Description (To add the import timestamp in the test case or step description, check the checkbox)
    9. Select the WorkSheet of the browsed file from where to import the test cases
    10. Click the Mapping button
    11. Map the External ID
    12. Map the Parent ID (Parent Node in Orcanos Product tree where you want to add the test cases)
    13. Map the Name (Mandatory Field)
    14. Map the other mandatory fields, if any
    15. Click the Export Mapping button that will export the mapping in seperate file and keep it for future reference in the migrator system itself.
    16. Click the Import Mapping button if you want to use the same mapping in the future for next time.
    1. Click the Next Button (Select some other cell in grid to enable the Next button)
    2. 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 steps
  1. Click the 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)

  1. Click the Validation Button as shown in the above image.

  1. Click the Migration Button. All test cases with steps migrated into the application and displayed the ‘migration successful’ message as shown below:

 

The Test cases with test steps get imported to the Orcanos System.

Related Articles