Synchronize Between SharePoint Lists and Microsoft Excel

Requirement: End-User has an Excel file, wants to create a SharePoint list with data from Excel file, and Synchronize between SharePoint Lists and Microsoft Excel. Fairly Simple, The very first option that comes to our mind is: Import Spreadsheet,  isn’t it? nope, That can be used to Create List and import data…

Read more

Creating Custom Timer Job for Automations in SharePoint

Business Scenario: We have a Project collaboration environment with 5000+ site collections. This environment has been primarily used for managing project artifacts by various teams. Every day, We – Admin Team, gets a lot of requests to create site collections, Change Owners of the site collections, Increase the Site quota for the…

Read more

SharePoint Content Type IDs – How to Find / Create?

SharePoint Content Type IDs – Reference: Here is the reference for SharePoint 2010 Parent content type id format: Content Type ID  System 0x  Item 0×01  Document 0×0101  Event 0×0102  Issue 0×0103  Announcement 0×0104  Link 0×0105  Contact 0×0106  Message 0×0107  Task 0×0108  Workflow History 0×0109  Post 0×0110  Comment 0×0111  East Asia Contact 0×0116…

Read more

SharePoint Content Databases Size – Storage Report using PowerShell

Requirement: Get content database size in SharePoint using PowerShell How to check SharePoint content database size? Have you ever wondered how to get the size of a content database in SharePoint? Well, This post will demonstrate how to get the size of a content database in SharePoint using PowerShell. As noted by…

Read more

Display PDF Files in Content Editor Web Part

We can display PDF files inside content editor web part. Here is how:add a Content Editor web part to the page and place the object tag as below in HTML Source of the content editor web part. Using Object Tag to display PDF document in CEWP: <object width=”400″ height=”500″ type=”application/pdf” data=”https://sp10.Crescent.com//MCM/Documents/Pre-Reads.pdf?#zoom=75&scrollbar=1&toolbar=1&navpanes=1″ id=”pdf_content”>…

Read more

Adding Custom Properties to SharePoint Advanced Search

Requirement: We had a metadata column called “Service” in many document libraries & lists. End-users wanted to perform Searches based on the metadata column. Solution: We can add custom properties to SharePoint’s Advanced Search page by following these  steps:                      A. Add Metadata Property Mapping                      B. Customize Advanced Search                      C. Trigger Full Crawl…

Read more