Sap Oracle

How to import Tests from file?

Panaya provides a simple to use Import Wizard for importing your tests. This is the fastest and most efficient way to import your test assets.
If you wish to import tests from another Panaya project, click here for instructions.

Launching the Import Wizard

  1. In order to launch the Wizard, right click on the Cycle / Folder / Business Process and select Import from File
  2. Select whether you wish the import the assets as Tests or Quick Tests. Click here to learn about the differences
  3. Continue on according to the selected option:
    For Tests, For Quick Tests

For Panaya Tests

You can import test assets from your own documents or from a Panaya template.

Importing from your own documents
Panaya's Test Box lets you automatically create Panaya tests from your own documents.
Click here to learn how

From a Panaya Template
If you select this option, the wizard will proceed to the Choose Template page, where you can select to use a Flat excel file for multiple tests or a single test per file format, which enables you to also define test data for each test.
If you select this option, you will need to archive all the files and upload them as a single ZIP file.

The Panaya Template for Tests

  1. Download the relevant template file and click Next
  2. Fill in all test details in the template file according to the guidelines
    You can use this completed flat excel example or a single test per file example spreadsheet as a reference. 
  3. In the Tests Selection page, click Choose File and select the filled template file or the archived ZIP.
    - Select whether your excel template includes any custom fields
    - If you wish to build a Folder Hierarchy during the import process, check the "Group tests by" to define the hierarchy for the imported tests in 3 optional hierarchy levels as shown in the example below.
  4. Click Next to continue to the Tests Validation page. Review the information displayed and click Next.
    You can also go back and change the selected file before you continue.
  5. Continue on to User Mapping

For Panaya Quick Tests

You can import test assets from your own documents or from a Panaya template.

Importing from your own documents
You can import MS Office files of your own. Panaya will create a new Quick Test activity for every imported file. The name of the file will be used as the activity name and the actual file will be added as an activity attachment.

Panaya will identify any TCODE names in your imported files and will consider them for Test Coverage reports

PDF files are not supported when importing Quick Tests using this method.

From a Panaya Template
If you select this option, the wizard will continue to the Choose Template page, where you can download the Script Template or the Planned Run Template.

Script Template
Use this if you need to create detailed instruction activity steps with the expected results. The template enables to define the a Section for your script - 1 section for each Quick Test. If you use TCODE names in the transaction field for the section, Panaya will identify it and consider them for Test Coverage reports.

Planned Run Template
This template allows to create Quick Tests and include their Planned Runs. Quick Test will be created with no attached script. You can later record or create it manually

  1. Fill in all test details in the template file according to the guidelines
  2. In the Tests Selection page, click Choose File and select the filled template file
    - Select whether your excel template includes any custom fields
    - If you wish to build a Folder Hierarchy during the import process, check the "Group tests by" to define the hierarchy for the imported tests in 3 optional hierarchy levels as shown in the example below.
  3. Click Next to continue to the Tests Validation page. Review the information displayed and click Next.
    You can also go back and change the selected file before you continue.
  4. Continue on to User Mapping

User Mapping

Panaya allows you to connect the users in the imported tests to the users within the Panaya project.

You can skip User Mapping by selecting Auto Mapping. In this case users will be mapped based on previous mapping (if available).

  1. In the User Mapping page, select to download the user mapping file and save it locally.
  2. Open the file and select the correct email address for existing users
  3. For new users, type in the active email address, first and last name.
  4. Go back to the Import Tests Wizard, and click Choose File to select the Panaya User Mapping XLS file. Click Next
  5. The Review and Import page will display the number of tests created and the number of users created and/or connected. New users will be automatically connected to the project.
    Click Submit.

Guidelines for Importing from a Template File

When importing tests using a template file, the following fields should be populated:

  • General tab
    • Name
    • Business Process – if you wish to combine several tests under one business process.
       
  • Steps tab‚Äč
    • Description
    • Transaction \ Object
    • Expected Result
    • Team \ Tester

The Test ID column data will appear as the Catalog ID of each Test. The Catalog ID can be viewed or changed under the General tab.

For Tests - you can use this completed flat excel example or a single test per file example spreadsheet as a reference
For Quick Tests - you can use this completed flat excel example for Quick Tests as a reference

Note

See also