Neil Clayton

[Neil Clayton]

I had meant to add that if you would like an EAP with suitable data in let me know what e-mail address to send it to and I’ll oblige — it’s about 3.5MB.

[Neil Clayton]

It’s in the FAQ. I found it about an hour ago. My elements have quite a deep hierarchical structure and I discovered that I needed to move elements in each branch to get it to work right. Makes sense wen you think what is actually happening.

Now working well. 🙂

[Neil Clayton]

Have tried again and restructured my Word doc to, I hope, better fit EADocX’s way of working but obviously have more of a problem than I thought! The sort order doesn’t follow the order in the Project Browser in my EAP file — no idea what I am doing wrong but presume I must have set an option somewhere that tells EADocX to ignore the EA sort order.

Happy to e-mail you an extract from my EA database and the Word doc generated if you let me know what e-mail address to send it to. 🙂

• This reply was modified 9 years, 11 months ago by Neil Clayton. Reason: Couldn't add EAP attachment.

[Neil Clayton]

Here’s the SQL the Search Term used was ‘Data Warehouse Features’.

[code]select O.ea_guid AS CLASSGUID, O.Object_Type AS CLASSTYPE, O.Name, O.Note, ‘Capability’ as Item, TV.Value AS CapabilityRef, TV0.Value AS CapabilityRefL0, TV1.Value AS CapabilityRefL1, TV2.Value AS CapabilityRefL2, TV3.Value AS CapabilityRefL3, TV4.Value AS CapabilityRefL4
from t_object O
inner join t_diagramobjects DO on O.object_id = DO.object_id
inner join t_diagram D on D.diagram_id = DO.diagram_id
left join t_objectproperties TV on O.object_id = TV.object_id and TV.property = ‘CapabilityRef’
left join t_objectproperties TV0 on O.object_id = TV0.object_id and TV0.property = ‘CapabilityRefL0’
left join t_objectproperties TV1 on O.object_id = TV1.object_id and TV1.property = ‘CapabilityRefL1’
left join t_objectproperties TV2 on O.object_id = TV2.object_id and TV2.property = ‘CapabilityRefL2’
left join t_objectproperties TV3 on O.object_id = TV3.object_id and TV3.property = ‘CapabilityRefL3’
left join t_objectproperties TV4 on O.object_id = TV4.object_id and TV4.property = ‘CapabilityRefL4’
where D.name = ‘

‘ and O.Stereotype = ‘Archimate_BusinessFunction’
union all
select O.ea_guid AS CLASSGUID, O.Object_Type AS CLASSTYPE, O.Name, O.Note, ‘Feature’ as Item, TV.Value AS CapabilityRef, TV0.Value AS CapabilityRefL0, TV1.Value AS CapabilityRefL1, TV2.Value AS CapabilityRefL2, TV3.Value AS CapabilityRefL3, TV4.Value AS CapabilityRefL4
from t_object O
inner join t_diagramobjects DO on O.object_id = DO.object_id
inner join t_diagram D on D.diagram_id = DO.diagram_id
inner join t_connector C on C.start_object_id = O.object_id
inner join t_object CO on C.end_object_id = CO.object_ID and CO.Stereotype = ‘Archimate_BusinessFunction’
left join t_objectproperties TV on CO.object_id = TV.object_id and TV.property = ‘CapabilityRef’
left join t_objectproperties TV0 on CO.object_id = TV0.object_id and TV0.property = ‘CapabilityRefL0’
left join t_objectproperties TV1 on CO.object_id = TV1.object_id and TV1.property = ‘CapabilityRefL1’
left join t_objectproperties TV2 on CO.object_id = TV2.object_id and TV2.property = ‘CapabilityRefL2’
left join t_objectproperties TV3 on CO.object_id = TV3.object_id and TV3.property = ‘CapabilityRefL3’
left join t_objectproperties TV4 on CO.object_id = TV4.object_id and TV4.property = ‘CapabilityRefL4’
where D.name = ‘‘ and O.object_type = ‘Feature’
order by CapabilityRefL0, CapabilityRefL1, CapabilityRefL2, CapabilityRefL3, CapabilityRefL4, Item[/code]

[Neil Clayton]

Taking the Glossary out worked speedwise! 🙂 But I still lose my sort order from my SQL Query. 🙁

Will try again on Monday. Thanks.

[Neil Clayton]

I did have a Glossary in it. I don’t think that my SQL was weird although it does return the Notes attribute.

A small part of me wonders whether it is to do with Word templates and where they are stored. I seem to remember from building a reporting engine that automated Word 2003 that you needed to be careful with where the Normal.dot template was as things could slow down greatly if Word couldn’t find one. I’ll investigate further on Monday.

[Neil Clayton]

I’ve actually used a Report section based on an EA Search based on a SQL query which delivers my elements in the order that I want them sorted in. However when I view the document gernated in draft mode by EADocX it seems to have lost my sort order. Is this because I ran it in draft mode or does EADocsX never let you specify the order?

I have tried generating it in draft but this seems to hang my machine. Or to be specific EA becomes unresponsive and Word occupies 25% of my cycles on a 4 core machine. It seems to insert all the content OK but never seems to complete the step after that — of course I could be being too impatient but I have waited about an hour for it to complete with Word reporting the generated document to be only 10 pages long.

• This reply was modified 9 years, 11 months ago by Neil Clayton. Reason: Added more detail

[Neil Clayton]

Thanks for the response. It feels like I could do with writing a script to generate a view based on the elements and hierarchy in my diagram. Will give it a go and see how I get on. 🙂

[Author]

Posts