Sales Creatio | Community Creatio

https://www.loom.com/share/c5af582e899043a8803854d5d7b12bd5

02:29 Feb 10, 2020

Hello Romadan,

We have never faced such issues in the past so please specify:

1) If this issue occurs if you are trying to open several different processes or only one?

2) Do you have "Debug mode" being turned on?

3) Seems that you are receiving some console error when trying to open a process. Please provide us with a screenshot of this error and also copy it here.

4) Do you open your process from process log or from process library? Or do you open execution diagram of your process?

Thank you in advance!

Best regards,

Oscar

Midun

05:45 Feb 10, 2020

Oscar Dylan,

Hi Oscar, thanks for reply.

Can you check my video for more details, I record what happen in my local.

1). Several process. The point is if open the application more than 2 tabs (wizard tool only).

2). No

3). Error is request timeout.

4) From process log, from process library, open section wizard too, the point is wizard tool.

Thanks

05:52 Feb 10, 2020

Romadan Saputra,

Got it, thank you! And can you please go to "Network" tab, catch the request that returns this error and check "Response" tab of this request? What response do you get from the server? Maybe there will be more information on this time-out error.

Best regards,

Oscar

Midun

06:23 Feb 10, 2020

Oscar Dylan,

I got 2 pending process

Midun

06:27 Feb 10, 2020

is it any configuration in IIS / Connection String / System Setting that shoul be modification?

Eric Garcia de ...

20:54 Dec 16, 2022

Hi Romadan and team,

Hope you are doing great!

I got the same issue this morning with version 8.0.5.

Did you have the chance to solve it?

Thank you.

Show all comments

data import

7.15_()

Force column value during data import

Ricardo Bigio

19:52 Feb 07, 2020

I need to set a column value indicating if a lead was added during data import from Excel. I would like to avoid creating a column in the Excel file to do do. Is it possible?

2 comments

20:32 Feb 07, 2020

Hello Ricardo,

There is no need to add columns in the application or in Excel file since if the record was created or modified via data import it gets unique tag that contains "Data import" part + date when this import was performed. In case CreatedOn of the record equals to ModifiedOn of the record and there is import tag on this record it means that the record was created using import from Excel. But if CreatedOn not equal to ModifiedOn and the record has import tag it means that the record was modified using data import.

Best regards,

Oscar

Ricardo Bigio

23:36 Feb 07, 2020

Oscar Dylan,

Great, Thanks !

Show all comments

11:42 Feb 07, 2020

Exception Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FKVJgxmU9tugUNJfIWHaADhTn9tE". The conflict occurred in database "SalesEnterpriseENU_2889781_1124", table "dbo.SysCulture", column 'Id'. The statement has been terminated. Exception Type: System.Data.SqlClient.SqlException Exception Source: .Net SqlClient Data Provider

Can you please fix my issues?

2 comments

05:32 Feb 10, 2020

The error indicates that your package has Culture that is not installed.

Here is the list of localizations that can be used in your package:

uk-UA

en-US

ar-SA

cs-CZ

de-DE

es-ES

fa-IR

fr-FR

it-IT

nl-NL

pl-PL

ro-RO

ru-RU

Ideally during installing the system should ignore localizations that are missing in the target system, but sometimes such issue may occur. Try to:

1) Roll back the DB to a point before you attempted to install the package.

2) Flush Redis.

Once done try to import the package once again.

Best regards,

Oscar

Ahmad Bagus Ariyanto

05:42 Feb 10, 2020

Oscar Dylan,

Its Work, Thank You Oscar !

Show all comments

11:28 Feb 07, 2020

Dear mates,

When i want to create a detail, i have several "Base Object" in the selection list.

How can i choose the good one ?

Thank you,

Nicolas

5 comments

Dean Parrett

09:40 Feb 10, 2020

Dear Nicolas,

It seems like you have multiple custom object with the same name. By default, there is only 1 Base object. Try to rename the custom ones and you will be able to see the original one or the required replaced base object.

Regards,

Dean

LÉZORAY Nicolas

09:56 Feb 10, 2020

Dear Dean,

Can you please tell me in which table can i find the custom object list having the Base object name?

Have a nice day,

Nicolas

Dean Parrett

10:04 Feb 10, 2020

Dear Nicolas,

It should be SysSchema.

Regards,

Dean

Luis Tinoco Azevedo

10:35 Feb 10, 2020

Hi Nicolas, I see you are orking with French language. I've had similar issues working with PT version were the translation is not so good and a several objects get translated with the same name. I've switched to English and then I could find the correct base object.

Luis

LÉZORAY Nicolas

10:42 Feb 10, 2020

Luis Tinoco Azevedo,

Hi Luis,

Thank you for the answer. It's ok too in english for me, but i prefer working in french and change the object title having this issue.

When i ve to select the parent object, i switch to english, and then i switch back in french.

Nico

Show all comments

Esq query not working

