Importing multi-valued attributes from EXCEL?

Is there a way to import multi-valued attributes from Excel using the normal import script?
SystemAdmin - Mon Sep 28 04:31:52 EDT 2009

Re: Importing multi-valued attributes from EXCEL?
SystemAdmin - Mon Sep 28 07:30:23 EDT 2009

Just save the Excel document as a spreadsheet, TSV works fine.
As long as the different values for the multi-valued attribute exist in the attribute type and are correctly spelled and in the same cell (one value per line) this is possible.
Note, just as with any other spreadsheet roundtrip, you must have some unique identifier for each object and if you are not going to update the object text and heading, remove the columns before importing...

/Kristian

Re: Importing multi-valued attributes from EXCEL?
kbmurphy - Mon Sep 28 15:32:25 EDT 2009

This can be done. In Excel, you just want to use Alt+Enter within a cell to generate a linebreak, so if your cell looks like so:

Value1
Value3
Value4

Then it will import to DOORS just fine, whether TSV or CSV.

Re: Importing multi-valued attributes from EXCEL?
llandale - Mon Sep 28 17:09:22 EDT 2009

Adding to the two previous posts "... so long as you define you multi-enumerated attr before importing."

  • Louie

Re: Importing multi-valued attributes from EXCEL?
SystemAdmin - Wed Feb 24 15:53:43 EST 2010

kbmurphy - Mon Sep 28 15:32:25 EDT 2009
This can be done. In Excel, you just want to use Alt+Enter within a cell to generate a linebreak, so if your cell looks like so:

Value1
Value3
Value4

Then it will import to DOORS just fine, whether TSV or CSV.

suppose you get a sheet that has a ton of space separated values in a cell, that really need to be Alt+Enter separated in DOORS?
Easier to fix in Excel before import, or is there a way to separate them in the attribute after import. Searched around a bit, but haven't found a way to sub <space> with Alt+Enter in DOORS.
Need em separated as they are link by attribute absolute values.

I'm sure this has been done a million times, I just can't find the right keywords to bring it up (or it's in the old forum).

Re: Importing multi-valued attributes from EXCEL?
kbmurphy - Wed Feb 24 16:44:39 EST 2010

SystemAdmin - Wed Feb 24 15:53:43 EST 2010
suppose you get a sheet that has a ton of space separated values in a cell, that really need to be Alt+Enter separated in DOORS?
Easier to fix in Excel before import, or is there a way to separate them in the attribute after import. Searched around a bit, but haven't found a way to sub <space> with Alt+Enter in DOORS.
Need em separated as they are link by attribute absolute values.

I'm sure this has been done a million times, I just can't find the right keywords to bring it up (or it's in the old forum).

> cliff_sadler wrote:
> suppose you get a sheet that has a ton of space separated values in a cell, that really need to be Alt+Enter separated in DOORS?
> Easier to fix in Excel before import, or is there a way to separate them in the attribute after import. Searched around a bit, but haven't found a way to sub <space> with Alt+Enter in DOORS.
> Need em separated as they are link by attribute absolute values.
>
> I'm sure this has been done a million times, I just can't find the right keywords to bring it up (or it's in the old forum).

You can't do it in Excel's interface. You have to do it in VBA, in a macro. Something like


Range.Replace(
" ", chr(10) )


will do the trick.

Re: Importing multi-valued attributes from EXCEL?
SystemAdmin - Wed Feb 24 18:01:32 EST 2010

kbmurphy - Wed Feb 24 16:44:39 EST 2010
> cliff_sadler wrote:

> suppose you get a sheet that has a ton of space separated values in a cell, that really need to be Alt+Enter separated in DOORS?
> Easier to fix in Excel before import, or is there a way to separate them in the attribute after import. Searched around a bit, but haven't found a way to sub <space> with Alt+Enter in DOORS.
> Need em separated as they are link by attribute absolute values.
>
> I'm sure this has been done a million times, I just can't find the right keywords to bring it up (or it's in the old forum).

You can't do it in Excel's interface. You have to do it in VBA, in a macro. Something like


Range.Replace(
" ", chr(10) )


will do the trick.

Well, I thought so too, but Go Go Google turned up a most esoteric combination for Find/Replace. How about CTRL-j !
So, select the column, replace <space> with CTRL-j, then replace CTRL-jCTRL-j with CTRL-j in case someone accidently put 2 spaces between values.
Import, and link by attribute. Works fine. Dang, it's true. You really do learn something new every day with DOORS.

Re: Importing multi-valued attributes from EXCEL?
kbmurphy - Fri Feb 26 14:02:39 EST 2010

SystemAdmin - Wed Feb 24 18:01:32 EST 2010
Well, I thought so too, but Go Go Google turned up a most esoteric combination for Find/Replace. How about CTRL-j !
So, select the column, replace <space> with CTRL-j, then replace CTRL-jCTRL-j with CTRL-j in case someone accidently put 2 spaces between values.
Import, and link by attribute. Works fine. Dang, it's true. You really do learn something new every day with DOORS.

VERY COOL TRICK. Wish I'd known about this years ago. I've never run across this one before!