Messages

1

Automation Interface, Add-Ins and Tools / Re: Shortcut Key for vba script?

« on: January 11, 2011, 05:37:17 pm »

neil, Geert , qwerty thanks for your replies.

I don't want to create a "addin" because script is too small.
Neil's solution works and its ok.

Thanks for all

Best regards
mario

2

Automation Interface, Add-Ins and Tools / [solved]Shortcut Key for vba script?

« on: January 06, 2011, 06:44:40 pm »

Hi
I have written a small vba script(built-in, part of my ea project).
It's running in context of element which is choosen from project browser window.
Is it possible to add a new option to a context menu (or add a shortcut key) to running my script?
Now I have to choose an element, open scripting window, choose a script and click "run" button - that is very uncomfortable.

Best regards
mario

3

Automation Interface, Add-Ins and Tools / Reordering method parameters

« on: October 19, 2010, 11:17:48 pm »

Is there any way to change order of method parameters via AI? I can't find suitable method.

Mario

4

Automation Interface, Add-Ins and Tools / Re: Problem with setting STATUS attribute via AI

« on: October 19, 2010, 11:15:40 pm »

Have you checked the returnvalue of update() If False check GetLatestError().

Geert

You are right!
There was an error in Update() operation. My status  had a space after name!
Now everything is ok

Thanks

5

Automation Interface, Add-Ins and Tools / Problem with setting STATUS attribute via AI

« on: October 14, 2010, 02:02:45 am »

Hi

I have problem with setting STATUS attribute (for Interface) via Automation Interface.

My code is simple:

Element pElem=repo.GetElementByGuid("MY_GUID")
pElem.SetStatus("MY_STATUS")
pElem.Update()
println pElem.GetStatus()

In result, I get "MY_STATUS" in my console, and that it is ok.

Unfotunately, this change is unvisible via Eterprise Architect, the status of my Interface is set to NULL. Why?


Best regards
mario

6

Automation Interface, Add-Ins and Tools / Deleting Packages-File sharing lock count. exeeded

« on: June 09, 2010, 08:05:19 pm »

I hava a very strange problem with removing Packages by API (very large file *.eap). Sometimes I get the message:

File sharing lock count exceeded.  (Error 3052)

I have found some information in MSDN (problem with driver), I have changed my reg keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0

according to MSD site:

http://support.microsoft.com/kb/815281/en-us

But the problem still exists.

Have you ever got the same problem ?

Best regards
mario

7

Automation Interface, Add-Ins and Tools / Is it possible to use COM api in Linux Environment

« on: July 07, 2010, 06:36:42 pm »

Hi

Is it possible to use Automation Interface (Java Version) in Linux/Unix environment ?

I'd like to write a small Java App to getting some information from EA repo, but I have problem with SSJavaCOM.dll...

Is it possible to use COM api in Linux (or only one part of Java API - eaapi.jar)?

Best regards
Mario

8

Automation Interface, Add-Ins and Tools / Re: Project Data Tranfer via Automation Interface.

« on: June 03, 2010, 07:25:07 pm »

If you want to execute insert/update/delete statements you better create your own database connection in code.
There is an operation somewhere that will return the connectionString (or the path to the eap shortcut file that holds the connection string)

Geert

But if it is possible to get a direct jdbc/odbc connection to local eap file ( because I need insert a lot of records from repo to local file - maybe it could be treat as a MS-Access DB file - but I haven't tested it)?


I'm still thinking about your proposal of recreation all Packages Elements, Diagrams itd. in local file. It is very interesting idea, but I have one more requirement. GUID all elements in my local file must be the same as Element GUIDs in remote Oracle Repo. Operation AddNew in Package/Element in my local file creates for my new Element with new GUID. This property is read only, so I can't copy it from old element to newly created.

9

Automation Interface, Add-Ins and Tools / Re: Project Data Tranfer via Automation Interface.

« on: June 03, 2010, 06:18:24 pm »

In theory you could write a program to query all details of the package and its elements, and recreate that into another model.

It could be a good idea, but is there any method to run SQL Update and Delete statements? (I have found only one method, which is only for SELECT statement)

10

Automation Interface, Add-Ins and Tools / Re: Project Data Tranfer via Automation Interface.

« on: June 03, 2010, 05:09:31 pm »

Thanks for your replies.

So is there any faster method to export many packages from EA repo than Export XMI?(via AI)

Best regards

11

Automation Interface, Add-Ins and Tools / Project Data Tranfer via Automation Interface.

« on: June 03, 2010, 01:05:11 am »

Is it possible to use Transfer Data Model (Oracle Repository to EAP ) via AI?
I have a very large project in Oracle Repository(EAP has about 0.5 GB!). Sometimes I have to generate eap file with some packages (it can be many packages, but not all). Now I generate xmi file (for root package), import it to local EAP, and in next step I remove needless packages(I wrote small Java App to automate it).

It is very uncomfortable and very time-consuming process (it takes me a few hours!)

Do you know more comfortable way to export some packages from very large repo to local eap via AI? I'd like to write Java App, to generate my project.

Thanks
mario

12

Automation Interface, Add-Ins and Tools / Re: Getting next auto-sequence value

« on: October 06, 2009, 01:54:12 am »

I have found:

EA.Repository.Execute();

13

Automation Interface, Add-Ins and Tools / Re: Getting next auto-sequence value

« on: October 05, 2009, 11:29:24 pm »

Is it possible to make a native sql update operation on table t_trxtypes?

sth like this:

update t_trxtypes set Notes='prefix=SCR;active=1;active_a=0;count=50;' where trx='Class' and Description='Autocount'

It could resolve my problem...

14

Automation Interface, Add-Ins and Tools / Getting next auto-sequence value

« on: October 03, 2009, 04:18:00 pm »

I'd like to create some model objects by using AI (C#).

How can I get next auto-sequence value, defined for this type of elements? Is it  possible?

mario

15

Automation Interface, Add-Ins and Tools / Re: Problem with adding a new package

« on: October 07, 2009, 07:30:07 pm »

Thanks Geert!!

It works