Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: jamesH on July 09, 2007, 11:04:43 am

Title: Batch update/change multiple elements
Post by: jamesH on July 09, 2007, 11:04:43 am
I have several hundred requirements in 4 packages and I need to update some of the properties inall of the requirements. I tried selecting more than one requirements via the project browser and the CTRL key. I'm alble to select multiple elements but can not action them as a group.

For example, how would I update the "Version" field on multiple elemnets at the same time?

Thanks
Title: Re: Batch update/change multiple elements
Post by: «Midnight» on July 09, 2007, 12:27:16 pm
James,

I don't think you can do this easily, but I stand to be corrected.

[Anyone who knows the right 'tweak,' please chime in!]

You could do this with an SQL query to the underlying database, if you are careful. Or, a short add-in would do the trick.

David
Title: Re: Batch update/change multiple elements
Post by: thomaskilian on July 09, 2007, 12:56:05 pm
For certain properties an Update Package Status from the package's context menu might help. But likely you need what David suggested...
Title: Re: Batch update/change multiple elements
Post by: jamesH on July 09, 2007, 01:25:15 pm
Underlying database? ?

You have intrigues me, what is the simplest way to access the database? I have access to MS SQL and MS Access....

THanks
Title: Re: Batch update/change multiple elements
Post by: thomaskilian on July 10, 2007, 02:46:55 am
Depends on what you are using. If you have .EAP files then these are simple MS Access databases (you can use ODBC and something like TOAD to SQL them - or even the build in SQL generator in EA's advance search to some extent). If you have a real repository then you can go directly into that database.
Title: Re: Batch update/change multiple elements
Post by: «Midnight» on July 10, 2007, 03:11:38 am
James,

Do a search for my reply to Pierre earlier today. That might give you a starting point.

David