Joseph LeMay

Flush the BLOB Cache in SharePoint

Sometimes you upload an HTML or JS file to SharePoint, reload it in a web browser, and it still downloads the old version of the file. You delete the old file using the Web UI, upload the new file, and it STILL downloads the old version of the file. When this happens, you need toContinue reading “Flush the BLOB Cache in SharePoint”

What Kind of SharePoint Site do I have?

You might need to know if you’re working on a Team Site or a Publishing site, or some other kind of SharePoint Site. To check, do a “View Page Source” on any page in the site and search on “g_wsaSiteTemplateId” See the following post to find out what that template ID is https://www.technologytobusiness.com/microsoft-sharepoint/sharepoint-online-site-template-id

Deleting and recreating the SharePoint search index

If left on its own, the SharePoint on-prem search index will grow in size, seemingly, forever. When my server disk gets to around only 20Gb free, the search crawl will run forever, until I stop it. A couple of blog posts helped me delete and recreate the index. See https://vigneshsharepointthoughts.com/2016/12/15/resetting-search-index-in-sharepoint-2013/ and http://jcaspadmin.blogspot.com/2014/05/sharepoint-2013-content-index-reset.html. The following PowerShellContinue reading “Deleting and recreating the SharePoint search index”

Calculate Business Days between 2 SharePoint Dates

IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([StartDate],[EndDate],”d”)/7)*2-IF((WEEKDAY([EndDate])-WEEKDAY([StartDate]))<0,2,0)-IF(OR(AND(WEEKDAY([EndDate])=7,WEEKDAY([StartDate])=7),AND(WEEKDAY([EndDate])=1,WEEKDAY([StartDate])=1)),1,0)-IF(AND(WEEKDAY([StartDate])=1,(WEEKDAY([EndDate])-WEEKDAY([StartDate]))>0),1,0)-IF(AND(NOT(WEEKDAY([StartDate])=7),WEEKDAY([EndDate])=7),1,0)) The formula above, where [StartDate] and [EndDate] are SharePoint date columns, will calculate the difference in days and exclude Saturday and Sunday from the calculation. It will return a pure number. I got it from https://stackoverflow.com/questions/61346718/how-to-get-difference-between-two-dates-in-sharepoint-calculated-column

InfoPath form checked out for editing

Problem: You’re editing an InfoPath form and try to publish it back to a form library and receive the error “InfoPath cannot save the following form: http://%5Byoursharepointsite%5D/ The file http://%5Byoursharepointsite/listname%5D/forms/template.xsn is checked out for editing by [yourname]” Solution: Open SharePoint Designer and navigate to the form library in question under the “All Files” group. OpenContinue reading “InfoPath form checked out for editing”

InfoPath TextBox isn’t wrapping – fix

I’ve run into the issue documented in this thread where the text just falls off to the right hand side of a text box and you cannot see it, as in this screen shot where there is more text off to the right. The answer was found on the bottom of page 2 of theContinue reading “InfoPath TextBox isn’t wrapping – fix”

Exclude Disabled User Accounts during Active Directy Sync in SharePoint

Borrowed from https://social.technet.microsoft.com/Forums/sharepoint/en-US/32ee6549-9f45-4893-9a88-1b7b8ffa8f62/removal-of-disabled-ad-users-in-sharepoint-2010-user-profile credit to https://social.technet.microsoft.com/profile/maartensundman/ To filter/exclude users during imports, do the following: Go to Central Administration and under Application Management, click Manage service applications Click on the link to your User Profile Service Application Under Synchronization, click Configure Synchronization Connections Click on the connection you want to filter and select Edit Connection FiltersContinue reading “Exclude Disabled User Accounts during Active Directy Sync in SharePoint”

Current User and InfoPath

I know I shouldn’t be using InfoPath in 2021, but I’m still on a SharePoint 2013 on-prem installation, and I have few options. I could write my own HTML-and-JavaScript apps using a framework like Vue, but it would take a lot longer. Anyway, here is how to get the current user in an InfoPath form:Continue reading “Current User and InfoPath”

SharePoint BCS Create New Item error

After going through the steps to create an External Content Type using SharePoint Designer with a SQL Server back end, you create a new SharePoint list to display the a table, accepting all the defaults along the way. Read, Update, and Delete operations work OK, but when you try to add a new item, youContinue reading “SharePoint BCS Create New Item error”

PowerShell Word Truncate

Sometimes when you issue a PowerShell command, the result comes back truncated with “…” and you cannot see what’s being printed to the screen. Pipe the command through Format-Table to fix. For example in SharePoint Get-SPServiceInstance | Where-Object {$_.TypeName –eq ‘Central Administration’} becomes… Get-SPServiceInstance | Where-Object {$_.TypeName –eq ‘Central Administration’} | Format-Table -Wrap -AutoSize InContinue reading “PowerShell Word Truncate”