Bojko Consult

Tag: SharePoint

  • Delete SharePoint List Items Permanently Using Power Automate in 3 easy steps

    Delete SharePoint List Items Permanently Using Power Automate in 3 easy steps

    Say you have a list in SharePoint with some data that you need to have deleted. The standard Flow action “Delete item” or “Delete file”, will actually delete the item, but only to the recycle bin. You need to use the Rest API to permanently delete the items If you have a lot of items,…

  • SharePoint – Create a view that only shows Minor Versions

    SharePoint – Create a view that only shows Minor Versions

    In SharePoint it’s actually not that easy to create a view that gives you all the minor or major versions of a document library. Out of the box, it doesn’t seems like you can create a calculated field, which are using the “Version” column. But it is perfectly possible, it’s just hidden from the choice…

  • The “SharePoint Timer Service” service terminated with the following service-specific error: Unspecified error

    The “SharePoint Timer Service” service terminated with the following service-specific error: Unspecified error

    In the event log every 2 minutes, this error pops up: A quick look at the Performance indicator, tells me that the CPU is not having it. Every 30 seconds or so, it maxes out. Most likely trying to restart the Timer service over and over. The solution seems to be to reset the config…

  • Moving versioned content to individual listitems in SharePoint

    Moving versioned content to individual listitems in SharePoint

    Often, it’s a good idea to version your content. And often it’s a good idea to simply, turn on versioning and the create a multiline field and selecting it to append the text. Thus creating a mini-log of something. But, when it comes to accessing that content across items, adding attachments on a log entry.…

  • SharePoint 2013 – Set executionTimeout value in web.config

    Standard SharePoint Timeout Values are set to 360 seconds (6 mins). But sometimes you can have a request for added timeout values. If for instance you have a need to upload large files on slow networks. You can set individual timeouts for all SharePoint application pages under the Layouts folder. You just need to edit…

  • Moving a SharePoint Document library to a new SiteCollection via PowerShell

    Case Recently I ran into a typical SharePoint problem. A SharePoint 2010 site exploded in storage usage. Users was uploading like crazy to one single document library and I needed to move the document library and a few lists to a new site on a new SiteCollection. The source site, was build on a SiteTemplate,…

  • Enable versioning on all SharePoint Document Libraries in a Site Collection

    Enabling versioning on all document libraries in a site collection or disabling versioning is often quite useful. Source

  • Office 365 shuts down public website feature

    Using Office 365 for a public website have always been a simple but not so sweet ride. Microsoft never got that one right and most likely, that is why they are discontinuing that part of Office 365. According to this support document existing websites will have two years to migrate and new tenants won’t have…

  • Formatting dates in Itemstyle.xsl

    Insert this line at the topxmlns:ddwrt=”http://schemas.microsoft.com/WebParts/v2/DataView/runtime” That will give you a header looking like this: <xsl:stylesheet version="1.0" exclude-result-prefixes="x d xsl msxsl cmswrt" xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" xmlns:cmswrt="http://schemas.microsoft.com/WebParts/v3/Publishing/runtime" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"> Then use the “ddwrt:FormatDate” to show the date i various ways: <xsl:value-of select=”ddwrt:FormatDate(@dato, 1030, 3)”/><xsl:value-of select=”ddwrt:FormatDateTime(string(@Publiceret), 1030, ‘dd. MMM. yyyy’)”/><xsl:value-of select=”ddwrt:FormatDate(string(@Dato), 1033, 7) “/> List of all…

  • Add ContentType to all documents in a SiteCollection using PowerShell in SharePoint 2013

    I came across a need to change all existing documents in a Site Collection to another ContentType, but without changing data like, “modified by” or “modified date”. Why? I need to attach a column to all documents and it’s just not good practise to add columns to the default “Document” ContentType. I need to add…

  • SharePoint Image Gallery that doesn’t suck in 7 easy steps

    [Update] I got an e-mail from Robert, who has refined the solution. Thank you for sharing Robert. Hi Ulrich,first I want to thank Ulrich for his great work and sharing it with us! I also don’t have the problem with more than 40 pictures in a picture gallery after using galleria-1.4.2.min.js and also galleria.classic.min.js from an…

  • Pop-up modal window SP2013

    Simple javascript command to open the dialog modal form function OpenPopUpPage(url, callback, width, height) function OpenPopUpPageWithTitle(url, callback, width, height, title) function OpenPopUpPageWithDialogOptions(dialogOptions) DialogOptions supports: Options Property Description title A string that contains the title of the dialog. url A string that contains the URL of the page that appears in the dialog. If both url and html are specified, url takes precedence.…

  • PowerShell – Create multiple SPWebs

    I often find myself in need of building a structure of SPWebs for demo purposes or for custom migrating scenarios. In order for me to build the structure fast, test it and then tear it down or extend it, I use PowerShell. Just extend the $url and the $name so they match your desire. Add-PSSnapin…

  • PowerShell – Create MySites for all users

    I found this script to be the most effective for creating MySites in advance for all users. #———————————————————————————#The sample scripts are not supported under any Microsoft standard support#program or service. The sample scripts are provided AS IS without warranty#of any kind. Microsoft further disclaims all implied warranties including,#without limitation, any implied warranties of merchantability or…

  • Import user profile pictures to SharePoint using PowerShell

    Best solution to create Automatic UserProfile Import to SharePoint Create folder “ImportProfileImages” Create subfolder “ProfileImages” Create “c:\SPSolutions\ImportProfileImages\UpdateUserProfiles.ps1” with the code from SharePoint Use Cases clsif((Get-PSSnapin | Where {$_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null) { Add-PSSnapin Microsoft.SharePoint.PowerShell;}#———————————————————————————# Default Values#———————————————————————————$spNotFoundMsg = "Unable to connect to SharePoint. Please verify that the site ‘$siteUrl’ is hosted on the local machine.";#—————————————————–#…

  • Force InfoPath to open in browserview

    A normal link to an InfoPath template could be /FormServerTemplates/template.xsn But in order to get pageviews in InfoPath to work in IE11, you have to add the domain in Compatibility View Settings, thus breaking the function of starting a new form in the browser, based on your template. The normal fix is to add ?clientinstalled=false…

  • Hide a text field in a SharePoint form using jquery

    If you have several SharePoint Forms, where you want to hide the input field and using SharePoint Designer to create a custom form is not an option. Here is my collection of jQuery you can insert, using the ScriptEditor webpart. Edit the “view” of a ListItem (DispForm.aspx) Open an element on the list, thus letting…

  • Create folder and copy a file to that folder in SharePoint Designer Workflow

    In this Video I will show how you can create a simple project folder and the copy a template file into that folder. The idea came from a comment on this blogpost, that shows more in-depth how to create folders and subfolders. If you like the video or have questions, leave me a note in…

  • August 2013 updates for Office 365 – Things just got bigger

    I have a hunch that Microsoft is sitting in  Redmond just thinking something along the lines of, “Let’s just give our customers more storage”. And so they did. The Office 365 is really starting to blow out the competition one-by-one. It will be interesting to see if Google will follow Microsoft’s lead and double their…

  • Javascript to create “New Page” like the one from Site Actions

    To create a link manually that have the same features as the one where you click on SiteActions and then “Create New Page”, you need some Javascript and some ModalDialog functions. How to use the links the Site Actions menu, is not all that documented. I actually had to get some help in order to…

  • Disable Mobile Redirect for SharePoint 2010

    SharePoint has always had a bit of a “Design Issue”. Let’s be honest. SharePoint has never been accused of being the hippest kid in the classroom. But the built-in design for displaying content on mobile devices is downright miserable. As a consequence I always recommend my clients to disable that and go for a responsive…

  • Mapping a networkdrive from SharePoint Document Library, finally fixed

    [[UPDATE: Links updated, thank you Saiful for pointing that out]] For months, it’s been a severe problem for the bulk of SharePoint Online (Office 365) customers. If you are running on Windows 7, while using the latest and greatest Internet Explorer (IE 10), you would experience problems whenever you try to map a network drive…

  • Error while executing web part

    Do you get this error in your ULS-log when visiting a page with a DataViewWebPart that’s been changed via SPD? Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object. Try and uninstall the Update: KB2844286 (Security Update for Microsoft .NET Framewok 3.5.1 on Windows 7 and Windows Server 2008…

  • SharePoint Group By Date using the CQWP in 4 Simple Steps

    If you have ever messed around with the XSL Itemstyles for use with the CQWP in SharePoint, you know how valuable they can be. Also how frustrating they can be from time to time. This is not as tricky as it may sounds. Out of the box, the Content Query WebPart (CQWP) does not support…

  • Sharepoint Designer 2010 subfolder workflow in 11 simple steps

    [ProjectCasemanagement solution] As a follow-up on my previous post, I’ve decided to make a short video demonstrating how to create a better solution. I still use the same method, but I’ve added some functions that makes it semi-dynamic. I say semi-dynamic because you’re still hardcoding the number of subfolders you want. It’s only the names of…