How to Change Notification Template for Active Process


#1

I have an Active process with several email template files and I’d like to tweak their formatting a little, just adding a Lbs for a pounds data and such, but I can’t edit the entry because the process is Active. I also can’t move it to test because there are active requests. I assume the file is stored somewhere, can I change it manually?


#2

Hello Ryan,

It’s possible, but you need to be careful with modification.
By the past we needed to modify email template.

We used the following procedure :

  1. On workflowgen database execute this request

    SELECT TOP 1
    [DATA_VALUE_FILE_NAME]
    FROM [dbo].[VIEW_PUB_REQ_FILE_V100]
    WHERE DATA_NAME = ‘?’ And PROCESS_ID = ?
    ORDER BY REQUEST_DATE_U DATE desc

  2. Get value returned
    image

  3. Find the file in your server, path could be like this : “\YOUR_SERVER\DISK\WorkflowGen\wfgen\App_Data\Files\DataSet\design\2018\02\19\99467-1.html”
    image

  4. Update the file and save, it could be usefull to set a save file before

  5. After this, check on your process data if the data has been updated

I hope this can help you :slight_smile: