Messages

16

Automation Interface, Add-Ins and Tools / Re: Diagram Image in RTF script template fragment

« on: March 31, 2016, 11:44:22 pm »

Hi Everyone!

For information - I've just tried this again in build 1229, and it works fine!

Yours,

Screwtape.

17

General Board / Re: Modelling Persistence - Converting a Class Diagram to Tables

« on: March 23, 2016, 02:12:57 am »

Thanks Helmut!

Transformation to DDL did exactly what I was looking for, although I'm slightly surprised that is didn't link the source class and generated tables in any way.

Thanks for pointing me in the right direction.

Screwtape.

18

General Board / Modelling Persistence - Converting a Class Diagram to Tables

« on: March 23, 2016, 01:07:34 am »

Hi!

Is there anything built in to EA to generate and link a database table structure from a class diagram? I've looked at the code generation options, but I can't see anything relevant, so I'm assuming it's a manual job.

Given there's no automated way, is there any best practice of how to link the tables to the classes they are persisting in the model?

Again, I can't see an obvious relation, since "realizes" isn't appropriate.

Sorry if the answer is obvious and I've just missed it.

Thanks!

Screwtape.

19

Automation Interface, Add-Ins and Tools / Re: Notes-Formatted not working in Document Generation

« on: February 25, 2016, 08:36:58 pm »

Thanks! At least I know I'm not going mad...

20

Automation Interface, Add-Ins and Tools / Notes-Formatted not working in Document Generation

« on: February 24, 2016, 07:58:29 pm »

Hi! I've tried about every combination of putting tags in the template etc., but I cannot for the life of me get Notes-Formatted to work in document generation.

I have a custom query starting

Code: [Select]

SELECT t_connector.Name, t_connector.Notes AS [Notes-Formatted],

and have the {Notes-Formatted} tag in the custom fragment, but this only ever appears in the doc as {Notes-Formatted} in a grey box.

I'm using the Jet (.eap) repository and my reading of the manual appears to suggest this is right, but it's not working for me.

Any ideas what I'm doing wrong?

Thanks! Screwtape.

21

Automation Interface, Add-Ins and Tools / Re: Display Elements belonging to Package as a Table

« on: February 04, 2016, 01:15:37 am »

Brilliant! Thanks!

What I've actually done is move the fragment to the package (I'd obviously been trying to add it to the packageElement rather than the package before), and put the heading in the package section of the fragment, and it works perfectly!

Code: [Select]

package>
| Name | Author | Description |
element>
| {Element.Name} | {Element.Author} | {Element.Notes} |
<element
<package


22

Automation Interface, Add-Ins and Tools / Display Elements belonging to Package as a Table

« on: February 03, 2016, 11:17:37 pm »

Hi! I've got a package which contains some requirements and I want to display them as a series of tables.

I've created a fragment which has a heading, and then a table in the element> section in the fragment. The fragment filters which requirement types I want, which is working.

The fragment is called by the main template, again in the element> section. I can's seem to call the fragment from any other section.

However, when I run the documentation, I get the whole fragment for each element - it puts the header in each time, and a complete table, rather than just the next row of the table.
When I create a number of fragments, each to show a table, then it becomes clear that each element is being processed by the main template in turn - the filtering in the fragment prevents the fragment occurring for the wrong element types, but what I want is each type to be grouped together under the package.

Any idea what I'm doing wrong? I really don't want to have to do this as a custom query, as the data I want is coming out fine.

Thanks!

Screwtape.

23

Automation Interface, Add-Ins and Tools / Re: Diagram Image in RTF script template fragment

« on: January 21, 2016, 10:52:05 pm »

Thanks Simon!

I raised this issue and was given the reference 16012968.

Interestingly, having upgraded to 1226, my test case now works, but my real-world program still crashes, so I'll have to try and "enhance" the test case until I can reproduce the real-world crashing I'm getting.

Yours,

Screwtape.

24

Automation Interface, Add-Ins and Tools / Re: Diagram Image in RTF script template fragment

« on: January 19, 2016, 09:55:36 pm »

Presumably you find the diagram you want from the element given by #OBJECTID# and then call DocumentDiagram (long diagramID, long nDepth, string templateName).

