Upload a File with CSOM

2014-02-032014-11-30 Andy BurnsCSOM, SP2013 Development2 Comments

This is an example of how to upload a file with the C# Client Side Object Model (CSOM):

internal static File UploadFile(ClientContext clientContext, Web web, string filePath, Folder folder, string fileName, string title)
{
 string target = folder.ServerRelativeUrl + "/" + fileName;
FileCreationInformation fci = new FileCreationInformation();
 fci.Overwrite = true;
 fci.Url = target;
 fci.Content = System.IO.File.ReadAllBytes(filePath);
File uploadedFile = folder.Files.Add(fci);
 uploadedFile.ListItemAllFields["Title"] = title;
 uploadedFile.ListItemAllFields.Update();
 clientContext.ExecuteQuery();
if (uploadedFile.CheckOutType != CheckOutType.None)
 {
 uploadedFile.CheckIn("Initial Upload", CheckinType.MajorCheckIn);
 }
 clientContext.Load(uploadedFile);
 clientContext.ExecuteQuery();
 return uploadedFile;
}

Note that this method also lets you set a title for the document, as well as the file name, and it checks the document in for you if required.

What does TaxonomyItem.NormalizeName() do?

2014-02-012014-11-30 Andy BurnsCSOM, SP2010 Development, SP2013 Development, Taxonomy4 Comments

So, the client side application I’ve been working on has to sync a LOT of terms to the term store, and I’ve mentioned how I had problems with Managed Metadata labels and the ampersand – and how I fixed them using TaxonomyItem.NormalizeName().

Well, that was fine, but my application was slow – so I started looking at what I could do to eliminate client side object model calls (CSOM). My suspicion was that, as the function was static, it wasn’t doing anything that I couldn’t do in my application, and save a round trip to the server.

So, I opened up reflected and decompiled Microsoft.SharePoint.Taxonomy.dll. Inside I found the code for the following:

Regex _trimSpacesRegex = new Regex(@"s+", RegexOptions.Compiled | RegexOptions.IgnoreCase);
//Normalize name as Taxonomy Service does
string name = _trimSpacesRegex.Replace(termName, " ").Replace('&amp;amp;', 'uff06').Replace('"', 'uff02').Trim();

That’s much, much faster than a round trip to the server, and I learnt that speechmarks are also converted from ASCII to Unicode too.

Remote Event Receivers: Identify when a document's metadata is first completed

2014-01-312014-11-30 Andy BurnsEvent Receivers, RemoteEventReceivers, SP2013 DevelopmentLeave a comment

Document events are a perennial problem in SharePoint. This is, in part, due to the way documents are put into SharePoint:

You upload the document into SharePoint…
…which fires ItemAdded …
…then you complete the metadata…
…which fires item updated.

So, my problem was that our customer wanted an email sent when a document was first ‘added’ to SharePoint – except that by added they meant “Has been uploaded and it’s metadata completed for the first time”. While SharePoint does, technically, fire the correct events at the correct times, it’s pretty easy to see this ‘business event’ is probably more useful. Continue reading “Remote Event Receivers: Identify when a document's metadata is first completed” →

Managed Metadata Labels and the Ampersand character

2014-01-292014-11-30 Andy Burnsampersand, CSOM, SP2010 Development, SP2013 Development, Taxonomy, unicode1 Comment

I am writing an application to import/generate a number of terms in a term set. I started to get some errors about my code trying to add terms that already exist – but it does check for the existence of terms with a given name.

You can see that the string comparison for the name of the existing term and the term I want to get/create returns false, and that the terms seem to be different lengths. Well, I tried looking for blank spaces, non-printing characters, carriage returns, etc., and found nothing. Then I looked really closely at the ampersand characters shown in the debugger:

Yup, they’re different characters. You can see a slightly different shape to each of them – one is wider. Continue reading “Managed Metadata Labels and the Ampersand character” →

Timed Jobs in Azure Provider-Hosted Apps

2014-01-202014-11-30 Andy BurnsAzure, azure, claims, Office 365, ProviderHostedApps, scheduler, SharePointApps, SharePointOnlineCredentials, SP2013 DevelopmentLeave a comment

As I’ve described recently, I’m working on a Provider-Hosted SharePoint App that’s hosted in Azure. I’ve said previously about using Remote Event Receivers, and this whole app is really about sending emails from SharePoint Online (which we’re doing via SendGrid).

One of the things the customer wants is ‘timed’ emails – that is, some sort of service that talks to SharePoint Online, checks to see if there are any items in a list that are due for action, and if so sends an alert email. Simple enough, but with one minor problem. There are no timer jobs in SharePoint Apps. And you can’t put them into Office 365. And Azure doesn’t have an equivalent … yet. Continue reading “Timed Jobs in Azure Provider-Hosted Apps” →

What happens with a large TaxonomyHiddenList?

2014-01-172014-11-30 Andy BurnsCSOM, QueryThrottling, SP2010 Development, SP2013 Development, SPFieldLookup, TaxonomyLeave a comment

SharePoint’s Taxonomy (or “Managed Metadata”) fields are a bit strange in how they work. In a lot of ways they’re actually like a lookup field, and part of this lookup field is that site collections that use them have a hidden list – called TaxonomyHiddenList – in the root of the site collection. You can find it at /lists/TaxonomyHiddenList/.

Each term that is used in a Taxonomy field has it’s label (actually, labels) and other details kind of ‘cached’ in this list, and there is a timer job that will push changes to the terms out into these lists – and therefore to items that refer to the entries in the list. Continue reading “What happens with a large TaxonomyHiddenList?” →

Register Remote Event Receivers on the HOST web

2014-01-102014-11-30 Andy BurnsAzure, azure, Event Receivers, Office 365, ProviderHostedApps, RemoteEventReceivers, SP2013 Development2 Comments

The project that I’m working on requires that I add remote event receivers to the host web for my Provider-hosted app. This is a little unusual – most of the stuff I found about remote event receivers was using the app web. It turns out, though, that it is possible, and there is a good explanation of how it works by Johnny Tordgeman on CodeProject. Rather than repeat all he’s said, I suggest you take a look. I just want to expand on some of the things I learnt doing this, that he didn’t mention. Continue reading “Register Remote Event Receivers on the HOST web” →

App Deployment Error: "Your app handles the uninstalling app event"

2014-01-092014-11-30 Andy BurnsAzure, azure, Office 365, ProviderHostedApps, RemoteEventReceivers, SharePointApps, SP2013 Development3 Comments

When trying to do an F5-Deploy of a Provider hosted app from Visual Studio, I got this error during the deployment:

Error occurred in deployment step ‘Uninstall app for SharePoint’: Your app handles the uninstalling app event. Ensure that the Windows Azure Cloud Web Service project is deployed to the emulator prior to uninstalling the app.

This happened just after the step “Uninstall app for SharePoint” in the process. Continue reading “App Deployment Error: "Your app handles the uninstalling app event"” →

Handle your Provider Hosted SharePoint App 'App Installed' event

2014-01-092014-11-30 Andy BurnsProviderHostedApps, RemoteEventReceivers, SP2013 DevelopmentLeave a comment

I’m creating a Provider-hosted app, and I want to do some things when the app is installed/uninstalled. It isn’t immediately obvious how you set that up in VS2012. Continue reading “Handle your Provider Hosted SharePoint App 'App Installed' event” →

Andy Burns' Blog

Whatever I'm working on

SharePoint