Solved

Person or Group vs. Single Line Text

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 with 3rd Party Video hosting 2 40
Convert a Master Page to HTML 16 124
SharePoint Foundation 2013 Search 11 49
SP2010 Parent Child Relationship 3 33
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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