Question
Development
FileSystemDevelopmentMode
ApplicationHub
install package
sourcecode
8.0
Changes in .cs files are not picked up by Creatio in newer version of a package if the files existed in previous version of the package
Mykhailo
16:52 Aug 11, 2024

Hey. I've been working with Creatio for some time already. And I've been facing an issue. The issue is not picking up on changes that were added to the files already added to the package when uploading a new version of a package on any environment. I am talking about .cs files, in other words, the source code type of Creatio files. So, when I finish fixing some bugs with the package locally, I go to the dev env. to upload the package there. I do the uploading via `ApplicationHub` page via `install from file`. So, the issue happens only when the previous package version is installed and I want to update with the newer version. If I remove the previous version and upload a new one, all new changes are picked up.

Like 0

Like

1 comments
Kyrylo Atamanenko
20:04 Aug 13, 2024

Hello!

 

In this case, it could be two possible options as to why it happens:

 

1. It can happen if the schema has a more fresh ModifiedOn date in configuration, for example, if it was recently modified directly on the environment; if so, the schema won't be updated.

2.  Sometimes, the schema updates only after full compilation. so the steps will be install package -> full compilation -> check the schema.

 

If the issue would still reproduce, contact us at support@creatio.com.

Show all comments
Question
package
install
install package
Sales_Creatio_enterprise_edition
8.0
Error importing package
Oliver Crowe
13:53 Mar 20, 2023

https://drive.google.com/file/d/14bXG1fyxZCbehwAVJIHvBv6TdTwKPz0s/view

 

I get this error every time I try to import an application, whats going wrong?

Like 0

Like

7 comments
Best reply
Cherednichenko Nikita
14:52 Mar 29, 2023

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    INNER JOIN "SysCulture" c ON c."Id" = ssv."GuidValue"

    WHERE ss."Code" = 'PrimaryCulture'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Oliver Crowe
14:32 Mar 20, 2023

Im running the following on the machine im exporting from: Version 8.0.3.2908 Sales enterprise

importing into: Version 8.0.6.3429

 

Does the version need to be the exact same?

Bogdan
14:43 Mar 20, 2023

Hello Oliver,



What is the bundle of the target website, Sales enterprise as well? 

 



 

Oliver Crowe
14:50 Mar 20, 2023

Bogdan,

Yeah, Im not sure 100% if the one im exporting from is, but im pretty sure its Sales Enterprise too

 

Is there any way to confirm what version youre running?

Bhoobalan Palanivelu
15:00 Mar 20, 2023

Oliver Crowe,

The below SQL script will give the product version.



Note: This is MSSQL and if you use other DBs please update the syntax wherever applicable.

DECLARE @ConfigurationVersion nvarchar(250)
DECLARE @PrimaryCulture nvarchar(250)
DECLARE @Product nvarchar(250)
 
DECLARE @SysAdminUnit_AllUsers uniqueidentifier = 'A29A3BA5-4B0D-DE11-9A51-005056C00008'
 
BEGIN
SELECT  @ConfigurationVersion = TextValue
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId
WHERE ss.Code = 'ConfigurationVersion' 
	AND SysAdminUnitId = @SysAdminUnit_AllUsers
 
SELECT @PrimaryCulture = c.Name
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId
INNER JOIN SysCulture c on c.Id = ssv.GuidValue
WHERE ss.Code = 'PrimaryCulture'
	AND SysAdminUnitId = @SysAdminUnit_AllUsers
 
SELECT @Product =
CASE
     WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
	 THEN 'bpmonline bank sales & bank customer journey & lending & marketing' 
     WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
	 THEN 'bpmonline bank sales & bank customer journey' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')
	 THEN 'bpmonline sales enterprise & marketing & service enterprise' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales enterprise & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales commerce & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales team & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
	 THEN 'bpmonline sales team & marketing'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
	 THEN 'bpmonline sales team'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')
	 THEN 'bpmonline sales commerce'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
	 THEN 'bpmonline sales enterprise'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name Like 'MarketingSoftkey%')
	 THEN 'bpmonline marketing'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline customer center'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')
	 THEN 'bpmonline service enterprise'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Studio%')
	 THEN 'bpmonline studio'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
	 THEN 'bpmonline lending'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
	 THEN 'bpmonline bank sales'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
	 THEN 'bpmonline bank customer journey'
	 ELSE  '?' END
 
