Importing requirements from spreadsheet

[jmccrillis]

I'm trying to set up our EA project so I can import the requirements we've been tracking in an Excel spreadsheet. There are numerous "custom" columns that we need to bring in, in addition to the normal stuff (name, priority, etc.) What is the best approach to getting this done? The CSV import isn't robust enough to pull in the custom columns (as far as I am able to tell). Would an XMI import do what I need? How do I set up my project ahead of time to have places for the custom data to reside (tagged values seem appropriate, but I haven't figured out how to import them).

Yes, I am a newbie.  

Janene McCrillis
NatureServe

[Dave_Bullet]

CSV cannot import tagged values (the extra custom properties you want to define on your requirements).  Don't think this has changed with V7.0

Only 3 ways I know of.
1. Generate an XMI with the tagged values
2. Use EA's automation interface.  There might already be an add-in out there
3. SQL to load them direct into the DB.

I use 3.  I would give you my scripts, but unfortunately I don't have any generic scripts I could give you to do the job.  Also depends on which RDBMS you are using.

David.

[Martin Terreni]

Do you happen to know how can I find in DB which external requirement is connected to which object?

Thanks

[Martin Terreni]

I found it!

SELECT     dbo.t_object.Object_ID AS ReqID, dbo.t_object.Name AS ReqName, t_object_1.Object_ID AS ObjID, t_object_1.Name AS ObjName

FROM         dbo.t_connector INNER JOIN

                     dbo.t_object AS t_object_1 ON dbo.t_connector.Start_Object_ID = t_object_1.Object_ID INNER JOIN

                     dbo.t_object ON dbo.t_connector.End_Object_ID = dbo.t_object.Object_ID

WHERE     (dbo.t_object.Object_Type = N'Requirement') AND (dbo.t_connector.Connector_Type = N'Realisation') 8) 8)

[jmccrillis]

CSV cannot import tagged values (the extra custom properties you want to define on your requirements).  Don't think this has changed with V7.0

Only 3 ways I know of.
1. Generate an XMI with the tagged values
2. Use EA's automation interface.  There might already be an add-in out there
3. SQL to load them direct into the DB.

I use 3.  I would give you my scripts, but unfortunately I don't have any generic scripts I could give you to do the job.  Also depends on which RDBMS you are using.

Thanks, David. I see an add-in to do an export of tagged values, but not an import. SQL straight in might be faster... I'm using "Microsoft OLE DB Provider for SQL Server", if that helps.

Janene

[Martin Terreni]

There is a "t_require" or "t_objectrquire" table in DB.
just check the object_id to wich you want ot add the requirements and the fields of table.
If you want to import them as independent requirements, just add them to t_objects table with a new Id and type requirement.

Hope it helps

[«Midnight»]

That should be t_requiretypes and t_objectrequires - spelling is important here. The former relates to the requirement type drop-down you see in some EA dialogs. If you define new requirement types they will show up here.

The latter seems to be involved in defining 'internal' - in the EA sense of the term - requirements.

[Martin Terreni]

That should be t_requiretypes and t_objectrequires - spelling is important here. The former relates to the requirement type drop-down you see in some EA dialogs. If you define new requirement types they will show up here.

The latter seems to be involved in defining 'internal' - in the EA sense of the term - requirements.

I meant there are 2 options:
1) internal requirements :
import them to t_objectrequires as requieremtns of a specific object (internal)
2) External requirements:
Create the in t_object with a new Object_ID and Object_Type = 'Requirement'