Author Topic: How to find EA-File GUID  (Read 5968 times)

dangel

  • EA User
  • **
  • Posts: 74
  • Karma: +0/-0
    • View Profile
How to find EA-File GUID
« on: December 10, 2014, 09:37:37 am »
Is there any mechanism to determine the ID,GUID of the EA-file which being opened by a user,
The goal is to know some signature of the file to recognize if I use this File before or not, so I assumed there is guid of each EA-file if so, where can I find this ID in DB-Tables?

Regards

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: How to find EA-File GUID
« Reply #1 on: December 10, 2014, 10:02:31 am »
You might use that of (one of) the root packages. Use Repository.Models to find them. There you also find a guid.

In the tables use
Code: [Select]
SELECT t_package.ea_guid from t_package where t_package.Package_ID = 0q.
« Last Edit: December 10, 2014, 10:04:40 am by qwerty »

dangel

  • EA User
  • **
  • Posts: 74
  • Karma: +0/-0
    • View Profile
Re: How to find EA-File GUID
« Reply #2 on: December 10, 2014, 10:10:27 am »
You mean: parent_ID=0 ?
if so, I think this is not prefect because in one file we could have 1 or more pakage as root package with no parent_id ?

Thanks

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +54/-3
    • View Profile
Re: How to find EA-File GUID
« Reply #3 on: December 10, 2014, 12:05:57 pm »
This looks promising:

Code: [Select]
SELECT Value FROM usys_system WHERE Property='ProjectGUID'
« Last Edit: December 10, 2014, 12:07:53 pm by KP »
The Sparx Team
[email protected]

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: How to find EA-File GUID
« Reply #4 on: December 10, 2014, 08:40:22 pm »
Quote
You mean: parent_ID=0 ?
Of course :-[

q.
« Last Edit: December 10, 2014, 08:40:46 pm by qwerty »

dangel

  • EA User
  • **
  • Posts: 74
  • Karma: +0/-0
    • View Profile
Re: How to find EA-File GUID
« Reply #5 on: December 11, 2014, 08:00:02 am »
perfect