Author Topic: Smart data import (from CSV/XLS) ?  (Read 4313 times)

MarcinG

  • EA User
  • **
  • Posts: 61
  • Karma: +0/-0
    • View Profile
Smart data import (from CSV/XLS) ?
« on: September 15, 2021, 01:57:06 am »
Hello,

Is there any way to import a list , that would contain e.g parent and child, allowing EA to create both parent, child, and dependency between them (specified in the list) ?  Not even dreaming about specifying different packages to import parent and child, but such small magic would already be helpful.

Any hints here :-) ?

Best regards
Marcin

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13387
  • Karma: +566/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Smart data import (from CSV/XLS) ?
« Reply #1 on: September 15, 2021, 03:26:45 am »
I'm not sure if any of the built-in features supports this, but you can build something like that yourself in Excel using a bit of VBA code.

If you want you can start from my excel import/export tool, and add the ownership relation as a new feature.
https://bellekens.com/product/ea-excel-import-export/

Geert

santhosh

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Smart data import (from CSV/XLS) ?
« Reply #2 on: September 15, 2021, 03:00:16 pm »
Yes, Sparx has MDG Office Integration Suite available which has Excel Import/Export and is pretty easy to configure your mapping profile and re-use them for synchronization as well when you want to update later. Also, you can have Parent-Child relations, Connectors, etc.

More details here: https://sparxsystems.com/resources/webinar/release/mdg-integration/mdg-office.html

Webinar Demo: https://sparxsystems.com/resources/webinar/release/mdg-integration/office-integration.mp4

Also, you can check Word, PowerPoint, and SharePoint integrations which could be useful exploring these which can make life easier when you are dealing with Model element creations.

$anthosh
« Last Edit: September 15, 2021, 03:13:57 pm by santhosh »