Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - YogaMatt

Pages: 1 ... 3 4 [5] 6 7
61
Hi Geert

I'd noticed the SQL fragments, but wasn't sure it would work as the query in our model view creates derived columns e.g.

COALESCE(dest.Name,destCls.Name) + '_AND_' + COALESCE(src.Name,srcCls.Name) [InterfaceName]

When you say "maybe" - do you know that this will work?

Cheers

YM

62
Hi All

There are two very different types of ModelView in EA. One is a model element, accessible from the toolbar on most diagram types, under Artifacts. The other is the Ctrl-Shift-5 "Model Views" window.
I'm asking about is the model element type, which we're currently using to display interface catalogues (see the TOGAF model template for an example).

They work nicely. But the document generation capability in EA disregards it. I can create a template to output the interface connectors, so that's not a major problem. But stakeholders want an output which looks very much like the one you can see in the model. We could do that by running the SQL script directly on the database and export the results to Excel. But that's not joined up when it comes to managing complete documents from place.

Any ideas?

Cheers

YM

64
Hi Gayle
That sounds like a neat trick, and of general use. Have you thought about posting it somewhere?
Does the diagram auto-refresh or can you place an "update" button on it to run the script?
Cheers
Matt
Namaste

65
Hi Gayle
I recommend you download a trial of eaDocX - I'm sure you'll be pleased with the results.
It'll give you HTML tabulated (and hyperlinked) model content.
With the collaboration edition, you can even get non-model stakeholders to provide feedback in one place for all to see.
You can then take that feedback and push it through into the model from the document.
Hope that helps!
Matt

66
Let me playback what I think you want:
Produce output which combines model output with externally "generated" stuff.
A very good option would be to use eaDocX (I have no commercial interest - just a happy user).
You can place various sections in an external document that are interlaced with the existing content in that document.
One use case is to use an external document template with header, TOC, disclaimer, etc and ensure model output goes into the appropriate sections.
eaDocX document generation will not trample all over the existing content, just squirt in what you want, where you want.
What's more, in one of the editions, you can manage the documents within the model.
I don't think it let's you generate HTML in this way (i.e. interlacing model content and other content), but having produced a Word document you could save as HTML.

Then you won't have to script.

Hopefully I've understood your problem and this is a viable solution for you.

67
If you're running on OSX, are you:
  • also running Microsoft Office under Crossover? In which case you may encounter the same issues seen running script within Office as you do within EA;
  • or running Office for Mac? In which case, have Sparx stated MDG fo Office integrates with Office for Mac?

I don't these questions help, but I'd like to understand your experience too as I use a Mac at home.

68
I can't answer definitively, but it would make sense for the file to be imported to be used as a Sample when creating a profile: surely it's just reading it as an aid to creating a mapping in the (separate) profile file and therefore shouldn't need to write to the "Sample". Thus the sample could then be the source? But perhaps this isn't allowed, and could be why we're having a related problem - see this thread: http://sparxsystems.com/forums/smf/index.php/topic,30337.0.html
Let's hope we get an answer  :)

69
Hi Stu_Cox
I have also failed to import the relationships between two types of thing, from an Excel spreadsheet.
It looks as though it's going to work in stepping through the dialogue windows (unlike the other thread: http://sparxsystems.com/forums/smf/index.php/topic,30348.0.html).
And it looks as though it has worked in the import log output window.
But it simply fails to create objects in the browser.
In disbelief, we even exported the package to XMI and searched on the XML - and saw the items that should have been created! Reloading the package content has no effect.
In further disbelief, we searched on the items in the model and they came up in the search results, but "find in browser" does not work.
Now I've written all this down, I think we have a bug report!?!?
Time to submit one. I'll reference this thread and ask support to post a response here.
Cheers and Namaste!
YM

70
General Board / Re: Keyboard shortcuts
« on: February 20, 2016, 01:22:39 am »
All good, thank you. I prefer the reference card as it fits nicely below my monitor.
Hopefully they are all consistent even if not the same!  :)

71
General Board / Re: Keyboard shortcuts
« on: February 17, 2016, 02:27:48 am »
Thank you - more good Karma :-)

72
General Board / Re: Keyboard shortcuts
« on: February 17, 2016, 01:13:39 am »
I wonder if, 14 years on, anyone has found / made a list of EA shortcuts?

73
General Board / Re: Search the text within relationships
« on: February 16, 2016, 07:51:13 pm »
Thanks everyone - I'm on my way!  :)

74
General Board / Re: Search the text within relationships
« on: February 16, 2016, 03:47:19 am »
Fantastic Geert
In and around other calls on my time I'd got to:
SELECT Connector_Type, c.Name as "Relationship", os.Name as Source, od.Name as Dest, c.Notes as C_Notes, ps.Notes, pd.Notes
FROM t_connector c
inner join t_object os on os.Object_ID = c.Start_Object_ID inner join t_objectproperties ps on ps.Object_ID = os.Object_ID
inner join t_object od on od.Object_ID = c.End_Object_ID inner join t_objectproperties pd on pd.Object_ID = od.Object_ID

But I'd stalled as I realised I'd need some mechanism to insert the search term. Came back to the forum for it, and there it was!  :)
You've given me a great fish. Now, so that I can fish myself, can you point me at the table definitions and any help sources on e.g. the #WC#<Search Term>#WC# macro?
Many, many thanks.

75
General Board / Re: Search the text within relationships
« on: February 16, 2016, 02:01:55 am »
I suspect you're right - so I'm now hunting for the definition of the tables I can search.
SELECT TABLE_NAME FROM <DATABASE_NAME>.INFORMATION_SCHEMA.Tables ORDER BY TABLE_NAME gives me a long, unfamiliar list!
Wish me luck!

Pages: 1 ... 3 4 [5] 6 7