Messages

1

Suggestions and Requests / Re: Two quality of life improvements

« on: November 19, 2013, 03:11:52 pm »

While this is a work around, I still feel that this should be native functionality.

2

Suggestions and Requests / Two quality of life improvements

« on: November 04, 2013, 03:49:50 pm »

It would drastically improve my QoL if I could change the tags of multiple objects at once, by selecting them in the diagram view and any tag changes applying to everything selected.

The other improvement would be to easily allow hot-keying some of the more advanced functions (i.e. Advanced -> Use Rectangle notation). It would also make sense to expose some of the functions only available on the individual level to groups of the same element (i.e. selecting multiple elements that have the Advanced - Use Rectangle Notation, and updating them all at once).

I use EA everyday, and it is great, except for these trivial things that make some basic tasks very time consuming.

3

General Board / Re: What is the best database for the EA datastore

« on: January 25, 2013, 02:52:36 pm »

MS SQL has worked well here too.

Have recently been investigating MS SQL (Azure) for smaller projects, and it seems to work well too. Just need to be aware that you need a different SQL setup script for Azure.

4

General Board / Re: EA on SQL Server 2012?

« on: January 16, 2013, 11:23:31 am »

Thanks for the replies everyone. I ended up getting it working. Through trial and error, I eventually narrowed it down to it being an ODBC driver problem.

Out of the three SQL ODBC drivers, only the "Microsoft OLE DB Provider for SQL" worked.

Not sure if this is purely because the DB is hosted in the Azure platform.

5

General Board / Re: EA on SQL Server 2012?

« on: January 15, 2013, 11:12:29 am »

Thanks Geert. I am getting stuck at what should be the most trivial stage.

I keep on getting the error: "Invalid data source... check configuration"

I am attempting to host the DB on the Azure platform. I have run the initial database script to make the tables, and it gives the error. I have also tried creating the suggested clustered indexes in the thread below, still errors.

A bit lost...


http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1326934114/0#5

6

General Board / Re: Windows Azure Support

« on: January 15, 2013, 11:06:44 am »

Time to bump this thread.

It should be simple enough to do this, but I keep getting stuck in random spots.

How did you connect to your SQL Azure? Which ODBC driver did you use? Did you try using SocketShifter or something to get through a corporate firewall?

I have quite a few questions, so a guide would be appreciated.

The latest error I am getting is: "Invalid Datasource... Check configuration"

I initially thought this was due to incorrect database structure... but now that I have run the above script (as well as the one off the EA repository page), this can no longer be the case.

At this stage, I can't even setup a blank EA repository, let alone think of bringing in data yet.  

EDIT: It turned out to be an ODBC driver issue. It only worked using "Microsoft OLE DB Provider for SQL".
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1357885265

7

Bugs and Issues / Re: How to debug MDG technologies not updating

« on: January 10, 2014, 11:21:33 am »

I did not use much of the MDG technologies a year or so ago, but I recall my first look at them (back then) leaving me with a distinct impression of "too hard". They seem to be a lot easier to make now... but still very troublesome.

I think we will eventually get there.

8

Bugs and Issues / Re: How to debug MDG technologies not updating

« on: January 10, 2014, 08:41:07 am »

Thanks for the suggestions.

It turns out multiple factors were at play. There was a filepath issue and  space in name issue.

MDG technologies sure are finicky.

Only a few tags became defunct after syncing.  

9

Bugs and Issues / How to debug MDG technologies not updating

« on: December 20, 2013, 03:43:34 pm »

I have made several MDG technologies in the past, but this particular one is driving me nuts.

I have updated an enum and it is not getting updated in the MDG when it is regenerated.

Does anyone have some tips to share on how I can start troubleshooting this? I have tried closing EA after unloading all MDGs before loading the MDG again.

Update the MDG enum
http://i.imgur.com/vKuaQKH.png

Regenerate the MDG and place the element. We can see it is of the device type from the first screenshot.
http://i.imgur.com/clUDdJs.png

The enum list does not match!!!
http://i.imgur.com/N8br5PZ.png

Attempt to resync the toolbar
http://i.imgur.com/8GGs0HZ.png

Does nothing
http://i.imgur.com/uz9VRQv.png

10

Automation Interface, Add-Ins and Tools / Re: Generating daily HTML report of entire reposit

