Book a Demo

Author Topic: Exporting "IsA" and "HasA" relationships to excel  (Read 4568 times)

Nosipho

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Exporting "IsA" and "HasA" relationships to excel
« on: April 26, 2016, 05:56:50 pm »
Hi Guys

I am new to SPARX and would like to know how to export relationships from the projects that I have to excel

Thank you in Advance  :) :)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Exporting "IsA" and "HasA" relationships to excel
« Reply #1 on: April 26, 2016, 06:59:44 pm »
A relation on itself is like a hook in the air ;) So you will likely export the two objects the connector links as well. You might look into the VB script to export tagged values (it comes with the EA Scripting Library). You can modify that to your needs.

q.

Nosipho

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Exporting "IsA" and "HasA" relationships to excel
« Reply #2 on: April 26, 2016, 10:22:21 pm »
I use SPARX v2, we can I find the VB script?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Exporting "IsA" and "HasA" relationships to excel
« Reply #3 on: April 26, 2016, 11:47:15 pm »
You meant V12, right? Even I started with V3 some 15 years ago.

First turn on EA Scriptlib in Extensions/MDG. Now go to Tools/Scripting. Here you find a lot of examples (along with the CSV script which is the one you need to modify).

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Exporting "IsA" and "HasA" relationships to excel
« Reply #4 on: April 27, 2016, 07:04:26 pm »
I tend to use SQL searches for all of my exports.
Usually it is easier (and a lot quicker) to write a query then it is to write a script.

Geert