Commands For “Add”, “Install”, “Update” The Solutions For SharePoint Site

In my last article, we saw how to create a SharePoint farm solutions project. After we have completed the project development, we can deploy the WSP to the SharePoint Server. WSP will be available after we publish the project in Visual Studio.

Steps to Add, Install and Update the WSP

Follow the below listed steps to deploy the WSP in SP Server.

Step 1

Open the SharePoint Management Shell with administrator rights in Server.

SharePoint

ADD Solution

Now, add the WSP solution first using the below command,

Add-SPSolution “Documents\Your WSP Name.wsp”

E.g

Add-SPSolution “C:\Workings\AE_WSP\SampleSPProject.wsp”

SharePoint

Open the Central Admin and go to System Settings from the left navigation. Now, select “Manage Farm Solutions” to check the status of your solution.

SharePoint

INSTALL SP solution

Then, install the WSP to the WebApplication by running following command in Management Shell,

Install-SPSolution –Identity “WSP Name”.wsp –WebApplication “Site Url” –GACDeployment -fulltrustbindeployment -force

E.g

Install-SPSolution –Identity “SampleSPProject.wsp” –WebApplication “http://test:8888/” –GACDeployment -fulltrustbindeployment -force

SharePoint

Finally, your solution will be deployed successfully. We can check the status in Central Admin, as shown in below image.

SharePoint
UPDATE Solution

If we want to update the solution, we can use the below command in PowerShell to update the previous solution,

Update-SPSolution -Identity “WSPNAME.wsp” -LiteralPath “PATHFORWSP\SampleSPProject.wsp” -GACDeployment -FullTrustBinDeployment -Force

E.g

Update-SPSolution -Identity “SampleSPProject.wsp” -LiteralPath “C:\Workings\AE_WSP\SampleSPProject.wsp” -GACDeployment -FullTrustBinDeployment –Force

SharePoint

In Central Admin’s “Manage Farm Solutions, we can check the status, as shown below.

SharePoint

Finally, our solution will be updated successfully.

SharePoint

UNINSTALL solution

Run the below command to uninstall the WSP in Management Shell.

Uninstall-SPSolution -Identity “wspname.wsp”

E.g

Uninstall-SPSolution -Identity “SampleSPProject.wsp”

When you uninstall the WSP it ensure that to perform this operation as shown below, type “Y” to proceed,

SharePoint

REMOVE Solution

Use the below command to remove the WSP solution.

Remove-SPSolution –Identity “SampleSPProject.wsp” -force

SharePoint

Summary

In this article, we have explored how to add, install, update, remove and uninstall the WSP package in SharePoint 2016 server.

Create Document Library With Folders In SharePoint Using VS 2015

In this article, I would like to share the steps for creating a document library with folders in SharePoint, using Visual Studio 2015. In my previous article, we saw how to create document library manually in SharePoint Online Site.

What a SharePoint Document Library is –

  • A Document Library is a collection of files that you can share as documents with your team members.
  • A Document Library stores the files and you can maintain the data in various folders.
  • A SharePoint Document Library is a place on a site where you can create, collect, and update files with others.
  • You can set the permission to each Document Library for the users.
  • You can show a Document Library in web part pages as List View Web Parts.

SharePoint provides templates for us to create SharePoint list and library. Each and every list will have its own list instance and list definition. In Visual Studio SharePoint projects, we can see the list instance, and the folders can be added in the list instance.

Follow the below listed steps to create Library with folders.

Already we saw how to create the SharePoint project using Visual Studio 2015.

Step 1

Open your SharePoint project in VS 2015.

SharePoint

Step 2

Then, create a subfolder under this project to keep the list and libraries separate. Right click the project and choose Add >> New Folder.

SharePoint

Step 3

Provide the folder name as per your need.

SharePoint

Step 4

Right click on the library folder and select Add >> New item….

SharePoint

Step 5

When you click the “New Item”, you will get a pop up as shown below. Here,  select the list template and provide a name for your library.

SharePoint

Step 6

Then, press “Add” button to create a new library.

SharePoint

Step 7

After you click the “Add” button, you need to provide library name and template. I have selected picture library template. Then, click “Finish” button.

SharePoint

Finally, the library will be added in our SharePoint project.

SharePoint

Now, we need to add the folders inside the library. So, add the below code in sample library element.xml file.

  1. <Data>
  2.       <Rows>
  3.         <Row>
  4.           <Field Name=“ContentTypeId”>0x0120004F994A3C0FF76546A528DA0D4B515898</Field>
  5.           <Field Name=“FileLeafRef”>Images</Field>
  6.           <Field Name=“Title”> Images</Field>
  7.           <Field Name=“FSObjType”>1</Field>
  8.         </Row>
  9.       </Rows>
  10.     </Data>

