Skip to main content
Version: 8.0

Bind an existing package to SVN using a database query

Level: intermediate
Example

Bind an existing sdkUnboundPackage user-made package to the SVN repository using a database query.

The path to the package in the SVN repository is .../SDKPackages/sdkUnboundPackage.

1. Connect the SVN repository to Creatio​

If the SVN repository is connected to Creatio, proceed to the next step.

To connect the SVN repository to Creatio:

  1. Click to open the System Designer.

  2. Click Advanced settings in the Admin area block.

  3. Select Open list of repositories in the SVN repositories group of the action menu.

  4. Click Add and add a repository. In this example, the repository is .../SDKPackages.

  5. Click Authenticate.

2. Bind the repository to the package​

To bind the repository to the package:

  1. Open the Creatio database.

  2. Run an SQL query in the database.

    Example of an SQL query
    UPDATE SysPackage
    SET
        [SysRepositoryId] =
        (
            select top 1 Id from SysRepository
            where Name = 'SDKPackages'-- Repository name.
        )
    where [Name]='sdkUnboundPackage'-- Name of the user-made package.

    This query executes the following actions:

    • Gets the ID of the record that contains the SVN repository location from the [SysRepository] table.
    • Adds the ID to the [SysPackage] database table’s record whose [SysRepositoryId] column contains the name of the package not bound to the SVN repository.

Log out from Creatio and log back in to apply the changes.

3. Download the package to the file system​

To download the package to the file system:

  1. Configure Creatio to work in the file system. Learn more in a separate article: External IDEs.

  2. Select Download packages to file system in the File system development mode group of the action menu.

As a result, Creatio will download the packages along the ..\Terrasoft.WebApp\Terrasoft.Configuration\Pkg path to the directory that has the corresponding package name.