locked
SP2007 Doc Info Panel (Person or Group column) and Word 2010 RRS feed

  • Question

  • I have a SharePoint 2007 Document Library with many columns. Some of the columns are of type Person or Group.

    When a user opens the document in the Word 2007 the Person or Group column contains the correct user name, however when the same document is opened in Word 2010 the Person or Group column contains a number (e.g. 39) and not the name.

    Anyone know what is causing this?

    • Moved by Mike Walsh FIN Tuesday, August 23, 2011 11:18 AM not general (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Tuesday, February 15, 2011 5:26 PM

Answers

  • FYI...

    This turns out to be an issue with Office 2010!

    Microsoft issued a hot fix in June: http://support.microsoft.com/kb/2552994

    At least I know I am not going mad!!

     

    • Marked as answer by Mike Walsh FIN Thursday, September 8, 2011 9:57 AM
    Thursday, September 8, 2011 9:31 AM

All replies

  • Hi Sonners,

    It is really a strange problem.

    Do the Person or Groups field a default column like Modified By column or a custom column added by you?

    If it is the default column, please check if it is a display name of a user by clicking the number and see where it will link to. Or go to Central Administration > SharedServices > User Profile and Properties > View user Profiles to check if the number is a name of a user.

    If it is a custom column, could you please elaborate how you get the users name in this field?

    Best regards,
    Emir

    • Marked as answer by Leoyi Sun Thursday, February 24, 2011 9:02 AM
    • Unmarked as answer by Sonners Thursday, February 24, 2011 5:54 PM
    Thursday, February 17, 2011 11:26 AM
  • This is a custom column of type Person or Group.

    The same column contents looks different depending on whether the user is viewing it in Word 2007 or Word 2010.

    In Word 2007 it displays the correct name Firstname Lastname.

    In Word 2010 it displays a number underlined with a red wiggly line. This happens quite often but not all the time.

    The User Profiles are set up correctly in CA, and have been used without any issues for >2 years. This issue has only appeared since Word 2010 was introduced to the office.

    Thursday, February 24, 2011 5:54 PM
  • This is still an issue and is becoming a real problem as more people are adopting MSOffice 2010.

    The people picker is still resolving itself as a number. It doesn't appear to be a problem with other site collections.

    Friday, May 20, 2011 10:59 AM
  • I still have not resolved this and it is now happening with Office 2007 users.

    I think I may have to recreate the whole site collection!

    Monday, June 27, 2011 8:07 PM
  • Rebuilding it won't do anything, it's an issue with data types and what you're submitting back the Document Library

    The red line suggests that you're trying to send back an incompatible datatype.  2010 is confusing the ID of your choice with the actual display value and is tryign to submit the wrong item back.

    Have you created a custom DIP for your content types?


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Wednesday, June 29, 2011 9:35 AM
    Answerer
  • Hi Steven

    It's the default Document Information Panel, nothing custom at all.

    The problem happens when a Word 2010 user opens the Document to make their changes and the  Person or Group column in the DIP appears with an ID and not a name. This makes it impossible for a Word 2010 user to save the doc as the column won't accept the number.

    However if you just view the properties of the doc via the SP GUI, the data is correct. It just appears incorrectly in the DIP.

    I don't know what else to try other than rebuilding the site collection!

     

    Wednesday, June 29, 2011 12:09 PM
    1. Have you tried the DIP in other Office 2010 applications?  If not, please give a shot and advise what happens
    2. Have you access to InfoPath and running SharePoint Enterprise?  If so, you'll be able to generate a new XSN file to replace the default one and see f you can fix the issue
    3. Are there any custom columns within your document library?

     


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Wednesday, June 29, 2011 12:38 PM
    Answerer
  • I'm seeing the same problem with a customer. Been using fidler to check what is going on because in one site colletion it works, but another it shows user ID both in the DIP and BackStage for the person field.

    It looks like  200 HTTP customer.net /policies/_vti_bin/_vti_aut/author.dll  application/x-vermeer-rpc winword:15916  

    Gets the metadata back and whehere the dip doesn't work,  
    display_urn:schemas-microsoft-com:office:office#ReviewedBy<li>SW|User Name

    But response also includes<li>ReviewedBy<li>IW|14

    I have confirmed that 14 is the user ID for User Name from _layouts/useredit.aspx?ID=14

    When it works, there seems to be a few more of the application/x-vermeer-rpc based responses.

    Monday, August 22, 2011 9:25 AM
  • Found the problem to be duplicate Custom Properties in Word.

    If the SharePoint Column Name is edited to set a different Display name after the document was already added to the library, you may get this problem (depends on the order of the Word Custom Properties).

    All you have to do is delete the Word property that matches the Display Name value of the SharePoint column, re-enter the correct person name in the DIP and save the document back to SharePoint. Next time you open it all will be fine...

    Regards,
    Ian


    Moderator Note: NEVER propose your own posts as answers. Use the function to propose the good answers of other people - not your own.
    • Proposed as answer by Ian Morrish - ILDS Monday, August 22, 2011 9:22 PM
    • Unproposed as answer by Mike Walsh FIN Tuesday, August 23, 2011 6:11 AM
    • Edited by Mike Walsh FIN Tuesday, August 23, 2011 6:13 AM Moderator Note added about not proposing own posts as answers
    • Proposed as answer by Steven AndrewsEditor Tuesday, August 23, 2011 10:57 AM
    Monday, August 22, 2011 9:21 PM
  • I'll propose it for Ian then, as I happen to agree with his findings and believe it will resolve Sonners concern.

    Mike, a question for you.  One of the two changes made to the recongnition was the fixing of "credit" for self marking.  Now that this has been implemented, how does this affect your views on self proposed answers, IF a clear case can be made for it.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Tuesday, August 23, 2011 11:00 AM
    Answerer
  • The fact remains that the average quality of posts proposed by the poster him/herself is lower than the average quality of posts proposed by someone else. There is clearly a much higher quality threshold before someone else proposes a post.

    (and that is even if you discount those people who - often new to the forums - think that every single one of their posts is an answer and thus propose the lot).

    On your other point, there is an ongoing thread in the Forum Issues forum in which I query the awarding of an "achievement" for proposing your own post (and later in the thread the retention of that achievement even if the post is subsequently unproposed).

    As Moderator I don't have the additional time to evaluate all the posts where someone proposes his own post so I remove every single such self-proposal. If I were to leave any one of them all the people whose self-proposals I unpropose would in any case complain.

    But basically each person who proposes his own post should instead wait for the system to work and for someone else to propose it (as you have done here). Even if they are Ian Morrish.  (Not sure if this is the (former?) Microsoft NZ guy or not)

    I am particularly grateful for people who propose the posts of other people after the OP has said in reply that the post solved his problem (but didn't himself mark it as the answer). They are then the clearest possible situation crying out for being upped to marked level.

    Mike


    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
    Tuesday, August 23, 2011 11:14 AM
  • It is NZ Ian Morrish, which is why the unmarking surprised me.

    I personally don't believe that achievements have a place in a professional, technical based forum, but if it improves the quality of posts / solutions I'm happy to be proved wrong.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Tuesday, August 23, 2011 11:21 AM
    Answerer
  • I can hardly leave self-proposals in just because I like the guy and respect his SP knowledge. That wouldn't be consistent.

    Mike


    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
    Tuesday, August 23, 2011 11:24 AM
  • Wouldn't have it any other way personally, just wanted to propose the question.  Believe it or not, I'm not intentionally a thorn in your side!


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Tuesday, August 23, 2011 11:35 AM
    Answerer
  • I have a Site Content Type (SCT) added to a Document Library. This is the only content type used in the library as I deleted the default document content type.

    The two custom People and Groups columns used in the SCT are NOT duplicated in the Word custom properties. I am using the default word template and the default XSN.

    This occurs when the user opens the 2007 document from the SP 2007 Doc library using Word 2010.

    There is no way possible that the custom SharePoint column display names are being duplicated in Word 2010 custom properties.

     

    Wednesday, August 24, 2011 8:51 AM
  • Hi Mike, and the rest of the SharePoint community. I only proposed it as an answer because I had the same (rather unique) problem and confirmed the root cause + solution. Looks like this was not the problem Sonners was having. I'll ping him directly to see if we can resolve it together and post another answer...

    I'm no longer with Microsoft so looking forward to other ways of connecting with the SharePoint community. Hope there is not too much red tape in using this forum ;-)

    Regards,

    Ian

    http://www.wssdemo.com

    Sunday, August 28, 2011 8:54 PM
  • Send me your email to ian _ morrish at hotmail and I'll send you a Lync invite to see if we can desktop share to sort it out...
    Sunday, August 28, 2011 8:56 PM
  • > Hope there is not too much red tape in using this forum ;-)

    Mainly

    a) don't propose your own posts

    b) don't say your post is urgent or you want asap replies

    c) don't ask SP 2010 questions or make SP 2010 comments  (off-topic as there are SP 2010 forums)

    d) don't advertise

    e) if proposing a third-party product say if you are connected to the company in any way

    and

    f) try to get the right sub-forum   (there is a post with rough guidelines in the General forum and a copy in the Setup forum)

     

    More like normal good forum behaviour than red tape imo.

     

    Finally,

    *Welcome*

     

    Mike

     


    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, August 29, 2011 6:41 AM
  • Incredibly.... I've discovered a pattern!

     

    1. If I open/edit the library document in Word 2010 using the DIP, save and check back in, it all looks OK. (OK means names are properly displayed in the Person or Group Fields)
    2. Then I open/edit the library item using the SharePoint edit document properties icon. (So it opens EditForm.aspx)
    3. Then when I reopen the document in Word 2010 again, the Person or Group Fields shows the ID number instead of the resolved AD name.

    Something is happening between Word 2010 and SP 2007 and using Editform.aspx seems to show it up or it causes a change in the item properties so that Word 2010 cannot understand the Person or Group fields in the DIP.

     

    Has no one else come up against this issue...?


    Tuesday, August 30, 2011 3:52 PM
  • FYI...

    This turns out to be an issue with Office 2010!

    Microsoft issued a hot fix in June: http://support.microsoft.com/kb/2552994

    At least I know I am not going mad!!

     

    • Marked as answer by Mike Walsh FIN Thursday, September 8, 2011 9:57 AM
    Thursday, September 8, 2011 9:31 AM