Book a Demo

Author Topic: Can you import relationships via CSV?  (Read 10560 times)

jplusip

  • EA User
  • **
  • Posts: 69
  • Karma: +0/-0
    • View Profile
Can you import relationships via CSV?
« on: November 14, 2015, 03:18:48 am »
Generally I've just used it to bring in model elements, but now my team is trying to bring in an Access database that has relationships built in.

Is there a way for them to export CSV files in such a way that we can create the relationships between model elements that they have in their database?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Can you import relationships via CSV?
« Reply #1 on: November 14, 2015, 03:46:19 am »
Use either the CSV ex/importer that comes with the EA scripts or use Geerts VB solution. You need to code the relations in addition to the elements yourself.

q.

Sam Courtney

  • EA User
  • **
  • Posts: 58
  • Karma: +1/-0
    • View Profile
Re: Can you import relationships via CSV?
« Reply #2 on: November 14, 2015, 03:53:43 am »
We provide a platform to export / import csv content with relationships.
See more here http://www.aprocessgroup.com/products/apg-modelflow/

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can you import relationships via CSV?
« Reply #3 on: November 14, 2015, 04:08:43 am »
For a database you best use the reverse engineering process over ODBC.
Right click on a package and choose Code Engineering|Import DB Schema from ODBC

Geert

PS. You can find my Excel importer here: http://bellekens.com/2015/10/24/simple-vba-excel-to-ea-importer-v4/

jplusip

  • EA User
  • **
  • Posts: 69
  • Karma: +0/-0
    • View Profile
Re: Can you import relationships via CSV?
« Reply #4 on: November 18, 2015, 02:52:57 am »
Quote
For a database you best use the reverse engineering process over ODBC.
Right click on a package and choose Code Engineering|Import DB Schema from ODBC

Geert


Is this capability available in all editions of EA? I'm running version 12 but whenever I right click on a package and go to Code Engineering the Import Schema from ODBC is grayed out. If it is available in all editions, is there some up-front work I need to be doing?

Thanks!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can you import relationships via CSV?
« Reply #5 on: November 18, 2015, 03:35:02 am »
On this page http://www.sparxsystems.com/products/ea/compare-editions.html database engineering is available in all but the desktop edition.
I expect this feature to be part of database engineering.

Geert
« Last Edit: November 18, 2015, 03:35:20 am by Geert.Bellekens »

jplusip

  • EA User
  • **
  • Posts: 69
  • Karma: +0/-0
    • View Profile
Re: Can you import relationships via CSV?
« Reply #6 on: November 20, 2015, 03:10:44 am »
Turns out that the Code Engineering on this project has been locked away behind administrative rights, hence my confusion. Ah well.

Anyways, thanks for the help guys!
« Last Edit: November 20, 2015, 03:13:05 am by jplusip »