Where are store the CustomerPage (newTicket.html)

Hi,

I don't know where are store the customerpage that I have modified of the server.

Can you tell me where I can find this of the server ?

I'm with SuperOffice 8.

Here my Structur:

RE: Where are store the CustomerPage (newTicket.html)

Inside SO_SERVICE (I am guessing that Service is installed here), there is a folder called "templates". Underneath this folder, there are several folders containing the customer page templates, and you will find a "customer" folder inside each of them.

Inside here again you will find "newTicket.html".
But note that changing that file directly is the old method of doing this. 
If the customization is done through the Service appliaction (the UI), then the changes are stored in the database instead (which overrides whatever is in the files on disk). 

You can see this inside Service:

All marked as "Yes" under modified are modified using the new method. I recommend using the new method anyway to prevent replacing the customer templates after an upgrade.

Av: Stian Andre Olsen 26. sep 2018

RE: Where are store the CustomerPage (newTicket.html)

Hi,

thanks. Can you tell me in which DB Table are the Page stored ?

I want only save the modified .HTML file as backup.

Thanks

Av: Fabrice Reithinger 26. sep 2018

RE: Where are store the CustomerPage (newTicket.html)

Hi Fabrice,

on the server they're stored in the Customer Service\templates\<language>\customer\ folder. Where language is the language you want to edit.

 

In the database, they're stored as a reply template. Which reply template is connected to which page is listed in the registry table. The reg_id starts at 10000. So do a select * from registry where reg_id > 9999 and you'll get them. They'll point to a reply template id, which you can open/copy/whatever.

 

Remember that, unless you have done something to the customer center pages inside the UI, it won't use that reply template, and instead will use the files on the server.

 

Hope this was helpful.

Av: Simen Mostuen Iversen 26. sep 2018

RE: Where are store the CustomerPage (newTicket.html)

Hi,

here on the server they're stored in the Customer Service\templates\<language>\customer\ folder. Where language is the language you want to edit. can I found the original Template.

In the DB to the Register I have yet a value for each template.

What I wish is to have the HTML-Code for my modified CS-Template. 

Where can I found the modified CS-Template in the DB and/or of the Server ?

Av: Fabrice Reithinger 26. sep 2018

RE: Where are store the CustomerPage (newTicket.html)

Hi Fabrice,

the body of an reply_template is stored in table REPLY_TEMPLATE_BODY.

You can access the right body with the reply_template_id from table REPLY_TEMPLATE.

Example:

select id, name from crm7.reply_template where name = 'framework.html'

==> 198

select language_id, body_plain, body_html from crm7.reply_template_body where reply_template_id = 198

==> <the complete code in the corresponding language>

BR

Ulli

Av: Ulrich Klein 26. sep 2018