Hello Jeffrey,

Hope you're doing well.

No, it's not necessary to populate the Account field. It seems you didn't set the field mapping correctly, so the Contact wasn't added as expected. Please try to import the Activity records using the mapping settings. For example:

configure the column values in the Excel file:

choose the Activity object as a target object:

match the needed columns:

and perform the import (using or noty using the duplicate checking, it depends on your business task).

As a result, the needed record was imported and it's also viewable from the connected contact:

Also you can find more information and examples of import/export in the articles below:

• https://academy.creatio.com/docs/user/platform_basics/business_data/exc…
• https://academy.creatio.com/docs/user/setup_and_administration/user_and…
• https://academy.creatio.com/docs/user/platform_basics/business_data/exc…

Best regards,

Roman

+1 on this idea , including custom ficsal quarters, maybe to set at system level ?

Hello,

Unfortunately, this logic is deeply integrated in the code and to change it correctly you would need to rewrite a lot of it.

We do not recommend doing it since it might break much of the base functionality. 

Best regards,

Max.

Max,

quite disappointing, being a OOTB functionnality in a couple other major CRMs ...  hope you change your mind in further updates!



KR,



Damien

Really surprised that this is not included. This is pretty much mandatory functionality for any business that wants to use the dashboards. 

We have the same issue at my company: We need to review fiscal quarters, not calendar quarters. It is a management nightmare to change hundreds of widgets on multiple dashboards to custom dates, 4 times a year! 

Have the product dev team revisited this feature? This is a very useful and widely wanted feature.

rob dobbs,

Unfortunately, we do not have the opportunity to customize those filters because the realization of this functionality is in the core code base.

The new behavior will be implemented in future releases with 8.x new filters.

As a workaround, I suggest adding a column in which you will set or calculate the fiscal quarter by business process and another column for the fiscal year and filter based on these columns. However, it is a complicated solution and requires adding those columns to every object that needs this filtration.

If you want to remove it completely:

1) Make sure your package has Samarasoft.SqlConsole as a dependency (or add this in Custom package)

2) Create a replacing view model and select parent "SystemDesigner"

3) Add this code:

define("SystemDesigner", [], function() {
	return {
		diff: [
			{
				"operation": "remove",
				"name": "SqlConsoleLink"
			}
		]
	};
});

If you want to only show it for the Supervisor user, do steps 1 & 2 above, but use this code instead:

define("SystemDesigner", [], function() {
	return {
		attributes: {
			"IsSqlConsoleVisible": {
				dataValueType: Terrasoft.DataValueType.BOOLEAN
			}
		},
		methods: {
			init: function() {
				this.callParent(arguments);
				this.set("IsSqlConsoleVisible", 
					Terrasoft.SysValue.CURRENT_USER_CONTACT.displayValue === "Supervisor"
				);
			}
		},
		diff: [
			{
				"operation": "merge",
				"name": "SqlConsoleLink",
				"values": {
					"visible": { "bindTo": "IsSqlConsoleVisible" }
				}
			}
		]
	};
});

Ryan

Hello Shivani,

Basically we don't have such functionality in our system. Alternatively, you can read the body of the letter that arrived (if it is available in the process) and, through the parameters, throw it into a new letter. It's essentially just working with parameters. 

Please also note that our core R&D department has a suggestion registered on their side to make possible send an email in single thread via business process in further releases. 

Thanks for the great idea!

Regards, 

Bogdan L.

Hello Mary, 



Unfortunately, there is no such functionality in our system due to the basic logic of the marketing emails. Please find more information here. 



Thank you!



Best regards,

Bogdan

OK, then is there a white paper or something that recommends how to attach emails sent from a 3rd party marketing mail platform to my creatio contacts?

Hello Shivani,



Unfortunately, it is impossible to implement your business task, as for now.



But we have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.  



Best regards,

Bogdan

Bogdan,

Thank you Bogan. I was wondering if this could be replicated using OOTB Case feedback process which sends the satisfaction smilies. If we tried tot replicate this, would we require a SysPortal user license??

Hi Amritha, 



Such scenario works properly on newer OOB version of the application. 

Please check if there are any errors in the developers console when opening the page. 

I'd recommend you to update the application to the newest version. 

If the issue persists or the update is not an option for you please contact us at  support@creatio.com and provide us with access/ copy of the DB. 



Best regards,

Yurii

Dear Nicolas,

Unfortunately, we do not have the base tools to achieve the described business task.



Best Regards,

Ivanna.

Hello Javier,

Hope you're doing well.

It seems at the moment the only way to solve your business task is to create a separate SQL script that will transfer the required data:

• https://community.creatio.com/questions/binding-base-system-setting-val…

Additionally, in general, there is a general recommendation not to consider the meaning of base values, but to add new ones to the reference and bind them to a custom package. This approach simplifies the transfer of data between environments and helps avoid the hassle after an upgrade or, for example, after re-installing the data bindings in the environment.

Best regards,

Roman

Hi Roman, 

The problem is that I can't bind the default columns of an OOB section, and that is something that I can't create a new record to fix it. 

There should be a easy way to bind configuration of the section grid, R&D should take a look at that. 

Best regards, 

Javier

Hello Javier,

Thank you for your reply. I will create a suggestion for our R&D team so they could implement the logic of binding system settings values and OOTB lookup values that are already bound to base packages in the next application releases.

Thank you for finding such a system behavior and helping us in making the application better!

Best regards,

Roman

It means that you are not authenticated properly in the application (see location part  "/Login/NuiLogin.aspx?ReturnUrl=%2f0%2fodata%2fAccount", you were redirected to the login page). You need to check all the cookies that are passed to the OData request that you send and compare it with cookies you get in Postman + perform more tests to see which cookie set will result in a successful call.

Oscar Dylan,

If the authentication error, it should be 401 or 403 status. But here it is always redirect to login page with 302. verified the headers from Postman and client app both, those are identical. 

Anusha,

That is correct - the resource was found, but you need to authenticate first (once again, pay attention to the location path /Login/NuiLogin.aspx?ReturnUrl=%2f0%2fodata%2fAccount). The system automatically redirected you to the login location.

 In Postman you receive 200 OK to the request, but before it you receive 302 response (can check in the Postman console):

Hi Oscar,

Thank you very much for the information, but still I'm confused authentication approach. This is what I'm doing.

When I get 302 for Contact endpoint, then I perform the authentication to  auth endpoint  POST call <Creation-app-host>/ServiceModel/AuthService.svc/Login with the body [1]. Then I see cookies details in the response with BPMCSRF cookie with 200 response.  Then I send again the Contact endpoint with those auth cookies, [2]  are the headers which I send to Contact endpoint again. But still same 302 redirection is there even after successful authentication. 

Could you please help me on this.

--- does the above approach wrong

--- does the auth headers wrong mentioned in [2]

If above approach wrong, please help me to find request format from the client application to complete the successful Contact create through the  client.

[1] body

{

   "UserName":"xxxxxxxxx",

   "UserPassword":"xxxxxxx"

}

[2] . Headers

Accept: application/json;odata=verbose[\r][\n]"

"BPMCSRF: cvHrL0GEHYdswl1QZh8Ie.[\r][\n]"

"ForceUseSession: true[\r][\n]"

"Set-Cookie: .ASPXAUTH=F82E.... "

"Set-Cookie: BPMCSRF=cvHrL0GEHYdswl1QZh8Ie."

"Set-Cookie: BPMLOADER=zchmt5tlzildsx22zlle1wnk"

"Set-Cookie: UserName=93|117|112|101|114|118|105|115|101|114"

"Content-Type: application/json; charset=utf-8[\r][\n]"

"Content-Length: 228[\r][\n]"

"Host: 103594-crm-bundle.creatio.com[\r][\n]"

"Connection: Keep-Alive[\r][\n]"

"User-Agent: Synapse-PT-HttpComponents-NIO"

Hi Anusha,

Unfortunately you have to run test and find a way to pass the cookies to the request properly in terms of your integration. For example I have this cookie header in Postman:

BPMSESSIONID=xjjysy25na5ig5sqbgdyxd14; visid_incap_2180455=49BJJNmNT1uK2vo4spt1YM3yQWEAAAAAQUIPAAAAAAB7xEOk/CkixDKkf1pVpwRW; .ASPXAUTH=0129CAB95F4B3C753B6B00E3BBC7F15E9F0CF094A9209DCC541E033D963163699488F8A6AF3F3F845BABCA582CE603AD00E4AC3EE005216347F4B399235033BF60A3338158451099DEC44FE8B1920F57398E4439EE170B436C75FF3BA3BFC2C28BF8BCCB6D37261D9942F97133800DFEED491B8C8671824183CF9CD2CC20549B5BF672599D3F9CAD151E6F4C92A95C7FC888E4214039842D8B53E540D03495542D8C60B238BA9759FFAE27920E7688D35C92795D59741A8D0E5B34234C6DCC769F79A176BF63CCA190D0BEC19A8ACF3793A6522866BF14A14092474BBA68D100282CE8CB6DAB3C8041DB7544EABD759617446687311CE784129E88BE2558CE2917C790372F214D6E8D05B630B789F0D37E4EBB60E06A6B0C20FE075ED78960211A017F115D32F53B2D76E9B2AF302EC3887E47FE421CA76D246B0FCD8260B25380BED735F19C87C0545187841709C5A75B5547CDF43D52304C9D4760C8E625F7DA674A74; BPMCSRF=ulHtF40aiiRNzRWk5BMTWO; BPMLOADER=mnbxfikelfxqnnl2iz0aiobd; BPMSESSIONID=xjjysy25na5ig5sqbgdyxd14; UserName=83|117|112|101|114|118|105|115|111|114

And I guess all of them should be also passed to your request. This is not something that can be solved on the community, you need to test your integration authentication to find a correct way.

Also check if your authentication in terms of your integration is configured in the similar way to the one explained here.

Hi Oscar,

Thanks for the information. I will check further.

Thanks & Best Regards

Anusha