I was finally able to build a report and get it into the correct section, but now I am receiving the following error message. 

I am not sure how i can edit the GUI. Please advise. Thank you.

 

Patrick

Like 0

Like

3 comments

Hello Patrick,

 

from this perspective it is really difficult to say where the issue may occur, So we would recommend you create a support case so our team can investigate the reasons for such an error and provide you with the solution.

 

Regards,

Gleb.

Gleb,

 

A report was made previously, but since the Excel Add-in was made by a third party creatio was unable to asssist.

 

Essentially in the Excel Add-in, when i am trying to create a related schema to the main table, i am being forced to select "id" as the Master Column. Even though the "id" is unique to each record. If i do not select "id" i get the aforementioned error message when trying to generate the report. I would prefer a different identifier so i can link the data from the main table to the related schema table. Thanks.

Patrick Ostrowski,

 

can you please detail a bit more on where exactly you are implementing such logic and where you are trying to add those columns?

 

Thanks in advance.

 

Regards,

Gleb.

Show all comments

Hello,

 

I am working on adding new fields in the cases section on mobile application to be visible for a portal user when submitting a case. I have added the fields in page setup via mobile application wizard as shown bellow:

but I still can't see those fields on mobile as a portal user:

 

Is there a way to accomplish this?

 

Thanks,

 

Like 0

Like

1 comments

Hello Mariam,

 

you can try to clear the cache and synchronize the Mobile app once again after you have created the Case page.

 

Also, you can refer to the articles on the Academy to find the solution:

 

https://academy.creatio.com/docs/7-18/developer/mobile_development/cust…

 

https://academy.creatio.com/docs/7-18/user/platform_basics/mobile_app/p…

 

if this won't help, we recommend you create a support case based on the problem so our Support team will be able to work on the issue.

 

Regards,

Gleb.

Show all comments

Hello,

 

For some technical issues, I had to reinstall database. so I exported the package "Custom" to be able to import it via application install. while trying to import it, it fails to restore configuration from backup.

How can I retrieve configuration done on this custom package? is there any best practice to export packages?

 

Thanks,

Like 0

Like

4 comments

Hello Mariam,

 

You can export the package from the Configuration section:

 

But we recommend installing the package in the Installed application section. So you will be able to download the application log to check the errors.

 

Best regards,

Bogdan

Hello Bogdan,

 

Thank you for the reply. in fact this is what I have done and then I tried to import the package from the installed application section. bellow is the screen of import failure. 

Bellow is a snippet of the errors in log file.

Error occured while performing operation on "Custom" item, UId = a00051f4-cde3-4f3f-b08e-c5ad1a5c735a.

2022-04-15 10:15:43,737 System.AggregateException: One or more errors occurred. (Error occured while saving resources for schema 'UsrServiceCatalogc9afd9b9Section' in 'Custom' package for 'pt-PT' culture) (Error occured while saving resources for schema 'UsrServiceCatalogc9afd9b9Section' in 'Custom' package for 'ro-RO' culture) (Error occured while saving resources for schema 'CaseInFolder' in 'Custom' package for 'pt-BR' culture) (Error occured while saving resources for schema 'UsrSchema6cea64dfPage' in 'Custom' package for 'it-IT' culture) (Error occured while saving resources for schema 'UsrSchema6cea64dfPage' in 'Custom' package for 'vi-VN' culture) (Error occured while saving resources for schema 'CaseInFolder' in 'Custom' package for 'he-IL' culture) (Error occured while saving resources for schema 'UsrSchema6cea64dfPage' in 'Custom' package for 'ar-SA' culture) (Error occured while saving resources for schema 'UsrSchema6cea64dfPage' in 'Custom' package for 'fr-FR' culture) (Error occured while saving resources for schema 'UsrCaseVisa' in 'Custom' package for 'en-US' culture) (Error occured while saving resources for schema 'UsrSchema6cea64dfPage' in 'Custom' package for 'cs-CZ' culture) (Error occured while saving resources for schema 'UsrRentalVehicle' in 'Custom' package for 'nl-NL' culture)

