append attribute note to attribute name

[peternees]

I did a reverse engineering of an iSeries DB to EA, which worked fine. However tehre is one problem: the <<column>>attribute names are the technical column names, and the logical column name is generated in the <<column>>attribute note. The <<column>>attribute not can apparently not be visualised on the class diagram, which makes my diagram uncomprehensable.
So I want to move the note value to the name property (or append it it).
How could I do this?

ps: I have no experience with scripting, and am not even sure I need it for my problem.

[Geert Bellekens]

Hi,

The best way would be to write a little program/script to manipulate the name/notes of your columns.
Summarized the code should look something like this:
(disclaimer: written from memory, not tested)

Code: [Select]

EA.Package myPackage = Repository.GetTreeSelectedPackage();
foreach (EA.Element myElement in myPackage.Elements)
{
    foreach (EA.Attribute myAttribute in myElement.Attributes()
    {
        myAttribute.Name = myAttribute.Name + "_" + myAttribute.Notes;
        myAttribute.Update();
    }
}
If you really want you could also update the database directly, but I would advise against that.

Geert

[mrf]

Be careful of foreach in JScript (from memory) it actually goes over all members in the structure, not all elements in a collection.

If you want foreach functionality you have to use enumerators (See JScript - Recurisve Model Dump Example in the example script library for an example on using enumerators).

[peternees]

bedankt! code werkt :

Code: [Select]

function main()
{
      myPackage = Repository.GetTreeSelectedPackage();
      for(var i=0; i < myPackage.Elements.Count; i++)    
      {
            myElement = myPackage.Elements.GetAt(i);
      
            for(var j=0; j < myElement.Attributes.Count; j++)
            {
                  myAttribute = myElement.Attributes.GetAt(j);
                  myAttribute.Name = myAttribute.Notes + " (" + myAttribute.Name + ")" ;
                  myAttribute.Update();
            }
      }
}

main();