Wednesday, 28 December 2016

This version of Visual Studio is unable to open the following projects (.Dtproj)

While opening a Project using Visual Studio 2015, we received an error called “This version of Visual Studio is unable to open the following projects”. To fix this issue we need to follow some steps to fix this issue.
Error Screen shots:
  • Open Web platform installer 5.0 and search for Microsoft Azure SDK for .Net (VS 2015)- 2.9.6 and click on add.
  • Once added, click on install button.
  • It will ask for accept license permission, just accept and wait for completion.

  • Also we need to Run devenv /Setup  on Developer Command Prompt for VS 2015 with Admin right and enter the same


Tuesday, 27 December 2016

How to assign task to user and send approval using Workflow in SharePoint online

Today I am writing about how to assign task to user and send approval using workflow in SharePoint.
We have pre-requested to do the same:
  • We need to create A document Library on SharePoint site
  • Once library created we need to upload or add some data on that library
  • We need SP designer Application to configure the same

To do the same, we have to follow below steps with screen shots:

  • Login to the site and create Library document, we need to select Setting gear box on the Top of the page and select Add an App.
  • On the Site contents>Your Apps and click on Document Library and Enter the Name want to mentioned
  • Once assigned the name, click on create option as above, will be getting page like below

  • Now open the create Document file and add or upload documents here. If you wish to upload created docs just click om Upload button or Drag or Drop to the Library, If you wish to create new document from available features on Office 365, we need to select New and select word file, excel or other available option.
  • Now document has been created, here so we move to create workflow from this particular list. To do the same we need to select workflow from library ribbon.
  • Here just click on drop down arrow and select “Create a workflow in SharePoint designer”
Note: make sure SP designer has been installed on your system.

If wish to install SPD 2013, download from below link and install to the local system or accessed server:

SharePoint Designer 2013 is the tool of choice for the fast & quick development of SharePoint applications.

We will have two type of SP designer; 32 bit and 64 bit. Select appropriate version of SharePoint application and download the same.

  • Now move to the next, once we will click on it will ask permission to use and allow SP designer, here click on allow and click on yes.
  • It will take some to retrieve data and fetch from SharePoint site. If you are going to do first time it will ask user name and password.
  • Assign user name and password and click on Login, after Login it will prompt Create List workflow for select List
  • After assigning Name, enter description and select the platform to build your workflow, here I am using SP 2013 workflow and click on ok.
  • Now we are on the page to create action to complete this task, I am adding all required action and user email where we need to send for Approval.
  • Here we need to Log message for workflow, on the next page we need to add Action called Assign to user where you want to send, task Title or other available details (make sure document is having selected field name) and click on ok.

  • On the Transition to stage page we need to end workflow.
  • Now all set, we need to check for any error on the top of page, and publish this workflow, it will take bit of time to publish the workflow.
Note: we can modify this workflow as per our requirement like if you wish this workflow will get start if any new item added or edited the same.

  • To do the above we have select, Go back to workflow created home page and tick mark on start option for below options:
Start workflow automatically when an item is created
Start workflow automatically when an item is changed

  • Again publish the same.

  • Come back to site Library page and start workflow to get result. On the Library of document select document and select Workflow from File ribbon page.
  • Now we will get workflow page here we need to start the workflow by clicking on workflow showing here. I have highlighted the workflow where we need to click for stating the workflow.

  • Now workflow will get start, we can see the on the workflow
  • Now select the document or check the email and select on linked document

  • Approve here or reject if it is not suitable

  • If Approved, it will take us to List page and will show the task completed


Saturday, 24 December 2016

How to Remove Former Employee’s License and User account on Office 365

Today I am writing about How to Delete Remove Former Employee’s License on Office 365, this is very important part of Office 365 Admin. If any of Employee has left your organization then we don’t need to pay for a License after they left. What basically we need to do is just we remove license from the user before deleting User account from Office 365. We have to an option of assigning the same license to another user and to continue with same services.
Below are the steps to configure the same:
  • Make sure you have admin rights, then sign in with your Office 365 global admin account
  • Now go to Office 365 Admin center and select users which you wish to remove or use the same subscription for other users.
  • Now, select the name of employee you want to delete and then select Edit next to Product License from user details Pop-up

  • Now click on edit for Go to Product licenses pane and slide the license indicator making to Off position

  • Once done click on save button to save the same. Now we can check License availability will be from 25 to 24, now the same license we can assign to other users.
  • We can continue following these methods of license removal until you do not hire other persons to work with your group.
Deleting Former Employee’s User Account on Office 365
  • Make sure you have admin rights, then sign in with your Office 365 global admin account
  • Now go to Office 365 Admin center and select users which you wish to remove after removing license.
  • Now click on Delete user option as above screen shots, it will take us Delete User page on the user properties. Here we need to click on Delete option.

