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

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: