Generating | Community Creatio

11:51 Feb 20, 2025

Hi,

I am trying to build a business process that will automatically generate an excel report using the Generate Excel Report task, available through package IntExcelReport.

In the business process Convert File to Base64String I pass the file that is generated from Generate Excel Report task.

Convert File to Base64String business process is as the following picture:

In the script task I have the following code:

But the when I try to get the content of the File parameter (FileParam bp parameter) I get a null value.

What else should I try, or am I not configuring it right?

Thank you in advance

2 comments

Damien Collot

12:34 Mar 03, 2025

Hi, trying also to figure out how to use this new excel process element to send the report by email. Documentation has not been updated in the marketplace. Anyone figured it out ?

Oleg Drobina

12:56 Mar 19, 2025

It's strange since I receive

System.InvalidCastException: Unable to cast object of type 'Terrasoft.File.EntityFileLocator' to type 'Terrasoft.Configuration.File'.
at Terrasoft.Core.Process.ProcessModel.GetParameterValue[T](FoundParameterData result)

And I do everything in the same manner:

Main process

Sub process

Process log

So what am I doing wrong?

If it's working on your end: I don't see the usage of FileAPI in the script task that is required and your app may use S3 file content storage and this can be the first reason for the empty file data. The second possible reason is that you check the file data using the tracing or you don't see file data since it's not saved in the memory of the app because of the system feature related to storing process parameters in the memory. This data should be then used in some interactive element or used in the process Formula element so it could be available in the application memory.

Show all comments

Subscribe to Generating