Excel: User not found in cell error when attempting import

Document ID : KB000047758
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

When attempting an import from CSV or using the CA Agile Central Add-in for Excel, an error is thrown stating "User not found in cell"

Issue

Attempting an import from CSV or using the CA Agile Central Add-in for Excel, an error is thrown stating "User <name> not found in cell". ?The value in the cell is the value that was exported from CA Agile Central, and is the correct owner for the work item.?

user not found
?

Resolution

The exported Owner name is actually the display name?for the Owner. ?To import data to CA Agile Central, enter the CA Agile Central?username?for the owner. ?

To resolve the problem:?
  1. Go back to the Owner column in the spreadsheet
  2. Replace the value in the Owner field to the CA Agile Central username for the Owner, i.e.?john@company.com
    owner username

    ?
  3. Click Import to CA Agile Central
  4. Select the correct Workspace and Type from the dropdowns
  5. Click Validate to ensure everything is correct
  6. Click Import