Importing Table Definitions from a Spreadsheet

[Duane Colley]

Hi All

Using EA 10, is there a way to mass import table/column definitions into a Data Model Diagram from a spreadsheet.  Database doesn't exist yet.

Spreadsheet would be typical layout.
table name, column name, type, precision, scale.

Thanks.

[qwerty]

A couple of ways: a) use the VB/Java script that comes with EA and adapt it. b) use Geerts importer. c) Use eaDocx.

q.

[Aaron B]

RE: using scripting to import CSV (option 'a' mentioned by qwerty) -

Enterprise Architect includes scripting libraries to assist with writing your own custom CSV Import/Export functions using EA's automation and scripting interface.  These libraries allow much greater control over CSV import/export (E.g. import/export of attributes, operations, connectors, etc).  Scripting is available in EA Corporate edition or higher. See the "Scripting" topic in EA help for details. The CSV scripting library can be found under Tools | Scripting > EAScriptLib > JScript-CSV.

You can find some import and export script examples on the following pages:
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1396310555/0#1
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1396913036/0#1

[Geert Bellekens]

For option b) see Simple VBA Excel to EA importer V3

It works out of the box for table name, column name and column type.
You'll have to adapt the VBA code a bit to include precision and scale, but that should be less then two hours of work.

Geert

[Geert Bellekens]

So now we just need a reply from Ian about option C  

Geert

[Ian Mitchell]

Oh - so I'm allowed to answer a question with 'use eaDocX' am I?  
Normally I get abuse when I do that
Geert's right - I can also be done - bi-directionally - with the Excel support in eaDocX.

[qwerty]

- I can also be done -

Well done

q.