Messages

1

General Board / Re: Exporting the results of a SQL query

« on: Today at 08:56:45 pm »

Export to CSV from the button/menu on the top right of your search results (next to the [?] button for help)
I think you need to first select all results

(or Ctrl-A, Ctrl-C, open notepad, Ctrl-V, save as .csv)

Geert

2

General Board / Re: Exporting the results of a SQL query

« on: Today at 08:16:40 pm »

Thanks Geert,
I've never written a SQL search query before (I am assuming it is in EA?) , I shall have to investigate!
Thank you.

I posted few articles about SQL searches on my website that might be of use: https://bellekens.com/tag/sql/

Geert

3

General Board / Re: Help! query to list all classes, attributes and all tagged values from a diagram

« on: Today at 06:49:07 pm »

Hi Richard,

It' a bit too much for me to write the complete query, but I can give you some hints:

Probably the best option will be to write a number of separate queries (one of elements, one for attributes, one for tagged values) and use a join stitch them all together.
You would need to join
- t_diagram->t_diagramObjects->t_object for elements
- t_diagram->t_diagramObjects->t_object->t_attribute for attributes
- t_diagram->t_diagramObjects->t_object->t_objectProperties for tagged values (on elements)

Geert

PS. If you need to include notes, you're going to need to do some special processing as newlines in the notes will mess up your CSV format. (the standard "save as CSV" function from the search window does not take handle this correctly.)

4

Automation Interface, Add-Ins and Tools / Re: Connect Connector to Class using ProxyConnector

« on: Today at 12:26:11 am »

Bug or Feature? :-)

Does it matter? I would report it anyway.
The worst that could happen is that Sparx refuses to do anything about it.

Geert

5

Automation Interface, Add-Ins and Tools / Re: Import C# - unexpected result

« on: November 20, 2018, 10:45:24 pm »

I'm guessing EA has to do it this way to be able to generate the same code if you would do forward engineering.

It is in fact the most literal translation of the code I can think of.

Geert

6

General Board / Re: DB error: table 'Schema.t_taggedValue' doesn't exist, found via RAS

« on: November 20, 2018, 08:04:38 pm »

Sounds like it would do harm if you actually used it.

AFAIK t_taggedValue is used to store tagged values for connector roles, operation parameters, and maybe a few others.

Geert

7

Automation Interface, Add-Ins and Tools / Re: Connect Connector to Class using ProxyConnector

« on: November 20, 2018, 07:56:27 pm »

I use a free tool called AnySQL Maestro to connect to .eap files.

Not sure if the SourceTS and DestTS fields are relevant. The best way to know for sure it to update the database and find out.
Not sure what these fields are supposed to mean, so I'm not sure if there is an API field that corresponds.

If all else fails you can always use the nuclear option: Repository.Execute, but make sure that you know what you are doing. Once you go there you are on your own (not supported by Sparx)

Geert

8

General Board / Re: [EA13.5] - Open EA and display diagram/element by GUID

« on: November 20, 2018, 07:09:58 pm »

There used to be an open source project called "EA Protocol handler" or something like that that did exactly this.
I remember testing it a long time ago, but the hyperlinks got too long for Word to handle.

You might be able to resurrect that.

