wiliammbr's blog

Some thoughts on programming stuff

Category: Best Practices

Export list in SharePoint via PowerShell

February 3, 2021 / / 3 Comments

SharePoint lists are very powerful and we often need to export list data for our customers. One of the best option to achieve that is by PowerShell. So in this blog post we will cover how to export list in SharePoint via PowerShell. After exported to CSV, it’s easy to convert to an Excel format and do whatever you want. It’s important to say that this script will work on SharePoint Server On-Premises and you will need to enter the server to run it.

But why using a PowerShell if we can do that by the UI? Well, I need to agree with you. What I can answer about that? Basically, you can schedule exporting activities, you can take leave the script running on long lists without short timeouts, etc.

A SharePoint list - Export list in SharePoint via PowerShell
A SharePoint list (PowerApps blog)
Continue reading

Update SEO Properties in SharePoint programmatically

September 8, 2019 / / 0 Comments

Last month, I had to make a bulk update of SEO properties from Pages in one of our customers website that runs SharePoint 2016. Basically we needed to update every property that was empty based on an Excel spreadsheet. This file defined the Keywords and Meta Descriptions for each area of the site. In this post I’m going cover how to update SEO Properties in SharePoint programmatically!

Continue reading

Canonical Tags in SharePoint

June 10, 2019 / / 0 Comments

Since its 2013 version, Canonical Tags in SharePoint are supported by default if you enable the Publishing Feature. You can also use Managed Navigation to have Friendly URLs and make your canonical tags look awesome!

These Canonical URLs are important to help Search Engines on their task for categorization, simplifying tracking metrics and consolidating links and references that may have different URL formats, but point to the same page. You can find more info in this post.

Continue reading

Optimize your SharePoint dev environment

April 5, 2018 / / 0 Comments

If you optimize your SharePoint dev environment, you will be more productive. We must agree that SharePoint demands a lot of resources to run smoothly, which usually is not the case of common standalone installations used by developers to code and test.

In this post I’m going to cover some basic settings that will help on your mission to optimize your SharePoint development environment, performing better when debugging, browsing and customizing your SharePoint on-premises projects.

Continue reading

SPQuery best practices in SharePoint

July 15, 2017 / / 1 Comment

This post will cover SPQuery best practices in SharePoint due to my recent experience with customers complaining about the performance of their SharePoint sites. This problem collaborated to create a bad impression of the product. “The page takes too long to load” or “Web Parts with pagination are terrible” were some of their complaints.

After the first contact with them, I usually asked for the source code to find out what was happening and do some troubleshooting. It didn’t take too much to find out that almost every case had performance issues due to queries being made with the SPList.Items property and followed by some LINQ query to filter the data.

Continue reading

FOLLOW ME

© 2024 wiliammbr's blog

Theme by Anders Noren — Up ↑