How to customize text within notification or reminder e-mail?

[jpa]

I am evaluating MS Project Server 2003.
I wrote a project sample and activated automatic notification and reminder
e-mail sending.
Indeed I received some e-mail as for instance:
===========================================================
The following tasks are scheduled to start soon.Project:
MyProject----------------------------------------------------------------------Task
Name: t8 Start: Jun 15 '07 Finish: Jun 21 '07 Work:
35h Rem Work: 35h
----------------------------------------------------------------------To view
and respond to the changes, please connect to your Project Web Access
timesheet at
http://MyServer/Sample/Tasks/Taskspage.asp?AllTasks=1&FilterBy=0&GanttView=0.The
following tasks are scheduled to finish soon.Project:
MyProject----------------------------------------------------------------------Task
Name: t7 Start: Jun 8 '07 Finish: Jun 15 '07 Work:
35h Rem Work: 35h
----------------------------------------------------------------------To view
and respond to the changes, please connect to your Project Web Access
timesheet at
http://MyServer/Sample/Tasks/Taskspage.asp?AllTasks=1&FilterBy=0&GanttView=0.To turn off these e-mail remind
===========================================================
As you can see look&feel is not very sexy!
Thus I'd like to MODIFY/CUSTOMIZE above e-mail text.
How to do that?

Thanks in advance
jpa

 

[Dale Howard [MVP]]

jpa --

Refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/CustomizeEmailMessages.htm

Hope this helps.

 

[jpa]

Hi Dale,

Thanks for your reply.
From the FAQ it is not clear for me where I need to go to modify
notification text content (I don't want to create any new notification but
just customize text content):
- do I need to edit some tables?
- If so which ones and how to edit them?

thanks again for your help
jpa

 

[Dale Howard [MVP]]

jpa --

I'm not a software developer, but you need to begin by downloading the
projsvremail.exe file containing the ASP pages. Did you do that? If so and
you still don't understand, you might want to repost your question in the
microsoft.public.project.developer newsgroup. Hope this helps.

 

[jpa]

Hi Dale,

Yes I dowloaded projsvremail.exe file containing the ASP pages.
The 2 ASP files actually don't deal with customizing any "notification text
content" I am interested in.
So still no idea how to solve my problem.

Any additional input is welcome
Thanks for your collaboration
Regards
jpa

 

[Brian Tkatch]

I am evaluating MS Project Server 2003.
I wrote a project sample and activated automatic notification and reminder
e-mail sending.
Indeed I received some e-mail as for instance:
===========================================================
The following tasks are scheduled to start soon.Project:
MyProject----------------------------------------------------------------------Task
Name: t8 Start: Jun 15 '07 Finish: Jun 21 '07 Work:
35h Rem Work: 35h
----------------------------------------------------------------------To view
and respond to the changes, please connect to your Project Web Access
timesheet at
http://MyServer/Sample/Tasks/Taskspage.asp?AllTasks=1&FilterBy=0&GanttView=0.The
following tasks are scheduled to finish soon.Project:
MyProject----------------------------------------------------------------------Task
Name: t7 Start: Jun 8 '07 Finish: Jun 15 '07 Work:
35h Rem Work: 35h
----------------------------------------------------------------------To view
and respond to the changes, please connect to your Project Web Access
timesheet at
http://MyServer/Sample/Tasks/Taskspage.asp?AllTasks=1&FilterBy=0&GanttView=0.To turn off these e-mail remind
===========================================================
As you can see look&feel is not very sexy!
Thus I'd like to MODIFY/CUSTOMIZE above e-mail text.
How to do that?

Thanks in advance
jpa

jpa, we are trying to do the same thing. Perhaps we should keep in
contact.

I will share what in know so far.

There are two separate parts of the email that can be customized.

1) Added text.
2) The actual text with inserted data.

1) Added text is supported within Project itself. Using the menu,
Collaborate=>Publish=>New And Changed Assignments there is a button
next to the "Notify all affected resources via email" checkbox that
says "Edit message text...". Clicking the button showing a dialog box
with an edittable text box stating "Below are the latest schedule
changes. Contact your project manager if there are any problems with
the changes.". That text is changeable for the email.

