Importing Table Definitions from a Spreadsheet

[Colley@localhost 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.
[original message]

[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.
[original message]

[B@localhost 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
[original message]

[Bellekens@localhost Geert Bellekens]

For option b) see Simple VBA Excel to EA importer V3 (http://bellekens.com/2013/04/30/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
[original message]

[Bellekens@localhost Geert Bellekens]

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

Geert
[original message]

[Mitchell@localhost 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.
[original message]

[qwerty]

58505F545C58455259545D5D310 wrote:

- I can also be done -

Well done ;D

q.
[original message]

[Ron Sonntag]

None of your links below work any longer.