Messages

1

Automation Interface, Add-Ins and Tools / Re: SQL query for document generation.

« on: January 10, 2019, 08:40:43 pm »

I found "#CurrentElementID#" macro in here : https://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_navigation/creating_filters.html
But probably I didn't use it right 

Anyway #OBJECTID# worked.

Thanks!

2

Automation Interface, Add-Ins and Tools / Re: Resizing of diagram images in document generation.

« on: January 10, 2019, 08:23:41 pm »

Solved using MS Word macro.

Thanks

3

Automation Interface, Add-Ins and Tools / SQL query for document generation.

« on: January 10, 2019, 08:18:59 pm »

Hi,

how can I use a SQL query to select some information from the element that is being processed by the template?
For example, I'm using this SQL query:

"   SELECT distinct t_operation.Type as ReturnType, t_operation.Name as OperationName, t_operation.Scope as OperationScope, t_operationparams.Type as ParamType, t_operationparams.Name as ParamName, t_operationparams.Kind as ParamDirection, t_operation.Object_ID as ObjID
FROM  t_operation, t_operationparams
where t_operation.OperationID = t_operationparams.OperationID and t_operation.Object_ID = #CurrentElementID#    "

                                                                                                                                                                                                                                                                                                                                                                              with the macro "#CurrentElementID#" for selecting the information needed from the current element. Does it look right?
I tried the above query (replacing #CurrentElementID# with an actual ElementID) in the search panel and it works.

Could someone please explain me how it works?

Thanks

4

Automation Interface, Add-Ins and Tools / Re: Resizing of diagram images in document generation.

« on: January 08, 2019, 12:34:24 am »

This is what I'm trying to generate. The title and other information are in one page and the diagram in another one.
I set the "Scale to 1 page" option but it does not work.

5

Automation Interface, Add-Ins and Tools / Re: Resizing of diagram images in document generation.

« on: January 08, 2019, 12:19:52 am »

Thanks for the answer.

I asked this because I noticed that the diagrams (that are larger than A4 page format) are automatically horizontally resized but not vertically.
I figured that there would be an option to do the same for vertical resizing. I even tried to put the diagram image in the template inside a table with fixed height but that did not work either.
It would be really helpful to fix/add this feature.

Thanks anyway.

6

Automation Interface, Add-Ins and Tools / Resizing of diagram images in document generation.

« on: January 07, 2019, 10:37:28 pm »

Hi all,

I'm struggling with the resizing of diagrams in document generation. Some diagrams are too big and go over to a new page of the generated document leaving the name of the diagram and other information in the previous page. Is it possible to automatically resize them to fit in the same page as the diagrams' name?