locked
SharePoint 2007 alert me sent out mail with wrong message RRS feed

  • Question

  • I have created a document library, and this doc library has set alert me. On this doc library, there is field name Category, this is a multiple check box with value like A, B, C, D.

    I uploaded a document Test.doc as sample with Category D, then the new added item alert email was sent out. And problem came out, in the alert email body, the item Text.doc with wrong Category A instead of D.

    I tried another two items again with Category B and C, but all these items with wrong Category A in the alert email body.

    Can any body give help on this? Thank you so much!

    • Moved by Frank Xu Lei Friday, April 8, 2011 9:51 AM Moss (发件人:Windows Azure Forum)
    • Moved by KeFang Chen Monday, April 11, 2011 3:35 AM (From:Microsoft Office SharePoint Server(MOSS))
    Thursday, April 7, 2011 8:52 AM

Answers

  • Hi,

    I did more researches, and the issue is still there.

    The SharePoint alert uses AlterTemplate to render the body of the mail. There are two variables to get value for fields, they are OldValue and NewValue. However, based on my research, whatever the variable is provided, the alert can only get the default value(if default is null, it will render empty too). Only when we change the item(and values for the choice item), the mail will be rendered correctly.

    It might be not a good workaround, but we can exclude the fields in the alert. The end-uses need to click the links in the alert mail to view the item.

    For more information about how to exclude fields in an alert, please see:
    http://msdn.microsoft.com/en-us/library/ff408063.aspx

    Thanks,
    Jinchun Chen


    Jin Chen - MSFT
    Tuesday, April 12, 2011 9:29 AM
    Moderator

All replies

  • Firstly, this is a Chinese SharePoint forum, I am not sure why MVP moved your thread here, I hope Moderator in this forum could move it to correct forum.

    For your issue, please provide more information on your SharePoint edition and version.


    上善若水
    Lambert Qin [秦磊] | 博客(Blog): SharePoint in My Eyes 中文 / LinkedIn
    Posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, April 8, 2011 10:23 AM
  • Hi AlwaysDJ,

    I can reproduce the issue as you mentioned. It seems to be a known issue.

    I would suggest you submitting a feedback at: https://connect.microsoft.com/site428
    Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

    Appreciate your understanding.

    Thanks,
    Jinchun Chen


    Jin Chen - MSFT
    Monday, April 11, 2011 9:07 AM
    Moderator
  • > I can reproduce the issue as you mentioned. It seems to be a known issue.

    > I would suggest you submitting a feedback at: https://connect.microsoft.com/site428

    I don't understand this response.

    If it is a known issue there must be either a solution for it or a KB article or similar stating that it is a known issue - typically then with a suggestion for a workaround.

    Also if it is a known issue there is surely no point in reporting it to Microsoft via the site you specify.

    ----------------------------------------

    Instead let us see if anyone here in the pre-SP 2010 forums has any help to give.

    Moderator pre-SP 2010 forums


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, April 11, 2011 9:21 AM
  • The KB article for Alerts below is not for this issue but may include a possible solution anyway.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;953446

    You will notice that one of the reasons given there was that there was a default value.

    Could you try your scenario without having Category A as the default value?

    Mike Walsh

    P.S. Of course if you don't have a default value then this idea is worthless, but if you have specified a default value then the first option in the list (Category A) is what is chosen if you don't specifically specify something else. So it might be your situation.

     

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, April 11, 2011 10:19 AM
  • Hi,

    I did more researches, and the issue is still there.

    The SharePoint alert uses AlterTemplate to render the body of the mail. There are two variables to get value for fields, they are OldValue and NewValue. However, based on my research, whatever the variable is provided, the alert can only get the default value(if default is null, it will render empty too). Only when we change the item(and values for the choice item), the mail will be rendered correctly.

    It might be not a good workaround, but we can exclude the fields in the alert. The end-uses need to click the links in the alert mail to view the item.

    For more information about how to exclude fields in an alert, please see:
    http://msdn.microsoft.com/en-us/library/ff408063.aspx

    Thanks,
    Jinchun Chen


    Jin Chen - MSFT
    Tuesday, April 12, 2011 9:29 AM
    Moderator
  • Hi, Yes, the issue I met was cause by default value. In fact, the default value is not important for my case, how can I remove the default value from the column definiton? I only can find "Default value" and "Calculate value" in the column setting page. Thanks!
    Wednesday, April 13, 2011 4:27 AM
  • I've done a test and you can specify a Calculated Value that is blank.

    That might be what you need to do.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, April 13, 2011 6:43 AM
  • Hi Mike,

    I have tried as you mentioned, but there is something unexpected result as below.

    1) When you re-enter the column setting page again, the "Default Value" still is "Choice" with blank value instead "Calculated Value".

    2) In the alert email, the relative field (setting as above) is missing in the email body.

    Thanks.

    Wednesday, April 13, 2011 8:32 AM
  • 1. doesn't matter much how it looks if the result is the same.

    2. is logical even if it perhaps isn't what you want.

    So it's really a question as to whether you want possibly a wrong link in the message (but at least now you know you can choose which wrong link - and you can therefore choose the most likely one) or whether you want no link at all (then it's not wrong ...)

    I'm out of suggestions.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, April 13, 2011 10:50 AM
  • Hi Mike, Thank you so much! I got your meaning. But why this still be an issue and not yet fix by SharePoint team.
    • Edited by Mike Walsh FIN Thursday, April 14, 2011 9:50 AM Add you new question in a new thread (also asking why the SP team haven't fixed it is rather pointless)
    Thursday, April 14, 2011 9:43 AM