Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How can I import a multi-select enumeration from Excel to DNG?

 I've exported an Excel file from SharePoint and now want to import it into DNG 6.0.3.  One of the fields in SharePoint is a multi-select enumeration (the only values are 2T and 5T), and I created a corresponding attribute in DNG and assigned it to the correct artifact type.  If the value in Excel is either 2T, 5T, or blank, it imports just fine.  However, I can't get an import to work if both 2T and 5T are selected: I don't know how to separate the values in the Excel file.  I tried using a semicolon (which is the default from a Sharepoint export) and also a newline (with alt-enter) but both fail (with the latter I get the error: CRRRS4215E Enumeration entry value "2T 5T" specified in import data is not found on specified enumeration type) .  How can I do this import?

0 votes


Accepted answer

Permanent link

For me it worked with a comma "2T,5T".
Also, make sure multiple values are allowed in the artifact attribute definition.

Ronald Wisniewski selected this answer as the correct answer

1 vote

Comments

 Thanks Tali, the comma worked!


One other answer

Permanent link

Multi-Select Imports do work, just make sure that your enumeration names have no spaces at the end.

That may be the culprit of your errors.

0 votes

Comments

This was already answered and accepted as solved. March 23rd 2017.  

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 173
× 64

Question asked: Mar 22 '17, 3:31 p.m.

Question was seen: 4,952 times

Last updated: Mar 24 '22, 6:52 a.m.

Confirmation Cancel Confirm