• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2036
  • Last Modified:

Person or Group vs. Single Line Text

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
gupshup
Asked:
gupshup
2 Solutions
 
sabby447Commented:
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
 
Minesh ShahSharePoint & all about itCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now