Hi Team,

 

I have been facing an error while updating the package from SVN.
It throws an error stating Schema with Unique identifier is not found.

 

Kindly guide me to resolve this issue.

Best regards,

Bhoobalan P.

Like 0

Like

1 comments

Hi Bhoobalan,

 

Please check the application logs at the moment of the issue reproduce for additional details on the error message. Additionally try generating the source code for all schemas and compiling the app in configurations before updating the package from SVN. Also this error message can state that there is a process or some logic in the package that uses the column that was deleted from some object. Try searching anything in the system using the query:

 

set nocount on
declare @name varchar(128), @substr nvarchar(4000), @column varchar(128)
declare @sql nvarchar(max),
  @newval nvarchar(max)
 
set @substr = N'BC2E7A0A-2B9E-4A10-BE73-B2FF59752ABF' --INPUT THE ID HERE
set @sql =  N''
set @newval = @substr
 
create table #rslt 
(table_name varchar(128), field_name varchar(128), value nvarchar(max))
 
declare s cursor fast_forward for select table_name from information_schema.tables where table_type = 'BASE TABLE' order by table_name
open s
fetch next from s into @name
while @@fetch_status = 0
begin
 declare c cursor fast_forward for 
 select quotename(column_name) as column_name from information_schema.columns 
   where data_type in ('text', 'ntext', 'varchar', 'char', 'nvarchar', 'char', 'sysname','uniqueidentifier') and table_name  = @name
 set @name = quotename(@name)
 open c
 fetch next from c into @column
 while @@fetch_status = 0
 begin
