Solved

Person or Group vs. Single Line Text

Posted on 2011-03-06
2
1,935 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 45 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 30 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

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…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

718 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