VERIFIED SOLUTION i

Resolving restore a removed message template in Portrait Dialogue Visual Dialogue?

Issue

By accident a message template is deleted from the Visual Dialogue directory.
The HTML file is still present at the server directory. Is there a solution to restore the message template to the Visual Dialogue (Explorer view) having it present in an instance directory and place it to the exact place in folder structure as it was before?

 

Cause

The data concering message templates are stored in tables in portrait database as follow:

1) Message template ID:
Dialog database >> DOC_BASE_MESSAGE >> DBM_ID

2) Message template name:
Dialog database >> DOC_BASE_MESSAGE >> DBM_NAME

3) Directory where the tample is present
Dialog database >> DOC_BASE_MESSAGE >> DBM_MESSAGE_UNC

4) Name of folders in Visual Dialogue:
Dialog database >> FOLDER

5) The right position in Visual Dialogue Explorer
Dialog database >> FOLDER_OBJECT

Resolution

UPDATED: August 29, 2017
It is not possible to restore deleted message template when a template is removed from Visual Dialogue as valid data and relationships that were present in the database are gone.
When a template is removed then data from the tables mentioned above are gone and there is no way to restore the message template.