Also we can see there is many other option for preventing access:

We can block the user from signing on.
Reset the user’s password
From this option we can remove product License

There is link called “Would you like to know more” about learning about Options for preventing user access to Office 365 &  Best practices when removing users from your organisation

  • Once click on delete it will take some time to delete the same user.

  • Once user will be deleted we will get confirmation about user has been deleted.

  • There is another method to delete the user from Office 365, we can click on more tab from the Active user page.
  • On the user delete user page, we need to search user name and select the user name

  • It will ask for confirmation and delete the user account.

In case we have deleted wrong user or we need to restore the user account, I have already written article about the same. Kindly check the below URL


Friday, 23 December 2016

Concept of REST APIs in SharePoint Online or On Premises

In this article, we will learn about REST APIs in SharePoint. REST API is not a customary API, which include a set of libraries and all data containing types and the types containing properties & methods.

The REST API is typically applied as a Data-centric web service based upon the Open Data Protocol this we can mostly use to retrieve data in details

So let’s start using IE to see details for API for site page in SharePoint

  • Open Internet explorer, Go to Internet Explorer Internet options. Navigate to Content tab and select the settings available for Feeds & Web Slices. See below screen shots:

  • A dialog box will open up on the screen. You need to make sure that feed reading view is fully off. Click OK.

  • Change the current URL to site URL +/_api/web. Next press Enter

You will get an XML document. If you scroll down further, you will get further information about the current web.

Next, in case we want to know more about the lists that are in the web, you need to append all such lists to your URL. When we were using the Explorer browser, you were issuing suitable get requests to your server. However, we can also do the remaining standard CRUD operations.

We can get all details using API file by expanding and adding List Name on the URL page.

Thanks ☺

How to deploy sandbox Solutions in SharePoint Online

I am writing this article about how to deploy sandbox solutions in SharePoint online. Sandboxed solutions will be hosted in the SharePoint user code solution worker process (SPUCWorkerProcess.exe) and run code that can only disturb or effect the site collection of the solution. Because sandboxed solutions don’t run in the IIS worker process, neither the IIS application pool nor the IIS server must restart. It means in case we have server farm and there are multiple Site collection deployed, now we need to do some changes or developed something to the particular site collection, earlier we use to deploy farm Solution which was effecting entire farm.  But later developer has find the solution called Sandbox solution which we will work on Particular site collection.

So today we are deploying solution sandbox on SharePoint online step by step with screen shots:
  • We need a Site collection to deploy sandbox solution in case if you have site collection login to the same or create new site collection
  • Once we will be login to the site collection, click on setting (Gear box) on the right side of the screen.
  • Once clicked site setting page, select site settings option from drop down option.

  • Now select Solutions option from Web Designer and Galleries, above highlighted the same.
  • Once selected solutions options, we will getting solution wizard, here option called Upload Solutions will be available from solutions tab.

  • Now select the Upload Solutions, we will getting Add a document wizard Here we need to upload solutions file.
  • Once uploaded we need to activate the solutions here

  • Once it will get activated we will be getting page like below.

Note: Might be we will be getting error option, if sandbox Is having any issue or expired, we need to check details if issue is occurring we need to fix the same.

  • Now we can add webpart which we have activated recently above.

Now to add web part of activated solutions, navigate any of site page and edit the page and click on Add a web Part and select activated solution web part page.

  • Now once added, we can get output page like below:


How to Restore a Deleted User Account in Office 365

This article is about how to restore a user Account in Office 365, in case we have deleted any of user accidentally we can recover the same user if deleted before 30 Days. When we can restore the same account within the period of mentioned time, here we can restore entire data or other important things.
Below is the step by step procedure to restore one or one more deleted Accounts:
  •  To restore the deleted user account we must have admin permission for office 365, which will allow us to restoring user account.
  • So Login to the Office 365 portal page with admin user account and password.

  • Now we will be appearing with Admin Center page, here we need to select Users from left side of the screen, here will be getting Deleted Users from the above.

  • Now once selected deleted users, we will be redirected to deleted users page. Here we can see the deleted users will be listed here.

  • Now select any of users, will be prompt up a page of user properties page. We can notice here option called Restore.
  • Just select restore option, will prompt restore page, here we will get option called Auto generate page or Let me create the Password, Also we will see check box to send password on the same.

  • Here just select restore, and will be restore the user successfully and will get page like below:
  • Now go back to the deleted user page and can see the user is restore successfully.
  • In case if you wish to restore multiple delete users select all users and follow the above steps