Moving the Publish File Location

When you create new message templates, DocLink Template Manager publishes them in the location defined in the Configure Message Template Options section. If at any time changes are made that affect this location (server move, share location move, etc.), it will affect all user-created templates. You will need to go into the doclink2 database and modify the entries for these templates. If you require help, please contact DocLink Support: Support@altec-inc.com or 1-800-997-9921.

Example

Step 1: Access the doclink2 database by logging into SQL Server. Look in the MessageTemplates table for entries where dbo.MessageTemplates.SystemTemplate = 0. This will return all templates that have been manually created.

Select * from MessageTemplates where SystemTemplate=0 
        

Step 2: Update the table to reflect the new template file location for all manually created templates. You can use the following example script to perform this task. Change the TemplateFile and TemplateName variables to where your templates are stored.

Update MessageTemplates
set TemplateFile='\\doclinkserver\DLShare\Templates\ICM - 10001.htm'
where TemplateName='ICM' and SystemTemplate=0
        

Also, if your manually created templates have associated stylesheets, the location will need to be updated for those as well. You can reference the Stylesheet column in the MessageTemplates table to verify the existence of one.

If you do not do this, you will receive an error when attempting to open a manually created template in Template Manager.