SharePoint

Once you add the above code, deploy the solution from VS. Your new Library will be created successfully with folder, as shown in below image.

SharePoint
Summary

In this article, we have explored how to create a document library with the predefined folders in SharePoint using Visual Studio 2015.

Create SharePoint Project And Deployment Steps Using Visual Studio 2015

What is SharePoint?

  • SharePoint is a web based document management and collaboration tool.
  • It is used to create the sites, manage permissions, and is highly configurable.
  • Search is one of the main features in SharePoint that is more efficient.

What is Farm Solution?

It is hosted on IIS Worked process i.e. W3WP.exe. It can affect the whole farm when we run the code. IIS application pool will be recycled when we retract or deploy the farm solutions.

Steps to create SP Project using VS Templates

Follow the below listed steps to create a SharePoint project. SharePoint Project Templates are available in VS.

Step 1

Open Visual Studio as administrator.

SharePoint

Step 2

Select File >> New >> Project, as shown below.

SharePoint

Step 3

Then, choose “SharePoint 2016 – Empty Project” from the template list. This template is available under Office/SharePoint – SharePoint Solutions.

SharePoint

Step 4

After selecting the template, provide the name for the project and then select the location of project as per your need.

SharePoint

Step 5

Then, click the “OK” button to create a new SharePoint project.

SharePoint

Step 6

Once you click the OK button, you will get the pop up to choose whether it is sandbox or farm solution. As we are creating the project for on-premise, we can choose the farm solution. Then, click “Finish” button.

Note

Before you proceed, ensure that the URL is valid.

SharePoint

Step 7

Finally, the project has been created successfully.

SharePoint

As per your need, you can create the List, Libraries, Modules, and webpart.

Then, right click the project and select “Deploy” to deploy the project on SharePoint site, as show below.

SharePoint

Summary

In this article, we have explored how to create SharePoint project and how to deploy the farm solution on SharePoint Server using Visual Studio. In the next article, we will see how to create a List/Library in SharePoint project using VS.

How To Upgrade The App In SharePoint Online

In previous articles we saw how to install the app/Client side webpart (SPFX). Before we upgrade the app in SharePoint site follow the following things

  • Ensure that you have changed the version for the app in app manifest file

    SharePoint

  • Then upload the .app file in app catalog (here you go for upload the app in app catalog)

When you upload the app again in appcatalog you will get the popup window like below, on pop up click the replace it button.

SharePoint

Once you complete the above steps, then follow the below listed steps to upgrade the app in SharePoint online site

Step 1

Go to your SharePoint site where you need to upgrade the app

SharePoint

Step 2

Go to site contents page using gear menu or left navigation as shown below

SharePoint

Step 3

On the site contents page you can see the app which is installed already,

SharePoint

Step 4

Then click on ellipse (…) to view the details of the app, on the pop-up click about as shown below

SharePoint

Step 5

On the about page we have the “GET IT” button, click the button to upgrade the app

SharePoint

Step 6

After you click “GET IT”, you will get the pop-up like below, then click “Trust it” to update the app,

SharePoint

Finally SharePoint hosted app will be updated on your site with the new version.

SharePoint

Summary

In this article we have explored how to upgrade the SharePoint hosted app in SharePoint online site

Change Your Profile’s Local Language In SharePoint Online

In this article, I would like to share the steps to change the language in SharePoint Personal Profile page.

  • SharePoint provides the option to see the display languages, country/regions, and time zone in our profile page.
  • If your organization allows it, we can also change our language and regional settings but these settings are applied only to our View of organization’s SharePoint site.

E.g. – If your organization has SharePoint Intranet site and you wish to see the profile page in your native language, you can change your language. It won’t affect the other users.

Steps

Follow the below listed steps to change the language in your personal profile.

Step 1

Open your SharePoint site.

SharePoint

Step 2 

Then, click on the profile image to open the profile pane, as shown in below.

SharePoint

Step 3 

From the “My Account” tab, select “About me” to navigate the profile page.

SharePoint

Step 4 

When you click “About me”, it will navigate to the profile page (DELVE) where you can change your settings.

SharePoint

Step 5 

On the delve screen, click on the “Update Profile” button as shown below. It will navigate to update the profile information page.

SharePoint

Step 6 

Then, scroll down the contact information page to see the “How can I see the language and regional settings?”

SharePoint

Step 7 

Click the link, when you click the link it will expand and show the “Click here, click the ellipsis (…) and then choose Language and Region.”

Then, click the “Click Here” to choose the language and region as shown in below image.

