Book a Demo

Author Topic: How to export relationship in CSV format & GUI  (Read 5907 times)

ddinh

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
How to export relationship in CSV format & GUI
« on: January 13, 2012, 01:35:39 am »
Hello,

I would like to export my whole model, but when I attempt to export my model, in the export specification, EA considers only metaclass "Element" which is really limited.

How can I include within my CSV export, the whole elements contained within my model ? (classifiers, relationships etc.)

1. I'm trying to use the "search" feature, I'm not able to include "relationship" within the result page. Maybe it's possible but I just don't find this feature.

2. I can manage to do this with Document export because he proposes what EA calls "connectors" but unfortunately GUID is not available in document export. If it was, I would have been able to create a CSV Template with GUID and then take benefit of the IMPORT CSV for getting back my Excel modifications within my EA model.

Any solution to propose ?

Thanks in advance,

Dorian.
« Last Edit: January 13, 2012, 01:40:13 am by ddinh »

ddinh

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: How to export relationship in CSV format
« Reply #1 on: January 13, 2012, 02:48:59 am »
I managed to get my "class" and "association" through SQL request on my model.

However, does anybody know how to list directly in the search result, the elements related to one element (equivalent of the content of the "links" properties within a class in a diagram) ?
« Last Edit: January 13, 2012, 03:12:06 am by ddinh »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to export relationship in CSV format & GUI
« Reply #2 on: January 13, 2012, 05:01:34 pm »
It looks like this is going to be a lot easier if you skip the EA search, and fill the excel file using code.
If you look for "export excel" you should find some example code in the forum.

Geert

ddinh

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: How to export relationship in CSV format & GUI
« Reply #3 on: January 13, 2012, 09:33:13 pm »
Hi,

There is no clue on excel interface within the whole forum.

The main issue is EA doesn't provide a simple editor for introspecting a model or even querying it with UML2 set of metaclass & metarelations...

Why providing a so static structure as table for querying a model ? I don't want tables, i need objects !

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to export relationship in CSV format & GUI
« Reply #4 on: January 13, 2012, 09:50:02 pm »
There's actually quite a lot, most of were responses with code snippets from me.

You just have to know how to search:
- Use the top left search button
- Search for "excel export"
- Select "Automation Interface, Add-Ins and Tools" forum
- Change "This post was made in the last..." into "(all posts)"
- Press Search
- Be patient

Geert