13:39 Feb 04, 2020

Can i anyone help me out to get correct esq query for

SELECT

[Account].[Name]

FROM

[dbo].[Order]

LEFT OUTER JOIN [dbo].[Account] ON ([Account].[Id] = [Order].[AccountId] )

WHERE ([Order].[Id]='10643C0B-4932-415C-9150-91458492BBBE')

My esq query:

I could not get the name of the account using this.

5 comments

15:11 Feb 04, 2020

Can anyone help on this?

Dmytro Smishchenko

15:54 Feb 04, 2020

Hi Susanna,

Seems like you have added a wrong column.

Correct column in the query will be:

esq.AddColumn("Account.Name");

Here you can find more samples. Its about C#, but logic is the same.

Regards,

Dmytro

07:34 Feb 05, 2020

Dmytro,

I tried it is not working.I need to join the two tables Account and Order, retrieve the account name.

Please correct the esq

09:38 Feb 05, 2020

Can anyone help on this?

Midun

20:58 Feb 08, 2020

Susanna Thomas,

Can you show us the console.log.

You want get the column account in order. The account is lookup from Order, no need "esq.AddColumn("[Account:Id:AccountId].Name");", just esq.AddColumn("Account"); and you will get the Id and Name of Account.

Then, when getting the result, set UsrAccount this.set("UsrAccount", {value: ..., displayValue: ...}); if the UsrAccount is lookup, else if string, just get displayValue

Show all comments

7.15_()

How to invoke configuration service (internal web-service) from Business Process ?

Marcin Kott

10:53 Feb 04, 2020

Hi Team,

As in topic, i'm looking example how to call internal post web-service inside business process. Should i use "Script Task" or "Call Webservice Task" to handle it ?

I found only information how to do this from client-side js under link https://academy.creatio.com/documents/technic-sdk/7-15/calling-configur… but i would like to invoke similar post method via business process.

Regards,

Marcin Kott

2 comments

Ryan Farley

18:14 Feb 04, 2020

You would use a script task, but you don't need to call it like a web service. Keep in mind, the web service is just a C# class in the Terrasoft.Configuration namespace. You can simply create an instance of the class, like you would any class, and invoke it's methods. The only thing you need to keep in mind is that how the service gets things like UserConnection will be different when used this way. For these cases, I usually have an overloaded constructor in the web service class where I provide the UserConnection to it

For example:

var myObj = new Terrasoft.Configuration.UsrSourceCode1(UserConnection);
myObj.SomeMethod();

Hope this helps.

Ryan

Marcin Kott

17:53 Feb 05, 2020

Ryan,

Yes indeed, Your comment help me to go forward with design solution. Thanks,

Regards,

Marcin

Show all comments

Generate, compile or publish takes a very long time

13:58 Feb 01, 2020

Hello

Very frequently we find that the Generate, compile, publish or Update operations from the Configuration manager take a long time to run ( > 30 mins). This happens across developers across projects.

Sometimes it keeps running endlessly and we need to force abort.

1. Are there any specific reasons why this might happen? Our hardware configurations are in line with what is recommended by Creatio for developer machines. So, I doubt if it is hardware related.

2. How long is Generate, publish, compile or update generally expected to take?

2. Could this be because of too many objects/schemas inside one package? If Yes, What is the recommended scale/volume of work that can go inside one package.

6 comments

03:21 Feb 03, 2020

Hello!

Compilation and source code generation depends on several parameters. 1st most significant parameter is connected to hardware. To ensure your hardware can provide enough resources for those action monitor server performance during compilation or source code generation.

2nd parameter is amount of code that should be compiled/generated. OOB instance without customisations can be fully compiled in 5-10 minutes. More code you have more time it will take for system to compile.

Most important recommendation here is not to compile all - you should understand when your system needs to be compiled and what should be compiled. In general you can simply compile only modified items to reduce compilation time and generate/compile all only before updates/package installation.

Best regards,

Angela

16:09 Feb 04, 2020

Angela Reyes,

To clarify, We only compile modified items and not compile all items. But still it takes a significant time. Your point regarding hardware does help. Thank you Angela..

Regarding my 3rd question,

Is there a maximum number of objects or schemas that is recommended to be in a package? Beyond that number, Would you suggest creating a new package? (This is presuming that generation and compilation happens only on the selected package?)

01:31 Feb 05, 2020

M Shrikanth,

There is no maximum number of objects in each package. Amount of objects in package should only depend on your development process so that you could always tell which package contains certain functionality.

09:02 Feb 05, 2020

Angela Reyes,

Thank you Angela. One follow up question.

It was recommended to us to have all the functionality in a single package, and not split into different packages. Would you have the same recommendation? Any reasons why?

00:29 Feb 06, 2020

M Shrikanth,

You can use several packages in case you have several different customisations that are not connected to each other and can be installed separately without each other. If all your changes are connected it is better to use 1 package.

