Notes:
Custom properties are not fetching with the CSOM
Properties marked with "Only Me" cant be fetched with CSOM
SSOM and PowerShell is the option when you fetching properties
using System;
using Microsoft.Office.Server.UserProfiles;
using Microsoft.SharePoint;
using CSVHelper;
using System.Data;
using System.Configuration;
using log4net;
namespace UserProfileUtility
{
class Program
{
// Get url from App config
static string siteUrl = ConfigurationManager.AppSettings["SiteUrl"].ToString();
// User Properties handler
static UserProperties userProp = new UserProperties();
//Logging
private static readonly log4net.ILog log =
log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
}
~~~~~~~~UserProperties.cs~~~~~~~~~~~~~~~~
class UserProperties
{
//Logging
private static readonly log4net.ILog log =
log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
References
https://msdn.microsoft.com/en-us/library/office/jj163800.aspx
https://msdn.microsoft.com/en-us/library/office/jj163142.aspx#bkmk_GetChangeUP
http://sharepoint.stackexchange.com/questions/140192/how-to-set-update-user-profile-custom-property-value-programmatically
Custom properties are not fetching with the CSOM
Properties marked with "Only Me" cant be fetched with CSOM
SSOM and PowerShell is the option when you fetching properties
using System;
using Microsoft.Office.Server.UserProfiles;
using Microsoft.SharePoint;
using CSVHelper;
using System.Data;
using System.Configuration;
using log4net;
namespace UserProfileUtility
{
class Program
{
// Get url from App config
static string siteUrl = ConfigurationManager.AppSettings["SiteUrl"].ToString();
// User Properties handler
static UserProperties userProp = new UserProperties();
//Logging
private static readonly log4net.ILog log =
log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
/// <summary>
/// Main method
/// </summary>
/// Arguments
static void Main(string[] args)
{
#region Definitions
DataTable dataTable = new DataTable();
bool first = true;
Object[] objArray;
#endregion
//logging configure
log4net.Config.XmlConfigurator.Configure();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
try
{
#region Fetching user profile prop
using (SPSite site = new SPSite(siteUrl))
{
SPServiceContext serviceContext = SPServiceContext.GetContext(site);
UserProfileManager upMananger = new UserProfileManager(serviceContext);
log.Info("Number of user profiles found :"+ upMananger.Count);
Console.WriteLine("Number of user profiles found : {0}", upMananger.Count);
Console.WriteLine("");
log.Info("Working on resolve user profile poperties . . . ");
Console.WriteLine("Working on resolve user profile poperties . . . ");
Console.WriteLine("");
//Looping user profiles
foreach (UserProfile profile in upMananger)
{
//keyList = new List();
Console.BackgroundColor = ConsoleColor.Yellow;
Console.WriteLine("Found: " + profile["AccountName"]);
Console.ResetColor();
Console.WriteLine(new string('_', 20));
var userAccName = profile["AccountName"].ToString();
//Getting user properties
var dictionary = userProp.GetUserProperties(userAccName);
//Adding headers
if (first)
{
foreach (var item in dictionary)
{
dataTable.Columns.Add(item.Key, typeof(string));
//keyList.Add(item.Key.ToString());
}
first = false;
}
//Adding values
if (dataTable.Columns.Count > 0)
{
objArray = new object[dataTable.Columns.Count];
int i = 0;
foreach (var item in dictionary)
{
objArray[i] = item.Value;
++i;
}
dataTable.Rows.Add(objArray);
}
}
//Console.ReadKey();
}
#endregion Fetching user profile prop
#region Writing to CSV
//Writing to csv
log.Info("User profiles to CSV file in progress. . .");
Console.WriteLine("Writing user profiles to CSV file . . . ");
Console.WriteLine("");
WriteCSV(dataTable);
Console.ForegroundColor = ConsoleColor.Green;
log.Info("User profile import success .");
Console.WriteLine("User profile import success . . . !");
Console.ResetColor();
#endregion Writing to CSV
}
//Catch exceptions here, ex. NullReferenceException
catch (System.Exception ex)
{
log.Error("Error on retriving user profile", ex);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex.ToString());
Console.ResetColor();
}
//getUserPropertiesCollection();
});
Console.ReadKey();
}
/// <summary>
/// Getting SharePoint User Profile Properties
/// </summary>
///
private static void getUserPropertiesCollection(string siteUrl)
{
using (SPSite site = new SPSite(siteUrl))
{
SPServiceContext context =
SPServiceContext.GetContext(site);
ProfileSubtypeManager psm = ProfileSubtypeManager.Get(context);
ProfileSubtype ps = psm.GetProfileSubtype(ProfileSubtypeManager.GetDefaultProfileName(ProfileType.User));
//Get the properties
ProfileSubtypePropertyManager pspm = ps.Properties;
foreach (ProfileSubtypeProperty profileSubtypeProperty in pspm.PropertiesWithSection)
{
Console.WriteLine(profileSubtypeProperty.Name);
}
}
}
/// <summary>
/// Write data table to Comma Seperated Value file
/// </summary>
/// Data Table
static void WriteCSV(DataTable dt)
{
//export CSV location
string exportCSVLocation = ConfigurationManager.AppSettings["ImportCSVLocation"].ToString();
try
{
log.Debug("Writing user profiles to CSV file. . .");
// Write sample data to CSV file
using (CsvFileWriter writer = new CsvFileWriter(exportCSVLocation))
{
CsvRow row = new CsvRow();
//Adding headers
foreach (DataColumn column in dt.Columns)
{
//Iterate Cells
row.Add(column.ToString());
}
// Writing headers
writer.WriteRow(row);
// Iterate rows
foreach (DataRow dr in dt.Rows)
{
//Iterate Cells
row = new CsvRow();
foreach (var item in dr.ItemArray)
{
if (item != null)
row.Add(item.ToString());
}
writer.WriteRow(row);
}
}
}
//Catch exceptions here, ex. NullReferenceException
catch (System.Exception ex)
{
log.Error("Error when writing to CSV file", ex);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex.ToString());
Console.ResetColor();
}
}
/// <summary>
/// Reading CSV
/// </summary>
static void ReadCSV()
{
// Read sample data from CSV file
using (CsvFileReader reader = new CsvFileReader("ReadTest.csv"))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
foreach (string s in row)
{
Console.Write(s);
Console.Write(" ");
}
Console.WriteLine();
}
}
}
}
}
~~~~~~~~UserProperties.cs~~~~~~~~~~~~~~~~
class UserProperties
{
//Logging
private static readonly log4net.ILog log =
log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
/// <summary>
/// Get User profiles prorpertise for the user accout name
/// </summary>
///
///
internal Dictionary GetUserProperties(string targetUser)
{
Dictionary dic = new Dictionary();
Microsoft.Office.Server.UserProfiles.UserProfile user;
try
{
log.Info("Resolving user properties for user : " + targetUser);
#region Getting user profile prop using SharePoint Server Object Model
string siteUrl = ConfigurationManager.AppSettings["SiteUrl"].ToString();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
SPSite spSite = new SPSite(siteUrl);
var serviceContext = SPServiceContext.GetContext(spSite);
UserProfileManager userProfileMgr = new UserProfileManager(serviceContext);
ProfilePropertyManager profilePropMgr = new UserProfileConfigManager(serviceContext).ProfilePropertyManager;
// Retrieve all properties for the "UserProfile" profile subtype,
// and retrieve the property values for a specific user.
ProfileSubtypePropertyManager subtypePropMgr = profilePropMgr.GetProfileSubtypeProperties("UserProfile");
Microsoft.Office.Server.UserProfiles.UserProfile userProfile = userProfileMgr.GetUserProfile(targetUser);
IEnumerator userProfileSubtypeProperties = subtypePropMgr.GetEnumerator();
while (userProfileSubtypeProperties.MoveNext())
{
string propName = userProfileSubtypeProperties.Current.Name;
ProfileValueCollectionBase values = userProfile.GetProfileValueCollection(propName);
if (values.Count > 0)
{
// Handle multivalue properties.
foreach (var value in values)
{
Console.WriteLine(string.Format("{0}: {1}", propName, value.ToString()));
log.Info("Resolved Property=>" + propName + " Property value=>" + values.ToString());
dic.Add(propName, value.ToString());
}
}
else
{
Console.WriteLine(propName + ": ");
log.Info("Retrieved Property name=>" + propName + " Property value=>");
dic.Add(propName, string.Empty);
}
}
});
#endregion
//Console.ReadKey(false);
}
catch (Exception ex)
{
log.Error("Error on retrieving user profile Properties", ex);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error on retriving profile properties");
Console.ResetColor();
}
return dic;
}
References
https://msdn.microsoft.com/en-us/library/office/jj163800.aspx
https://msdn.microsoft.com/en-us/library/office/jj163142.aspx#bkmk_GetChangeUP
http://sharepoint.stackexchange.com/questions/140192/how-to-set-update-user-profile-custom-property-value-programmatically
Comments
Post a Comment