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

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

book

Article ID: 47921

calendar_today

Updated On:

Products

Rally On-Premise Rally SaaS

Issue/Introduction

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]"

Resolution

*** This issue has been resolved in version 2.4.4.

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: