Data Import

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>

1. Change endpoint address to your account name i.e. https://app.orcanos.com/[account_name]/qpackserv/qpackserv.asmx
   
2. 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

STEPS TO IMPORT TEST CASES

1. 1. Click on the QPackMigrator application exe.
   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. Press 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. Press Next Button (Select some other cell in grid to enable the Next button)
   16. 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.