It will navigate to Edit Details page.

SharePoint

Step 8 

On the “Edit details” page, click on the ellipsis (…) to get “Language and Region” option.

SharePoint

Step 9 

Then, select the language from language section dropdown, as shown below.

SharePoint

Step 10 

Once you select the language (here I selected Spanish), click Add button to add the language.

SharePoint

Select the priority of the language by clicking on the up arrow.

SharePoint

Step 11 

Finally, click “Save and Close” button to save your selected language.

SharePoint

After you click the “Save and Close” button, it will show the pop-up like below. Then, click OK button.

SharePoint

After some time, you can see the profile page with selected language, as shown below.

SharePoint

Summary

In this article, we have explored how to change the local language in SharePoint online personal profile page.

Add Table Of Contents Webpart In SharePoint Online Site

What is Table of Contents?

  • TOC is used to display the navigation hierarchy of your site.
  • This webpart is a configurable component that we can add to the SharePoint pages
  • It automatically generates the SharePoint site map. Every time a page is added or removed from the site and every time a page is renamed or moved, TOC is updated automatically.

Steps

Follow the below steps to add the “Table of Contents” webpart in your SharePoint site page.

Step 1

Open your SharePoint site and go to the page where you want to add this webpart.

SharePoint
Step 2

Edit the page using ribbon bar, as shown below.

SharePoint
Step 3

On the edited page, click on “Insert” tab from the top ribbon.

SharePoint

Step 4

Then, click on the “Webpart” option and go to the Content Rollupcategory in webpart category section. Select “Table of Contents” here.

SharePoint

Step 5

Once you select “Table of Contents” webpart, click “Add” to add the webpart on your page.

SharePoint

Step 6

The “Table of Contents” webpart will be added on your page, as shown below.

SharePoint

Step 7

Then, edit the “Table of Contents” webpart and change the properties as you need. I’ve changed the level for this webpart. Once you complete the changes, click OK to save the properties.

SharePoint

Step 8

Finally, click the “Save” button to add this webpart on the page.

SharePoint

We can also Add, Edit, and Remove the links manually using Quick Launch “Edit Links” option.

SharePoint
Thus, we have successfully added the “Table of Contents” webpart on SharePoint Site.

SharePoint
Summary

In this article, we have explored how to add the “Table of Contents” webpart. Happy learning!

Add Excel Web Access Webpart In SharePoint Site

In this article, I would like to share the steps to add the Excel Web Access webpart in SharePoint online site

  • Excel Web Access web part is used to display the content in SharePoint page.
  • We can customize the webpart appearance and functionality of Excel web access webpart.
  • We can connect this webpart to other webparts for data analysis tasks like filtering and getting external data.

Steps

Follow the below listed steps to add the Excel Web Access webpart on your site.

Step 1

Open your SharePoint Site.

SharePoint
Step 2

Then, go to the page where you want to add this webpart.

SharePoint

Step 3

Edit the page using ribbon bar, as shown below.

SharePoint
Step 4

On the edited page, click on the “Insert” from your top ribbon, where you can see the webpart option.

SharePoint

Step 5

Click on the “Webpart” option and go to the “Business Data” Category in webpart category section, and select “Excel Web Access”.

SharePoint

Step 6

Once you select “Excel Web Access” webpart, click “ADD” to add the webpart on your page.

SharePoint

Step 7

Excel web access webpart will be added on your page, as shown below. Then, save your page.

SharePoint

Step 8

On the page click on “Click here to open the tool pane.” Link to customize the webpart appearances and add the workbooks. Then, click on the ellipse (…) button on the webpart properties to map the workbook.

SharePoint

Step 9

When you click on the ellipse (…), you will get the pop up as shown below. On the pop up, you can select the workbook from your document libraries.

SharePoint
Step 10

Click Insert button on the pop up window after selecting the workbook from the document library, and click “OK” on webpart property pane as shown below.

SharePoint
SharePoint

Finally, the workbook will be displayed on your SharePoint page. You can customize the webpart using property pane.
SharePoint

Summary

In this article, we have explored how to add the Excel web access webpart and how to connect the work book in SharePoint Online Site.

Re-index Site In SharePoint Online

In one of my articles, we saw how to Re-index the list in SharePoint Online.

  • Without writing any coding, we can do the re-index of SharePoint Site, list and document library.
  • When we are done with the crawling, the items will come up soon.

Here are the steps to re-index SharePoint Site.

Steps to re-index the site

Follow the steps given below to re-index SharePoint Online site.

Step 1

Open your SharePoint site.

SharePoint

Step 2

Now, go to site settings using the gear icon from your site.

