Excel Plugin - Validation error when importing display name, user name, e-mail address

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

Issue

When importing items with the Rally Excel Plugin you receive the following Validation error:
  • "User 'User Name Here ' not found in cell [Cell Range Here]"
?Import Validation Error

Resolution

*** This issue has been resolved. ?The latest version of the Excel Add-in can be downloaded here

Workaround: Use the User OID instead of the Display, User Name or E-mail Address to import.
  • How to Export:
  1. Navigate:?Export?-> Manage Queries
  2. Configure Query:
    • Query = User OIDs
    • Type = User
    • Order = Object ID
    • Limit = This may need to be increased depending how many users you have and if you are filtering
      • OPTIONAL: Filter =?
    • Select "OK"
  3. Column "ObjectID" will have the OID that will replace the Display, User Name or E-mail Address (ie: "Owner" field
  • Visual Walk Through:
Export OID Instructions