Showing posts with label User Information List. Show all posts
Showing posts with label User Information List. Show all posts

Tuesday, February 17, 2015

User information list manuall sync

User information list manuall sync

Question :

I removed one of my users department from AD and did a full sync from centeral administration.but still my user's department in user information list shows old value.please help me how can I manually sync this list with AD?

Answer :

The UPA Sync connection synchronizes with the User Profile database, not the UIL(User informations list).
To synchronize with the UIL, there are two timer jobs:
User Profile Service Application - User Profile to SharePoint Full Synchronization
User Profile Service Application - User Profile to SharePoint Quick Synchronization
Those synchronize the information from the UPA Profile database to the UIL of each Content Database.

Hope this help,

Wednesday, July 16, 2014

User Information List (hidden user-list)

SharePoint’s hidden user-list – User Information List

Okay, this might not come as news to most SharePoint developers who’ve been around a while, but lately I’ve been messing with the User Information List in SharePoint and it doesn’t seem that many people know that it exists.
Note: This list is only visible to and accessible by administrators.
User Information List – Background
The User Information List stores information about a user by having some metadata set up for the user. Some examples are Picture, Email, DisplayName, LoginName etc. ) For a complete list of fields, see further down this blogpost under "User Information List Fields".
Something to note is that when a user is granted access to a site, a new item will be created in the User Information List storing some information about the user.
When a user add/create or edit an item, SharePoint will display something like "Last modified at 1/1/2008 by Tobias Zimmergren" like the following pic:
In this example the DisplayName (used to display System Account) is gathered from the User Information List
Browsing the User Information List
The User Information List can be accessed (Only if you’re admin) via the browser by navigating to /_catalogs/users/simple.aspx from your site. (Ex:http://zimmergren/_catalogs/users/simple.aspx)
This works for both Windows SharePoint Services 3.0 (WSS 3.0) and Microsoft Office SharePoint Server 2007 (MOSS 2007) and looks like this when you access it through the browser:
Write code to interact with the User Information List
If you want to interact with this list to set properties on a user (Probably only want to do this if you’re running WSS) you could do it like this:
// Instantiates the User Information List
SPList userInformationList = SPContext.Current.Web.SiteUserInfoList; 
// Get the current user
SPUser user = SPContext.Current.Web.EnsureUser(@"ZIMMERTobiasZimmergren");

// The actual User Information is within this SPListItem
SPListItem userItem = userInformationList.Items.GetItemById(user.ID);
The above code will give you the SPListItem object which links to the currently logged in user (the one executing the request).
You can then work with the SPListItem object like normal to get or set the properties like this:
string pictureURL = userItem["Picture"].ToString();
User Information List Fields
Instead of writing out all the fields/columns availible, you can simply create a new Console Application and insert the following code in order to output all the fields names and internalnames:
Note: You will ofcourse have to change the URL and User LoginName
Note2: No comments needed about not disposing the objects as this was merely a sample, eh? ;)

Populate additional fields in User Information List

How to populate additional fields in ‘User List Information’ such as the ‘Manager’ field, in order to reference them using InfoPath and Workflows

By default in SharePoint, the *manager* field is not exposed in the User Information List” in a SharePoint site collection.
 But wait, here’s another place you can look for this information and more specifically, this is the place you’ll want to extract from, in your Workflows, InfoPath, etc.

Choose Site Actions, People and Groups
Then select “All People” from the Quick Launch bar/Navigation
Alternatively, you can go directly to the ‘User Information List’ by appending the following on to your sites URL:/_catalogs/users/simple.aspx (i.e.
Ok, back to the problem, I want the *manage* field to appear within this list as well. And it ain’t there… see!
052009 0020 Howtopopula5 How to populate additional fields in ‘User List Information’ such as the ‘Manager’ field, in order to reference them using InfoPath and Workflows

The Solution

  1. Login to your Central Administration and go to your Shared Service Provider
  2. Under User Profiles and My Sites, choose ‘User Profiles and Properties’
  3. Go to ‘View Profile Property’ under ‘User Profile Properties’
  4. Find the ‘Manager’ Property and hover over and click ‘edit’
  5. Click the ‘Replicable’ checkbox and also check the ‘show in the profile properties section of the user’s profile page’
  6. Return to the ‘User Profile and Properties’ section via the Breadcrumb trail
  7. Start a full Import

Optimising bulk inserts with Entity Framework 6

Optimising bulk inserts with Entity Framework 6 In Entity Framework 6+ the database context implements the  unit of work  pattern so th...