Book a Demo

Author Topic: Possible to get Site-IDs (i.e. EA1/EA2/EA3.htm) out of the eap-database (SQL)?  (Read 4383 times)

Schludi

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Hello Community!

I have the Object-Name/Object-Alias for an exported HTML-Site/EA-Object and want to get the link like:

.../EARoot/EA3/EA3/EA3/EA2/EA834.htm

out of the database by name.

What I need is a function like this, that gets from the SQL-EAP-File (MDB) the link.

Code: [Select]
url getLinkForSiteAlias(string sitealias) {... return sitealias}

or

url getLinkForSiteName(string sitename) {... return sitename;}

Is it somehow possible to get the generated filepath from the SQL?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
You can get stable url's using the GUID.

Geert

Schludi

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Hi Geert!

Is it possible to use the GUID to link to an HTML Export Element?

Greets Björn

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Hej!

Try https://example.com/Generated_EA_Stuff/index.html?guid={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}

This works for diagrams too, if you want to link to your generated HTML from another page.
Just be aware that while GUIDs obviously survive successive generations, those links tend to die if people delete and redraw diagrams, since that results in a new GUID.

/Uffe
My theories are always correct, just apply them to the right reality.

Schludi

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Thank you very much that is exactly what i need!