However, I would be careful, as calling DocumentElement within a document script fragment, currently seems to crash EA. (I've raised a support request regarding this issue, which has been reproduced, and is under investigation.)

25

Automation Interface, Add-Ins and Tools / Re: Custom SQL query problem

« on: January 19, 2016, 09:19:54 pm »

Geert is right, the only way I can see of doing this is using SQL subqueries (which personally I could write for Oracle but not any other database), or a script fragment.

Sadly, the script fragment approach is also laborious, since you would have to break your join into two queries, and handle the concatenation yourself within the script.

It is a shame that EA doesn't have structure within the custom fragment dataset, even though it is structured in such a way that it would be possible.

Instead of just having the

Custom>
{AField}
<Custom

tags, it would be nice at least to be able to have

Custom>DataSet0>
{AnyField}
<DataSet0
DataSet1>
{AnotherField}
<DataSet1<Custom

given that the XML format would support that, and even better if you could nest datasets (which the current XML format doesn't support).

26

Uml Process / Re: UML vs BPMN for detailed design documentation

« on: January 13, 2016, 02:47:46 am »

What I particularly like about using BPMN in EA, is to be able to do the high level process, which you can give to execs and users, and drill down to the minutiae, which the developers need.

I've built a script which also writes the "Steps" part of a use-case directly from a BPMN diagram (unless you have very complex processes), which I hope to publish at some point, since you can't do enough complexity in the scenarios within EA.

27

Automation Interface, Add-Ins and Tools / Re: Null Values in Custom Script Fragments

« on: January 12, 2016, 08:17:19 pm »

Hi Again!

I'm still trying to find out if this is possible. I note a recent post regarding lists in custom fragments, and that bookmarks for CustomSQL_TITLE_Begin and CustomSQL_LIST_Begin etc. are functional. However, having tried all sorts of combinations of bookmarks such as CustomSQL_Notes_Begin or CustomSQL.Notes.Begin etc., have failed to have any effect. If the value in the custom XML is an empty string, the text between the bookmarks is printed, along with the blank custom field, and if the custom XML is doesn't have the relevant field (in this case Notes) then the default value is displayed, along with all the text between the bookmarks.

That this doesn't work makes the custom fragments much less useful in themselves, since doing any "clever" formatting or optional fields is virtually impossible.

Thanks for any suggestions!

Screwtape.

28

Automation Interface, Add-Ins and Tools / Re: Document Script gives "expected ';'" Error

« on: January 07, 2016, 12:09:50 am »

Thanks for the pointers Geert! I'd started that way, and then just kept trying every option I could think of to get the trivial example to work.

As you suggested, I moved the code into the "Dummy" script that was referenced in the drop down, and called it from the Custom Fragment as you'd suggested.

There was an error in the change I made too, as I'd missed a parameter from the InsertText field, which caused a "type mismatch" error.

The following code worked:

Code: [Select]

!INC Local Scripts.EAConstants-JScript
function main()
{
Session.Output("Got here!");
    var reporting as EA.DocumentGenerator;
    reporting = Repository.CreateDocumentGenerator();
    if(reporting != null)
    {
        Session.Output("Got here 2!");
if(reporting.NewDocument(""))
        {
            Session.Output("Got here 3!");
if(!reporting.InsertText("This is some text",""))
            {
                Session.Output( "Error: " + reporting.GetLastError() );
            }
Session.Output("Got here 4!");
var retStr;
retStr = reporting.GetDocumentAsRTF();
Session.Output("Got here 5!");
            return retStr;
          }
    }
}

At least, with your help, I've got the trivial example to work now, which is a major step forward.

Sadly, the code I was intending to use seems to cause EA to crash and shutdown.

29

Automation Interface, Add-Ins and Tools / Document Script gives "expected ';'" Error

« on: January 06, 2016, 10:14:26 pm »

Hi! It's my first attempt at a Document Script fragment, and everything I've tried either gives me

Error:   
Script Error - xpected ';'   

or nothing happens.

I've copied the example from the manual, and just changed the InsertFile command to InsertText for simplicity, and added a debug line, leaving me with the following:

Code: [Select]

!INC Local Scripts.EAConstants-JScript
function main()
{
     Session.Output("Got here!");
     var reporting as EA.DocumentGenerator;
     reporting = CreateDocumentGenerator();
     if(reporting != null)
     {
          if(reporting.NewDocument(""))
          {
               if(!reporting.InsertText("This is some text"))
               {
                    Session.Output( "Error: " + reporting.GetLastError() );
               }
               return reporting.GetDocumentAsRTF();
          }
     }
}

If I don't have anything in the "Script" combobox, nothing happens. If I have a script, I get the error above. In order to make sure that the script selected didn't cause the issue, I've created an empty "Dummy" script. Still no joy. Everything I do either gives the error above, or nothing happens - i.e. no text, and no debug message.

Has anyone got this working and can anybody suggest what I'm doing wrong. I'm sure it's obvious, but just not to me.

Thanks!

Screwtape.

30

Automation Interface, Add-Ins and Tools / Re: Example for "Document Script" fragment

« on: January 06, 2016, 09:01:22 pm »

D'oh! I looked at all the manual pages except that one - assuming that "Custom Query Fragments" meant SQL Query, rather than more general custom fragments.

I knew I'd found it before...

Thanks!