Hi Team,

 

I am following this article here

 

sysadmin = pg_akshitsaxena

password = pg_syspassword

 

public user = pg_newpublicuser

passwrod = pg_password

 

Under the section "Restore PostgreSQL Database" at point 4 when I put the password for sysadmin then it doesn't show me any error but when I perform point no5. then it gives me this error

 

Can anyone help me with this please?

 

 

Like 0

Like

1 comments

Hi Akshit,

 

The issue is with the database user permissions to login to the database. This error message should be addressed to the database administrator.

 

Best regards,

Oscar

Show all comments

Hi community!

 

I have tried to update my customer's version from 7.17.1 to 7.18.5.

Everything worked fine until version 7.18.2. The update process stopped with the following errors:

 

[10:51:58] List of errors occured during utility execution: 

[10:51:58] 1) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(52,45) error CS0029: Cannot implicitly convert type 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactsFolder' 

[10:51:58] 2) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(85,35) error CS1503: Argument 1: cannot convert from 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactGroup' 

[10:51:58] 3) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(68,41) error CS0029: Cannot implicitly convert type 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactGroup' 

[10:51:58] 4) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(98,45) error CS0029: Cannot implicitly convert type 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactGroup' 

[10:51:58] 5) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(163,48) error CS0029: Cannot implicitly convert type 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactsFolder' 

[10:51:58] 6) Autogenerated\Src\GlbExchangeGroupHelper.GlbExchangeFolderSynchronizer.cs(134,45) error CS0029: Cannot implicitly convert type 'System.Threading.Tasks.Task' to 'Microsoft.Exchange.WebServices.Data.ContactGroup' 

 

The errors are coming from the following marketplace addon: Exchange contacts sync for Creatio | Creatio Marketplace

 

From the release notes, I found out that there was a net standard change in the exchange sync feature in version 7.18.2.

 

The logfile also states that the file Microsoft.Exchange.WebServices.dll is missing in the directory Terrasoft.WebApp\Terrasoft.Configuration\Lib. Instead, the file Microsoft.Exchange.WebServices.NETStandard.dll is now there.

I tried copying the DLL from the backup into this directory, but it didn't solve the problem.

 

I also tried regenerating and rebuilding with the WorkspaceConsole, but since the addon is still installed, the errors are still there.

I haven't found a way to remove packages with the WorkspaceConsole (at least it's not documented). I know clio can do this, but since the web app is nonfunctional, I guess this is no option.

 

Any ideas are very much appreciated!

 

Thanks,

Robert

 

Like 0

Like

1 comments

Hi Robert!



We reviewed this add-on and unpublished it as it has installation issues in the latest Creatio version.



To upgrade successfully on 7.18.2:



1. Delete this package from the configuration using the "Installed applications" section.

2. Re-generate the schema source code.

3. Recompile Creatio.



Then you can update Creatio.

Show all comments

Hi,



We would like to deactivate "New Order" in opportunities, we deactivated all the processes related to orders but it is still generating.



Any idea ?



(7.18.5)

Like 0

Like

3 comments
Best reply

Hi Damien,



If you want to deactivate button 'New order', you can add this code in diff of OpportunityPageV2:



            {

                "operation": "remove",

                "name": "CreateOrderFromOpportunityButton"

            }



 

Hello Damien,

 

Your business task could be achieved only by delelopment.

 

Please refer to the post by the link below:

https://community.creatio.com/questions/hide-button-opportunity-edit-pa…



Best regards,

Bogdan

Hi Damien,



If you want to deactivate button 'New order', you can add this code in diff of OpportunityPageV2:



            {

                "operation": "remove",

                "name": "CreateOrderFromOpportunityButton"

            }



 

Vladimir Sokolov,

 



Thanks a lot, worked like a charm :)

Show all comments

Hello Community,

Is there any way in Creatio to read all Entity fields from front-end (including lookups),besides fetching the entity Metadata?

Thank you

Like 0

Like

3 comments

Hello Petrika,

 

Can you please share a screenshot or a detailed description of your business task?

 

Thank you!

 

Best regards,

Oscar

Oscar Dylan,

In this case I want that in the Lookup, all the fields (Display Value, not the name of the fields in the database) regarding the application form are displayed. How is this realised Oscar ?

