.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

WSS and MOSS Datasheet view people and groups bug or limitation

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
 
I need help trying to work around a limitation with the datasheet view with a list in sharepoint WSS and MOSS.  I need to figure out how to fix the people and group lookup fields so it will not corrupt my data. Currently  the data filters for this type of group does not work.  I have listed the steps below on how to recreate my issue:1. Create a sharepoint group called DELETEMETEST  > add a user to that group2. Create a new list3. Create a column in the list called DELETEMEPEOPLE > Select people only > Choose From DELETEMETEST Group4. Finish creating the list5. Create item in the list    * Notice that if you search for users in DELETEMEPEOPLE it will only show the users assigned to the group.6. Finish creating the record.Back at the listActions > Edit in DatasheetNotice that the DELETEMEPEOPLE now no longer has any filters, and you can add people outside of the DELETEMETEST Group.What are the possible solutions to working around this issue?1. Setting a bit flag on the SPField - Didn't see one that only worked for the datasheet.    2. You could make a custom field type of people and groups and that would make it read only in the datasheet, but isn't that a lot of work for something that is already created?Thanks for any advice....Ivan


View Complete Post


More Related Resource Links

Issue with People and Groups type of column in datasheet view of shrepoint list.

  
Hi,

We have a list created in MOSS 2007 which has a column of type people and groups. When we open the list in datasheet view and try to add records for people and groups type of column the column shows only records from All People section of the site collection. I have verified this for another site collection within the same web application where I am able to see all the users though they are not in the All people section of site collection.
Could anyone please let me know if I am missing any setting or if there is any change required to see all the user names in the people and groups type of column in datasheet view.

Thanks ,
Deepak

problem with datasheet view and people and group lookup

  

hi,

There seems to be a problem in my list datasheet view, when I try searching for a certain person's name from the lookup list, whereas when I click the new item, choose from the people and column list..I can view their names..Why is it so..


# string with cross site lookup field value of List in datasheet view in moss 2007

  
I am getting appended # code value with cross site lookup field value of List in datasheet view, and also i am getting this value while export to Spreadsheet. How to remove this value.....

# string with cross site lookup field value of List in datasheet view in moss 2007

  

I am getting appended # code value with cross site lookup field value of List in datasheet view. I dont want that hash coded value, i need actual value. Please provide me the solution.

 

Thanks

Rajanikanth Rayala


Problems with datasheet view in WSS3/MOSS and IE7

  

 

We've got MOSS and WSS3 sites here (as well as SPS and WSS2) and Office 2003 Enterprise throughout the organization.

 

The datasheet view displays fine in IE6 or in either browser when hitting WSS2/SPS sites. 

 

You get the following error when attempting to view a new generation sharepoint list in datasheet view in IE7, even with the browser's settings set to low, everything enabled, and the site entered into the "trusted sites" list:

 




Some names in people lookup are not available when in datasheet view

  

I am trying to do some list updating (new items) while in datasheet view. I have some names (from our AD) that are not showing up in the droplist of names while in this datasheet view.  The names do show up if I go to standard view and create a new item there.  Any ideas what may be causing this? This is problematic because I'm actually trying to move this data in from an access database and I have about 275 records that won't go in because the names are in the list.


There are no mistakes; every result tells you something of value about what you're are trying to accomplish.

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open

  

When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.

Help.. 


Applying custom CSS to the MOSS 2007 Calendar control Month view

  

hi,

I have a requirement to use the MOSS 2007 Calendar Control - month view is to apply a custom css to have a look and feel as per our requirements.

We tried applying the custom css to the MOSS 2007 calendar control - month view, it does take the custom css and applies it, but when i click on any date and come back to the calendar control, it changes the CSS of the MOSS calendar control back to the default one.

Let me know if anyone has any suggestion on  how to customize the calendar control for css for our intranet application.

Your response would be highly appreciated.

regards

Ram

 

 


PC

Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

http://support.microsoft.com/kb/948952

Any ideas how to get this resolved?


Persons and Groups column in datasheet

  
Hi - we have a problem where we have a column in a datasheet in sharepoint. The column is a person and group column and shows all people/groups etc as well as their presence using MS communicator. Works great on all PCs expect one which is using office 2010 32 bit. When you access the column in the datasheet via that single PC it only shows one option "NT authority\authenticated users" - instead of a list of the people and groups. Any ideas of how to fix this? Thanks

SharePoint 2010 datasheet view 64 bit vs 32 bit

  
I think that the Windows 7 64 bit I have is causing problems between My Office Suite (32 bit) and my IE 8 is (64 bit). I am not able to edit in datasheet view and my upload multiple documents is greyed out? Any help would be greatly appreciated! Thanks!

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns become read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug?

hide links in quick launch bar for "People and Groups", "Group", "All People"

  
Can you tell me how to hide links in quick launch bar for "People and Groups", "Group", "All People"? If a site user click these links all users in site collection will be displayed. (I do want it happends. I only need people for one site only) If you can show me how to display people in one site only would be perfect.

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns are read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug? Should I be able to edit them in 2010 and were they editable in 2007 version. Please help. thanks. I came across this other post which suggests that functionality is not available ? pls someone confirm. Mass-editing metadata when documents are uploaded (individually or in bulk) to MOSS 2010  

Update Datasheet View with Blackberry?

  
Has anyone seen a Blackberry update a SharePoint List in Datasheet View? I know I can update a SharePoint list in Standard View, but need to be able to update in datasheet view.

Cannot display list in Datasheet view sharepoint 2010

  
Hello, I encounter the following errror when I want to display a list in datasheet view: The error messaqe says: A datasheet component compatible wiht Microsoft Sharepoint Foundation is not installed Your web browser doesnt support active x controls a component is not properly configured for 30-bit or 64-bit support. Does anyone know how to solve this problem? I am running windows 7 X64 + Office 2010 x64 Internet explorer: 8.0 Thanks a lot, Jacques

How to apply dynamic filter in Datasheet View from Query String

  
The datasheet view doesn't support either connections/dynamic filters from Query string. How to filter the data using query string?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend