Users,
I have created a multi-valued attribute (32 different values) in DOORS as an enumerated list. I need to have several SMEs populate the attribute value for over 650+ requirements. These SMEs are not DOORS users so I am left with exporting to a spreadsheet and then impoarting back in to populate the values.
My question is, what is the best way in Excel to set up the cells so the users can select the multiple choices and then I can import those multiple values per object back into DOORS for an enumerated list?
Thanks in advance for any help.
Chris
CR_SPAWAR - Tue Nov 01 16:35:17 EDT 2011 |
|
Re: DOORS to Excel and Import Back In
OurGuest - Tue Nov 01 16:55:19 EDT 2011
You can make a drop down list in excel see: http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm
You have to have the type and attribute set up in DOORS prior to importing the values.
|
|
Re: DOORS to Excel and Import Back In
CR_SPAWAR - Tue Nov 01 16:57:21 EDT 2011 OurGuest - Tue Nov 01 16:55:19 EDT 2011
You can make a drop down list in excel see: http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm
You have to have the type and attribute set up in DOORS prior to importing the values.
|
|
Re: DOORS to Excel and Import Back In
OurGuest - Wed Nov 02 07:26:29 EDT 2011 CR_SPAWAR - Tue Nov 01 16:57:21 EDT 2011
Drop down lists are simple but they cannot be multi-valued can they? I thought they were single value restricted....
Attachments
attachment_14699527_MultiSelect.xls
|
|
Re: DOORS to Excel and Import Back In
OurGuest - Wed Nov 02 07:50:47 EDT 2011 OurGuest - Wed Nov 02 07:26:29 EDT 2011
See attached spreadsheet for two approaches.
Attachments
attachment_14699533_MultiSelect.xls
|
|