Messages

1

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: April 02, 2016, 12:57:24 am »

We tried to use the API provided by Sparx, but the "ProjectTransfer()" method is the only method that is not accessible from the outside, it seems private. We are thinking about re-compiling Sparx' dll....
Anyone ever used the ProjectTransfer() method with Java ?

Please confirm that you have EA 12 or higher installed.  The Java API was updated in EA 12 to add several methods and attributes that had previously been missing, including ProjectTransfer().  If possible, please update to the latest build of EA, then make sure to use the latest eaapi.jar and SSJavaCOM.dll files from that version.

Hi Aaron,
You were right, the version of the Java API was incomplete in version 9. We got the same answer for Sparx support.

But they wrote us that in the scripting interface, the ProjectTransfer function was fine in version 9 !
We ran the script using EA 12 and got no errors !! 
So our problem is now solved.

What a waste of time ! 

2

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: April 01, 2016, 12:15:13 am »

Hi all,

We use Eclispse with Java.
We wanted to created a script that would be called by Windows Scheduler or something.
We tried to use the API provided by Sparx, but the "ProjectTransfer()" method is the only method that is not accessible from the outside, it seems private. We are thinking about re-compiling Sparx' dll....

Anyone ever used the ProjectTransfer() method with Java ?

Thanks

3

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: March 31, 2016, 04:34:02 am »

Hello Paolo,

How do you call your EA script periodically ? We need this backup to be taken automatically 3-4 times a day.

Thank you,
Anik

4

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: March 30, 2016, 07:47:24 am »

Unique, indeed.
This test prooves EA processes differently the connection string though scripting VS trough File \ Open.
I wish I was a guru like you qwerty

5

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: March 30, 2016, 06:46:48 am »

If you are backing up the entire repository, you should use the inbuilt Project Transfer API calls.  There is some fiddling but you can create an EAP file quickly, easily and fully supported.

We take our exports twice a day (at least) and it has "saved our bacon" a few times.

If you are interested, I can discuss in more detail.

HTH,
Paolo

Hello Paolo,

Thank you for your reply.
Are you using the JAVA API dll found in C:\Program Files (x86)\Sparx Systems\EA\Java API ?

We don't want to use Visual Studio so we tried using the Automation module with Eclipse but the ProjectTransfer() function isn't exposed !
 

Thank you in advance for giving me more details ! 
Anik

6

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: March 30, 2016, 06:41:19 am »

Hi,

regarding your SQL error.

In the file %APPDATA%SparxSystem\EA\DBError.txt you see the SQL together with the error. Often this is more helpful than the message.

In my experience there is no reason to check the created database.

Settings of source:
I would check the setting of the existing / running source Repository / (look eg with Repository.ConnectionString). Then I would take these settings. The source has to be a valid EA Repository. You can see tables like t_object in it.

Have you tried with different source Respositories?

Helmut

Thank you Helmut, I didn't know about the existence of  "DBError.txt". It says : Attribut de chaîne de connexion non valide

Context:
   Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DEV_ENTERPRISE_ARCHITECT_2;Data Source=EArchitect.bd.capitale1dev.local

What is weird is that the connexion string works fine when opening the project or when doing the project Transfer manually. The error only occurs when scripting.
Also, if I add a port number, for example 15001 after the Data Source name, it doesn't give the error, but pops a "password" dialog !

7

Automation Interface, Add-Ins and Tools / Re: Automated backup from a database source

« on: March 23, 2016, 03:09:30 am »

We get the same error, but every time script is running.
Anyone found anything ?

Thx

8

General Board / Re: assign target or javascript to a hyperlink

« on: February 09, 2016, 02:37:17 am »

I am looking for the same thing.

9

General Board / Re: HTML Report - Making Hyperlinks open in new Window

« on: February 09, 2016, 02:36:27 am »

"target = _blank"