SharePoint 2013 : Add lookup column from in a list from VS2012

To add the lookup column in the SharePoint list in visual studio 2012 wizard we have to create first list from we have to add lookup column in anther list.

Then add anther list, like below in this list Course is lookup column

Just edit the properties other lookup column ‘Course’, and add the List to =Lists/Courses and  ShowField to Title

SharePoint 2013 : Add date and time field on your custom page

Add the date and time SharePoint control in the SharePoint 2013 hosted app.

Just drag and drop the controls on the page from toolbox of the VS2012

 

The code block will look like as follows :

<SharePoint:DateTimeControl ID="srtDate" ClientIDMode="Static" AutoPostBack="false"
                       runat="server" ToolTip="Start date for training beginning" />

But when you render this control from your app it does not load on the page, and give below screen error.(500 INTERNAL SERVER ERROR)

Then add the following property of the control : DatePickerFrameUrl="../_layouts/15/iframe.aspx" and add the ralative pat of the app like as I added “../”. After that it will render the control on the page.

SharePoint 2013 : Create a declarative workflow in O365 SharePoint Hosted App

Hi,

Well, recently I encountered with one requirement to send email from Office 365 SharePoint Site. The scenario is like send a mail from SharePoint List, and have to take email address from the SharePoint List column, say Email.

Snap

 

Variables

So, In above activity well achieve to send email from list in O365. But still I am looking for sending email’s to other domains.Right Now its sending the email in its domain, like I have created ZapataIndi.onmicrosoft.com.

Link for “Sign in as Different User” in SharePoint 2013

It’s think the developer team of the SharePoint 2013 forget to add the  “Sign in as a Different User” menu command in SharePoint 2013

No worry’s we can add that using the below steps(on premise)

1. Open the Welcome.ascx from “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\CONTROLTEMPLATES”
2. Find the “<SharePoint:MenuItemTemplate runat="server" id="ID_RequestAccess"”.
3. Press enter and add

<SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser"
                 Text="<%$Resources:wss,personalactions_loginasdifferentuser%>"
                 Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>"
                 MenuGroupId="100"
                 Sequence="100"
                 UseShortId="true"
                 />



4. Save the welcome.ascx

Now you can see that “Sign in as Different User” appears at drop down.

Enjoy SP 2013

Visual Studio 2012 Project Load Failure Dialog Box for Database Project

Upon loading Visual Studio 2012 RC or Visual Studio 2010, several package load failure messages are shown for SSDT components.

The ‘SqlStudio Editor Package’ package did not load correctly.

Trying to build solution that contains a sql database project (VS 2012 RC). Other projects build fine but database project fails. Error log shows:

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(386,5): error MSB4061: The "SqlModelResolutionTask" task could not be instantiated from "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\Bin\Microsoft.Data.Tools.Schema.Tasks.Sql.11.dll".  [C:\a\src\Gamma.Db\Gamma.Db.sqlproj]

SQL Server Data Tools (SSDT) : SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development and maintenance/update inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise.

Resolution : Install SQL Server Data Tools (SSDT) in the system and restart the machine

Link to download : http://msdn.microsoft.com/en-us/jj650015

SharePoint 2010 error when trying to delete a managed account: An object in the SharePoint administrative framework, SPManagedAccount Name=managed-account could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation.

After deleting a User profile Service Application, we may want to clear up the corresponding managed account that we have created for the Service Application.

But we get the above error when we try to deleted the acount from CA-> Securtiy->Configure Managed Accounts.

To resolve this error, we have to use SharePoint PowerShell,

Steps :

1. Go to Start->Microsoft SharePoint 2010 Products->SharePoint 2010 Management Shell
2. Paste this commend on the shell “Get-SPServiceApplicationPool” (get a list of the Service Application Pools)
3.           
4. The run the following cmdlet “Remove-SPServiceApplicationPool” and press enter key.
5. The the service application pool and press enter
6.         
7. Remove the Managed account via PowerShell by following cmdlets

Get-SPManagedAccount
Remove-SPManagedAccoun <accounetname>

The forefront identity manager service service on local computer started and then stopped : SharePoint 2010 user profile issue