« on: January 25, 2013, 03:03:02 pm »

I am not sure how big your repos usually are, but the one I wanted to automate is quite big. I found that generating the HTML straight out of the DB was extremely slow. Instead I do a project transfer from DBMS to local EAP, and html the local file.

I cobbled my code together quickly borrowing snippets of code from all over the internet, so there are potentially even more improvements that could be made. (Not claiming ownership of this code, but it works which is all I cared about)

I thought I would share for the next person that could use a C# implementation.

Code: [Select]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EA;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            EA.Repository repo = new EA.Repository();
            EA.Package package = null;

            // PARAMETERS !!!UPDATE THESE!!!
                String conn = "Enterprise_Architect --- DBType=1... etc"; //PUT WHOLE SQL STRING IN
                String username = "user";
                String password = "pass";

    
            //Transfer DBMS to EAP
                String eapfile = "C:\\Temp\\html\\model.eap";
                String eaplog = "C:\\Temp\\html\\transfer_log.log";
                repo.GetProjectInterface().ProjectTransfer(conn, eapfile, eaplog);
    
            // Browse through structure
                repo.OpenFile2(eapfile, username, password);
                package = repo.GetPackageByGuid("{HARDCODED_GUI}"); //I PUT MY NODE GUI HERE TO GET WHOLE MODEL

            // Generate HTML Documentation
                    String guid = "" + package.PackageGUID + "";
                    String tmppath = "C:\\Temp\\html";
                    String image = "PNG";
                    String template = "Feedback";
                    String ext = ".htm";

                    repo.GetProjectInterface().RunHTMLReport(guid, tmppath, image, template, ext);


            // Close connection to database
                repo.CloseFile();
        }
    }
}



11

Automation Interface, Add-Ins and Tools / Re: Importing XMI via API corrupting model

« on: September 12, 2013, 04:22:56 pm »

Further note, I am running easetupfull.10-1007

12

Automation Interface, Add-Ins and Tools / Importing XMI via API corrupting model

« on: September 12, 2013, 04:20:16 pm »

Has anyone else seen weird behaviour recently regarding importing XMI via the API? I have the following C# code, and I am finding that my models are frequently getting corrupted, rendering them impossible to open.

Code here: http://pastebin.com/WGi38La9

This has only been a recent issue. Before lodging a support ticket, I just wanted to establish whether this has happened to other people too.

13

Automation Interface, Add-Ins and Tools / Re: Automatically transfer DBMS to .eap

« on: February 06, 2013, 08:16:44 am »

Had to do this as part of my daily html generator. It was far faster to transfer and generate HTML off the local copy. Here is an exceprt in C#.

Code: [Select]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EA;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            EA.Repository repo = new EA.Repository();

            // PARAMETERS
                String conn = "Enterprise_Architect --- ACCESS STRING";
                String output_directory = "C:\\TEMP\\ea_temp\\";
                String project_directory = "aamc_lwmotf\\";
                String username = "username";
                String password = "good pass";
    
            //Transfer DBMS to EAP
                repo.OpenFile2(conn, username, password);

                String eapfile = output_directory + project_directory + "model.eap";
                String eaplog = output_directory + project_directory + "transfer.log";
                repo.GetProjectInterface().ProjectTransfer(conn, eapfile, eaplog);

                repo.CloseFile();
}}}

14

Automation Interface, Add-Ins and Tools / Re: Model Profile View

« on: February 08, 2013, 02:28:17 pm »

Thanks. I will look into those suggestions.

EDIT: Just from looking at the help file, it doesn't seem like you can use tagged values or model searches.

The content of the report is defined as either:

· A list of packages (defined as attributes) dragged onto the element in whatever order or combination is most appropriate to your requirements; you can easily add or delete packages as necessary
 
or

· (Not for HTML reports) a standard model search (identified by Tagged Values) created within the Model Search facility; note that diagram searches are not supported - when you generate the document, this search captures the required data throughout the model and populates the document

15

Automation Interface, Add-Ins and Tools / Model Profile View

« on: February 06, 2013, 08:21:38 am »

Is it possible to mark packages with a tag that can then be programatically found to generate a HTML report?

We have a big model, and several projects that work in various sections of the model.

We want to generate daily HTML reports for each sub-model, and noticed that you can make packages non-reportable.

If not, would be generating baselines be a better solution?