Creatio development guide
PDF
This documentation is valid for Creatio version 7.10.0. We recommend using the newest version of Creatio documentation.

Saving packages to the database

Glossary Item Box

Introduction

Saving packages from the file system to the application database is performed when transferring custom packages between non-shared environments (e.g. development and test environments). Usually, packages are saved from the development environment, and loaded into the test and production environments. Learn more about saving packages in the “Exporting packages from database” and “Saving SVN packages” articles.

To load packages to the database, run the WorkspaceConsole utility with the following parameters:

Table 1. WorkspaceConsole utility parameters for loading packages to the database

Parameter Value Description
operation InstallFromRepository It saves the contents of packages from archives in the database. Bound SQL-scripts, source code regeneration, and bound data installation are performed if necessary. The InstallFromSvn and InstallFromRepository operations work with new or modified packages and their elements.
packageName [Package Name] The name of the package specified in the workspaceName configuration parameter. All dependent packages are used as well. This parameter is optional. This parameter is optional. The -clearWorkspace parameter
workspaceName [Workspace name] The name of the workspace (configuration) with the saved packages. By default, all users work in the Default workspace.
sourcePath [Path to local directory]

Path to a local directory in the file system. This directory should include the required packages in the *.gz format.

destinationPath [Path to local directory]

Path to a local directory in the file system. The packages from the directory specified in the sourcePath parameter will be saved here.

skipConstraints false The option to skip foreign key creation in database tables. Available values – true, false.
skipValidateActions true The option to skip the process of table index creation verification when updating the database structure. Available values – true or false.
regenerateSchemaSources true Indicates the need to regenerate source codes after saving the packages. Available values – true, false.
updateDBStructure true Indicates the need to update the database structure before and after saving the packages. Available values – true, false.
updateSystemDBStructure true Indicates the need to update the database structure before and after saving the packages. Creates all missing system table indexes. Available values – true, false.
installPackageSqlScript true Indicates the need to execute SQL scripts before and after saving the packages. Available values – true, false.
installPackageData true Indicates the need to install bound data before and after saving the packages. Available values – true, false.
continueIfError true Indicates the need to abort the installation process upon encountering the first error. If the parameter value is true, the user will receive the error list once the installation is complete. Available values – true, false.
logPath [Path to local directory] Path to to the operation log. The log name contains the start date and time of the operation.

Command signature for Windows command prompt that will export packages from the database:

[The WorkspaceConsole utility path]\Terrasoft.Tools.WorkspaceConsole.exe -packageName=[Package name] -workspaceName=Default -operation=InstallFromRepository -sourcePath=[PAth to package archives] -destinationPath=[Archive extraction path] -skipConstraints=false -skipValidateActions=true -regenerateSchemaSources=true -updateDBStructure=true -updateSystemDBStructure=true -installPackageSqlScript=true -installPackageData=true -continueIfError=true -logPath=[Log path]

ATTENTION

The WorkspaceConsole utility makes direct changes to the database, and therefore they become available only after restarting the application in IIS.

ATTENTION

Packages loaded into the application using WorkspaceConsole are considered pre-installed and can not be modified (see: "Package structure and contents").

Saving packages to the database

Case description

The bpm’online application is installed in the C:\bpmonline7.9.2 directory. Save the userPackage package to the Default workspace. The package archive is located in the C:\SavedPackages directory. Extract package contents to the C:\TempPackages directory. Save the operation log file to the C:\Log directory.

Case implementation:

Use any text editor to create a batch command file (*.bat or *.cmd) with a command that will launch the WorkspaceConsole utility. Enter the following command in the file:

C:\bpmonline7.9.2\Terrasoft.WebApp\DesktopBin\WorkspaceConsole\Terrasoft.Tools.WorkspaceConsole.exe -packageName=userPackage -workspaceName=Default -operation=InstallFromRepository -sourcePath=C:\SavedPackages -destinationPath=C:\TempPackages -skipConstraints=false -skipValidateActions=true -regenerateSchemaSources=true -updateDBStructure=true -updateSystemDBStructure=true -installPackageSqlScript=true -installPackageData=true -continueIfError=true -logPath=C:\Log
pause

Upon saving the batch file and running it, a console window will appear, and the WorkspaceConsole execution process with specified parameter values will be displayed (Fig. 1).

Fig. 1. Saving a package to the application database

Run the command to load the userPackage package to the Default configuration.

Fig. 2. The userPackage package in the [Configuration] section

© bpm'online 2002-2017.

Did you find this information useful?

How can we improve it?