How to search SharePoint users in the User Information List

To find the User Information List in the sharepoint, You need to enter the below URL

http://SPSiteName/_Catalogs/users/simple.aspx

Then you can search either User ID or Email or FirstName or Last Name

All SharePoint Sites Not working After Installed March 2015 Microsoft Patches

Operating Sytem: windows server 2003

Sharepoint Server : Sharepoint Server 2007

DB Server : MS SQL Server 2005

We have several Windows Server 2003 boxes available , and last night, tech admin guys had installed their Microsoft March 2013 Security patches around 12 installed.

This morning, users cannot access sharepoint sites they were previously able to, and are prompted for credentials. When entering their credentials, authentication seems to fail.

Users always frustrating even they has entered correct domain name,user name and password.

But I am an share point admin, I tested the sites inside the server using system account and normal users account, which is working fine.

When i am accessing the share point sites from other laptop or system using normal account, it is keep on prompting credentials.
I checked windows event logs,sharepoint logs and DB logs, we didnt get any clue regarding that issue, so we asked to tech admin to uninstall all Mar 2013 patches installed by last night, he only unistalled two web front end servers and DB servers and AD server. Then i tested again it is again prompting user name and password for normal users.

Solution:

Finally the sites are working for all users, Because Tech admin should forget to uninstall the patches on the two Domain Controller server.

Mainly Uninstall this patches KB 3002657

After that We checked the share point sites can be accessible to all user's without prompting credentials

We also referred the below sites, thanks for your valuable suggestion and gave sleeping time by tonight otherwise ...we might be spent to research for other parameters, my courtesy in the below sites, bcos we found the root cause of the issue for installed  Mar 2015 patches denoted in the below site.

http://serverfault.com/questions/674541/has-march-2015-patch-tuesday-broken-2003-shares

Updating Sharepoint List Column Value using Sharepoint Object Model in C#

Progress

SharePoint Designer workflows never reflects the new changes

I've ran into this scenario a lot it seems. I'm not sure if it's an issue with SharePoint Designer, or SharePoint itself, but the following seems to occur often:   I create a Workflow in SharePoint Designer, and when I save it, it's good to go, and works as expected. However, when opening it later for edits in SPD, I can make changes to the workflow, very large ones, and save it, and on the SharePoint site, it shows as a new version of this workflow, but never reflects the new changes I made to it.     For instance, I created a simple one to test, simply an email gets sent to me when a new item is created in a list. Works fine. However, when I add an item lookup in the body of the email, save the workflow again, and create a new item in my list, I still get a blank email, not the new item lookup in the body of the email as expected. Is there some kind of timer with SharePoint updating workflows? Am I missing something here?   SOLUTION:   For SharePoint Designer, the solution is similar to Dave's solution. It seems SharePoint Designer saves local copies of DLLs from your servers, and although everything seems OK, this prevents it from updating the workflow (this is when custom activities are involved, which the question didn't mention).   To solve this issue for MOSS 2007: Close SharePoint Designer Go to %LOCALAPPDATA%\Microsoft\WebsiteCache Or, on older versions of windows: C:\Documents and Settings\%USER%\Local Settings\Application Data\Microsoft\WebSiteCache Delete either (choose one, based on how annoyed you are by now): All folders. The folder that "looks most like your site" (can be more than one: site, site(1), etc, and should be the bottom level site, not the root site) The relevant DLL in that folder. Start SharePoint Designer, save the workflow again, it should be ok. To solve this issue for SharePoint 2013 or 2010: Go to the folder and delete the files and folders C:\Users\LOginUse\AppData\Roaming\Microsoft\Web Server Extensions\Cache C:\Users\LOginUse\AppData\Local\Microsoft\WebsiteCache Before that take backup  and delete it, some sites ask to delete the files and folders in the below location, Don't try to delete, Because after deleting the files the existing workflows never open C:\Users\LOginUser\AppData\Roaming\Microsoft\SharePointDesigner\ProxyAssemblyCache

