?
Solved

Person or Group vs. Single Line Text

Posted on 2011-03-06
2
Medium Priority
?
1,966 Views
Last Modified: 2012-05-11
This is a two part question regarding SharePoint 2007 and Person or Group types

First Part
1. I am doing a data upload from access to sharepoint and one of the columns in sharepoint is of person or group type.  However, the access data contains a lot of free text in this field and also the person doesnt exactly match the person or group type from the GAL.  Question:  I was thinking of changing the field tpye in SharePoint to single line text so that the upload will work and going forward a user can type anything in this column.  If any, what are the main advantages and disadvantages of using a single line text vs. person or group type for the column?

Second Part
1. The person or group column is setup as "all users" in SharePoint.  Does this mean that the name is validated against all names in the peoples and groups list first and then against names in AD?  Or does it validate agasint just one and not the other?  How does this work?

Thanks.
0
Comment
Question by:gupshup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
sabby447 earned 180 total points
ID: 35052212
1. You can use single line of text instead of person or group, Person or group is primarily defined to use user profile from AD thus it will not allow other entries, Looking at your situation as data may not be perfectly in sync in Access DB, You can use Single line of text and change the coloum type to it

2. Person or Group look at the users in AD and not in other lists

Regards
~Sabby
0
 
LVL 10

Assisted Solution

by:Minesh Shah
Minesh Shah earned 120 total points
ID: 35053793
Change to text one or better create a new one.
your copy paste won't work, you wouldrequire to fiil individual entries of ppl since it takes its own format.
whatever way you migrate, the text won't get merged into such column type.
on the top of that even if you use any .Net Custom application to migrate, the ppl picker doesn't appears the way it is (it takes a default id before display name).
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question