It's all about the answers!

Ask a question

Problem importing enumeration list value in RTC 5.0


Dudley Thomas (41614) | asked Jul 29 '14, 1:08 p.m.
edited Jul 31 '14, 4:35 a.m. by Ralph Schoon (63.2k33646)
Importing an enumeration list value works in RTC 4.0.3 client but not in 5.0. The import succeeds but the value is not displayed properly. Instead of the value, the enumeration list shows "NA<cr>NA<cr>NA".  Any ideas?

4 answers



permanent link
Lily Wang (4.9k714) | answered Jul 30 '14, 12:47 a.m.
Hi Dudley,
I tested in RTC 5.0 to import  enumeration list attribute for work items from a csv file. The enumeration list was imported successfully.
Could you provide a sample csv file you used?


permanent link
Dudley Thomas (41614) | answered May 21 '15, 9:33 a.m.
We are running v5.0.1 and this does not work.  If I import an enumeration list attribute with values that have multiple words separated by spaces it does not assign. For each word, it assigns the default value for each word.  
Situation:
Type: Issue
Attribute: Enumeration List: Testattribute
Values are
  • Unassigned (default)
  • SingleWord
  • Two Words

Import.csv (contents)
Type,Id,Testattribute
Issue,208159,"Two Words"

Results in the field containing "Unassigned, Unassigned" where "Unassigned" is the default value for this enum list.

If the import value is changed to "SingleWord" it works file.

Comments
Lily Wang commented May 21 '15, 8:32 p.m.

 I think RTC can not process the csv file which has whitespace in the enumeration value. You can consider to remove the whitespace, and using a mapping file to map the value to enumeration literal id during the import.


permanent link
Dudley Thomas (41614) | answered May 26 '15, 9:51 a.m.
 Ok. Thanks.

permanent link
Dudley Thomas (41614) | answered May 26 '15, 3:18 p.m.
 I tried this but it still does not work. I will file a PMR.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.