Searching for Find and Replace functionality

[gluzm]

Hi all, this question might seem simple but I am not able to find a way how to replace a name of one entity in the whole EA project.

Our marketing friends decided to promote "system users" to "customers", and I promised them to change the specification and all occurrences of the old name to the new one.
Naively hopping this could be done by Find and Replace functionality, within 5 minutes, I just spent around one hour searching for this functionality. Being not able to find it I resigned, and decided to do the chnage manually. Well this boring job is behind me, but still I am wondering if I am blind and not able to find this functionality or this functionality is missing.

I have a packing with list of requirements, having the old name in the description and details area.

Jan

[thomaskilian]

For unknown reasons there is nothing like that. You can either go directly through a SQL script or you use automation to do the job.

[Dave_Bullet]

SQL scripts on the t_connector (if associations you need to change) or t_object (if type of object / stereotypes etc...).  These 2 tables alone (plus t_package for the hierarchy in the project view) are usually enough for your bulk update needs.

Always test out on a backup repository first.

Cheers,
David.

[greywolf20k]

based on:
"SQL scripts on the t_connector (if associations you need to change) or t_object (if type of object / stereotypes etc...).  These 2 tables alone (plus t_package for the hierarchy in the project view) are usually enough for your bulk update needs."

can anybody please tell me what table the notes are kept in to make it easier on my DB guy?

Is there any chance that Sparx will be including this functionality in the near future as our sales people change their minds every 5 minutes....  
TIA

[Dave_Bullet]

I should have read your original post properly...

Do you have "system users" defined as a single actor in your model?  and you want to change this to "customers"?  If so - just change the name of that one actor and EA will automatically update any diagrams that use that actor.

If you have defined multiple "system users" actors and want to replace the lot - then yes, SQL is an easy option... here are the column details you need.

Assuming you are using an "actor" UML element and have used the element name (the description that appears in the project explorer treeview), then this script will rename "system users" to "customers" for every actor with that name:

update t_object
set name = 'customers'
where lower(name) = "system users"
and object_type = 'Actor'

If the above is no use - let me know whereabouts the words "system users" appears on the EA interface - and I can help pinpoint the underlying tables.

Cheers,
David.