Import and Export Parameters

Sometimes you may have already created and structured your Parameters in Microsoft Excel. In this case, re-creating them from scratch in qTest would be time-consuming and redundant. To save effort time, you can import your Parameters directly from Excel. You can also export Parameters to a .csv file for any purpose.

Import Parameters

Prerequisite

Before importing Parameters, verify that your .xls or .xlsx file follows the format provided in the template. To access the template, click the the template here link on the Import Parameters dialog.

To import Parameters:

  1. Access the Parameters tab. To access the Parameters tab, access qTest Parameters. The Parameters tab displays by default.

  2. On the Parameters tab, click the Import button.

    The Import Parameters dialog appears.

  3. Select the Projects to import the Parameters to. By default, the Parameters will be imported to all of your qTest Projects. To change the Projects that the Parameters should be imported to, click the Projects button. A list appears, where you can select the Projects that the Parameters should be imported to. Click OK to save your selections.

  4. Drag and drop your Excel file to the blue file upload box or click the click here to pick from a folder link to upload a file from your computer.

    When the file is uploaded, the file name appears in the blue file upload box.

  5. Next, select one of the following options to indicate the method for how the import should deal with duplicate Parameters.

    • Overwrite duplicate parameters. If a duplicate Parameter is detected, the existing Parameter will be overwritten with data and values from the Parameter in the import file.

    • Add data to existing parameters. If a duplicate Parameter is detected, only additional data and values from the Parameter in the import file will be added to the existing Parameter.

    • Skip duplicate parameters. If a duplicate Parameter is detected, the duplicate Parameter in the import file will not be imported.

  6. Click Import.

    Once the file is imported, the Import Parameters Result dialog appears. This dialog lists details for the Parameters that were imported, the Parameters that failed to import, and the Parameters that were skipped, if applicable.

  7. Click Close to close the Import Parameter Result dialog.

Export Parameters

To export Parameters:

  1. Access the Parameters tab. To access the Parameters tab, access qTest Parameters. The Parameters tab displays by default.

  2. On the Parameters tab, select the check boxes for the Parameters that you want to export.

    Up to 100 Parameters can be exported at a time. Archived Parameters cannot be exported.

  3. Click the Actions button. On the menu that appears, click Export.

    Once the file has been compiled, the Export Parameters dialog appears.

  4. On the Export Parameters dialog, click the Download exported file link to download the file to your computer.

    export-prm-result.png