Thanks,

mariam moufaddal,

Did you ever find a solution?

The package "Custom" cannot be exported between environments. A solution would be to add a new package and add the same dependencies as in the package "Custom" and move files from Custom to the new created package. then you can export that package between environments.

Show all comments

Hi Community,

 

Any idea how can I access EmailPagev2 in portal. Currently if you browse this url using Portal credentials it is redirecting to Portal main page.

 

site/0/Nui/ViewModule.aspx#CardModuleV2/EmailPageV2/add/Type

 

Like 0

Like

3 comments

Hello,

 

The basic functionality does not support sending the emails from the portal case page, and therefore it is not possible to add the email activity on the detail from portal, so this page is not available when you are logged in the portal.

 

Kind regards,

Mira

Mira Dmitruk,

 

Hi,

 

Is there any workaround to where I can call this url in Portal? How can I register EmailPageV2 for portal users?

Fulgen Ninofranco,

 

It is not possible to access this URL in the portal or register it. Despite that, we will take into account this idea, but currently, emails cannot be sent via the portal.

 

Thank you,

Igor

Show all comments

Hi team 

Is it possible to have an "add from event" item and an "add audience" item in the same campaign?

If the flow for the "Add Audience" item goes to a landing page that registers an attendee for an event, was the attendee captured by the "Add from Event" item?

Like 0

Like

4 comments

Hello,

 

Can you please elaborate on your question and give us a bit more details how you want this business logic to work?

 

Kind regards,

Mira

Hi Mira Dmitruk,

 

  • For branch 1, the campaign participant receives an email with a link to a landing form to register them for event "A".
  • for branch 2 the participants in the campaign are the participants in the "A" event
  • If the Stefano contact receives the invitation email and registers for event "A", does he re-enter the campaign from branch 2?

 

Stefano Bassoli,

Hello Stefano,

 

As it may be judged from the screenshot you shared - the contact will not reenter the campaign, as the participant is not exiting when following the flow 1. In other words, participants can't enter a second time until they exited.



There should be an exit element (perhaps with a specific filter set) for flow 1 so the contact will have a possibility to reenter the campaign for flow 2.

 

I hope my answer was useful for you.

 

Best Regards,

Dan

Denis Bidukha,

thank you for your response,

I will check

Show all comments

Hi everyone,

how to use filter month and year Esq Server (EntitySchemaQuery)?

SELECT 
* 
FROM UsrTable 
WHERE 
MONTH(CreatedOn) = 1 AND YEAR(CreatedOn) = 2022

I found there is a function at https://academy.creatio.com/api/netcoreapi/7.17.0/#Terrasoft.Core~Terrasoft.Core.Entities.EntitySchemaQuery~CreateMonthFunction.html for get month and year.

https://prnt.sc/8brMGtYq3qhP

But how to use in filter?

esq.Filters.Add(esq.CreateFilterWithParameters(FilterComparisonType.Equal, "CreatedOn", Month));
esq.Filters.Add(esq.CreateFilterWithParameters(FilterComparisonType.Equal, "CreatedOn", Year));

Thank you.

Like 1

Like

1 comments
Best reply

Hello Romadan,

You can do filters like this using macros: 

// CreatedOn is the 1st month (January)
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Month, 1));
 
// CreatedOn is the first day of the month
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.DayOfMonth, 1));
 
// CreatedOn is in the year 2022
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Year, 2022));

Ryan

Hello Romadan,

You can do filters like this using macros: 

// CreatedOn is the 1st month (January)
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Month, 1));
 
// CreatedOn is the first day of the month
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.DayOfMonth, 1));
 
