Labs: New Import Syntax

This lab allows you to import multiple types in one file as well as test case steps. These features are not available currently in CA Agile Central.

Notes:
  • Any time you do an import with the importer, you will have to specify the ObjectType. If you don't enter a value in this field, you will get an error, regardless of whether you're importing one or multiple work item types.
  • When you download the import template, the sample values in line two will display “(required)” next to sample values for required fields.
  • Each line is individually processed and saved, and only the lines that fail are not imported. If you have failures and re-run the same file, you will have duplicate objects.
  • The Project field cannot be imported; all artifacts that are imported will be added to the current project.
  • If you import test case steps to a test case that already has steps, the test case steps in the import file will always be appended to the list of existing test case steps.
  • Enter the user ID to set an owner on import.
  • The fields and sample values in the import template are specific to test cases. If you want to import test case steps (or any other type of data), include the required fields as columns in the import file. You can edit an existing test case to view the required fields for a test case step.
  • Certain fields cannot be imported. For example, when you import a test case, using the test sets field will not associate it to a test set. You won't see an error message for these fields since you can import item types in a single file. Some other examples of fields that cannot be imported includes:
    • test cases - test sets and rank
    • test sets - test cases
    • test folders - test cases
    • defects - test cases
    • any work item - tags

Once enabled, users can use this new import option from the Test Cases page.

Import multiple types in one file

This requires an Object Type column. The value should be the type name of what you’re importing, such as Test Case, Test Case Step, etc.

For any properties that are not applicable to a particular object type, add a blank value.

Associate a test case step to a test case on a previous line

In the Test Case column, use the line[2] syntax to indicate that you want to refer to the object created at line 2.

There are two options for importing test case steps into an existing test case.

Option 1 - copy the Formatted ID of the new test case

After you create and save a new test case, copy its Formatted ID. Create a CSV using that formatted ID for your Test Case Steps. Choose that file for import, and when it's completed, you will notice that your newly created test case now has test case steps.

Use the Formatted ID of the Test Case in the Test Case column.

Note: If you refer to a recycled or deleted item, that line with fail on import.

Option 2 - use the WSAPI reference

Alternatively, you can use the WSAPI reference of the test case in the Test Case column.

Feedback

Need more help? The CA Agile Central Community is your one-stop shop for self-service and support. To submit feedback or cases to CA Agile Central Support, find answers, and collaborate with others, please join us in the CA Agile Central Community.