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

We have previously installed the ExcelReports add-on. Apparently we had an issue with the installation. 

Then we build a custom package to deploy our many customizations.

To get the installation to work correctly, the IntExcelReportSection client module had to be added to our custom package.

Now I am unable to install the latest version of the ExcelReports add-on because of the following errors

2022-05-09 23:47:33,681 Data "SysModuleEdit_SysModuleEditManager_4efd452f42e04729bcb1e28f5821567b" from package "IntExcelExport" installed
2022-05-09 23:47:33,713 Compiling configuration dll
2022-05-09 23:48:29,266 Errors and (or) warnings occurred while compiling configuration dll
2022-05-09 23:48:29,266 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(84,49) error CS0433: The type 'ExcelPackage' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'
2022-05-09 23:48:29,266 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(273,31) error CS0433: The type 'ExcelWorksheet' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'
2022-05-09 23:48:29,266 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(84,11) error CS0433: The type 'ExcelWorksheet' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'
2022-05-09 23:48:29,266 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(110,11) error CS0433: The type 'ExcelWorksheet' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'
2022-05-09 23:48:29,266 Autogenerated\Src\IntReportHelper.IntExcelExport.cs(110,54) error CS0433: The type 'ExcelPackage' exists in both 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' and 'EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'
2022-05-09 23:48:29,266 C:\Program Files\dotnet\sdk\3.1.301\Microsoft.Common.CurrentVersion.targets(2081,5) warning MSB3243: No way to resolve conflict between "EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1" and "EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1". Choosing "EPPlus, Version=4.5.3.2, Culture=neutral, PublicKeyToken=ea159fdaa78159a1" arbitrarily.

Looking for some advice on how to successfully uninstall and reinstall this add-on. We're very interested in using this.

Is this a known issue? When any of our users try to upload a template to an excel report, it fails without an error message. The "template uploaded" box does not get checked. Any other users experiencing this or have troubleshooting suggestions?

Hello community, while installing ExcelReportBuilder on the production environment I get the following error:

2021-12-15 17:58:14,812 Terrasoft.Common.DbOperationException: 23503: insert or update on table "SysPackageDataLcz" violates foreign key constraint "FKfg1JPl35PDx2FCE8Oagxv7VAMIc" ---> Npgsql.PostgresException: 23503: insert or update on table "SysPackageDataLcz" violates foreign key constraint "FKfg1JPl35PDx2FCE8Oagxv7VAMIc"

   at Npgsql.NpgsqlConnector.d__157.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

Hi, community. We have the excel report builder add-on installed. It works fine for all sections except Leads. This is the error message we get:

When I save changes to the section in the section wizard, it saves them fine. The object compiles correctly. How can I dind out which column is the problem?

Thanks!

Trying to run an Excel Report, for Leads, with the "include all columns" checkbox enabled.  When run, get this error:

Object reference not set to an instance of an object.

In the f12 console of the browser, I see this:

"The Id column is not declared in the ViewModel of the menu item"

Thoughts?

Thanks!

Hi all.  I have created some custom reports and exported them as xlxs.  I am looking at the DATE data from Creatio objects that appear in the xlxs files. 

• What is the format used in the Date fields ?
• What MS Excel function will display this data in a human readable format?

hello colleagues

On Creatio 7.17.2 (Cloud, updated by Creatio) I cannot upload Excel Templates.

I also delete extensions .jar, and .apk regarding what publish some time ago @Ryan Farley on https://customerfx.com/article/failure-to-upload-template-for-excel-rep…

But on a new site (demo) on v 7.17.1 without to modify nothing regarding extensions I can upload without any problem. I report this to Creatio Support, but they ask me to publish the problem here.

Thanks in advance

Hi Community,

In my application, I installed a new Plug-In ( https://marketplace.creatio.com/app/excel-reports-builder-creatio). 

The problem is, when I select the file that I want to download, it does not work at first, I need to click twice in order to be able to download it.

Do you have any idead why is this happening?

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Dear team

Today I’ve installed on production tenant the "Excel report builder" available on the marketplace.

Before installing it I tried to install on a test tenant and everything is fine.

Now, when I try to add the new section “Excel reports” to Studio workplace I receive an error on the browser console and the section doesn't appear on workplace.