Requirements Table: Excel import v/v Custom Columns

Diagramming issues

Moderator: Moderators

Requirements Table: Excel import v/v Custom Columns

Postby yshragai.firmware@gmail.com » Mon Jul 19, 2021 5:22 pm

Hi,
I created a Requirements Table. Now I want to import requirements to it, using the Excel import facility in the Requirements Table (the little Excel icon in the table's menu strip).

My Excel file has columns for: ID, Description, Short Text, Comments, Rationale.
ID, Description, and Short Text in the file map nicely to ID, Text, and Name in the MagicDraw table.
For Comments and Rationale, I created custom columns in the table, and mapped the file columns to those table columns in the file selection dialog.
Then I did "Read the file".
The content for the standard columns (ID, Text, Name) were imported fine from (ID, Description, Short Text).
The content for Comments and Rationale was not imported.

Is there some trick involved for importing to custom columns?

Thanks!
yshragai.firmware@gmail.com
Forum Newbie
Forum Newbie
 
Posts: 17
Posts Rating:1
Joined: Fri May 07, 2021 2:35 pm

Re: Requirements Table: Excel import v/v Custom Columns

Postby yshragai.firmware@gmail.com » Wed Jul 21, 2021 6:12 pm

Found the answer, after a lot of exploration and experimentation:
The columns in the Requirements Table have to match the properties of the requirement stereotype (Requirement or any of its derived stereotypes).
You find all the available property types, organized by stereotype, if you go to the full column selection dialog (from the Requirement Table menu strip, click the column icon, then don't just choose columns from the limited menu - but rather, choose "select columns" or something like that near the bottom).
Also, you can find the properties of the stereotype by going into the Specification of the stereotype, choosing "All" view, and looking for the member list.

I ended up creating a new stereotype - with a generalization relationship to extendedRequirement - in which I added the properties that I needed.
yshragai.firmware@gmail.com
Forum Newbie
Forum Newbie
 
Posts: 17
Posts Rating:1
Joined: Fri May 07, 2021 2:35 pm

Re: Requirements Table: Excel import v/v Custom Columns

Postby ephenminette@gmail.com » Sat Aug 14, 2021 12:22 am

File origin Select the character set that is used in the text file. In most cases, you can leave this setting at its default. If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set. For example, if your computer is set to use character set 1251 (Cyrillic, Windows), but you know that the file was produced by using character set 1252 (Western European, Windows), you should set File Origin to 1252.

MyBalanceNow
ephenminette@gmail.com
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Sat Aug 14, 2021 12:20 am

Re: Requirements Table: Excel import v/v Custom Columns

Postby emilyjohan200@gmail.com » Sat Jul 30, 2022 3:52 am

yshragai.firmware@gmail.com wrote:Found the answer, after a lot of exploration and experimentation:
The columns in the Requirements Table have to match the properties of the requirement stereotype (Requirement or any of its derived stereotypes).
You find all the available property types, organized by stereotype, if you go to the full column selection dialog (from the Requirement Table menu strip, click the column icon, then don't just choose columns from the limited menu - but rather, choose "select columns" or something like that near the bottom).
Also, you can find the properties of the stereotype by going into the Specification of the stereotype, choosing "All" view, and looking for the member list.

I ended up creating a new stereotype - with a generalization relationship to extendedRequirement - in which I added the properties that I needed.

Thanks for your answer, this is exactly what I was looking for word hurdle
emilyjohan200@gmail.com
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Sat Jul 30, 2022 3:47 am

Re: Requirements Table: Excel import v/v Custom Columns

Postby lauralordelaure@gmail.com » Fri Oct 28, 2022 3:35 am

Thanks for the information, I will try to figure it out for more. Keep sharing such informative post keep suggesting such post.
shell shockers
lauralordelaure@gmail.com
Forum Newbie
Forum Newbie
 
Posts: 2
Posts Rating:0
Joined: Fri Aug 19, 2022 12:40 am


Return to Diagramming

Who is online

Users browsing this forum: No registered users and 0 guests

cron