Thanks very much !

Petrika,

 

Now I understood, thank you!

 

You will need to preform the SelectQuery request directly to the database from the client-side using filtration needed (this is what happens if you click the lookup, just check it in the "Network" tab of the console) or you can perform the ESQ query to get data from the lookup drop-down. Using one of the scenarios above you will be able to get data needed.

 

Best regards,

Oscar

Show all comments

Hi Team,

 

I want to set the value of current user logged in to the system in a lookup of contact of a section and as soon as the New button for new record is clicked, the lookup should be already auto-filled with the current user contact name.

 

 I tried using this.set("UsrUserName",CURRENT_USER_CONTACT); but it is not working.Please help me achieve this.

 

Thanks,

 Sarika

Like 0

Like

2 comments
Best reply

Hi Sarika,

 

UsrCurrentContact below is a lookup column referencing the Contacts object:

onEntityInitialized: function() {
				this.callParent(arguments);
				this.set("UsrCurrentContact", Terrasoft.SysValue.CURRENT_USER_CONTACT);
			},

As a result the value is set for the column once the page is opened.

 

Best regards,

Oscar

Hi Sarika,

 

UsrCurrentContact below is a lookup column referencing the Contacts object:

onEntityInitialized: function() {
				this.callParent(arguments);
				this.set("UsrCurrentContact", Terrasoft.SysValue.CURRENT_USER_CONTACT);
			},

As a result the value is set for the column once the page is opened.

 

Best regards,

Oscar

Hi Oscar,

 

Thanks for the response. It works fine

Show all comments

Hello,

 

I would like to locate the "CONTACT SECTION' tile in the general tab of the portal section.

Please refer to the screenshot:

 

Below is my code:

 

  • 	diff: /**SCHEMA_DIFF*/[			   
    {
    					"operation": "insert",
    					"name": "Um6pTabsContainer",
    					"parentName": "ActionButtonsContainer",
    					"propertyName": "items",
    					"values": {
    						"className": "Terrasoft.LazyContainer",
    						"itemType": Terrasoft.ViewItemType.CONTAINER,
    						"visible": {"bindTo": "getTabsContainerVisible"},
    						"items": []
    					}
    				},
                  {
    				"operation": "insert",
    				"name": "Tabs",
    				"parentName": "Um6pTabsContainer",
    				"propertyName": "items",
    				"values": {
    				"itemType": Terrasoft.ViewItemType.TAB_PANEL,
    				"activeTabName": "GeneralInfoTab",
    				"classes": {"wrapClass": ["tab-panel-margin-bottom-portal"]},
    				"collection": {"bindTo": "TabsCollection"},
    				"tabs": []
    				}
    			},
     
    			{
    				"operation": "insert",
    				"name": "GeneralInfoTab",
    				"values": {
    				"caption": {
    				"bindTo": "Resources.Strings.GeneralInfoTabCaption"
    				},
    				"visible":true,
    				"items": []
    				},
    				"parentName": "Tabs",
    				"propertyName": "tabs",
    				"index": 0
    			},
     
    			{
    				"operation": "insert",
    				"name": "GeneralInfoTab2",
    				"values": {
    				"caption": {
    				"bindTo": "Resources.Strings.GeneralInfoTab2Caption"
    				},
    				"visible":true,
    				"items": []
    				},
    				"parentName": "Tabs",
    				"propertyName": "tabs",
    				"index": 1
    			},
    				{
    					"operation": "insert",
    					"name": "SectionCaptionCustomerContainer",
    					"propertyName": "items",
    					"parentName": "SeparateModeActionButtonsLeftContainer",
    					"values": {
    						"itemType": Terrasoft.ViewItemType.GRID_LAYOUT,
    						"items": []
    					}
    				},
    				{
    					"operation": "insert",
    					"name": "SectionCaptionLabel",
    					"parentName": "SectionCaptionCustomerContainer",
    					"propertyName": "items",
    					"values": {
    						"itemType": Terrasoft.ViewItemType.LABEL,
    						"caption": {"bindTo": "Resources.Strings.SectionLabelCaption"},
    						"classes": {
    							"labelClass": ["content__title"]
    						},
    						"layout": {
    							"column": 0,
    							"row": 0,
    							"colSpan": 24,
    							"rowSpan": 1
    						},
    					}
    			   	},
    				{
    					"operation": "insert",
    					"parentName": "SectionCaptionCustomerContainer",
    					"name": "PortalSearchText",
    					"propertyName": "items",
    					"values": {
    						"bindTo": "SearchText",
    						"contentType": this.Terrasoft.ContentType.SHORT_TEXT,
    						"caption": {
    								"bindTo": "Resources.Strings.ITXSearchTextPlaceholder"
    							},
    						"labelConfig": {
    							"visible": false
    						},				
    						"layout": { "column": 0, "row": 2, "colSpan": 10, "rowSpan": 1 },
    						"controlConfig": {
    							"placeholder": {
    								"bindTo": "Resources.Strings.ITXSearchTextPlaceholder"
    							},
    						},
    						hasClearIcon: true,
    						clearIconClasses: ["clear-button-style"],
    						"cleariconclick": "$clearSearch",
    					}
    				},
    				{
    					"operation": "insert",
    					"name": "GetOrgButton",
    					"values": {
    						"id": "GetOrgButton",
    						"itemType": 5,
    						"style": "transparent",
    						"classes": {
    							"wrapperClass": [
    								"get-service-button"
    							]
    						},
    						"imageConfig": {
    							"bindTo": "Resources.Images.FindButtonImage"
    						},
    						"visible": true,
    						"selectors": {
    							"wrapEl": "#GetOrgButton"
    						},
    						"enabled": true,
    						"layout": {
    							"colSpan": 0,
    							"rowSpan": 1,
    							"column": 10,
    							"row": 2,
    						}
    					},
    					"parentName": "SectionCaptionCustomerContainer",
    					"propertyName": "items",
    					"index": 3
    				},
    			{"operation": "insert",
    				"name": "GridDataContainer",
    				"parentName": "DataGrid",
    				"propertyName": "items",
    				"values": {	
    					"itemType": Terrasoft.ViewItemType.CONTAINER,
    					//"className": "Terrasoft.AlignableContainer",
    					"classes": {"wrappClass": ["tile-border"]},
    					"visible": true,
    					"items": []	
    				},
    				"index": 0
    			},
    			{"operation": "insert",
    				"name": "GeneralTabTile",
    				"parentName": "GridDataContainer",
    				"propertyName": "items",
    				"values": {
    					"itemType": 5,
    					"imageConfig": {
    							"bindTo": "Resources.Images.ContactButtonImage"
    						},
    					"visible": true,
    					"caption": {bindTo: "Resources.Strings.TileLabelCaption"},
    					"enabled": true,
    						"layout": {
    							"colSpan": 1,
    							"rowSpan": 1,
    							"column": 10,
    							"row": 2,
    						},
    					"items": []
    				},
    			 "index": 0
    			},
    ]/**SCHEMA_DIFF*/,
    	methods: {
    			getTabsContainerVisible: function() {
    					return !(this.get("TabsCollection").isEmpty());
    				},

 

Is there any way to add a border to the "GridDataContainer". The CSS style still not working?

 

Any help is appreciated.

Thank you.

Like 0

Like

3 comments

Hello,

 

If the task is to move the "Contact section" element to the "General" tab, for example, then you need to specify the GeneralInfoTab element as a parent element for the SectionCaptionCustomerContainer. This will automatically move the "Contact section" to the "General" tab.

 

Best regards,

Oscar

Hello Oscar,

 

Thank you for your response.

 

I added the GeneralInfoTab element as a parent element for the SectionCaptionCustomerContainer and even for the GridDataContainer but it didn't work in both cases.

 

Do you have any other recommendations please ?

 

Best regards,

Mouna.

Mouna RACHIDI,

 

Hi,

 

I've used your code locally and was able to move the GridDataContainer by specifying the GeneralInfoTab as a parent for the below element:

{
				"operation": "insert",
				"name": "GridDataContainer",
				"parentName": "GeneralInfoTab",
				"propertyName": "items",
				"values": {	
					"itemType": Terrasoft.ViewItemType.CONTAINER,
					//"className": "Terrasoft.AlignableContainer",
					"classes": {"wrappClass": ["tile-border"]},
					"visible": true,
					"items": []	
				},
				"index": 0
			},

As a result the GeneralTabTile element was also moved to the General tab since its parent (GridDataContainer) was moved to the GeneralInfoTab.

 

Best regards,

Oscar

Show all comments

Hi everyone,

 

Does anyone know if is is possible to set up a field value in business rules by combining 2 strings? For example change the title to something like "Account name - Customer need"? Hope this is achievable without programming as this is really a basic "no code" functionality...

 

 

Thanks!

Like 0

Like

1 comments

A business rule isn't able to do this. 

You could do it with a no code approach by creating a process that starts on the record added or modified that reads the record, then sets the field value by combining the two values. The down side to this approach is that the user won't see this value until they refresh the page.

I realize you're after a no code approach, however, if you want to do this with code, you can add something like this to the methods of the page - this will set the name when the record is saved (assuming the field names are correct):

save: function() {
    var account = this.get("Account");
    var need = this.get("LeadType");
 
    if (account && need) {
        this.set("Name", account.displayValue + " - " + need.displayValue);
    }
 
    this.callParent(arguments);
}

(btw, I don't know why formatted code doesn't format code correctly on these forums, but the && is supposed to be &&)

Ryan

Show all comments

Hi, 

 

When trying to run a  sql query in clio against a Creatio cloud environment I'm getting this eror:

 

System.Net.WebException: The remote server returned an error: (404) Not Found.

   at System.Net.HttpWebRequest.GetResponse()

   at Creatio.Client.ATFWebRequestExtension.GetServiceResponse(HttpWebRequest request)

   at Creatio.Client.CreatioClient.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

   at Clio.Common.CreatioClientAdapter.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

   at Clio.Common.SqlScriptExecutor.Execute(String sql, IApplicationClient applicationClient, EnvironmentSettings settings)

   at Clio.Command.SqlScriptCommand.SqlScriptCommand.Execute(ExecuteSqlScriptOptions opts)

 

Any thoughts?

 

Like 0

Like

1 comments

Hi,

 

It's impossible to determine the reason without reviewing the logs. You need to try running the same command using a local copy of the app hosted in cloud, get the error message and review the application logs. Also sine this is a PostgreSQL command review the command itself and check if all tables and columns in the query are double-quoted and the register is correct.

 

Best regards,

Oscar

Show all comments

Hi Community,

 

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

 

Best Regards,

Pedro Pinheiro

Like 0

Like

1 comments
Best reply

Hello Pedro,

 

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Hello Pedro,

 

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Show all comments

Hi Team ,

 

I'm looking for a solution for a scenario where a user double clicks on the record of a detail with column setup as list view, the record of the connected section should open instead of that detail record page.

 

Please help me achieve this.

 

Many Thanks,

 

Sarika

Like 0

Like

2 comments
Best reply

Hi Sarika,

To do this would would add some code to the detail to change what happens when the row is double clicked. First, add the NetworkUtilities to the modules list at the top of the detail schema, something like this:

define("UsrMyDetail", ["NetworkUtilities"], function(NetworkUtilities) {

Something like this:

editRecord: function(primaryColumnValue) {
    var row = this.getActiveRow(),
        entity = row.get("UsrMyEntityColumn");
 
    if (Ext.isEmpty(entity)) {
        return;
    }
 
    var hash = NetworkUtilities.getEntityUrl("UsrMyEntityName", entity.value);
    this.sandbox.publish("PushHistoryState", {hash: hash});    
}

Ryan

Hi Sarika,

To do this would would add some code to the detail to change what happens when the row is double clicked. First, add the NetworkUtilities to the modules list at the top of the detail schema, something like this:

define("UsrMyDetail", ["NetworkUtilities"], function(NetworkUtilities) {

Something like this:

editRecord: function(primaryColumnValue) {
    var row = this.getActiveRow(),
        entity = row.get("UsrMyEntityColumn");
 
    if (Ext.isEmpty(entity)) {
        return;
    }
 
    var hash = NetworkUtilities.getEntityUrl("UsrMyEntityName", entity.value);
    this.sandbox.publish("PushHistoryState", {hash: hash});    
}

Ryan

Hi Ryan,

 

Thanks for the solution, I tried the below given code and it is working as expected. 

 

 

Best Regards,

 

Sarika 

 

 

 

 

Show all comments