SharePoint Dragons

Nikander & Margriet on SharePoint

Word to PDF using Word Services

We enjoyed this article http://msdn.microsoft.com/en-us/library/ff181518.aspx which explains how to convert Word documents to PDF using Word Services.

Remove SharePoint

This Wiki page describes how to remove SharePoint: http://social.technet.microsoft.com/wiki/contents/articles/11177.sharepoint-2010-best-practices-removing-sharepoint-from-servers.aspx

The steps are as follows:

1. Log in to each of the SharePoint servers in the farm

2. Run the SharePoint Configuration Wizard on each of the Web Front End servers and unjoin them from the farm. Provided no Web Apps were built outside of SharePoint’s control, they should be automatically deprovisioned along with the web sites.

3. Run the SharePoint Configuration Wizard on the App server, and choose to remove it as the last server in the farm.

4. Go into SQL Management Studio and remove the Configuration, Content, and Service Application Databases.

5. Rejoin servers and recreate the farm to your new specifications.

The datasheet view is greyed out and the Open With Explorer button is gone too

What’s the matter when the datasheet view of a list is greyed out? And what’s up with the missing Explorer button? This is totally unrelated to the fact whether Office was installed or not and which version. It is related to two things:

  • The currently used browser needs to be MSIE.
  • It needs to be the 64 bit version.

SharePoint uses JavaScript to check this, and if you don’t meet these prerequisites, you won’t see the datasheet view or Open with Explorer button.

SharePoint 2010 Best Practice Overview Page

The SharePoint 2010 Best Practice Overview page just underwent a major overhaul and here’s the result: http://social.technet.microsoft.com/wiki/contents/articles/8666.sharepoint-2010-best-practices-en-us.aspx

SPUtility.SendEmail() limit

The SPUtility.SendEmail() method has a limit of the max number of characters on a single line: 2048. However, you can divide the message body in chunks of several lines, thereby circumventing the maximum: http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/a0292b6b-e412-4ccb-910d-1df90f90d5d9. Alternatively, you can send emails directly, using code like this:

System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
message.From = new System.Net.Mail.MailAddress(objWeb.Site.WebApplication.OutboundMailSenderAddress);
message.To.Add(new System.Net.Mail.MailAddress(objTcnlSite.AcmaEmail));
message.Subject = Subject;
message.Body = Body;
message.IsBodyHtml = true;
System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient(objWeb.Site.WebApplication.OutboundMailServiceInstance.Server.Address);
smtpClient.UseDefaultCredentials = true;
smtpClient.Send(message);
smtpClient = null;
message.Dispose();

Wikis just may be your best bet

Margriet is a regular TechNet Wiki contributor. Read more about how Wikis can help you placing the right bets in SharePoint projects on Margriet’s first post as a Wiki Ninja on the Official Blog of TechNet Wiki: http://blogs.technet.com/b/wikininjas/archive/2012/05/20/wikis-just-may-be-your-best-bet.aspx

Wiki Community Win

Asset vs Picture library revised

The Asset vs Picture library TechNet Wiki article has been revised. You can find the latest version here: http://social.technet.microsoft.com/wiki/contents/articles/8110.sharepoint-2010-best-practices-asset-vs-picture-library-en-us.aspx

Working with large files

Sometimes we come across an article we’ve written in the past and think: “Hey, this is quite good and still applies!” This is the case with http://www.loisandclark.eu/Pages/largefiles.aspx , it discusses tips and tricks for working with large files.

ULS in logging database

You can use the logging database to store ULS logs, check http://www.oriolardevol.com/Article/Details/36. See http://www.oriolardevol.com/Article/Details/Sharepoint%20Logging%20database%20-%20ULS%20Trace%20tables,%20how%20they%20work for info on how it is stored. Consolidated storage and access to the ULS is a huge benefit, and also makes querying it a lot easier. In addition, the logging db also contains other useful info such as DMVs and performance counters:http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=124