// CreatedOn is in the year 2022
esq.Filters.Add(esq.CreateFilter(FilterComparisonType.Equal, "CreatedOn", EntitySchemaQueryMacrosType.Year, 2022));

Ryan

Show all comments

Hi Team. Im try to add the excel report to the workplace sales (or any other) and getting this error:

 

https://i.imgur.com/uoLu5dC.png

https://i.imgur.com/rToRhPF.png

https://i.imgur.com/ZxbkuVz.png

 

Some idea?

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

Like 0

Like

3 comments

I get that often with that Addon for some reason, not sure why. It will usually work after a log out and back in again (or sometimes after a few). 

Sometimes I just add it directly to the SysModuleInWorkplace table.

Either way, it must be some sort of caching issue, since eventually it will work and all you to add it to the workplace.

Ryan

Yes, I just add it with SQLquery 

INSERT INTO "SysModuleInWorkplace" ("Position", "SysWorkplaceId", "SysModuleId") VALUES ('99', (select "Id" from "SysWorkplace" where "Name" = '<Name of workplace>'), (select "Id" from "SysModule" where "Caption" = 'Excel reports'))

Thanks Rayan.

 

Federico.

Federico Buffa ?,

 

Hi, Federico!

Thank you for the query.

We are aware of this issue. It can occur after the installation of any package, not just this add-on.

Our R&D department is reviewing it, but we don't have a solution currently.



As workaround, you can make any changes in workplaces. For example, delete a section and add it again. You should not have problems with adding a new section after this.

Show all comments

Hello community,

 

I am trying to connect a full organizational role with an organization. To implement this solution I want to update the Account column of SysAdminUnit table which is impossible from the client side. Is there a way I can update the Account column of SysAdminUnit?

 

Like 0

Like

1 comments

Hello,

 

Could you please specify what is the purpose of connecting an organizational role with an Account? Organizational roles are used to distribute access rights between the users in the system, however, organizations and accounts do not have access to the system.

 

You can update the table with a SQL query like

UPDATE SysAdminUnit 

SET AccountId = value

WHERE condition;

Where the condition can be something like

Id = '9dc7626c-e03a-4978-b5c2-cdcf99de7801'

or

Name like '%Accounting Department%'

 

Best regards,

Dariy

Show all comments

Hi team,

is it supported the multi edit page feature on portal case page?

I created two different edit page for case for portal section but it doesn't work.

What Am I doing wrong?

Like 0

Like

3 comments

Hello Stefano, 

 

Yes, such feature is available for the portal case pages. 

Edit pages can be added and configured directly from the Section Wizard:

 

If the issue occurs for the specific portal user or role, I would suggest to double-check the access rights for such users.

Should you have any additional questions, please let us know. 

 

Best regards,

Anastasiia

Anastasiia Zhuravel,

Hi Anastasiia

I created 2 edit pages based on the category field.

The weird thing is that if I remove the block element "Response container" and "Solution container" from edit page 1, the same changes appear on edit page 2

Stefano Bassoli,

 

The issue may occur if the edit pages were created incorrectly, for example directly from the configuration and have incorrect dependencies.  I would suggest to re-create anew the edit pages directly from the Section wizard.

If the issue persists, please contact us at support@creatio.com so we could investigate the issue from our side. 

 

Best regards,

Anastasiia

Show all comments

Hi team,

in portal section page is missing the switch advanced mode feature,

how can I enable it ?

 

Like 0

Like

2 comments

Hello Stefano,

 

Basic functionality doesn't include the ability to apply filter conditions based on the connected objects  for the portal user directly in the section, therefore the advanced filter option is not available for such user there.

As a workaround you may use a dynamic folder and set the needed filter conditions for it. 

Also, we already have a query registered for our responsible R&D team to implement this functionality for portal users in the upcoming versions of the application. I will assign your case to this project in order to increase its priority.

Thank you!

Best regards,

Anastasiia

Anastasiia Zhuravel,

thank you Anastasiia

Show all comments