.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

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

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 

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.


View Complete Post


More Related Resource Links

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..


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?


WSS and MOSS Datasheet view people and groups bug or limitation

  
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

# 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


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

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?

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  

In data view web part - how to display document name with link that opens lookup document rather tha

  
I have a list with a lookup column to create relationships with documents in a separate library. I am creating a data view web part to display each item in the list. One of the fields I want to display is the document field (the lookup column). I want this to be in the form of the related document's name with link to directly open the source document itself (Word, PPT, ...). Now I am only managing to display the document name linked to opening the document's display form of the related document library, and then I have to click the document's name there to open it. Alas one unnecessary click too many. Any wize tips? Henning

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.

XSL Lookup to another List in a View. Joining in data from another List. xsl:value-of select=

  
I've been able to create a DataView with data joined from two SP Lists. I did this using SPD, a linked Source, and doing joined subviews.  The technique works nicely, but I have to create my DataView from scratch.As an alternative, I took an existing AllItems View in SPD, converted it to XSL, and was able to add a column from another List as follows:   <TD Class="{$IDA1VDGH}" style="width: 62px; height: 23px"><xsl:value-of select="/dsQueryResponse/Master/Rows/Row/@Lastname" />The problem is, it reports the column for the first row everytime. I'm new to XSL and was wondering..    using XSL, and preserving all the original columns already in the View, is there anyway to make the added column smarter, maybe with a filter?I noticed in my working example, I have this filter (I guess where the subview join magic is)            [@Title = $dvt_ParentRow/@Key] which does not resolve syntax:I tried this, but it does not work, only finding one match, and it also seems to get set for the entire Dataview and not just the column.     [../../../Master/Rows/Row/@Title = @Key] I guess I'm looking either for the SPD steps, or XSL code for adding a single column from another list, joined in by a column in both lists.Thanks for any help or information.

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?

Edit in Datasheet view does not work on one SharePoint 2007 farm, works on another.

  
The ability to edit in datasheet view on one of our environments no longer works.  I've tried different client machines on different builds and regardless of the install every library, list, etc. when attempting to edit in datasheet view shows as read only.  Our other environments those systems work as intended with those same clients. I've searched all over and haven't found anything that helped.  Any ideas?

List lookup to document library not showing folder names

  
Hi all, I've got a Sharepoint List, which has a lookup field to a Document Library on the same site. That document library library is populated with several folders, each with several Word documents within. I want my lookup (in the List) to only display the top level folders in the document library. I managed to do that in my test environment. But in my production environment doesn't list the folder names. I've compared the settings in the two and they look identical. What could be wrong, and how to I fix it so that the folder names appear? I'm using SharePoint 2007. Thanks in advance for the help.

How to put Data in multi Taxonomy type fields using Datasheet view

  
Hi, We have a requirement where data has to be uploaded to a list having a Multi Taxonomy column.Is it possible to do so using datasheet view. Or please suggest if there is any other way. Thanks, Ash
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