--   print 'Processing table - ' + @name + ', column - ' + @column
   exec('insert into #rslt select ''' + @name + ''' as Table_name, ''' + @column + ''', ' + @column + 
 ' from' + @name + ' where ' + @column + ' like ''' + @substr + '''')
   fetch next from c into @column
 end
 close c
 deallocate c
 fetch next from s into @name
end
 
select table_name as [Table Name], field_name as [Field Name], count(*) as [Found Matches] from #rslt
group by table_name, field_name
order by table_name, field_name
 
select * from #rslt order by table_name, field_name
 
drop table #rslt
close S
deallocate S

 

And check what does this query return.

 

Best regards,

Oscar

Show all comments

Hi Team,

I need to stop the contact creation when a new case is created from the landing page.
 

The below article helps in creating a case from the landing page.

https://academy.creatio.com/docs/developer/elements_and_components/marketing_campaigns/web-to-case#case-1964

But at the same time I need to create only case and prevent from creating contact.
Any insight on this would be helpful!

Regards,
Bhoobalan P.

Like 0

Like

3 comments

Hello,

 

It is not possible to disable contact creation. However, you can setup autofill of landing page fields that will help to avoid he duplicate contact records creation 

 

https://academy.creatio.com/docs/user/crm_tools/landing_pages_and_web_f…

 

Regards,

Dean

dean parrett,

 

Thanks for the response!

When the same case is created through email the following business process is triggered "Incoming email registration processwhere only the case got created (No contact creation).

What runs to create a Case in Creatio CRM site via the Landing page? and What triggers to create a contact when a case is created?

Regrads,

Bhoobalan Palanivelu.

Hello,

This logic is hardcoded and cannot be disabled without changing the records creation from web forms. It doesn't have anything in common with cases creation from emails. The above article is the solution to any web forms that may create duplicate records.

 

Regards,

Dean

Show all comments

Hi,

 

I have a field Remider2 on the Activity [General information Tab].Based on the reminder2  value i need to send the reminder to the owner.

i have referred article in academy ,but couldn't follow the approach

https://academy.creatio.com/docs/developer/front-end_development/333/34…

 

Could someone help me with the  custom reminder in detailed.

 

Thankyou in advance!!!

 

 

Like 0

Like

1 comments

Hello Indira,

 

Do you have any particular place in the instruction that doesn't work for you or probably you can post the error you receive?

 

Best regards,

Bogdan

Show all comments

Hi ,

 

I have bound the data for Sysadministration unit,Activity category lookup.

when i push my code to dev environment,iam able to see the data in bound data

,but it is not showing up in display data.

 

Could somebody help me with this.

 

Thanks in advance.

Like 0

Like

3 comments

Dear Indira,

 

Check installation logs - this data is installed via SQL queries, there could be some error in the script or in the data installation. Also, check if it is present in the database. 

 

Best regards,
Angela

Angela Reyes,

Hi Angela,

 

Thankyou for the reply,

I have checked the installation logs and couldn't find any issues ,the data is installed sucessfully,i couldn't see the data in database though.

if could you  elaborate the approach,that would be very helpful.

Hi Indira,

 

Could you please send us your package to support@creatio.com and refer to this community question so we will be able to test it at our end?

 

Regards,

Anastasiia

Show all comments

I am getting a 404 error while creating a new "Workplace".

https://localhost/0/rest/SectionService/GetSectionTypes

Do you have any idea how to fix the issue?

 

Note : I have installed/enabled "WCF Services" and "ASP .NET 4.7" for my local PC bundle sucessfully.

 

Like 0

Like

3 comments

Hello Nagaraju,

Could you please tell us what is the version of your instance?

Thank you.

Bohdan Zdor,

17.4.1.935

 

Nagaraju,

 

To fix it you should check the next strings in the internal web.config file which is stored in Terrasoft.WebApp folder:
 

<add key="FeatureLoadPackagesBinAssembliesOnAppStart" value="true" />
   <add key="EnableRegisterServicesFromRefAssemblies" value="true" />
    <add key="EnableRegisterEntityEventsFromRefAssemblies" value="true" />
    <add key="EnableRegisterDIBindingsFromRefAssemblies" value="true" />

After you edit the web.config file, please go to the path 

Terrasoft.WebApp\Terrasoft.Configuration\Pkg\SspWorkplace\Files\Bin
and replace the file SspWorkplace.dll with the attached one.
Also, go to the path Terrasoft.WebApp\Terrasoft.Configuration\Pkg\Workplace\Files\Bin

and replace the file Workplace.dll with the attached one.

You can find files here 

https://we.tl/t-g5yUFylmCT

 

Thank you.
 

Show all comments

Hi,

I need one clarity.

When the user clicks on the emojis in feedback email sent to customer, for displaying the "Feedback" page with provision to enter comments and submit, do one portal license need to be given to "SysPortalConnection" user? 

is this a mandatory thing? Any workarounds by not giving the portal license?

 

Thanks

Krishna

Like 0

Like

2 comments

Hello Krishna,

 

Yes, you should distribute a portal license to the SysPortalConnection Creatio portal user to set up the customer satisfaction evaluation. 

 

You can find more detailed instruction on how to configure Customer Satisfaction (CSAT) evaluation in the following Creatio Academy article: https://academy.creatio.com/documents/customer-center/7-15/customer-sat…

 

Please, let us know in case you have any further questions. 

 

Best regards, 
Olga Avis. 

Olga Avis,

Thanks Olga

Show all comments

Can we add columns of an object to be selected in a custom lookup, similar to the data validation lookup? 

For e.g. in one lookup, can I have column Name, object and attribute where object = contact and attribute will have values as the columns in contact object.

Like 0

Like

1 comments

Dear Krishna, 

The mentioned data entry compliance lookup and it's functionality is build upon a few separate objects in "Completeness" package. 
In order to create the same lookup or implement the similar functionality you will have to check objects and pages from this package and create a new object with the same parameters upon which the new lookup will be created. 

Kind regards,
Roman

Show all comments

Hi All,

For an on going project, in the contact centre, when a customer calls and asks for certain specific service requests, few (3 to 5) security questions need to be asked (based on the category and service selected for the case) to validate that the customer himself is calling.

For this, we are having a lookup to keep the pool of questions. Can we have the answers (object and it's columns where the answers are populated) also captured in this lookup? 

For e.g. for question "What is the birth date?", can we record the answer to be checked against Contact (object) > birth date (column) ? 

Like 0

Like

2 comments

Dear Krishna, 

It would be much more convenient to create a separate detail which would contain all questions along with an answers and all needed information. 
By the way, can you please specify for which section you would like to add the described functionality? Cases or any other? 

Kind regards,
Roman
 

Roman Brown,

Thanks Roman for the inputs.

Yes I would like to add the questions connected with cases section.

 

I had created a detail for the same in cases (given below).

Also creating activity connected to cases to prompt agent to ask questions and capture the responses for these questions.

 

Is there anyway these questions can be asked one by one in a UI ?

 

Show all comments