Data Model import

[kadamowi]

I have Excel file with Data Model, list of entities and attributes with type and description.

Hot to import it to EA as a tables with attributes ?

Import/export csv dont have attributes -:(
XMI is to complicated.

Do You have any idea ?

Kris

[skiwi]

Use your model to create an instantiated database.
Then reverse engineer the model into EA.

[kadamowi]

I don't know how to do it, but ...

I remembered that Geert Bellekens uploaded on Community Site example in VBA which can import data from Excel.
It is exactly this what I'm looking for.

It's working well, I only try to change it how to add element as a <table> stereotype and Database "Oracle".

[kadamowi]

Maybe somebody know what is the type Attribute.Scale ?

myAttribute.Precision = attrPrec
is working, but
myAttribute.Scale = attrScale
causes error : Expected: ( on "=" char

and another little problem
data after import are in alphabetical order, can be in the sam as in file ?

Kris

[Geert Bellekens]

Kris,

The easiest to find out what to put in the Attribute.Scale is to manually add a scale in EA and then inspect the Scale attribute of the attribute in your code.
Another option is to open the database (if you are using an eap file use MS-Access) and see what EA has put in the t_attribute.scale column.

The alphabetical ordering is probably cause by the option: Tools/Options/Objects/Sort Features Alphabetically.

Geert

[kadamowi]

Thanx Geert,
for Scale I will try use Access.
Alphabetical order not working with this option, but I find another solution: in VBA script I set field attribute.Pos
after that its ok.

Kris