Miles

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

 

 

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 |November 29th, 2016|Uncategorized|0 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 |December 18th, 2014|Uncategorized|0 Comments|
  • ps
    Permalink Gallery

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

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 [...]

By |April 29th, 2014|Uncategorized|0 Comments|

SharePoint List ID and View ID Calculator

Simply paste the Url from the “Modify View” page in SharePoint and it will generate the List ID and View ID for you.

 

List ID:      
View ID:     

 

I got tired of doing this in notepad, so I built this as an easy way to get a SharePoint List ID or View ID from a Url.

For the list ID, go to List Settings, and copy the Url, and paste the url in the box.
For the list ID and the View ID, go to a list view, and click “Modify View,” and copy the url in the box.

Paste the url in the box and press ‘Submit’