https://css-tricks.com/everything-you-need-to-know-about-date-in-javascript/

09:35 Feb 06, 2020

Angela Reyes,

Thank you Angela for your comments. They really help us!

Show all comments

11:23 Jan 29, 2020

Dear mates,

How can i format date in Creation source code ?

When i do this:

var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {
   rootSchemaName: "Order"
});
 
esq.addColumn("Date");
 
esq.getEntityCollection( function(result) {
    result.collection.each ( function (order) {
       this.console.log(Date);
    });
});

the system return me:

function Date() { [native code] }

What the way to format Date ?

Thanks,

Nicolas

2 comments

Alina Kazmirchuk

18:46 Feb 06, 2020

The Date can be formatted via default js functions. Please feel free to find out more about working with Date in JavaScript in the article by the link below:

Also there are some examples of working with Date in ESQ in the article on academy :

https://academy.creatio.com/documents/technic-sdk/7-15/entityschemaquery-class-filters-handling

Ryan Farley

20:03 Feb 06, 2020

You can format the date based on the current users culture settings using the following:

var formattedDateString = myDate.toLocaleDateString(Terrasoft.currentUserCultureName);

Ryan

Show all comments

Auto-generated page - How to hide Close button

Marcin Kott

13:18 Jan 28, 2020

Hello Team,

Is there any possibility to hide/disable Close button rendered in Auto-generated page on standard ?

Alternatively we are looking possibility to handle this event after click (eg. go to terminate process).

Regards,

Marcin Kott

2 comments

Best reply

Alina Kazmirchuk

13:30 Feb 20, 2020

It's possible to hide "Close" button by applying custom CSS style to the AutoGeneratedPageV2 schema. In this way you need to find the correct selector for "Close" button in AutoGeneratedPageV2.

The article by the link below describes how to add custom CSS:

https://community.creatio.com/articles/how-add-or-edit-css-style

Reid Burger

02:39 Jan 31, 2020

I would recommend to use the Pre-Configured page instead of the Auto-generated page. You can decide which buttons display to the user. You can use conditions in the process based on the button the user clicks in the Pre-Configured page.

Alina Kazmirchuk

13:30 Feb 20, 2020

It's possible to hide "Close" button by applying custom CSS style to the AutoGeneratedPageV2 schema. In this way you need to find the correct selector for "Close" button in AutoGeneratedPageV2.

The article by the link below describes how to add custom CSS:

https://community.creatio.com/articles/how-add-or-edit-css-style

Show all comments

7.15_()

How could I find out edition of the current Creatio product by interface?

Yuriy Konstantinov

11:19 Jan 28, 2020

Hi community,

We got Sales Creatio licence,

however when I'm asked what edition we use, I'm not sure what to choose.

I may be asked by interface either of documentation or forum:

Is there a way of finding it out by interface, not contacting manager or teammates?

For a user with admin rights.

Thanks in advance.

________

If there a need to tell that searched for the answer on the community forum an in docs, I could tell I spent a considerable time on it; googling also. Searched by keywords "get edition", "find out edition", etc.

4 comments

Best reply

16:16 Jan 28, 2020

Hi! Please use following sql query to determine version of your application:

DECLARE @ConfigurationVersion nvarchar(250)

DECLARE @PrimaryCulture nvarchar(250)

DECLARE @Product nvarchar(250)

DECLARE @SysAdminUnit_AllUsers uniqueidentifier = 'A29A3BA5-4B0D-DE11-9A51-005056C00008'

BEGIN

SELECT @ConfigurationVersion = TextValue

FROM SysSettingsValue ssv

INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId

WHERE ss.Code = 'ConfigurationVersion'

AND SysAdminUnitId = @SysAdminUnit_AllUsers

SELECT @PrimaryCulture = c.Name

FROM SysSettingsValue ssv

INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId

INNER JOIN SysCulture c on c.Id = ssv.GuidValue

WHERE ss.Code = 'PrimaryCulture'

AND SysAdminUnitId = @SysAdminUnit_AllUsers

SELECT @Product =

CASE

WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')

   THEN 'bpmonline bank sales & bank customer journey & lending & marketing'

WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

   THEN 'bpmonline bank sales & bank customer journey'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')

   THEN 'bpmonline sales enterprise & marketing & service enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales enterprise & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales commerce & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales team & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

   THEN 'bpmonline sales team & marketing'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

   THEN 'bpmonline sales team'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')

   THEN 'bpmonline sales commerce'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

   THEN 'bpmonline sales enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name Like 'MarketingSoftkey%')

   THEN 'bpmonline marketing'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')

   THEN 'bpmonline service enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Studio%')

   THEN 'bpmonline studio'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')

   THEN 'bpmonline lending'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

   THEN 'bpmonline bank sales'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

   THEN 'bpmonline bank customer journey'

   ELSE '?' END

SELECT @Product, @ConfigurationVersion, @PrimaryCulture

END