SELECT @Product Product, @ConfigurationVersion Version, @PrimaryCulture Localization
END

 

 

BR,

Bhoobalan Palanivelu.

Oliver Crowe
16:33 Mar 20, 2023

Bhoobalan Palanivelu,

 

Im using PostgreSQL - All MSSQL syntax checkers ive tried also says this syntax is wrong and I cant seem to get anything that will run from this, I cant find any conversions that work manually and ive tried using online converters too

 

None of the syntax works, could you please be more specific in what I can do to get it working

 

If you scrolled slightly further down the page you got that code from you'd have seen me commenting that it doesnt seem to work.

Cherednichenko Nikita
14:52 Mar 29, 2023

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    INNER JOIN "SysCulture" c ON c."Id" = ssv."GuidValue"

    WHERE ss."Code" = 'PrimaryCulture'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Oliver Crowe
17:25 Mar 29, 2023

Cherednichenko Nikita,

 

This is the best solution for PostgreSQL, thanks!

Show all comments
Question
minipage
install package
Transferring a minicard
Roman
12:03 Feb 27, 2023

Hi!

How to add mini pages to the package? For further transfer between environments

Like 0

Like

3 comments
Ryan Farley
18:44 Feb 27, 2023

As long as the package you want this to go into is the current package when you use the Section Wizard to create the mini pages, it will go into that package. You should see the mini page client schemas in the package. 

Ryan

Roman
19:38 Feb 27, 2023

Ryan Farley,

Yes, that's right. But when I install the package, these checkboxes are missing. Because of this, it seems that this action must be somehow fixed in the package.

Roman
16:15 Mar 16, 2023
The settings for using the mini-page are stored in the data of the "SysModuleEdit_SysModuleEditManager" type and are displayed in the "Mini page modes" column.
Show all comments
Idea
Discussion
install package
on-site
Improve package installation across environments for on-premise environments
Damien Collot
11:46 Nov 30, 2022

Hi Creatio,



It would be great to be able to link on-premise environments such as to reduce time and improve reliability of transferring packages across environments (dev/test) and even production.



A good example is SAP - a 1-click almost instant operation ;)



Cheers,



Damien

3 comments
Mira Dmitruk
14:22 Dec 01, 2022

Hello Damien,

 

Currently Creatio offers a similar tool for transfering packages between environments using SVN. You can learn more about this functionality in this Academy article.

We have additionally registered this idea for our R&D team and it may appear in future releases.

Jonathan Quendoz
14:48 Dec 01, 2022

Hello Mira,

 

How could we achieve the same functionalities as the SVN with Git ? Is it possible to ensure this packages transfer procedure between the environments with GIT ? If yes, how could we achieve this ? What are the best practices ?

 

Many thanks for those hints.

 

Best regards,

Jonathan

Mira Dmitruk
14:57 Dec 01, 2022

Jonathan Quendoz,

 

GiT can be used as well, here's a great video with instructions and examples how that can be implemented.

Show all comments
Question
maps
Adding
install package
Studio_Creatio
8.0
Problems with Toolkit to setup map view
Anas Iyad Ahmad Ibrahim
12:43 Nov 16, 2022

Hi All,

 

