Juan and Ashok,
Browsing the project server database schema will reveal several tables that are involved in this process.
1) MSP_WEB_NOTIFICATIONS
2) MSP_WEB_NOTIFICATION_EVENTS
3) MSP_WEB_CONVERSIONS
MSP_WEB_NOTIFICATIONS captures the notifications that are active in the system and whom the should go to - i.e. which users.
MSP_WEB_NOTIFICATION_EVENTS contains all the details of each of the notifications that the system performs. In this table you'll see columns that contain lots of numbers - foreign keys to a lookup table that contain the actual text of the notification messages.
MSP_WEB_CONVERSIONS is that table of the actual text that goes in the messages. This table is called MSP_WEB_CONVERSIONS because it's got all the strings used in the web application (a lot of them if not all) in the language that you've selected for your product installation. In other words the strings will have been "converted" if you installed in a language other than English.
You'll see quite a dizzying array of text in here and you need to know how to sort it out. This is where the other tables come in handy. If you look at the "..._EVENTS" table you'll see column names that end with _EMAIL_[something], like title, subject, contents, tail1 and tail2. These are the various pieces of the email messages. If you want to modify the email subject then work with the values in the MSP_WEB_CONVERSIONS table that have corresponding subject records. This same principle holds true for the rest of the columns.
Once you get into these tables and write a couple queries to see how the pieces fit together you should be able to tell pretty easily which records you want to change.
You probably need to respect the token insertions (^1,^2, <20>, {15} etc), field insertions and line ending formats so you don't end up with a mess on your hands after you make your adjustments. I have no idea how all of those work, in any detail anyway. It's plain to see that they are placeholders for data from the database. Mess them up and you could have your hands full really quickly.
Hope that helps.
Here's a query I wrote that shows this.
SELECT DISTINCT
ne.WNTFY_EVENT_ID, t.CONV_STRING AS title, s.CONV_STRING AS subject, c.CONV_STRING AS content, t1.CONV_STRING AS tail1,
t2.CONV_STRING AS tail2
FROM MSP_WEB_CONVERSIONS t1 INNER JOIN
MSP_WEB_CONVERSIONS c INNER JOIN
MSP_WEB_NOTIFICATION_EVENTS ne INNER JOIN
MSP_WEB_CONVERSIONS s ON ne.WNTFY_EMAIL_SUBJECT = s.CONV_VALUE ON c.CONV_VALUE = ne.WNTFY_EMAIL_CONTENT INNER JOIN
MSP_WEB_CONVERSIONS t2 ON ne.WNTFY_EMAIL_TAIL2 = t2.CONV_VALUE ON t1.CONV_VALUE = ne.WNTFY_EMAIL_TAIL1 INNER JOIN
MSP_WEB_CONVERSIONS t ON ne.WNTFY_EMAIL_TITLE = t.CONV_VALUE
Earl
PS - the business logic that controls how this all works in built into the notification service that runs on the project server host. There is no documentation (that I know of - that's publicly available) that details how this service operates so you're on your own with that part of it. Your pretty much limited to changing some of the basic text of the messages.
Hi all:
Does anybody know how to custimize the mails project server sends to
resources.
i.e: adding other fields,
Thanks a lot
