By default, the option to hide a calculated column for a content type is grayed out. Some people are able to use SharePoint Designer to hide these columns, but we kept running into an error when saving our changes. "This column already exists in the list. Choose a different column." The workaround, as always, was … Continue reading Hiding Calculated Columns from Display Form
PowerShell
SQLVDI and SQLWRITER Errors
Problem: The following errors appear in Event Viewer on a SharePoint 2013 server. Event 1, SQLVDI SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=2620. Thread=8476. Client. Instance=LOCALDB#E89AD36E. VD=Global\{0B738066-D3E2-437C-A844-8950BDDC6044}1_SQLVDIMemoryName_0. Event 24583, SQLWRITER Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft SQL Server Native … Continue reading SQLVDI and SQLWRITER Errors
Change Content Type With PowerShell
Objective: Change the content type of many files in a single library. Solution: Use the following PowerShell script to change the content type instead of editing each file one at a time. In my example, I change the content type from "Document" to "Process". Credit to Phil Childs' article for SharePoint 2010. The script also works … Continue reading Change Content Type With PowerShell
Newsfeed’s “SHOW MORE POSTS” Not Displaying More Posts
Issue: Clicking "SHOW MORE POSTS" on your site's feed does not display posts older than 7 days. Cause: The Newsfeed is configured to display posts that are available in the Feed Cache. By default, the feed cache only retains posts from the last 7 days. Any post older than that will not be displayed when … Continue reading Newsfeed’s “SHOW MORE POSTS” Not Displaying More Posts
Start Workflow on Inbound Email
By default, workflows will not auto start for attachments sent to a library via email. To enable this functionality, run the following PowerShell script on your SharePoint server. Next, make sure your workflow is configured to start automatically when an item is created.
Mass Delete Empty Folders With PowerShell
If you don't feel like manually deleting empty folders, use this PowerShell script to query and delete all empty folders and subfolders. Make sure you change the $WebURL to your SharePoint site or subsite, and the $listName to your library.
Internal Column Names
Document Library Fields: Display Name Internal Name GUID Type ID ID {1d22ea11-1e32-424e-89ab-9fedbadb6ce1} Counter Content Type ID ContentTypeId {03e45e84-1992-4d42-9116-26f756012634} ContentTypeId Content Type ContentType {c042a256-787d-4a6f-8a8a-cf6ab767f12d} Text Created Created {8c06beca-0777-48f7-91c7-6da68bc07b69} DateTime Created By Author {1df5e554-ec7e-46a6-901d-d85a3881cb18} User Modified Modified {28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f} DateTime Modified By Editor {d31655d1-1d5b-4511-95a1-7a09e9b75bf2} User Has Copy Destinations _HasCopyDestinations {26d0756c-986a-48a7-af35-bf18ab85ff4a} Boolean Copy Source _CopySource {6b4e226d-3d88-4a36-808d-a129bf52bccf} Text Approval Status … Continue reading Internal Column Names
Audit Web Part Locations
Through PowerShell, you can export a csv list of every single app and web part and the URLs where they exist. This is useful for keeping track of where apps are visible and who has access to them. The script will prompt you for the URL. Enter the entire URL of the top site collection site. For … Continue reading Audit Web Part Locations
Update List/Library Columns With External Content Type Columns
Scenario: You have a column on a custom list or library that needs to be back-filled with data from an External Content Type (ECT). Solution: Create a list from the ECT and use PowerShell to update your custom list's column with the ECT's list column. Creating a list (assuming you already connected an ECT): Open SharePoint Designer 2013 … Continue reading Update List/Library Columns With External Content Type Columns
Update All List Items Using PowerShell
Scenario: You added a new column and need to update that column for every item in a list or library. Solution: Here is an example PowerShell script that can be used to update one or more columns for every single item in a list. Remember: change $WebURL to the URL of the site or subsite … Continue reading Update All List Items Using PowerShell