Messages

1

Automation Interface, Add-Ins and Tools / How to work with review data

« on: August 26, 2022, 06:24:59 pm »

Hi,

I would like to use review data in my reports and (SQL) searches, but I don’t have clue where to begin. I can see that reviews are added in the t_object table, but I don’t have a clue where the content of the review is stored. Any suggestion that can point me in the right direction are more than welcome

Thanks advance!

2

Automation Interface, Add-Ins and Tools / Re: Where are milestones from resource allocation stored in the database

« on: July 13, 2022, 08:06:12 pm »

I've found it. It's in the t_xref table, the type must be t_objectresource and the "Supplier" contains the milestone's guid.

Thanks for your help and good luck with your terrace.

3

Automation Interface, Add-Ins and Tools / Where are milestones from resource allocation stored in the database

« on: July 13, 2022, 05:33:07 pm »

Hi,

Where in the database is the value stored that is set in the milestones property in the assign resource editor?

Thanks in advance!

Kind regards,

Luigi

4

General Board / Re: Database columns and SQL queries

« on: February 23, 2022, 11:26:03 pm »

The EAPX file is an Access Database as far as I know. So could open with any tool that supports Access and see the database structure. I don't know if EA lets you write SQL statements against an EAPX.

In the new EA 16 the EAPX is replaced by an SqLite DB. Maybe that is something to consider.

5

General Board / Re: Project transfer problems

« on: February 23, 2022, 11:19:58 pm »

I finally got it working. I have downloaded the EA 16 RC and migrated the old eapx file  (which was complete afaik) to the new file format after this I transferred the new file to the MSSQL DB.

Thanks for all the support!

6

General Board / Re: Project transfer problems

« on: February 23, 2022, 10:13:50 pm »

Hi Geert,

Not all of the missing t_document records are baselines, some of them are linked documents  I think it's kind of tricky that you can transfer it one way but not back.
I am going to try if your 64 bit suggestion works.

Note:
I just transfered an MSSQL to MSSQL (2008) with huge baselines without any problems so I looks like the MSSQL part can deal with large baselines both reading and writing. The transfer from MSSQL to eapx succeeded so I still don't understand why EAPX->MSSQL can't work.

7

General Board / Project transfer problems

« on: February 23, 2022, 09:10:58 pm »

Hi,

I am using EA (15.2.1559.26) together with a MSSQL 2008 Database and I have issues with transfering from a file to the MSSQL database. The source file I use is the output of a transfer from MSSQL to the file. This is the error I get:

Code: [Select]

An error has occurred: DAO.Field[0x0000bdb]
Insufficient system resources (translated from Dutch)
[Select * from t_document]
Field: bincontent

Press OK to continue to the next row (this record will be lost). Cancel to abort.

The log file looks like this:

Code: [Select]

  ERROR: *** t_document - record no: 738 Key: docid={5C162AA6-69C8-438c-BD1C-00C5AEE1E12B}
  ERROR: *** t_document - record no: 739 Key: docid={5C313952-2F63-4618-8D5A-9C4B41C16C70}

Opening the eapx file with Access I noticed that most of the docid where from baselines, but not all of them.  After removing the baselines manually in Access (Couldn't remove it from within EA because of errors) the project transfer worked with some errors. Before removing the baselines from the EAPX the file transfer never finished and stopped somewhere when processing t_document.

How can I transfer the EAPX to MSSQL with all data, including baselines?

Thanks in advance!

8

General Board / Current selected diagram object in SQL search

« on: February 14, 2022, 07:46:20 pm »

Hi,

I would like to obtain the GUID or ID of current selected diagram object from within a (SQL) search. How can I do that?

Thanks in advance!

9

Automation Interface, Add-Ins and Tools / MDG and search categories

« on: January 19, 2022, 02:59:40 am »

Hi,

In my MDG I will have a lot of searches and I would like to organize them with categories. Is this possible without creating multiple MDG profiles?

Thanks in advance!

10

General Board / Delphi language macro

« on: January 10, 2022, 02:05:32 am »

Hi,

I'm trying to import source code from a Delphi project into EA and during the import I get a message that says:
There was an error parsing <some file>. Unexpected symbol: <
You may need to define a language macro.

The line in the source code that gives the error looks like this:

Code: [Select]

FSearchQueryFieldId: kbmMWNullable<integer>;
I understand that I have to write a language macro for this "exotic" line of code, but I have no clue where to start? Any advice that points me in the right direction?

Thanks in advance!

Kind regards,

Luigi

11

Automation Interface, Add-Ins and Tools / Re: What is the most basic metatype?

« on: January 04, 2022, 02:17:55 am »

Works great! Thank you!

12

Automation Interface, Add-Ins and Tools / What is the most basic metatype?

« on: January 04, 2022, 12:48:25 am »

Hi,

What is the most basic metatype which I can use to create my own type?

Thanks in advance!

13

Automation Interface, Add-Ins and Tools / Re: MDG document generation with ImageRef tagged value type

« on: December 09, 2021, 01:24:56 am »

Ciao Paolo,

I compared the MDG tagged value with the non MDG tagged value in the t_objectproperties table but I don't see any differences. As far as I understand there is no difference once a record is inserted in the t_objectproperties table. How it came there MDG or manual shouldn't matter execpt if the property is prefixed or something. Or am I wrong about this?


I don't get it

14

Automation Interface, Add-Ins and Tools / MDG document generation with ImageRef tagged value type

« on: December 08, 2021, 10:07:30 pm »

Hi,

I have created an MDG Class which has a tagged value type as one of its attributes. The tagged value type is defined as:

Code: [Select]

Type=ImageRef;All works fine except that when I want to generate a document the following text is shown:

Code: [Select]

id=1948243495;mdg=Global;name=RiskMatrix.PNG;type=Bitmap;instead of the image. Which is of course not what I want.

When I create a ImageRef tagged value type and add it “manually” to an element and generate the report it works fine.

Any suggestion how I can solve this?

Thanks in advance!

15

Automation Interface, Add-Ins and Tools / Re: SQL Search selected or zero results returned

« on: December 08, 2021, 02:59:45 am »

I finally found the problem. My SQL looked like this:

Code: [Select]

SELECT *
FROM
(
SELECT #Concat t_object.ea_guid,t_object.Name# AS [BaseClassName.Hyperlink]
FROM t_connector  JOIN t_object  ON t_connector.End_Object_ID = t_object.Object_ID
WHERE
 t_connector.Start_Object_ID = #OBJECTID#
AND
 t_connector.Stereotype = 'TechDoc Trace'
UNION
SELECT #Concat t_object.ea_guid,t_object.Name# AS [BaseClassName.Hyperlink]
FROM t_connector  JOIN t_object  ON t_connector.Start_Object_ID = t_object.Object_ID
WHERE
 t_connector.End_Object_ID = #OBJECTID#
AND
 t_connector.Stereotype = 'TechDoc Trace'
) AS A
ORDER BY 1 ASC
Changing the * to [BaseClassName.Hyperlink] did the trick.