Format defects

Before you upload your defects to the ALM Defects module, you format the defects in your worksheet.

To format a defect:

  1. Open your Excel worksheet.

  2. Define each defect on a separate row. For each defect, you must define all required fields as defined in your ALM project.

Consider the following points when formatting defects:

  • If you enter data in a Detected in Release, Detected in Cycle, Target Release, or Target Cycle field, you must include the path preceding the release or cycle. Separate each hierarchical level with a backslash (\) character.

    Example: parent1\parent2\TC1

    Make sure not to use a forward slash. If a Target Release or Target Cycle value is unique, you do not need to include its preceding hierarchy.

  • If you enter data in a Detected in Cycle or Target Cycle field, you must also enter data in the Detected in Release or Target Release field.

Example: Suppose you want to upload the following defects:

After you upload the defects to ALM, the defects are displayed in the Defects module.

Note: When an ALM defect field has an input mask, the mask is not checked when you upload defects from Excel to ALM.

For additional formatting guidelines, see Guidelines for formatting.

Once you have formatted your defects, you can upload them to ALM. For more information, see Upload data from Excel add-in to ALM.

Back to top