Project Transfer Automation

[[email protected]]

Hello,

we manage our EA Models in SQL Database and transfer thw different models every day to eap file. Is there away to do the project transfer via batch/skript to automate the database transfer into eap file?

Thanks a lot for some ideas.

best regards

Anton

[qwerty]

See the ProjectTransfer operation in http://www.sparxsystems.com/enterprise_architect_user_guide/12.1/automation_and_scripting/project_2.html

q.

[Geert Bellekens]

You can run a vbs script as a scheduled task
 
A client of mine uses the following code in  vbs file:
Just make sure you run the taks with an actual user logged in.

Code: [Select]

sub main

Dim CurrentDate
Currentdate = Replace(Date, "/", "-")

dim repository
dim projectInterface
set repository = CreateObject("EA.Repository")

Dim FileName
Filename = "EA_Export.eap"
 
dim LogFilePath
LogFilePath = "C:\EA\EA_to_EAP.log"

dim TargetFilePath
TargetFilePath = "C:\EA\EA_Export.eap"

dim eapString
eapString = "EAConnectString:DB_EA_PROD --- DBType=1;Connect=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DB_EA_PROD;Data Source=BESQLCP;LazyLoad=1;"

'get project interface
set projectInterface = repository.GetProjectInterface()

projectInterface.ProjectTransfer eapString, TargetFilePath, LogFilePath

'repository.CloseFile
repository.Exit

Dim newFilename
newFilename = "C:\EA\EAP_Files\EA_Export_" & CurrentDate & ".eap"

Dim Fso
Set Fso = WScript.CreateObject("Scripting.FileSystemObject")
Fso.MoveFile "C:\EA\EA_Export.eap", newFileName
   
end sub
 
main