Page Comparison

The first step to using the VERA qTest Migration Helper utility is to edit the included config.json file. Follow the steps below to update the file:

Example config.json file

{
  "api_key": "########-####-####-####-############",
  "server_url": "https://tx3.qtestnet.com" ,
  "project_ids": ["116893", "117063"]],
  "page_size": "999",
  "log_level": "Info",
  "fields_to_match": [
    {
      "name": "VERA Approval Status",
      "values": [ "Closed", "Approved" ]
     "Draft" ],
      "constraint": "Field Is Equal"
    },
    {
      "name": "Version",
      "values": [ "0.3" ],
      "constraint": "Version Field Contains"
    },
    {
      "name": "Last Modified User",
      "values": [ "t.yapaolo@tricentis.com" ],
      "constraint": "User Is"
    },
    {
      "name": "Assigned To",
      "values": [ "t.yapaolo@tricentis.com" ],
      "constraint": "User Is"
    },
    {
      "name": "PriorityLast Modified Date",
      "values": ["Medium"]
    },
     "03/04/2023 01:00:00 PM" ],
      "constraint": "Date Field Is Greater Than Or Equal"
    }
  ],
  "fields_to_update": [
    {
      "name": "Migration Notes",
      "value": "Migration Notes - qTest Helper Tool",
	  "overwrite": false
    },
	{
      "name": "Comments",
      "value": "qTest Helper Tool",
	  "overwrite": false
    },
	{
      "name": "Priority",
      "value": "High",
	  "overwrite": true
    },
	{
      "name": "Assigned To",
      "value": "j.koelle@tricentis.com",
	  "field_type": "User",
      "overwrite": true
    },
	{
      "name": "Date Modified",
      "value": "03/04/2025 01:00:00 PM",
	  "field_type": "Date",
      "overwrite": true
    },
	{
      "name": "Type",
      "value": "Automation",
      "overwrite": true
    },
	{
      "name": "Status",
      "value": "In Progress",
      "overwrite": true
    }
  ],
  "run_fields_to_match": [
    {
      "name": "Assigned To",
      "values": [ "t.yapaolo@tricentis.com" ],
      "constraint": "User Is"
    },
	{
      "name": "VERA Approval Status",
      "values": [ "Draft" ],
      "constraint": "Field Is Equal"
    }
  ],
  "run_fields_to_update": [
	{
      "name": "Comments",
      "value": "qTest Helper Tool",
	  "overwrite": false
    },
	{
      "name": "Priority",
      "value": "High",
	  "overwrite": true
    },
	{
      "name": "Execution Type",
      "value": "Regression",
	  "overwrite": true
    },
	{
      "name": "Assigned To",
      "value": "j.koelle@tricentis.com",
	  "field_type": "User",
      "overwrite": true
    },
	{
      "name": "StatusPlanned Start Date",
      "value": "03/04/2025 01:00:00 "ImportedPM",
	  "field_type": "Date",
      "overwrite": true
    },
    {
      "name": "DescriptionPlanned End Date",
      "value": "Approved in previous system03/04/2025 01:00:00 PM",
	  "field_type": "Date",
      "overwrite": falsetrue
    }
  ],
}

1. Provide an API Key (optional):

   1. This is the API key available from qTest for the account that will be updating records:

      1. To access your api key, click on the Resources button

...

1. 1. 1. 1. Image Added

      2. Then expand the API & SDK section

...

1. 1. 1. 1. Image Added

      2. Finally, copy the token after bearer:

...

1. 1. 1. 1. Image Added

            
            

            Note
            title Required Permissions
            The account used for the migration utility must have access to edit all tests and fields in the projects being updated.

            
            

   2. This can also be left blank and the utility will ask for the API Key each time it is run.

2. Provide the Server URL:

   1. This is the URL for the qTest server and is required,

3. Provide Project IDs:

   1. Enter a list of Project IDs for the projects that you want the utility to scan.

   2. Project IDs can be obtained from either the URL for a project or the list of Projects in the Administration area:

      1. URL:

         1.  

...

1. 1. 1. 1. Image Added

      2. Project Administration:

         1. As a site admin, access the Administration Area > Projects:

...

1. 1. 1. 1. 1. Image Added

         2. The table displays all projects and their ids:

...

1. 1. 1. 1. 1. Image Added

   2. This is required and the utility will fail if it is not provided.

2. The utility provides a log level setting “log_level” which defaults to “Info” but can be set to “Debug” to provide detailed log messages for each constraint evaluation.

3. Provide a list of criteria to match when selecting

...

1. Test Cases and/or Test Runs:

   1. Criteria are

...

1. 1. presented as JSON objects with

...

1. 1. three properties: Name, Values and

...

1. 1. Constraint

      1. Name is the qTest Label of the field. This must match exactly with what is in qTest.

      2. Values is a list of string values to match. The utility will match any of the values in the list. This will only work for single select field and text fields. The field must match the text of the value exactly

...

1. 1. 1. but is case insensitive. The default constraint for text field comparisons is “Field Contains”. Additional supported field constraints are “Field Is Equal”, “Field Is Less Than”, “Field Is Less Than Or Equal”, “Field Is Greater Than” and “Field Is Greater Than Or Equal”.

      2. Date fields can be specified for test case or test run selection. For date field comparisons, a single date value is specified in the “Values” property in the format “M/d/yyyy h:mm:ss tt" where the month and day are specified in one or two digits, year as four digits and the hour, minutes and seconds as two digits with the AM or PM designation. Multiple date values cannot be specified. The supported Date field constraints are “Date Field Is Equal”, “Date Field Is Less Than”, “Date Field Is Less Than Or Equal”, “Date Field Is Greater Than” and “Date Field Is Greater Than Or Equal”.

      3. User list fields can be specified for test case or test run selection. The constraint “User Is” can be used to specify the user name defined for the user in the user account profile in the form username@url.com.

      4. The Version information is saved in the test case properties. Selection of the test based on the Version property can be specified with the “Version Field Contains” constraint.

   2. At least one criteria must be present

...

1. 1. .

2. Provide a list of field updates: for Test Cases and/or Test Runs:

   1. Field updates are presented as a list of JSON objects with

...

1. 1. four properties: Name, Value, Field Type and Overwrite

      1. Name is the qTest Label of the field. This must match exactly with what is in qTest.

      2. Value is the value to set the field to or append to the existing value

      3. Overwrite is a boolean indicating if the existing field value should be overwritten or appended to. True or omitting the property will overwrite the contents of the field and false will append to the existing value.

         1. Appending only works for text fields and will be ignored for single select fields, user and date fields.

      4. If the field to be updated is a User or Date type field, specify “field_type” as “User” or “Date”. Otherwise, the “field_type” is not specified and defaults as a text field.

   2. This is not required for the utility to process.

   3. User list fields can be specified for test case update as the user name defined for the user in the user account profile in the form username@url.com. Test run user fields are specified as a single user account profile name.