Book a Demo

Author Topic: Relationship Matrix export to CSV via Script?  (Read 5808 times)

yaccoff

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Relationship Matrix export to CSV via Script?
« on: September 18, 2019, 07:11:51 am »
V12. MS Access DB. I can use the GUI to export to CSV a Relationship Matrix. Can I do it vis VBScript?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #1 on: September 18, 2019, 07:46:20 am »
Actually Sparx provides a script (EAScriptingLib MDG activated) to do that.

q.

yaccoff

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #2 on: September 20, 2019, 03:48:07 pm »
How does one obtain this Script? I can see it in the general scripting library and my company has a fully licensed copy?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #3 on: September 20, 2019, 04:45:37 pm »
Where the hell did my menu go? I can't find the Scripting window in V13 (think of a longer rant here). So I opened an older EA version where it's under Tools/Scripting (no ribbon there, no logical menu position, but anyway). Once you have that open you see a folder EAScriptLib (provided you have turned on the MDG with the same name). Inside that folder there's JScript-CSV.

q.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Best Regards, Roy

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #5 on: September 23, 2019, 02:49:26 pm »
Not really, since there is no Ribbon/Code. It ripped off, I guess.

q.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #6 on: September 23, 2019, 04:04:21 pm »

https://sparxsystems.com/enterprise_architect_user_guide/13.0/user_interface/ribbons.html

Perhaps someone minimized the ribbon band, or customized it to not show the Scripting ribbon? (See the Ribbon Menus link at the end of the Help page).
Best Regards, Roy

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #7 on: September 23, 2019, 04:38:32 pm »
If you tell me where to find
Quote
select the 'Ribbon Menu' page of the Workspaces And Commands Window
I will happily look further. The best match for that looks like Start/Workspace. But that's a cul-de-sac.

q.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #8 on: September 24, 2019, 10:23:41 am »
That would be here:

https://sparxsystems.com/enterprise_architect_user_guide/13.0/user_interface/ribbon_menus.html

It is the topic that the first topic links to, in the 'Learn more' list.
Best Regards, Roy

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix export to CSV via Script?
« Reply #9 on: September 24, 2019, 03:41:37 pm »
That finally was a hit. It must be a hell of work to keep the documentation with the ever changing menus in synch :-/

Now back to the OP. I don't know whether your company has the rigt license. I have Corporate and that allows me to use scripting. It's a medium level license. If your company has a lower (why should they?) you can run the script from outside as well. It needs a bit of framework to be set up by yourself, though.

q.