Excel: User not found in cell error when attempting import

book

Article ID: 47758

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction

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.?

<Please see attached file for image>

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.?[email protected]

    <Please see attached file for image>

    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

Environment

Release:
Component: ACPREM

Attachments

1558697595977000047758_sktwi1f5rjvs16nx5.png get_app
1558697594151000047758_sktwi1f5rjvs16nx4.png get_app