I Installed the toolkit for map view(https://marketplace.creatio.com/app/toolkit-setup-map-view-creatio ) but when I tried to follow the guide I stuck in second step, I didn't find "BaseModulePageWithMap" in the card schema.

 

I created my section within a new package, also I added the dependencies to my package but I didn't find "BaseModulePageWithMap".

 

Like 0

Like

2 comments
Best reply
Eugene Vorobiov
12:24 Nov 30, 2022

Hi!

I have checked this add-on and was unable to reproduce the issue. The steps I took are as follows:

 

1. Install the add-on.

2. Create a package and set dependencies.

3. Create a custom section that includes a page.

4. Open the page source code in the configuration and change the parent object to "BaseModulePageWithMap."





Could you please tell us the steps you took?

Eugene Vorobiov
12:24 Nov 30, 2022

Hi!

I have checked this add-on and was unable to reproduce the issue. The steps I took are as follows:

 

1. Install the add-on.

2. Create a package and set dependencies.

3. Create a custom section that includes a page.

4. Open the page source code in the configuration and change the parent object to "BaseModulePageWithMap."





Could you please tell us the steps you took?

Anas Iyad Ahmad Ibrahim
14:34 Nov 30, 2022

Yevhen Vorobiov,

Thanks a lot, it works now

Show all comments
Question
install package
Sales_Creatio
8.0
How do I install a file
Jeremy Jason Schulze
10:27 Jun 20, 2022

Hi there,

I received a file from creatio to install to the system.

 

Where do I find install it?

 

Thanks

Jeremy

Like 0

Like

1 comments
Mira Dmitruk
11:26 Jun 20, 2022

Hello,

 

Could you please specify what kind of file you received?

 

Regards,

Mira

Show all comments
Question
ExcelReportBuilder
8.0
install package
Sales_Creatio_team_edition
Error while installing the the Excel Report Builder package.
Pedro Pinheiro
16:27 May 26, 2022

Hi Community,

 

Currently we are in the middle of migrating our projects from Creatio version 7.18 to 8.0.1. To do that, we have installed new Creatio machines on our servers, and the packages for each project. However, we are getting some errors while installing these packages on the new Creatio 8 machines. 

 

One of the packages that we are trying to install is this one:

https://marketplace.creatio.com/app/excel-reports-builder-creatio

 

While installing this package we got the folllowing errors:

2022-05-26 11:15:05,856 [33] INFO Supervisor InstallZipPackage Save - Compiling configuration dll
2022-05-26 11:15:33,238 [33] INFO Supervisor InstallZipPackage Save - Errors and (or) warnings occurred while compiling configuration dll
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(110,11) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(273,31) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(84,49) error CS0246: The type or namespace name 'ExcelPackage' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(20,8) error CS0246: The type or namespace name 'OfficeOpenXml' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(84,11) error CS0246: The type or namespace name 'ExcelWorksheet' could not be found (are you missing a using directive or an assembly reference?)
2022-05-26 11:15:33,277 [33] ERROR Supervisor InstallZipPackage LogCompilerResult - Autogenerated/Src/IntReportHelper.IntExcelExport.cs(110,54) error CS0246: The type or namespace name 'ExcelPackage' could not be found (are you missing a using directive or an assembly reference?)

I did a full system source code generation and multiple compilations, and the error persists.

 

Is there any way to fix this?

 

Best Regards,

Pedro Pinheiro

Like 1

Like

3 comments
Eugene Vorobiov
10:03 May 30, 2022

Hi Pedro!

Could you please provide more details about the issue?

Specifically, the platform type (.NET Framework or .NET Core). Are you trying to install the add-on from the marketplace on a clean site, or is the site already customized?

Seems like the compilation system didn't process the external EPPlus.dl

Pedro Pinheiro
10:47 May 30, 2022

Yevhen Vorobiov,

 

We are installing the package on a new clean site which uses the .Net Core platform. 

 

Best Regards,

Pedro Pinheiro

 

Eugene Vorobiov
11:58 May 30, 2022

Pedro Pinheiro,

 

Please note, this add-on doesn't support .NET Core platform.

I recommend using .NET Framework.

Show all comments
Question
marketplace
dependencies
install package
devlabs
Sales_Creatio_enterprise_edition
7.18
Using Installed Business Process Template in Current Package
Andriana Pachella
00:42 May 04, 2022

I installed the "Calculation Working Days" business process template from marketplace. It is set as having the Custom Package as its only dependent package, but we need to be able to use it as part of business processes in our current configuration package (which is not the Custom Package). When I try to add the  package from marketplace as a "dependent on" for our current package I get an error. See screenshot. Posting here as the Marketplace page says it's supported via posts in Creatio Community.   https://marketplace.creatio.com/template/calculation-working-days-busin…

Like 0

Like

2 comments
Eugene Vorobiov
18:52 May 23, 2022

Hi Andriana!

The issue is caused by the missing data binding for the "SysWorkplace" and "SysModuleEntity" objects. To fix the issue, make sure that data with aforementioned IDs is bound to the package that is experiencing data binding issues.

Shivani Lakshman
09:03 May 25, 2022

Hello,

 

We are facing a similar issue. Could you please let me know if binding solved this issue? Please confirm what are the bindings that need to be done because I see that sections are already present in the SysModuleInWorkplace_SectionInWorkplaceManager data binding. 

Show all comments
Question
install package
package
lookup
Installing Package from dev doesn't publish the lookup tables
Raz Guille Rosman
11:57 Oct 20, 2021

Hi,

As part of my developments I'm transferring some lookups from dev environment to test.



In the dev env, I have the lookups and their bound data.

Once I export the package and install it in the test env, I see that the lookups are in the db, but the UI can't find them.

Meaning, I don't see them in the lookup list and even when I try to create a new lookup from the UI, the object does not exists.

If I publish the lookups in the test env, I get the following error message:

"Unable to save changes for item "UsrAutoNumbering". It is either created by third-party publisher or installed from the file archive"

 

The thing is that I tried to do the same process in two demo env that I've created from scratch and it works fine. Once I install the package all the lookups and are being published and their data populated correctly.

 

The only difference I see between the demo envs and mine is the creatio versions.

The demos are in 7.18.3.1241. 

The dev is in 7.17.1.1363

The Test is in 7.17.2.1728

 

Looking forward to having your advice on this issue.

 

Thanks,

Raz

Thanks,

Like 0

Like

1 comments
Cheng Gong
13:50 Oct 20, 2021

Hi Raz,

If you do not receive any errors while you are installing the package. You can check the following points.



Bind the lookup and value correctly:

If you have the databinding tool installed on your local dev, you need to do 2 binding as:

1. Go to studio->lookup section->click on bind lookup

In the popup, select the new lookup which you would like to bind. This will ensure your object will show in the lookup section after your release.

2. In the lookup section, find you lookup (for example, ContactType), open the lookup and bind the value. This will ensure the value you bind will be released on the target site.

Please make sure the binding is unique in one package. For example, the contact type "Competitor" should be bound in the same package only once. If you have 2 binding files for the same record in the same package, you will get an error while installing the package.



Object in your package is installed and published correctly:

If you can not see your object, when you create a new lookup. Please go to the advanced setting first, and double check if the object is created already after installing the package. Sometimes you will see the object is created but you can not use it from the UI. That might be caused by the database structure need to be updated/installed.  If I get the issue like this, I always compile the site after update the structure in database, then refresh the page, or log out and log in again.



If errors are received while installing package, you need check the log file and resolve the issues in the package.

 



Hopefully, it will help you to resolve the issue.

 

regards,

 

Cheng Gong

Show all comments
Question
install package
7.17
Web Application Firewall - installed packages are not reflecting in the CRM
Fulgen Ninofranco
14:09 Jul 28, 2021

Hi Community,

 

We applied Web Application Firewall, currently all our customization coming from the installed custom package are not reflecting on the CRM and the installed Samarasoft.SqlConsole is not also showing in the CRM . Any idea what could be the problem.

 

Thank you.

Like 0

Like

1 comments
Bogdan
18:04 Jul 28, 2021

Hello Fulgen,



This issue is not related to the Web Application Firewall. 



Please specify, is this your custom package?



We recommend you follow the instruction to Install the application from Marketplace.



Best regards,

Bogdan

Show all comments
Subscribe to install package