Another option is to use the EA Navigator add-in I developed. It has a feature to select an item based on the GUID in the clipboard (just like qwerty's add-in)

Geert

9

Automation Interface, Add-Ins and Tools / Re: Connect Connector to Class using ProxyConnector

« on: November 20, 2018, 06:52:58 pm »

You'll have to compare your results in the database with those when you do it manually.
Make sure to also look in the t_xref. You might be missing some magic dust here or there.

I've never actually created those proxy connectors in code myself.

Geert

10

Automation Interface, Add-Ins and Tools / Re: Import C# - unexpected result

« on: November 20, 2018, 05:30:27 am »

Well, to be honest, your code doesn't contain any attributes either.

So it fact it seems that the result in EA is an exact representation of your code, including the fact that you choose to make your attributes implicit.
I guess this is the way EA distinguishes implicit from explicit attributes.

Geert

11

General Board / Re: Exporting the results of a SQL query

« on: November 19, 2018, 05:08:33 am »

David,

The simplest way is to write an SQL search query and export the results from there.

Another option is to write a small script that automates that.
In such a script you could also directly export to Excel if you wanted to.

Geert

12

Bugs and Issues / Re: FK association not created at import from ODBC

« on: November 16, 2018, 11:12:47 pm »

Apparently the automatic script creation doesn't include unique indexes. Below the complete script.

Code: [Select]

/****** Object:  Table [dbo].[MESSAGE_IN]    Script Date: 16/11/2018 13:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_IN](
[MESSAGE_IN_ID] [bigint] IDENTITY(1,1) NOT NULL,
[MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_IN] PRIMARY KEY CLUSTERED
(
[MESSAGE_IN_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Index [messageID]    Script Date: 16/11/2018 13:08:36 ******/
CREATE UNIQUE NONCLUSTERED INDEX [messageID] ON [dbo].[MESSAGE_IN]
(
[MESSAGE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[MESSAGE_IN2]    Script Date: 16/11/2018 13:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_IN2](
[MESSAGE_IN2_ID] [bigint] IDENTITY(1,1) NOT NULL,
[MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_IN2] PRIMARY KEY CLUSTERED
(
[MESSAGE_IN2_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MESSAGE_OUT]    Script Date: 16/11/2018 13:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_OUT](
[MESSAGE_OUT_ID] [bigint] IDENTITY(1,1) NOT NULL,
[REFERENCE_MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_OUT] PRIMARY KEY CLUSTERED
(
[MESSAGE_OUT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MESSAGE_OUT2]    Script Date: 16/11/2018 13:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MESSAGE_OUT2](
[MESSAGE_OUT2_ID] [bigint] IDENTITY(1,1) NOT NULL,
[REFERENCE_MESSAGE_ID] [bigint] NOT NULL,
 CONSTRAINT [PK__MESSAGE_OUT2] PRIMARY KEY CLUSTERED
(
[MESSAGE_OUT2_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MESSAGE_OUT]  WITH CHECK ADD  CONSTRAINT [FK_MESSAGE_OUT_MESSAGE_IN] FOREIGN KEY([REFERENCE_MESSAGE_ID])
REFERENCES [dbo].[MESSAGE_IN] ([MESSAGE_ID])
GO
ALTER TABLE [dbo].[MESSAGE_OUT] CHECK CONSTRAINT [FK_MESSAGE_OUT_MESSAGE_IN]
GO
ALTER TABLE [dbo].[MESSAGE_OUT2]  WITH CHECK ADD  CONSTRAINT [FK_MESSAGE_OUT2_MESSAGE_IN2] FOREIGN KEY([REFERENCE_MESSAGE_ID])
REFERENCES [dbo].[MESSAGE_IN2] ([MESSAGE_IN2_ID])
GO
ALTER TABLE [dbo].[MESSAGE_OUT2] CHECK CONSTRAINT [FK_MESSAGE_OUT2_MESSAGE_IN2]
GO
Geert

13

Bugs and Issues / Re: "Prefer property dialogs" not working in sequence charts?

« on: November 16, 2018, 11:00:34 pm »

Heiko,

This setting was only introduced for the attributes and operations dialog, not for any of the other dialogs.

If you want to get the old dialog back for sequence messages I guess you'll have to send in a feature request.

Geert

14

Automation Interface, Add-Ins and Tools / Re: Insert Related Elements - Q

« on: November 16, 2018, 06:17:52 pm »

I also once made an EA-Matic script that basically does the same thing, but on the fly.

I called it Self-maintaining diagrams

Geert

15

Automation Interface, Add-Ins and Tools / Re: TFS connector synchronization error

« on: November 16, 2018, 06:14:32 pm »

So will this connector also work with VSTS?

I'm not sure. I'm afraid basic authentication won't be enabled on VSTS, but I've never actually tested it.

Geert