Hi Team,



We are testing the Feedback emails in an on premises for one of our client.

When the case will be created and resolved by call center team with internal network URL and once the case is resolved customer gets a feedback email on resolution of the case. So the customer will provide ratings outside the client network with a public URL which is mentioned in Website URL system settings.

But still the email is generated and sent to customer through client's internal URL only.

What would be the issue or any inputs to perform?



Thank you.

Akshaya B M

Like 0

Like

3 comments

Hello Akshaya,

 

Please elaborate on this part of your message:

"So the customer will provide ratings outside the client network with a public URL which is mentioned in Website URL system settings. But still the email is generated and sent to customer through client's internal URL only."

Does it mean that the client wants to send the feedback links to some external resource?

 

Regards,

Mira

Mira Dmitruk,

 

Hi Mira,



Yes, The client has private network where the on-site server is there.

We are facing issue when a customer needs to give feedback outside of the client servers network.



Regards,

Akshaya B M

Hello Akshaya,

 

Here is the instruction on how to achieve your goal:

1. You need to set up a proxy server on the Internet gateway or another computer that is accessible via Internet and has access to the internet creatio server.

2. Configure the proxy server in reverse-proxy mode. Configure proxypass for the addresses such as http (s): //dns_external_interface_name/0/ServiceModel/CaseRatingManagementService.svc/* to the internal Creatio server (select http or https) keeping the relative address.

3. If https is used, configure the certificates corresponding to the external address

4. Fill in the setting with the PortalSiteURL code with the address http(s)://dns_name_external_interface/0 (select http or https)

5. Test it

 

However, there's also an easier way to set everything up for you, which is to simply open access to

http(s)://your_website/0/ServiceModel/CaseRatingManagementService.svc/

 

Regards,

Mira

Show all comments
Question

Hi community!

 

I need to insert feeds in Cases through database, please help me to find out the relations between tables.

I have found that feed is stored in "SocialMessage". How is it related to "Case", which tables must be updated ?

What are "EntityShemaUid", "EntityId" in "SocialMessage" table?

 

Best regards,

Jana

Like 0

Like

2 comments
Best reply

Hello Jana!

 

EntityShemaUid - this is the ID of Section, where the feed is stored

 

EntityId - this is the ID of particular record in Section

 

In order to insert feeds in Cases through database, please find the Uid of Case section:

 

SELECT Name, Uid from SysSchema

 

Then insert needed info and specify values for these columns in the INSERT query.

 

Best Regards, 

 

Bogdan L.

 

 

Hello Jana!

 

EntityShemaUid - this is the ID of Section, where the feed is stored

 

EntityId - this is the ID of particular record in Section

 

In order to insert feeds in Cases through database, please find the Uid of Case section:

 

SELECT Name, Uid from SysSchema

 

Then insert needed info and specify values for these columns in the INSERT query.

 

Best Regards, 

 

Bogdan L.

 

 

Bogdan, thank u smiley

 

Show all comments