2) I will predicate this by saying i am not qualified, YMMV, and when
i initially tried this i destroyed the database. I had to request a
backup restored on the dev box.

The actual text with the data is kept in a TABLE in the database.

First come pre-defined events. These can be seen with the following
query:

SELECT
WNTFY_EVENT_ID,
WNTFY_EVENT_QUERY Query,
(SELECT CONV_STRING
FROM MSP_WEB_CONVERSIONS
WHERE CONV_VALUE = WNTFY_EMAIL_SUBJECT) Subject,
(SELECT CONV_STRING
FROM MSP_WEB_CONVERSIONS
WHERE CONV_VALUE = WNTFY_EMAIL_TITLE) Title,
(SELECT CONV_STRING
FROM MSP_WEB_CONVERSIONS
WHERE CONV_VALUE = WNTFY_EMAIL_CONTENT) Content,
(SELECT CONV_STRING
FROM MSP_WEB_CONVERSIONS
WHERE CONV_VALUE = WNTFY_EMAIL_TAIL1) Tail1,
(SELECT CONV_STRING
FROM MSP_WEB_CONVERSIONS
WHERE CONV_VALUE = WNTFY_EMAIL_TAIL2) Tail2,
WNTFY_EVENT_DESC [Description]
FROM
MSP_WEB_NOTIFICATION_EVENTS
WHERE
WNTFY_EMAIL_CONTENT IN (1,4)

The MSP_WEB_NOTIFICATION_EVENTS stores events, and what is done in the
event. CONV_VALUE is the usual text-to-string conversion table (used
because it supports multiple languages so *technically* the
sub-queries should include AND Lang_Id = 1033 (for US English or
whatever)).

WNTFY_EVENT_ID is the PK, this gets put into the other TABLE for the
notification to be sent out. I have no idea why i put
"WNTFY_EMAIL_CONTENT IN (1,4)" in there, i wrote this query a while
ago. The rest should be self-evident.

For a fuller view, see MSP_WEB_NOTIFICATIONS for the notifications
that were/will be sent (?) and of course MSP_WEB_RESOURCES to make
those resource ids get names.

When i tried messing with things like:

UPDATE
MSP_WEB_NOTIFICATION_EVENTS
SET
WNTFY_EVENT_QUERY = 'select TASK_NAME, ASSN_START_DATE,
ASSN_FINISH_DATE, ASSN_WORK, ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS
where WASSN_ID in (^0) order by ASSN_START_DATE'
WHERE
WNTFY_EVENT_ID = 1001

UPDATE
MSP_WEB_CONVERSIONS
SET
CONV_STRING = '\nProject: ^1\nAssign to:
^3\n----------------------------------------------------------------------@@[\nTask
Name: ]TASK_NAME<21>{30}[\n],[Start: ]ASSN_START_DATE<4>{12},[Finish:
]ASSN_FINISH_DATE<4>{12},[Work: ]ASSN_WORK<8>{8},[Rem Work:
]ASSN_REM_WORK<8'
WHERE
CONV_VALUE = 1

UPDATE
MSP_WEB_CONVERSIONS
SET
CONV_STRING = '\nProject: ^1\nAssign to:
^3\n\n^6\n\n----------------------------------------------------------------------@@[\nTask
Name: ]TASK_NAME<21>{30}[\n],[Start: ]ASSN_START_DATE<4>{12},[Finish:
]ASSN_FINISH_DATE<4>{12},[Work: ]ASSN_WORK<8>{8},[Rem Work:
]ASSN_REM_WORK<8'
WHERE
CONV_VALUE = 1

the database became corrupted. I asked for a restore, and haven't
really tried anything since. I'm not quite sure qhat i did wrong.
Maybe it didn't like the UPDATE, or perhaps it was unrelated to this.
Though, i do have to get back to this soon, i just have other things
to work on right now.

Perhaps you want to try your hand. Please let me know what you find.
We can converse here or in private email.

B.