Hide left navigation panel without using Sharepoint designer

The users ask to remove left navigation in the Sharepoint Master pages.
You hust hide the left navigation using the below code with Content Editor
webpart

Since this web part is just added to the home page, it doesn’t hide the
left nav penal for other pages.

Once move the code in the CEWP then set the chrome type to be “None”.
 

Sharepoint Caluclation column

1.Display date format like "dd-MMM-yyyy"

=TEXT(StartDate,"dd-mmm-yyyy")

How to check the W2WP Process is running in the Sharepoint

Opend cmd

C:\Windows\System32>issapps.vbs

How to load sharepoint List data values in to the User control Dropdown box via Sharepoint Object Model

Sharepoint Object Mode

How to retrieve People Picker AD id and Display name to store in the SQlL Server Databases

How to retrieve People Picker AD id and Display name to store in the SQlL Server Databases

Sharepoint Event receiver for SP List

Sharepoint Event Viewer and Receiver

Sharepoint 2007 Timer Job Development and Deployment Steps

Sharepoint 2007 Timer Job Create Timer job solution File. 1.Create C# project Library 2.Create Timer.CS, TimerInstaller.CS, Feature.xml, manifest.xml files 3.Copy existing code and past it in the proper files 4.Set strong name 5.Build DLL 6.Copy DLL id in the feature file 7.Build WSP and following deploying procedures. Deployment Timer Jobs: 1. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES 1.1 Create a folder " KarNet.TimerJob " 1.2 Copy the files "Feature.xml" & "Manifest.xml" 2. Run the install.bat file to deploy the Solution file. 2.2 before that edit the file to point to correct SharePoint site, by changing the "TargetUrl". 2.3 stsadm -o installfeature -name KarNet.TimerJob -force 3. Copy the KarNet.TimerJob.DLL to GAC. 4. Activate the Site Collection feature to enable the custom Timer 5. Restart the Timer Service in services. 6. Create a Folder in C:\ as "KarNetLog" 7. Share the folder and allow "everyone" full access. Activate Feature manually C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o deactivatefeature -name KarNet.TimerJob -url "http://KarNet-46b4a490b" C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o uninstallfeature -name "KarNet.TimerJob" C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o installfeature -name KarNet.TimerJob -force C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o activatefeature -name "KarNet.TimerJob" -url "http://KarNet-46b4a490b " Timer .cs using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.Diagnostics; using Microsoft.SharePoint.Workflow; using System.IO; using Microsoft.SharePoint.Utilities; using System.Collections.Specialized; using System.Text.RegularExpressions; namespace HRction.TimerJob { public class Timer : SPJobDefinition { public Timer() : base() { } [Persisted] private string siteToPerformJob; public Timer(string jobName, SPService service, SPServer server, SPJobLockType targetType) : base(jobName, service, server, targetType) { } public Timer(string jobName, SPWebApplication webApplication, SPSite site) : base(jobName, webApplication, null, SPJobLockType.Job) { this.Title = "HR.TimerJob"; this.siteToPerformJob = site.Url; } public override void Execute(Guid contentDbId) { try { //System.Diagnostics.Debugger.Break(); //System.Diagnostics.Debug.Assert(false); //System.Diagnostics.Debug.WriteLine(SPContext.Current.Site.WebApplication.Name); // get a reference to the current site collection's content database SPWebApplication webApplication = this.Parent as SPWebApplication; //LogMessage("Welcome " + webApplication.Name, EventLogEntryType.Information); //SPContentDatabase contentDb = webApplication.ContentDatabases[contentDbId]; //SPList taskList = contentDb.Sites["FEDemo"].RootWeb.Lists["Tasks"]; // create a new task, set the Title to the current day/time, and update the item //SPListItem newTask = taskList.Items.Add(); //newTask["Title"] = DateTime.Now.ToString(); //newTask.Update(); //int ID = 0; DateTime ActionDate; string IsError = ""; string strWFStatus = ""; string strActionDate = ""; string strItemID = ""; string strDivAction = ""; string strAction = ""; string strWfStarted = ""; string siteURL = ""; string CC = ""; string Body = ""; string TO = ""; string HRction_Mail_Group = ""; string GetHRctionEmail = ""; StringDictionary headers = new StringDictionary(); headers.Add("content-type", "text/html"); if (this.siteToPerformJob != null) { ////siteURL = this.siteToPerformJob + "/wss"; //need to enable for client deployment siteURL = this.siteToPerformJob + "/"; //need to enable for client deployment using (SPSite currentSite = new SPSite(siteURL)) { //LogMessage("SPSite - " + currentSite.Url, EventLogEntryType.Information); currentSite.AllowUnsafeUpdates = true; currentSite.CatchAccessDeniedException = false; using (SPWeb AnetWeb = currentSite.OpenWeb()) { AnetWeb.AllowUnsafeUpdates = true; //LogMessage("AnetWeb - " + AnetWeb.Url, EventLogEntryType.Information); ////SPList BGOperatorReminder = AnetWeb.Lists["BGOperatorReminder"]; SPList ActionList = AnetWeb.Lists["HRList"]; //- for Production foreach (SPListItem item in ActionList.Items) { strItemID = item["ID"].ToString(); LogMessage("Item ID " + item["ID"].ToString(), EventLogEntryType.Information); strActionDate = item["ReminderDate"].ToString().Replace("datetime;#", ""); // For Production ////LogMessage("strActionDate " + strActionDate, EventLogEntryType.Information); ActionDate = Convert.ToDateTime(strActionDate, System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat); //LogMessage("ActionDate " + ActionDate.ToString(), EventLogEntryType.Information); LogMessage("Reminder Date " + ActionDate.AddDays(-1).Date, EventLogEntryType.Information); strDivAction = item["Action"].ToString(); ////LogMessage("strDivAction " + strDivAction, EventLogEntryType.Information); strAction = Regex.Replace(strDivAction, "<[^>]*>", string.Empty); strWFStatus = item["WFStatus"].ToString(); strWfStarted = item["WFStarted"].ToString(); //LogMessage("strAction " + strAction, EventLogEntryType.Information); //LogMessage("Reminder " + item["Reminder"], EventLogEntryType.Information); //LogMessage("Added By " + item["AddedBy"], EventLogEntryType.Information); //LogMessage("WF Status " + item["WFStatus"], EventLogEntryType.Information); //LogMessage("WFStarted " + item["WFStarted"], EventLogEntryType.Information); if (item["Reminder"].ToString() == "True") { if (ActionDate.AddDays(-1).Date == DateTime.Today.Date && item["WFStatus"].ToString() == "Pending") // for Production (&& InFavourOf != "The Controller of Immigration") { if (item["WFStarted"].ToString() == "No") { using (SPSite site = new SPSite(siteURL)) { using (SPWeb web = site.OpenWeb()) { SPGroup gp = web.Groups["HRAction"]; if (gp != null) { foreach (SPUser usr in gp.Users) { if (usr.Name != "System Account") { if (HRAction_Mail_Group == "") HRAction_Mail_Group += usr.Name; else HRAction_Mail_Group += ", " + usr.Name; if (GetHRActionEmail == "") GetHRActionEmail += usr.Email; else GetHRCActionEmail += "," + usr.Email; } } } } } TO = GetHRActionEmail; if (TO.Length > 0) { headers.Add("from", item["FromEmail"].ToString()); Body = Body + "<table dir='ltr' cellspacing='0' designtimesp=23183> <tr designtimesp=23184><td designtimesp=23185> </td></tr>"; Body = Body + "<tr designtimesp=23186><td designtimesp=23187> The HR Competitor Action status as follows:</td></tr>"; Body = Body + "<tr designtimesp=23188><td designtimesp=23189> </td></tr><tr designtimesp=23190><td designtimesp=23191> </td></tr>"; Body = Body + "<table dir='ltr' cellspacing='1' cellspacing='1' border='1' designtimesp=23192><tr designtimesp=23193><th designtimesp=23194> Name</th><th designtimesp=23195> Name</th><th designtimesp=23196> Name </th><th designtimesp=23197>Action</th></tr>"; Body = Body + "<tr designtimesp=23198><td designtimesp=23199><p align='Center' designtimesp=23200>" + item["PropertyName"].ToString() + "</p></td><td designtimesp=23201><p align='Center' designtimesp=23202>" + item["Name"].ToString() + "</p></td><td designtimesp=23203><p align='Center' designtimesp=23204>" + item["AssociateName"].ToString() + "</p></td><td designtimesp=23205><p align='Center' designtimesp=23206>" + strAction + "</p></td></tr></table></td></tr>"; Body = Body + "<tr designtimesp=23207><td designtimesp=23208> </td></tr>"; Body = Body + "<tr designtimesp=23209><td designtimesp=23210> </td></tr><tr designtimesp=23211><td designtimesp=23212> </td></tr><tr designtimesp=23213><td designtimesp=23214>Best regards,</td></tr><tr designtimesp=23215><td designtimesp=23216> Admin Team</td></tr></table>"; //headers.Add("cc", CC); headers.Add("to", item["ToEmail"].ToString()); headers.Add("subject", "HR Status : " + item["AssociateName"].ToString()); SPUtility.SendEmail(AnetWeb, headers, Body); headers.Clear(); item["WFStatus"] = "Completed"; item["WFStarted"] = "Yes"; item.SystemUpdate(); CC = ""; Body = ""; TO = ""; HRAction_Mail_Group = ""; GetHRActionEmail = ""; } } } } } // INITIEAL FOR LOOP CLOSED } // SP WEB IF LOOP CLOSED // item.SystemUpdate(); /// # endregion } // SP SITE URL LOOP CLOSED } // SP TIMER JOB IF LOOP CLOSED //LogMessage("Updated", EventLogEntryType.Information); } // TRY LOOP CLOSED catch (Exception ex) { LogMessage(" Error " + ex.Message + " Trace " + ex.StackTrace, EventLogEntryType.Error); } } // EXCECUTE DB ID LOOP CLOSED protected static string StartWorkflow(SPListItem wfListItem, string workflowName, string SiteURL) { SPWorkflowAssociationCollection wfAssocs = wfListItem.ParentList.WorkflowAssociations; SPWorkflowAssociation activeWorkflowAssoc = null; string errorMessage = string.Empty; foreach (SPWorkflowAssociation wfAssoc in wfAssocs) { if (wfAssoc.Name.Equals(workflowName)) { activeWorkflowAssoc = wfAssoc; break; } } // if the workflow exists, start the workflow SPWorkflow activeWorkflow = null; if (activeWorkflowAssoc != null) { try { using (SPSite currentSite = new SPSite(SiteURL)) { activeWorkflow = currentSite.WorkflowManager.StartWorkflow( wfListItem, activeWorkflowAssoc, "<Data DESIGNTIMESP=23217></Data>"); } } catch (Exception ex) { errorMessage = "error " + ex.Message; } } else { errorMessage = "error No WF Found"; } return errorMessage; } //kcline private static void Log(String logMessage, string LogType, TextWriter w) { w.Write("\r\nLog Type :{0} ", LogType); w.WriteLine("\r\n{0} {1}", DateTime.Now.ToLongTimeString(), DateTime.Now.ToLongDateString()); //w.WriteLine(" :"); w.WriteLine(" - {0}", logMessage); w.WriteLine("-------------------------------"); // Update the underlying file. w.Flush(); } //kcline private void LogMessage(string message, EventLogEntryType type) { string FilePath = "C:\\HR Log"; //SPDiagnosticsService.Local.LogLocation.ToString(); string FileName = ""; bool EndSlash = false; if (FilePath.EndsWith("\\")) EndSlash = true; if (Directory.Exists(FilePath)) { if (EndSlash == false) FileName = FilePath + "\\" + " HR-Timer.log"; else FileName = FilePath + "HR-Timer.log"; string LogType = ""; using (StreamWriter w = File.AppendText(FileName)) { LogType = type.ToString(); Log(message, LogType, w); //ka line// Close the writer and underlying file. w.Close(); } } } } } TimerInstaller.cs using System; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; namespace HRction.TimerJob { class TimerInstaller : SPFeatureReceiver { const string JOB_NAME = "HRAction.Timer"; /// <summary> /// Occurs after a Feature is installed. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureInstalled(SPFeatureReceiverProperties properties) { } /// <summary> /// Occurs when a Feature is uninstalled. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureUninstalling(SPFeatureReceiverProperties properties) { } /// <summary> /// Occurs after a Feature is activated. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureActivated(SPFeatureReceiverProperties properties) { // register the the current web SPSite site = properties.Feature.Parent as SPSite; // make sure the job isn't already registered foreach (SPJobDefinition job in site.WebApplication.JobDefinitions) { if (job.Name == JOB_NAME) job.Delete(); } // install the job Timer AnetTimerFBG = new Timer(JOB_NAME, site.WebApplication, site); SPMinuteSchedule schedule = new SPMinuteSchedule(); schedule.BeginSecond = 0; schedule.EndSecond = 59; schedule.Interval = 5; AnetTimerFBG.Schedule = schedule; //schedule.BeginHour = 12; //schedule.BeginMinute = 30; //AnetTimerFBG.Schedule = schedule; //AnetTimerFBG.Update(); AnetTimerFBG.Update(); } /// <summary> /// Occurs when a Feature is deactivated. /// </summary> /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param> public override void FeatureDeactivating(SPFeatureReceiverProperties properties) { SPSite site = properties.Feature.Parent as SPSite; // delete the job foreach (SPJobDefinition job in site.WebApplication.JobDefinitions) { if (job.Name == JOB_NAME) job.Delete(); } } } } Feature.xml <?xml version="1.0" encoding="utf-8" ?> <Feature xmlns="http://schemas.microsoft.com/sharepoint/" Id="2FAE7079-FD53-4371-81DF-E7A206884AA8" Title="HRction.TimerJob" Description="HR Action TimerJob ." Scope="Site" Hidden="FALSE" Version="1.0.0.0" ReceiverAssembly="HRAction.TimerJob, Version=1.0.0.0, Culture=neutral, PublicKeyToken=52505fa26f9ec918" ReceiverClass="HRction.TimerJob.TimerInstaller"> </Feature> manifest.xml <?xml version="1.0" encoding="utf-8" ?> <!-- Solution created by WSPBuilder. 5/25/2011 8:13:46 PM --> <Solution xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SolutionId="932AE855-EBA7-4c4c-A54A-7FD36415DCF7" ResetWebServer="True" xmlns="http://schemas.microsoft.com/sharepoint/"> <Assemblies> <Assembly Location="HRAction.TimerJob.dll" DeploymentTarget="GlobalAssemblyCache" /> </Assemblies> </Solution>

 

Ajax User Control page upload in the sharepoint web parts

solutions:In few it is possible to insert script manager from within control, unfortunately in many cases the control may not be able to insert the script manager early enough in the page lifecycle depending on how the control is used . You need to add script manager in master page and remove Steps:
Open SPD , Open your Site, navigate to Catalog-> MasterpagesSelect your master page & checkout.Edit your master page in SPD.

Save , CheckIn , Publish

windows sharepoint search service existing database name changed

Resolution: Rename the database "WSS_Search_MIG" to some other name. SharePoint is trying to create a new search database and find the file already exists so its not able to overwrite the schema of that database.

And start the Search Service from Central Administration -> Operations -> Services on server -> Click on the Windows Sharepoint Services Search service.