Importing CSV Columns into EAUML::table Stereotype Tables

[Tarzan]

Hi everyone,

I have tables modeled using the EAUML::table stereotype in Enterprise Architect, and I have a CSV export from an Oracle database with columns like:

Column_Name

Mandatory

Computed

Formula

Check_Constraint_Name

Default_Value

Use_Domain_Constraint

Uses_Default

Engineer

Table_Name

PK_Flag

FK_Flag

Native_Type

Sequence

I understand that you can customize the CSV import specification in EA, but what I don’t know is which exact values should be used in the CSV to correctly map fields to the stereotypes and attributes in the tables. For example, how should I represent a primary key checkbox (PK_Flag), or other flags like FK_Flag, Mandatory, etc., so that EA correctly interprets them as stereotypes or tagged values?

I want to import the columns into the correct tables based on the Table_Name field and have these attributes correctly set in EA.

If anyone has experience with this, or can share the correct way to format these values in the CSV for EA to recognize and map them properly, that would be a huge help!

Thanks in advance for any tips or examples.

[Geert Bellekens]

You can't import attributes with the CSV import/export.

I wrote an excel import/export tool to do that type of stuff: https://bellekens.com/product/ea-excel-import-export/

Geert

[Sunshine]

If I've understood correctly you want to model the oracle database so why don't you just reverse engineer the oracle database
 using functionality built into Sparx EA?
https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_domains/importdatabaseschemafromod.html