M365 Conference Las Vegas December 2022

What a great conference!  It was interesting to see conferences coming back to the MGM Grand.  It looks like they combined 3 conferences together at once, Dev Intersections, M365, and AI.  Lots of great sessions on Microsoft Viva, Teams, SharePoint, and Power Platform including Power Automate and Power Apps.  Some really nice UI demos with MS Lists, inline approvals and bulk editing, emojis and animations.  I'll be updating this post as I go through my notes more.

By |2022-12-12T18:43:25+00:00December 12th, 2022|Uncategorized|0 Comments

Cleaning the cache on SharePoint On Prem servers

https://blogs.msdn.microsoft.com/jamesway/2011/05/23/sharepoint-2010-clearing-the-configuration-cache/ There were many common issues that could occur in WSS v3 and MOSS that would require you to clear the configuration cache on your servers. While less common, these issues can still turn up occasionally on SharePoint Server 2010 (And Foundation). While the resolution for these issues might be the same, the steps are a bit different. The main thing to note is that the Configuration Cache is located in a different directory on Windows Server 2008 then it was in Windows Server 2003. The new path for the Configuration Cache under Windows Server 2008 is: %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\ The overall steps remain largely the same: 1.Stop the Timer service. To do this, follow these steps: 1.Click Start, point to Administrative Tools, and then click Services. 2.Right-click SharePoint 2010 Timer, and then click Stop. 3.Close the Services console. 2.On the computer that is running Microsoft SharePoint Server 2010 and on which [...]

By |2022-12-12T15:21:07+00:00June 27th, 2018|Uncategorized|0 Comments

CSOM SharePoint Online error: The server does not allow messages larger than 2097152 bytes

If you get the following error with CSOM while trying  to upload documents to SharePoint Online: The server does not allow messages larger than 2097152 bytes The reason is that CSOM limits SharePoint Online to 2MB file uploads by default if using the "ReadAllBytes" method. Use the ContentStream property instead: public void UploadDocumentContentStream(ClientContext ctx, string libraryName, string filePath) { Web web = ctx.Web; // Ensure that the target library exists. Create it if it is missing. if (!LibraryExists(ctx, web, libraryName)) { CreateLibrary(ctx, web, libraryName); } using (FileStream fs = new FileStream(filePath, FileMode.Open)) { FileCreationInformation flciNewFile = new FileCreationInformation(); // This is the key difference for the first case - using ContentStream property flciNewFile.ContentStream = fs; flciNewFile.Url = System.IO.Path.GetFileName(filePath); flciNewFile.Overwrite = true; List docs = web.Lists.GetByTitle(libraryName); Microsoft.SharePoint.Client.File uploadFile = docs.RootFolder.Files.Add(flciNewFile); ctx.Load(uploadFile); ctx.ExecuteQuery(); } }   source: https://msdn.microsoft.com/en-us/pnp_articles/upload-large-files-sample-app-for-sharepoint    

By |2022-12-11T19:44:48+00:00May 23rd, 2017|Uncategorized|0 Comments

Datasheet View error and solution: The list cannot be displayed in Datasheet view for one or more of the following reasons

Error message: The list cannot be displayed in Datasheet view for one or more of the following reasons: - A datasheet component compatible with Microsoft SharePoint Foundation is not installed. - Your Web browser does not support ActiveX controls. - A component is not properly configured for 32-bit or 64-bit support.   Symptom: When trying to click datasheet view in SharePoint 2010 with Windows 10, IE 11, and  Office 2016 (Excel 2016 x64).   Solution: You just need to install the 32 bit Data Connectivity Components.  https://www.microsoft.com/en-us/download/details.aspx?id=23734  

By |2016-11-29T22:18:08+00:00November 29th, 2016|Uncategorized|2 Comments

Adding bootstrap apps inside a Page Viewer Webpart

Problem:  Adding a bootstrap app inside a page viewer web part in SP2010 causes the formatting to be messed up. Reason:  SP 2010 does not have the right compatibility mode required on the master page. Solution: Open the site in SharePoint Designer Copy the v.4 master page for the site to a new master page and add the following line as the first "meta" tag:  <meta http-equiv="X-UA-Compatible" content="IE=10" /> Click save as default master page on the ribbon.  Keep in mind this applies to all pages to the site.    

By |2014-12-18T18:58:58+00:00December 18th, 2014|Uncategorized|0 Comments

Cleaner List View Boxed style using jQuery

I'm sure we've all customized Lists in SharePoint to create different types of views. While most of the Styles to choose from aren't always practical, the Boxed view is an interesting view because it creates a Table along with a row of all your properties and values, for each List item. A common issue with this view is that if you have empty values, it takes up space on the screen and is too "ugly" to use. This is particularly true if your list or library is associated with many Content Types because different Content Types may not populate certain fields. There's also that hideous column/filter bar that doesn't seem to have any value on a view like this. By adding the jQuery below, you can make the Boxed view much more presentable. It will not display columns that have empty values or unchecked (yes/no) values. $("table.ms-listviewtable tr td.ms-stylebox table tr").each(function() { [...]

By |2022-12-11T19:44:48+00:00May 20th, 2014|Uncategorized|13 Comments

Accounting for Site / Subsite regional time zone settings

Often times, you will have custom web parts or code that write date values back to lists. In many cases, time zone settings are different across an organization and using DateTime.Now is generally not recommended. Two scenarios come to mind. #1, when a site changes its time zone to be different than the hosted servers' time zone. #2,  if a web part was deployed across a Site Collection and used in 5 different sub-sites with 5 different regional time zone settings. I found the best way to retrieve a date is this here: // time zone of site SPTimeZone siteTimeZone = SPContext.Current.Web.RegionalSettings.TimeZone; // currentTime will contain the current date and time according to the sites' time zone settings DateTime currentTime =  siteTimeZone.UTCToLocalTime(DateTime.Now.ToUniversalTime()); This will give you the current time in relation to the Site Regional Settings and will account for changes to the settings.

By |2014-05-17T00:24:53+00:00May 17th, 2014|Uncategorized|0 Comments

Powershell script to change Sharepoint Information Policy for large document libraries (over 1 million docs)

Ran into an issue on a SP2010 farm that had over a million documents in a document library with a hundred thousand folders. Yes, lots of data, but not a bad practice in this case as it was tied to another system that relied on the folders. In any case, I was unable to change information Policy on document library with many thousand folders due to SharePoint’s UI which creates a tree view of folders on the page to change the Information Policy. Not the best design. So as my browser crashed waiting for 100,000 folders to load, we came up with a Powershell script to accomplish this. This script will create an Information Policy to delete all documents inside the document library that are older than 180 days. It is applied to the content type, but is scoped to the document library itself. Other libraries on the site are [...]

By |2014-05-28T05:48:56+00:00April 29th, 2014|Uncategorized|1 Comment
Go to Top