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?
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 :
-
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 -
Get value returned
-
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”
-
Update the file and save, it could be usefull to set a save file before
-
After this, check on your process data if the data has been updated
I hope this can help you