7.15_()
Sales_Creatio_()
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.

Like 0

Like

4 comments
Best reply
Angela Reyes
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

 

Angela Reyes
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

 

Mary P D'Arrigo
16:13 Nov 30, 2021

I know this post is almost 2 years old, but it seems like this information should be readily available from the UI on the Help menu

Oliver Crowe
11:32 Mar 20, 2023

Angela Reyes,

This seems like an overly complicated solution, this SQL query also doesnt run for me?

Frances Carrera
22:21 Apr 04, 2023

It should be available on the settings somewhere, but for now, simplest way I've found is to log out. Version is visible on the login screen, underneath where you enter credentials

 

 

Show all comments
langage_development
7.15_()
Sales_Creatio_()
Langage development in Creatio
LÉZORAY Nicolas
19:36 Jan 27, 2020

Dear mates,

Can i develope using french language in Creatio ?

Which browser would you advise for users ? (not developers)

Thank you,

Nicolas

 

Like 0

Like

1 comments
Oleg Drobina
18:04 Jan 29, 2020

Hello Nicolas,

Yes, you can adjust changes to the application using French localization and also you can use French words when specifying parameters names (but not key words like "method" or "function").

As for browser that can be used - here is the list of client side system requirements with the list of browsers that can be used.

Best regards,

Oscar

Show all comments
container
LeftModulesContainers
minipage
7.15_()
Sales_Creatio_()
Modify a Minipage data container
NCS.JulioFalcon
00:39 Jan 24, 2020

Hello,

Somebody knows how can I add or remove fields on the provider containers on Minpages?, in my case New Account Minipage, I want to change Primary Contact from List to Lookup...

http://prntscr.com/qs0ij7

thanks

Like 0

Like

3 comments
NCS.JulioFalcon
17:20 Jan 24, 2020

Hello, somebody had any suggestion?

Vladimir Sokolov
21:30 Jan 24, 2020

You can just add to your schema AccountMiniPage in DIFF definition:

                "operation": "merge",

                "name": "PrimaryContactEdit",

                "values": {

                    "layout": {

                        "colSpan": 18,

                        "rowSpan": 1,

                        "column": 0,

                        "row": 4

                    },

                    "dataValueType": this.Terrasoft.DataValueType.LOOKUP,

                    "contentType": Terrasoft.ContentType.LOOKUP

                }

NCS.JulioFalcon
22:14 Jan 24, 2020

Thanks Vladimir, it works! :-)

Show all comments
string text field
performance
database
7.15_()
Sales_Creatio_()
How much size do text fields take? Performance impact?
Yuriy Konstantinov
16:05 Jan 21, 2020

Hi community,

I would like to know more about the amount of space next fields take in database (cloud version):

For example, Text(250) field holds a string of 70 characters. How much space would it take in bytes? 

What if the value is null?

If we have 20 custom Text columns for Contact object, how much do they affect the performance? For table of 10K-30K rows. And if they are null for bigger amount of contacts?

For the section table (Account, Contact) of 10K-30K rows, what should be... hmm... the strategy of creating new custom fields for better performance? As an option, instead of adding the columns to Contact object we may add them to a separate detail object, but that increases complexity.

Should we consider much about that?

Thank you.

Like 0

Like

1 comments
Dennis Hudson
22:07 Jan 23, 2020

Dear Yuriy, 

We haven't performed such precised tests, however, the size of the string field is approximately 2 bytes per character. You can perform tests yourself populating columns in sql and evaluating the difference in size of the table. However, the value of the field itself doesn't affects the performance of the system. The amount of columns may affect the performance of the system depending on how often and in which volume you get the data (how many records and how many columns) as it loads an sql to the certain extent. However, 20 text fields shouldn't cause much trouble. There are some ways of optimizing this based on what's said above, e.g. when you use Read Data element in the Business process we recommend to read only columns that are further used in the system. 

Show all comments
7.15_()
Sales_Creatio_()
Applying Mobile Rule to multiple Stage values
Heather
21:07 Jan 16, 2020

I am trying to add a mobile business rule that applies at various stages for an Opportunity. With the below code, the rule is only working on the Verified stage. I need it to work at 13 different stages so I was hoping to be able to add it all in one rule, but not sure if that is possible?

Terrasoft.sdk.Model.addBusinessRule("Opportunity", {

    ruleType: Terrasoft.RuleTypes.Visibility,

    events: [Terrasoft.BusinessRuleEvents.Load],

    conditionalColumns: [

                        {name: "Stage" , value: "e39b75ac-db07-4f37-a140-2f881a0a98e5"}, //Closed Won

                        {name: "Stage" , value: "423774cb-5ae6-df11-971b-001d60e938c6"} //Verified

                        

                        ],

    triggeredByColumns: ["Stage"] ,

    dependentColumnNames: ["UsrEstStartDate","UsrEstEndDate"]

    });

Like 0

Like

1 comments
Alina Kazmirchuk
17:50 Jan 21, 2020

Please check ids that are using in "conditionalColumns" array. It seems like the wrong id is used. The stage values are saved in the OpportunityStage table in the database.

Show all comments
mobile application
Mobile app
7.15_()
Sales_Creatio_()
Toggle operation mode for Mobile Creatio not working
Ahmad Bagus Ariyanto
09:58 Jan 14, 2020

Toggle operation mode for Mobile Creatio is not working now, when I click the button toggle for offline mode there are some process running on it,

and stack as long as the application is open. Anyone idea to solve this problem?

Like 0

Like

1 comments
Angela Reyes
01:30 Jan 15, 2020

Hi! In OOB creatio mobile app offline mode can be enabled only via PC version. If this button is custom try to debug it using mobile emulator that can be requested from support team. 

Best regards,

Angela

Show all comments
7.15_()
Sales_Creatio_()
How to resize show information message box ?
Midun
05:22 Jan 14, 2020

Hi everyone,

Is it possible to resize message box in method "showInformationDialog" ?

and how ?

Thank you.

Like 0

Like

1 comments
Alina Kazmirchuk
19:06 Jan 21, 2020

Unfortunately, it's not possible to configure message box size in the method "showInformationDialog". However you can resize the message box by applying custom css. The article by the link below describes how to add custom css style:

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

The example for css style:

.ts-messagebox-box {

    height: 500px;

    width: 500px;

}

Please note that this css style can be applied globally, to all message boxes in the system. 

Show all comments
MailboxSyncInterval
Mailbox_synchronization_interval
7.15_()
Sales_Creatio_()
Mailbox synchronization interval (MailboxSyncInterval) in minutes?, hours?
NCS.JulioFalcon
19:42 Jan 08, 2020

Good morning,

At difference with "LDAP synchronization interval, hours" that indicates is on hours or "Webhooks synchronization interval, min" minutes, the "Mailbox synchronization interval (MailboxSyncInterval)" didn't indicates if the sync value is hours or minutes, also on documentation just "LDAP synchronization interval" is documented,

Also there no reference to "Mailbox synchronization interval" on Creatio documentation on https://academy.creatio.com/documents/administration/7-15/system-settings-description

Somebody knows if the value here is hours or minutes?

Thanks in advance

Like 0

Like

3 comments
Angela Reyes
20:54 Jan 08, 2020

Hello!

 

This interval is stored in minutes. Please note that this system setting will not be applied for existing mailboxes - you need to add them again to apply this setting.

Best regards,

Angela

NCS.JulioFalcon
21:08 Jan 08, 2020

Angela Reyes,

thanks Angela, we have configured, by default 1, I understand minute, but it doesn't works. You indicate me if I change this setting I must to delete the current mailboxes and add it again to recognize the new setting, this is no logic, are you sure?

Thanks again

Angela Reyes
21:14 Jan 08, 2020

Julio.Falcon_Nodos,

Yes, system setting will work only for new mailboxes. Old mailboxes cannot be affected by it. 

Show all comments
7.15_()
Sales_Creatio_()
Email Template Images
Pedro Longa
18:49 Jan 07, 2020

Hi,

  I have configured some email templates in recent weeks but when the email is sent the inserted image is not visible. This is the same image that I have always been using.

 

 

https://prnt.sc/qkgvdj

https://prnt.sc/qkgw16

Like 0

Like

2 comments
Dennis Hudson
18:19 Jan 23, 2020

Dear Pedro, 

The issue happens with jpg images in the gmail provider. The issue would be fixed in one of the upcoming versions of the application. As a workaround you can change the image format to png or contact support team (support@creatio.com) to have temporary fix installed. 

Pedro Longa
19:42 Jan 23, 2020

Dennis Hudson,

Thanks

Show all comments
Business Process
7.15_()
Sales_Creatio_()
Why link an object to a process? What happens if It is not done ? Please clarify.
Ricardo Bigio
23:06 Jan 01, 2020

What is the reason why it is needed to link objects to processes?

Like 0

Like

1 comments
Dennis Hudson
01:22 Jan 02, 2020

Dear Ricardo, 

This element is needed to track what objects were used in the process. It just adds the object to the corresponding record in process log. It doesn't do anything with the object itself and nothing would happen if you don't use it, however, it is easier to track the process flow with this element. It takes an extra space on the site though and process runs a bit slower. 

Show all comments
Subscribe to Sales Creatio