SharePoint
Step 3

On the site settings page, select Search and offline Availability under Search section, as shown below.

SharePoint
Step 4

Now, select the option given below on your Search and offline Availability page and click re-index button in re-index site section.

Indexing Site Content. Specify whether this site should be visible in search results. If a site is not visible to search, then the content from that site and all of its subsites will not appear in the search results.

  • Indexing ASPX Page Content- The text of the items displayed on ASPX pages is often included in the search results. If the individual items on the pages on this site are secured by using permissions, which are more restrictive than the page itself, unauthorized users might see this restricted information in the search results.
  • Offline Client Availability- Specify whether this site should be available for offline clients.
  • Re-index site- Marking this site for re-indexing will enable this site to be picked up during the next scheduled search crawl.

    SharePoint

Step 5

Finally, click OK button to affect the changes on your site.

SharePoint
Summary

In this article, we have explored how to re-index SharePoint site manually in SharePoint Online. Happy searching.

Get Particular SP List Items Using Content Search WebPart (CSWP) in SharePoint Online

What is Content Search Webpart?

  • This Webpart is introduced in SP 2013. It is powerful.
  • Display content on your SharePoint pages by configuring simple and advanced queries in a Content Search Web Part.
  • One of the best feature in SharePoint Online will return the data very quickly compared to content query Webpart.
  • Content Search allows you to query and display the information from any site collection and beyond.

Steps

Follow the listed steps given below to add CSWP in your SP page.

Step 1

Open your SharePoint site.

SharePoint

Step 2

Now, go to the page, where you need to add CSWP.

SharePoint
Step 3

Edit the page by clicking the page tab on the top ribbon bar.

SharePoint
Step 4

On the click on the Add a Web part, after you clicked, you can see many categories.

SharePoint
Step 5

Select Content Rollup section. We can see the Content Search Webpart on the right side.

SharePoint

Step 6

Click Add button to add CSWP on your page.

SharePoint

Step 7

Finally, content search Webpart will be added on your page and it will show the recent items from your site.
SharePoint
Step 8

Now, edit the page and edit the Web part properties to configure the search Query.

SharePoint

Step 9

On the Webpart properties pane, click Change Query button under search criteria. After you clicked, you will get the pop up.

SharePoint

Step 10

In the pop up screen, click Switch to Advanced Mode to configure the query, as shown below.

SharePoint

Step 11

Now, select a Query result source, Keyword Filter and Property Filter.

  • Result Source – Local SharePoint results.
  • Keyword Filters – Only returns the lists and the libraries.
  • Property Filter – ListID , Manual Value.

Note

ListID is list GUID (take list GUID from the list settings URL).

SharePoint

Step 12

After you provided all the details, click Add Property Filter button and Test the Query. Click OK button.

When you click Test Query button, you will get the relevant results on the right side, as shown below.

SharePoint

Step 13

Now, do the property mappings on the Web part properties Window and click OK button.

SharePoint

Finally Content Search Webpart will be added on your page with the particular list items.

SharePoint

Summary

In this article, we have explored how to get the list items, using content search Webpart in SharePoint Online. Happy searching.

Add RSS Viewer Web Part In SharePoint Online

What is RSS?

  • Really Simple Syndication (RSS) is used for transmitting information across the internet and intranets
  • We can display the information from external sites by adding the RSS feed webpart in SharePoint page
  • We can use the RSS feed webpart to show the news, weather etc.

Before adding the RSs viewer webpart on the SharePoint page activate the below feature:

“SharePoint Server Standard Site Collection features’

SharePoint

Steps

Follow below listed steps to add RSS viewer Webpart,

Step 1

Open your SharePoint site

SharePoint

Step 2

Then open the SharePoint page where you want to add RSS viewer webpart

SharePoint

Step 3

On the page select the page tab from top ribbon bar as shown below

SharePoint

Step 4

Click on Edit to add the webpart,

SharePoint

Step 5

Then click “Add a webpart”, and select “Content Rollup” group from categories section

SharePoint

Step 6

Select “RSS viewer” webpart on right side and click on “Add” button

SharePoint

Step 7

After you clicked the ADD button “RSS Viewer” webpart will be added on your page as shown below,

SharePoint

Step 8

Then click “OPEN THE TOOL PANE” link, you will get the web part properties and add the URL in “RSS Feed URL” Text box as shown in below

SharePoint

Step 9

Finally Click “OK” button and save the page to show the feeds in the page

SharePoint

Successfully RSS feed webpart is added on our page

SharePoint
Summary

In this article we have explored what RSS viewer webpart is, how it’s used in SharePoint and how to add in SharePoint page