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 - RWHurra

Pages: [1] 2 3 ... 6
General Board / Sort elements in Gantt?
« on: April 09, 2018, 05:58:07 pm »

I am trying to organize a project with EA. No problem creating a Gantt, I would however like to change the order of the elements by end (or start) date. Now it always sorted in alphabetical order.

Can I somehow add milestones in this Gantt? Or only by creating element, assign resource? I can't easily visually distunguish "work" from milestones.

I also saw a post on the forum, without answers, regarding linking element w resources together, e.g. if I delay one element, the next moves as well. Is this possible?

Thank you.


General Board / Office MDG and SharePoint
« on: April 06, 2018, 05:39:41 pm »

I did some googling but mostly found questions regarding using SharePoint as repository which is not what I'm looking for.

I can't find out what the SharePoint integration is. There is Publish to SharePoint. Is this a HTML-export? Images? Should I use it on diagrams? Packages? Root nodes?

Also, I can't seem to be able to connect to our SharePoint URL. Do I have to log in as admin? What URL should I use?

Where can I find more information?

Thank you!


Weird. I'm not sure why it doesn't work.
I've used similar constructions in the past without issues.

Nothing in the template filters that is blocking some content?


Before I implemented the new diagram and SQL search I tried to get my elements of interest with filters... Ofc I forgot about that.

Thank you!

As an extra I can ask if this approach is considered "good". We have structured a stereotype with the dependency relation, depends on/needed by. If I only want the TOP element, can I create an SQL search to find all these elements but filter out the elements which only acts as source? The TOP element is never target I guess?

Thanks again Geert!

And you are using a model document with the search and this template?


Yes. The search is selected through tagged values, and also search string specified.


table with Element.Name and Element.Notes



I use a SQL search to find my elements that I want in a table in my report.

I made it easy for me and put the desired elements in a diagram and my search has diagram name as input and lists all the elements on the diagram which was found:

Code: [Select]
SELECT o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, AS Name, o.Note AS description
FROM (( t_object o
INNER JOIN t_diagramobjects do ON do.Object_ID = o.Object_ID)
INNER JOIN t_diagram d ON d.Diagram_ID = do.Diagram_ID)
WHERE LIKE '#WC#<Search Term>#WC#'

The result is correct according to the SQL search/output window, however in the report, only the first element of that list is generated.

What am I missing?


General Board / Re: Element name on default iamge
« on: March 16, 2018, 11:35:01 pm »
Thank you qwerty!

I tried to return to original format, but the element looks strange.

I originated from an ArchiMate BusinessProcess default appearance. Now I have the stereotype on the element, and what it looks like, a function symbol above the process symbol.

General Board / Re: HTML report for large diagrams
« on: March 16, 2018, 09:07:48 pm »
First thought: why is the diagram that big? Can't you chop it off in several smaller diagrams?

General Board / Element name on default iamge
« on: March 16, 2018, 07:09:04 pm »

I was requested to use an image as background image for a certain type of element. We have not made a custom MDG and can therefore (?) not add a background through shape script. I added the image by right clicking: Appearance: Set Default Image.

The problem is that I now only can place the name under the element, or hide it. Can I somehow still have the name in the same place in the element, just on top of the background image?

I tried to do some googling but didn't find anything.

I guess the problem also is that this has to be done to all element "instances" of this type. I guess I might be able to script it..

I know I have played around with editing shape scripts through: UML Types, but I cant find any elements from ArchiMate there? I do see two ArchiMate relations: ArchiMate3::ArchiMate_Association and ArchiMate3::ArchiMate_Composition, but no elements.

Thank you!

No, mainly because there's no generally agreed on definition of "real" I guess.


There is no spoon.

use "left join" instead of "inner join"


Thanks for your fast reply Geert!

I really need to step up my SQL game.. hehe ::)

Hello again!

I added
Code: [Select]
inner join t_objectresource objr on o.Object_ID = objr.Object_ID

to fetch start and end date. It works fine but:

if the element have no resource allocation assigned the row comes empty.

Column 1: Name of related element
Column 2: Start date of column 1 element
Column 3: End date of column 1 element

So if column 1 element have no start/end date, there is no row. Can I somehow always show column 1, and leave column 2 and 3 blank if there is no data? Or do I have to do this with scripting?


Thank you Geert and Uffe!

The problem was that we had a <Diagram Notes> in the diagram. I removed it and ticked "Show Diagram Details" instead, works like a charm again!

I guess there is no built-in solution to only get "real" elements. I have to to a for loop to check type/sub-type?

Code: [Select]
Script Trace - CWIX 2017 has 6 childs
Script Trace - Element: CIWX 2017 IPC, stereotyp: ArchiMate_BusinessCollaboration
Script Trace - Element: CWIX 2017 ESC, stereotyp: ArchiMate_BusinessCollaboration
Script Trace - Element: CWIX 2017 EXE, stereotyp: ArchiMate_BusinessCollaboration
Script Trace - Element: CWIX 2017 FCC, stereotyp: ArchiMate_BusinessCollaboration
Script Trace - Element: CWIX 2017 MPC, stereotyp: ArchiMate_BusinessCollaboration
Script Trace - Element: , stereotyp:

Where does the extra empty element(?) come from??

Notice that this is the only element with this problem. Other elements with child elements and diagrams documents fine.

When I change location of the diagram, i.e. no child diagrams, it runs fine. But other elements with child diagram runs fine as well...

childElems has length 6 although there are only 5 child elements, and 1 child diagram.

Pages: [1] 2 3 ... 6