Send Link in Email can cause problem if site URL has – e.g. my-portal.com


I am not sure but once I saw such post few months back explaining this but if you have a – in your moss portal link or dns, your send link in email functionality will not work properly because IE change the – to %2d.  To fix this issue you need to edit core .JS file

Core.js file is placed at

System Drive:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033

Open Core.js in notepad

If you have customized core.js before this search for L_SendToEmail_Text

if you have not customized core.js simply jump to line 3309

image

all you need to do is to encode the url to show – instead of %2d.  unescapeProperly method encodes the URL.

Simple press enter on line 3309

fileUrl = unescapeProperly(fileUrl);

If you wanted to test it add alert before and after fileURL variable.

Save Core.js and Refresh the page.

Go to a document library and using document drop down click Send To -> Send Link in Email

I hope this will solve your problem.

Jerry

Query to Get Project Assignment Time Phased


Project Server 2003 Query to Get Project Assignments as Timephased

SELECT     dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME AS [Task Name], dbo.MSP_WEB_PROJECTS.PROJ_NAME AS Project,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart, dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork / 60000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME
FROM         dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
                      dbo.MSP_WEB_ASSIGNMENTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID AND
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_PROJECTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_RESOURCES ON dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID

 

Note: Please do test this query on local development environment before testing in on production.

Jerry