Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: dangel on December 10, 2014, 09:37:37 am

Title: How to find EA-File GUID
Post by: dangel 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

Title: Re: How to find EA-File GUID
Post by: qwerty 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.

Title: Re: How to find EA-File GUID
Post by: dangel 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

Title: Re: How to find EA-File GUID
Post by: KP on December 10, 2014, 12:05:57 pm

This looks promising:

Code: [Select]

SELECT Value FROM usys_system WHERE Property='ProjectGUID'

Title: Re: How to find EA-File GUID
Post by: qwerty on December 10, 2014, 08:40:22 pm

Quote

You mean: parent_ID=0 ?

Of course :-[

q.

Title: Re: How to find EA-File GUID
Post by: dangel on December 11, 2014, 08:00:02 am

perfect