Dear Alisson,



As we can see, you created a support case on this matter - 0998614 and we provided you with a reply:



This logic developed by our project team developers on your website. We are looking into it and will get back to you with the solution soon.

 

Thank you.



Best Regards,

Ivanna Yatsura.

Hello Alisosn!



Could you tell me some more information about that issue? What do you see on the page and what is the expected result? That would help us to solve the problem,



Best Regards,

Tetiana Bakai

Hello,

There is no way to generate the excel report since it is not piece of default functionality. The workaround to attach the excel report manually on the attachments detail and use simple process to send it. Here is the example that send attachments from account:

Other than that, it is necessary to develop custom integration that will call for endpoint of the excel report generation, get file, send it to Creatio and then the process would re-send it according to your needs.

When clicking on generate excel report, the query calls for https://yourwebsite.com/0/rest/IntExcelReportService/GetExportFiltersKey with the following parameters:

EsqString: "{\"rootSchemaName\":\"Contact\",\"operationType\":0,\"includeProcessExecutionData\":true,\"filters\":{\"items\":{\"8488ded0-40f6-4167-95ca-20bccc49bfc1\":{\"filterType\":1,\"comparisonType\":3,\"isEnabled\":true,\"trimDateTimeParameterToDate\":false,\"leftExpression\":{\"expressionType\":0,\"columnPath\":\"Id\"},\"rightExpression\":{\"expressionType\":2,\"parameter\":{\"dataValueType\":1,\"value\":\"c4ed336c-3e9b-40fe-8b82-5632476472b4\"}}}},\"logicalOperation\":0,\"isEnabled\":true,\"filterType\":6},\"columns\":{\"items\":{\"Full name\":{\"caption\":\"Full name\",\"orderDirection\":0,\"orderPosition\":-1,\"isVisible\":true,\"expression\":{\"expressionType\":0,\"columnPath\":\"Name\"}},\"Age\":{\"caption\":\"Age\",\"orderDirection\":0,\"orderPosition\":-1,\"isVisible\":true,\"expression\":{\"expressionType\":0,\"columnPath\":\"Age\"}},\"Email\":{\"caption\":\"Email\",\"orderDirection\":0,\"orderPosition\":-1,\"isVisible\":true,\"expression\":{\"expressionType\":0,\"columnPath\":\"Email\"}}}},\"isDistinct\":false,\"rowCount\":-1,\"rowsOffset\":-1,\"isPageable\":false,\"allColumns\":false,\"useLocalization\":true,\"useRecordDeactivation\":false,\"serverESQCacheParameters\":{\"cacheLevel\":0,\"cacheGroup\":\"\",\"cacheItemName\":\"\"},\"queryOptimize\":false,\"useMetrics\":false,\"adminUnitRoleSources\":0,\"querySource\":0,\"ignoreDisplayValues\":false,\"isHierarchical\":false}"

RecordCollection: ["c4ed336c-3e9b-40fe-8b82-5632476472b4"]

ReportId: "ec1724f7-e58e-491f-8471-0ce19b61bc02"

so it is necessary to generate the POST request to this endpoint  /0/rest/IntExcelReportService/GetExportFiltersKey with similar parameters as above. As the response - you will get the file. 

Here is the similar post describing how to generate such POST request

https://community.creatio.com/questions/how-can-i-generate-excel-report…

Regards,

Dean

Dear Javier,

Thank you for your question!

The best way to monitor the Business Process error messages is to turn on the Traces parameter of a particular BP.

But please note that this may impact the system`s performance.

You may find these Academy Articles useful:

https://academy.creatio.com/docs/node/1790

https://academy.creatio.com/docs/node/1792

In addition, you may turn on the Debug mode of the whole Creatio itself by typing in this string in the browser`s console:

Terrasoft.SysSettings.postPersonalSysSettingsValue("IsDebug", true)

But please make sure to turn it off as you are finished as it impacts the system performance.

Hope this helps!

 

Regards,

Danyil

Hi Danyil, 

Thank you for your response, I know about Traces parameter, but actually I'm trying to debug server side business process' c# code(script task) in visual studio. 

Isn't that possible? 

Best regards, 

Javier

Javier Collazo,

Hi Javier,

This is only possible using C# interactive tools like dnSpy (can be downloaded from here) where you need to connect to w3wp.exe process of your application pool and debug the logic in real time.

As for connecting the app to Visual Studio - you can do it, but this feature was developed to allow development in the File system, but not debugging.

Best regards,

Oscar

Hello, 

Such error occurs when variables (ContactName, ContactPhone and ContactList) are not defined in the function, the code itself should be revised a bit. 

After adding 

var ContactName = Get<string>("ContactName");

var ContactPhone = Get<string>("ContactPhone");

.... etc

at the beginning of the Script Task element the process can be saved and published with no errors. 

Best regards, 

Anastasiia Zhuravel

Hello Nageswara,

Unfortunately, this feature is not implemented in Creatio and we do not have examples of this implementation. This integration has to be implemented from the scratch.

I've registered this idea for our R&D to consider using SSRS reports in future. 

Regards,

Dean

Hi Nagaraju,

To run this action once per month a business process with a timer can be created that will create a scheduler task. And then you can either add a script task to the process, or use read data and read a collection of records or implement any other logic required.

Best regards,

Oscar

Hello,

Please check if your SysPortalConnection user has the portal license assigned to him and also check if the password for the SysPortalConnection is the same as the password specified in the UserManagementSauPassword key of the root/Terrasoft.WebApp/Web.config file.

Also what message is logged in the application logs at the moment you click the link? Also do you click the link directly from the case processing tab or do you receive a feedback email and click the link from the email? Because clicking the link from the processing tab of the case is restricted for company employees and can lead to this error (secure case evaluation, logged-in company employees cannot rate cases).

Best regards,

Oscar

Hi Nageswara, 

Firstly please check the "QueueItem" object and set up checkboxes according to your further events

If you activate this checkbox (on Updating as you need) you will see new field below which was generated automatically. The value of that generated field will be used as trigger for the object process. In your case the override method will be "IsInserted" , where your logic is implemented. 

Here is more information : 

https://academy.creatio.com/docs/developer/back-end_development/entity_…

Best Regards, 

Bogdan L

Bogdan Lesyk,

Thanks for the reply Bogdan,

We did the same thing here, but we are unable to debug the code in VS, We put a break point on method OnInserted() mode but it is not hitting the break point when a QueueItem record  is inserting, but somehow it is inserting in DB.

Can you pls help on this?

Best Regards,

Nageswar

Hello Shivani,

Add the following CSS for this:

#mainHeaderContainer.opened-right-panel #header-command-line-container {
    display: none;
}

When the right panel opens the command-line (what can I do for you?) will disappear. When it closes it will reappear. See https://share.customerfx.com/xQubRjWj

Ryan

Additionally, if you only wanted to do this when the screen resolution is less than 1440px you could add the following: 

@media only screen and (max-width: 1440px) {
    #mainHeaderContainer.opened-right-panel #header-command-line-container {
        display: none;
    }
}

Ryan

Thanks Ryan! This works!