Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: MarcinG on September 15, 2021, 01:57:06 am

Title: Smart data import (from CSV/XLS) ?
Post by: MarcinG 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

Title: Re: Smart data import (from CSV/XLS) ?
Post by: Geert Bellekens 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/ (https://bellekens.com/product/ea-excel-import-export/)

Geert

Title: Re: Smart data import (from CSV/XLS) ?
Post by: santhosh 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