Are there any options to assist with the Excel Report Builder? The Word report builder does not work for my processes. The instructions do not show all of the options and what we can or can not do. I am trying to add in data from different objects, but continue to run into errors. Any help to walk through the process is appreciated.

Like 0

Like

1 comments

Hi Patrick,

Unfortunately, the Excel reports builder is a free add-on, so there are no options for online assistance. The only support available is via the Creatio Community.

The add-on is quite simple and doesn't cover all complex cases. I recommend using an app guide as a list of available features. For example, the app doesn't allow downloading data from different objects in one spreadsheet. You could consider a workaround by developing a data view and downloading this data view like one object using the app.

Show all comments

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

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

Yevhen Vorobiov,

 

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

 

Best Regards,

Pedro Pinheiro

 

Pedro Pinheiro,
 

Please note, this add-on doesn't support .NET Core platform.
I recommend using .NET Framework.

Show all comments

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.

 

Like 0

Like

2 comments

As an update, I was able to uninstall the ExcelReports through the Installed Applications utility, but when I tried to uninstall the Excel Reports built in 2019 (see attached screenshots) I get an error that the package cannot be deleted because "Unable to delete the "IntExcelExport" package as it has dependent package "Beable_Customization"

 

 

See note above how we had to add the IntExcelReportSection client module to our custom package to get the package to compile (not sure why).

 

We deleted that component from our Beable_Customization package. I don't know what other component of the IntExcelReport package may be dependent/has a dependancy on the Beable_customization package. 

Hi Mary!
Regarding the first error, I recommend checking the EPPlus library.
It must be only in one package. You have to delete it from another one.
 

Regarding package relations. Please, recheck the dependence of "Beable_Customization" package. It could be connected to the "IntExcelExport" package (see an example in the attachment).

Show all comments

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?

Like 0

Like

3 comments

Hi Mitch,

 

Yes, this issue was reported, however we were unable to reproduce it. Please specify the following to help us reproduce the issue:

your Creatio product and version

add-on installation date

send us a template file without confidential data in a private message

 

Kind regards,

Ivan.

We are using Creatio Service, Sales, and Marketing v7.18.3 install date 11/1/2017

Mitch Kaschub,

Hi Mitch!

I recommend updating your add-on to the latest version as this issue was fixed in it.
You can find the latest version on this page:

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

Show all comments

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.<DoReadMessage>d__157.MoveNext()
--- End of stack trace from previous location where exception was thrown ---

Like 0

Like

2 comments
Best reply

This is not an issue with the Excel reports package but is due to an issue with new systems only including two records in the SysCulture table (that is my assumption of the issue). The package will attempt to write data to the SysPackageDataLcz table for cultures that do not exist in the system and cause the constraint violation when the package is installed.

If you report it to support, you can reference my open case about this issue #SR-01065588

Ryan

This is not an issue with the Excel reports package but is due to an issue with new systems only including two records in the SysCulture table (that is my assumption of the issue). The package will attempt to write data to the SysPackageDataLcz table for cultures that do not exist in the system and cause the constraint violation when the package is installed.

If you report it to support, you can reference my open case about this issue #SR-01065588

Ryan

Thank you Ryan, in fact I noticed afterwards that the environment had some major problems. I wrote to the support.

Show all comments

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!

Like 1

Like

0 comments
Show all comments

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!

Like 0

Like

2 comments

Hello Chris,

This message doesn’t mean that something is broken or works in the wrong way.
It doesn’t influence the system's performance at all.

According to the information from our development team, this message appears in the Console due to the existing part of a code that was modified and currently is out of use.
It is shown to our developers as a reminder that adjustments are to be done.

Best regards,
Bogdan

Bogdan,

 

Thanks, but what about the error that prevents us from running the report:

 

Object reference not set to an instance of an object.

 

Thanks!

 

Chris

Show all comments

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?
Like 0

Like

2 comments
Best reply

Hello Charles,

What you need to do is create a template for the Excel report. In the date columns, you can add cell formatting in any date format you'd like. Then upload the template for the Excel report and from then on the report will use the date format you specified in the template. I have a video tutorial of how to do this here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…

Ryan

Hello Charles,

What you need to do is create a template for the Excel report. In the date columns, you can add cell formatting in any date format you'd like. Then upload the template for the Excel report and from then on the report will use the date format you specified in the template. I have a video tutorial of how to do this here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…

Ryan

Perfect help, thank you

Show all comments

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

Like 0

Like

11 comments

 

Hello Julio,

 

Thank you for the detailed video. I saved the link and removed it from the post.

 

I was able to reproduce the issue and forwarded it to the relevant team for further analysis.

Ivan Leontiev,

Thanks Ivan

Hi

I have the same problem. Did you find the solution ?

Thanks

Hi Tiffany,

 

The team is still investigating this issue. I will let you know as soon as we have more information.

Ivan Leontiev,

Thanks Ivan

Any news about this case? I have the same problem

Hello Julio, Tiffany and Daniel,

 

The team fixed this issue. Install the updated package from Creatio Marketplace to resolve it on your end.

Hi Ivan Leontiev,

 

When I install the updated package are giving me the following mistakes that I don't understand.
Any idea how to solve it?

2021-04-21 18:30:27,256 Errors and (or) warnings occurred while compiling configuration dll
2021-04-21 18:30:27,271 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'
2021-04-21 18:30:27,271 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'
2021-04-21 18:30:27,271 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'
2021-04-21 18:30:27,271 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'
2021-04-21 18:30:27,271 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'
2021-04-21 18:30:27,271 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.
2021-04-21 18:30:35,410 When application installed, an error(s) occured

 

Hi Daniel,

 

This means you have another package with the EPPlus library. Creatio does not allow you to install the same library twice.

Any idea in how to delete the ERPlus library?

Hi Daniel,

 

Unfortunately, the responsible team cannot remove the EPPlus library from the app package. Would you consider removing the library from the other package installed on your site?

Show all comments

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

Like 1

Like

1 comments

 

Hi Pedro,

 

I had no issues with generating a report in Studio Creatio, Enterprise Edition, version 7.17.2.

 

Please send us more information to help us reproduce this issue. What we need the most are the name of your Creatio product and its version. Moreover, do you use *.xlsx file templates in your reports? Can you see any error messages in the console after clicking to generate a report?

Show all comments