It's all about the answers!

Ask a question

Map value from csv file to enumeration list

Joshua Giangrande (2621216) | asked Mar 13 '13, 1:49 p.m.

When importing a work item from csv, how does one get a value to appear in an enumeration list? We are migrating a field called "Customer  Name." In RTC, the corresponding field (with an ID of "customers") is an enumeration list, which is backed by the CustomerName enumeration. We have a customer called "CustomerA." The ID of said customer (in the enumeration) is customer_name.literal.l23. The CSV file also reads "CustomerA." I have tried:

<attribute sourceId="Customer Name" targetId="customers">
<value sourceId="CustomerA" targetId="customer_name.literal.l23" />


<attribute sourceId="Customer Name" targetId="customers">
<value sourceId="CustomerA" targetId="CustomerA" />

I would expect one of these to cause "CustomerA" to appear in the work item, but no customer name ever appears in the field. Is this a supported field type for migration? I am using RTC 4.0.1.

- Josh

One answer

permanent link
Stephanie Bagot (2.1k1513) | answered May 24 '13, 8:48 p.m.
Importing Enumration list via CSV is supported in 4.0.1. Make sure your eclipse client is at 4.0.1 as well. Using a 4.0 eclipse client will fail.

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.