When we create user profile service application, then some times the User profile Synchronization services does start or run. The common scenarios the farm admin and domain admin are same. So, user profile synchronization does not run under the same account. From my research or we can say finding, when we do new installation of the SharePoint in new server, most of the time the service does not run, we just wait for long hours, and it stat is like starting. Seriously it wasted my lot of time, just sitting at my screen and waiting to start.

The main reason of the that is, we have create a new service account say “sp_userprofiles” in managed account of the Active Directory section.

And give the following permissions.

Now we have create one Delegate Control for created user.

Click on Next

On the Users or Groups page, click Add

Type the name of the synchronization account (farikam\sp_userprofiles), and then click OK.

On the Tasks to Delegate page, select create a custom task to delegate, and then click Next.

On the Active Directory Object Type page, select This folder, existing objects in this folder, and creation of new objects in this folder, and then click Next.

On the Permissions page, in the Permissions box, Select Replicating Directory Changes (select Replicate Directory Changes on Windows Server 2003), and then click Next.

Click Finish.

Create User profile Service Application.

Run the services from Central Admin(User Profile Service and User Profile Synchronization Service )

Check the services.msc in the system

Both service are now running(Do not run or edit the properties of the service manually)

Enjoy SharePoint

SharePoint 2010 : Types of Event Receivers

List Events -
Adding/ed a new list field.
Updating/ed a field.
List Item Events -
Adding/ed a new list item or document.
Document checking/ed in or out.
Adding/ed an attachment.
Deleting/ed an item or document.
List Email Events -
A list received an email.
Web Events -
Deleting/ed a site collection or site.
Creating/ed a new site collection or sub site.
Feature Events -
Feature activating/ed or deactivating/ed.
List Workflow Events -
A workflow is starting/ed, postponed, or completed.

SharePoint 2010 : Enhancements for Developers in SharePoint Foundation

 

Enhancement	Benefit
Service application architecture	Redesigned infrastructure to facilitate sharing of resources across Web applications and farms.
Windows PowerShell support	New support and capabilities for writing administrative scripts.
Feature versioning and upgrade	New support for versioning and upgrading features.
SharePoint Developer Tools for Visual Studio 2010	A first-class development experience for SharePoint developers (finally).
Sandboxed solutions	New support for deploying solution packages at site collection scope in a sandboxed environment.
New features for throttling lists and controlling query execution	Enhanced support for stabilizing the farm by prohibiting large,inefficient queries.
New events for sites, lists, and workflows	Additional events for developers to hook up event handlers.
LINQ to SharePoint provider	New support for writing LINQ query statements to access SharePoint list data.
REST-based access to SharePoint list items	New support for accessing SharePoint list data from across the network using REST-based Web service calls.
Client-side object model	Ability to leverage the SharePoint object model from across the network when programming with .NET, Silverlight, and JavaScript
Enhanced support for integrating Silverlight applications	Rich support for deploying and versioning Silverlight applications within a SharePoint environment
Claims-based security	New authentication support for leveraging external identity management systems and extending access control in SharePoint sites using custom claims
Business Connectivity Services (BCS) and external lists	New support for creating read-write connections to back-end databases and line-of-business systems and exposing their data as lists within SharePoint sites
NET Assembly Connectors for BCS	Support for creating a custom component to integrate any data source with the BCS.

SharePoint 2010 : Programmatically Add a Term to The SharePoint 2010 Term Store.

The new metadata features in 2010 are of great value to us. With each of our assets having a unique accounting identifier and our document contributors having room for improvement with naming documents favorably for search it could be a life savor!

Add following reference to the solution

using System.Globalization;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Taxonomy;

 

To add term in the term store, add following code

SPSite site = new SPSite("http://newdemo2010"); TaxonomySession taxSession = new TaxonomySession(site); TermStore termStore = taxSession.TermStores["Managed Metadata Service"]; Group storeGroup = termStore.Groups["BPTemplate"]; TermSet termSet = storeGroup.TermSets["Timecard"]; termSet.CreateTerm(pTerm, 1033); //It will term to the root term Term propertyIdsTerm = termSet.Terms["TimeLog"]; propertyIdsTerm.CreateTerm(pTerm, CultureInfo.CurrentCulture.LCID); //This will add term to a term termStore.CommitAll();