Skip Ribbon Commands
Skip to main content

Mark Overdijk | zevenseas | SharePoint Blog

:

Home
October 26
I'm a Speaker at SharePoint Connections Amsterdam 2011

Just received the speaker contract! Come see me and Mark van Lunenburg talking about Socializing SharePoint! 

Wednesday 23rd of November 2011, 09:30 - 11:15 hours, Room 2

i'm-a-speaker.gif

August 29
Creating publishing pages with powershell in SharePoint2010

​For a client we created an extended powershell script to do an One-Click deployment of their intranet. This was awesome to create because it really saved huge amounts of time creating sites & site collections, adding and activating solutions and setting permissions, navigation and master pages. 

But we still had to add a piece of code to create pages in the Pages Library. After a quick search, I came across this blogpost of Brendan Newell. It helped me out greatly! It just missed 1 crucial element; setting the page title. So I added this to his script. They were minor changes (in bold), so all credits go to Brendan.

Powershell Script;

# Read in list of pages from XML

[xml]$pagesXML = Get-Content “pages.xml”

if ($pagesXML -eq $null) { return }


# Get publishing web

$site = New-Object Microsoft.SharePoint.SPSite($server1)

$web = $site.rootweb

$pWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web)


# Loop through each page node to extract filename and titlename

$pagesXML.Pages.Page | ForEach-Object {

    $fileName = [string]$_.FileName

    Write-Host “Creating $fileName”

    $titleName = [string]$_.TitleName

    Write-Host “Creating $titleName” 


    # Create blank page

    $newPage = $pWeb.AddPublishingPage()

    $newPage.Update()


    # Update the filename to the one specified in the XML

    $newPage.ListItem["BaseName"] = $fileName

    $newPage.ListItem["Title"] = $titleName

    $newPage.ListItem.SystemUpdate()


    # Check-in and publish page

    $newPage.CheckIn(“”)

    $newPage.ListItem.File.Publish(“”);

}


# Dispose of the web

$web.Dispose()​


XML Structure;

<?xml version="1.0" encoding="utf-8"?>

<Pages>

  <Page>

    <FileName>P1</FileName>

    <TitleName>Page One</TitleName>

  </Page>

  <Page>

    <FileName>P2</FileName>

    <TitleName>Page Two</TitleName>

  </Page>

</Pages>


August 25
List view Lookup threshold in Office365

I created a list which uses 12 Person or Group fields. So I changed the resource throttling in Manage Web Applications > General Settings in Central Admin. Customer happy, so I'm happy too.

Now we have to the move this list to Office365 because their intranet is moving to the cloud. But changing the resource throttling settingis not possible in Office365 (yet?). So now we have to create a new solution.

So keep in mind when working with Office365, you can't change the list view lookup threshold.


*UPDATE*; waiting for reaction Microsoft if the settings will be made available in the future


*UPDATE 20110829*; Microsoft Customer Support has confirmed that the settings will not be available as of yet, but this may change in the future...


August 22
SharePoint Server 2010 performance and capacity test results and recommendations

​Quick post about a selection of white papers I came across. It's a complete of white papers and articles focussed on performance and capacity test results for SharePoint Server 2010;

Subject Description

Access Services

Provides guidance on how using Access Services impacts topologies running SharePoint Server 2010. View the article at Estimate performance and capacity requirements for Access Services in SharePoint Server 2010.

Business Connectivity Services

This article provides performance and planning guidance and discusses the impact of using Business Connectivity Services in Microsoft SharePoint Server 2010. View the article at Estimate performance and capacity requirements for Microsoft Business Connectivity Services in SharePoint Server 2010.

Caches overview

Provides information about how the three SharePoint Server 2010 caches help the product scale and grow to meet the demands of your business application. Download this white paper (SharePointServerCachesPerformance.docx).

Excel Services in Microsoft SharePoint Server 2010

Provides planning guidance for Excel Services in Microsoft SharePoint Server 2010. View the article at Estimate performance and capacity requirements for Excel Services in SharePoint Server 2010.

InfoPath Forms Services

Provides guidance on the footprint that use of InfoPath Forms Services has on topologies running SharePoint Server 2010. View the article at Estimate performance and capacity requirements for InfoPath Forms Services in SharePoint Server 2010.

Large lists

Provides guidance on performance of large document libraries and lists. This document is specific to SharePoint Server 2010, although the throttles and limits that are discussed also apply to Microsoft SharePoint Foundation 2010. View the article at Designing large lists and maximizing list performance (SharePoint Server 2010).

Large-scale document repositories

Provides guidance on performance of large-scale document repositories in regards to SharePoint Server 2010. Download this white paper(LargeScaleDocRepositoryCapacityPlanningDoc.docx).

Managed metadata

Provides guidance on how to perform sizing and performance optimization of the managed metadata service in SharePoint Server 2010. View the article at Estimate capacity and performance for enterprise managed metadata in SharePoint Server 2010.

My Sites and social computing

Provides guidance on the footprint that use of My Sites and other social computing features has on topologies running SharePoint Server 2010. Download this white paper(MySitesSocialComputingCapacityPlanningDoc.docx).

Office Web Apps

Provides guidance on the footprint that use of Office Web Apps has on topologies running SharePoint Server 2010. Download this white paper(OfficeWebAppsCapacityPlanningDoc.docx).

PerformancePoint Services

Provides guidance on the footprint that usage of PerformancePoint Services has on topologies running SharePoint Server 2010. View the article at Estimate performance and capacity requirements for PerformancePoint Services.

Search

Discusses capacity planning for different deployments of SharePoint Server 2010 search, including small, medium, and large farms. View the article at Estimate performance and capacity requirements for SharePoint Server 2010 Search.

Visio Services

Provides guidance on the footprint that use of Visio Services has on topologies running SharePoint Server 2010. View the article at Estimate performance and capacity requirements for Visio Services in SharePoint Server 2010.

Web Analytics

Provides guidance on the footprint that use of the Web Analytics service has on topologies running SharePoint Server 2010. View the articles at Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010.

Web Content Management

Provides guidance on performance and capacity planning for a Web Content Management solution. View the article at Estimate performance and capacity requirements for Web Content Management in SharePoint Server 2010.

Word Automation Services

Provides capacity planning guidance for Word Automation Services in SharePoint Server 2010. Download this white paper (WASCapacityPlanningDoc.docx).

Workflow

Provides guidance on the footprint that usage of Workflow has on topologies running SharePoint Server 2010. View the article at Estimate performance and capacity planning for workflow in SharePoint Server 2010.​

These docs are on my reading list this week, because performance is one of the key factors in user adoption. Knowledge is power!

Download link for 7 white papers feature specific for SharePoint Server 2010

July 07
SharePoint webservices overview

I was going through the different webservices that are available for SharePoint at the MSDN site, just to get an overview of the possibilities. And the overview wasn't there. If you want to see the different classes for a service, you need to click through and when you need more info on that class, you would need another mouse click. It got a bit time consuming, so I gathered all the information and put it in an excel file. And now it's up on the web. Hopefully it'll help you too when you're searching for classes or are in need of an complete overview.

 

 

Webservice Description Access MSDN Classes
SharePoint Foundation 2010 Web Services        
WebSvcAdmin Provides methods for managing a deployment of SharePoint Foundation, such as for creating or deleting sites. /_vti_bin/PSI/Admin.asmx Link… Admin; ADSyncERPSettings; ADSyncGroupSettings; DepartmentsDataSet; DepartmentsDataSet.DepartmentsDataTable; DepartmentsDataSet.DepartmentsRow; FiscalPeriodDataSet; DepartmentsDataSet.DepartmentsRowChangeEvent; FiscalPeriodDataSet.FiscalPeriodsDataTable; FiscalPeriodDataSet.FiscalPeriodsRow; FiscalPeriodDataSet.FiscalPeriodsRowChangeEvent; FiscalYearDataSet; FiscalYearDataSet.FiscalYearsDataTable; FiscalYearDataSet.FiscalYearsRow; FiscalYearDataSet.FiscalYearsRowChangeEvent; StatusingSettingsDataSet; StatusingSettingsDataSet.StatusingSettingsDataTable; StatusingSettingsDataSet.StatusingSettingsRow; StatusingSettingsDataSet.StatusingSettingsRowChangeEvent; TimePeriodDataSet; TimePeriodDataSet.TimePeriodsDataTable; TimePeriodDataSet.TimePeriodsRow; TimePeriodDataSet.TimePeriodsRowChangeEvent; TimesheetAuditExportDataSet; TimesheetAuditExportDataSet.AuditExportsDataTable; TimesheetAuditExportDataSet.AuditExportsRow; TimesheetAuditExportDataSet.AuditExportsRowChangeEvent; TimesheetLineClassDataSet; TimesheetLineClassDataSet.LineClassesDataTable; TimesheetLineClassDataSet.LineClassesRow; TimesheetLineClassDataSet.LineClassesRowChangeEvent; TimeSheetSettingsDataSet; TimeSheetSettingsDataSet.TimeSheetSettingsDataTable; TimeSheetSettingsDataSet.TimeSheetSettingsRow; TimeSheetSettingsDataSet.TimeSheetSettingsRowChangeEvent; UnsubmittedTimesheetDataSet; UnsubmittedTimesheetDataSet.TimePeriodsDataTable; UnsubmittedTimesheetDataSet.TimePeriodsRow; UnsubmittedTimesheetDataSet.TimePeriodsRowChangeEvent; VersionsDataSet; VersionsDataSet.VersionsDataTable; VersionsDataSet.VersionsRow; VersionsDataSet.VersionsRowChangeEvent
WebSvcAlerts Provides methods for working with alerts for list items in a SharePoint Foundation site. /_vti_bin/Alerts.asmx Link… Alerts; DeliveryChannel; EmailChannel
WebSvcAuthentication Provides classes for logging on to a SharePoint Foundation site that is using forms-based authentication. /_vti_bin/Authentication.asmx Link… Authentication
WebSvcBdcAdminService Provides methods that can be used to import and export Business Data Connectivity Services (BDC) models. /_vti_bin/Bdcadminservice.svc Link… BusinessDataCatalogSharedServiceClient; PackageFormatExceptionState
WebSvcCellStorage Enables client computers to synchronize changes made to shared files that are stored on a server. /_vti_bin/CellStorage.svc Link… CellStorageClient
WebSvcCopy Provides methods for copying items between locations in SharePoint Foundation. /_vti_bin/copy.asmx Link… Copy; CopyResult; FieldInformation
WebSvcdiagnostics Enables client computers to submit diagnostic reports that describe application errors that occur on the client. /_vti_bin/diagnostics.asmx Link… SharePointDiagnostics
WebSvcDspSts Provides a method for performing queries against lists in SharePoint Foundation. /_vti_bin/DspSts.asmx Link… AllFields; Authentication; DataRoot; DspQuery; DSQuery; Field; Fields; OrderField; PTQuery; QueryRequest; RequestHeader; ServerParameter; ServerParameterInfo; StsAdapter; Versions
WebSvcDWS Provides methods for managing Document Workspace sites and the data they contain. /_vti_bin/dws.asmx Link… Dws
WebSvcForms Provides methods for returning forms used in the user interface when working with the contents of a list. /_vti_bin/forms.asmx Link… Forms
WebSvcImaging Provides methods that enable you to create and manage picture libraries. /_vti_bin/imaging.asmx Link… Imaging
WebSvcLists Provides methods for working with lists and list data. /_vti_bin/Lists.asmx Link… Lists
WebSvcMeetings Provides methods that enable you to create and manage Meeting Workspace sites. /_vti_bin/Meetings.asmx Link… Meetings
WebSvcPeople Provides methods for working with security groups. /_vti_bin/people.asmx Link… People
WebSvcPermissions Provides methods for working with the permissions for a site or list. /_vti_bin/Permissions.asmx Link… Permissions
WebSvcSharedAccess Provides a method that determines whether a document is being coauthored. /_vti_bin/sharedaccess.asmx Link… SharedAccess
WebSvcsharepointemailws Provides methods for remotely managing distribution groups. /_vti_bin/Sharepointemailws.asmx Link… RequestInfo; RequestResponse; SharepointEmailWS
WebSvcSiteData Provides methods that return metadata or list data from sites or lists in SharePoint Foundation. /_vti_bin/Sitedata.asmx Link… SiteData
WebSvcsites Provides methods for working with Web sites. /_vti_bin/Sites.asmx Link… FormDigestInformation; Sites; Template
WebSvcspsearch Provides methods for remotely performing searches within a SharePoint Foundation deployment. /_vti_bin/spsearch.asmx Link… QueryService
WebSvcUserGroup Provides methods for working with users and groups. /_vti_bin/UserGroup.asmx Link… UserGroup
WebSvcVersions Provides methods for managing file versions. /_vti_bin/Versions.asmx Link… Versions
WebSvcviews Provides methods for working with list views. /_vti_bin/Views.asmx Link… Views
WebSvcwebpartpages Provides methods to send and retrieve Web Part information to and from Web services. /_vti_bin/Webpartpages.asmx Link… WebPartPagesWebService
WebSvcWebs Provides methods for working with Web sites and content types. /_vti_bin/Webs.asmx Link… Webs
Sharepoint server 2010 web services        
WebSvcOrganizationProfileService Provides an interface for remote clients to read and create organization profiles. (-) Link… ContactData; OrganizationProfileData; OrganizationProfileService; PropertyData;PropertyInfo; SchemaPropertyData; SLProfileData; ValueData
WebSvcPublishedLinksService Provides a published links interface for remote clients to read and create published links. /_vti_bin/PublishedLinksService.asmx Link… PublishedLinksService; ServerLink
WebSvcSearch Provides methods that can be used to remotely query SharePoint Server search. /_vti_bin/search.asmx Link… QueryService
WebSvcSocialDataService Provides an interface for remote clients to read, create, and manipulate social data. /_vti_bin/socialdataservice.asmx Link… DeletedSocialCommentDetail; DeletedSocialDataDetail; DeletedSocialRatingDetail; FeedbackData; SocialCommentDetail; SocialDataDetail; SocialDataService; SocialRatingAverageDetail; SocialRatingDetail; SocialReplicationData; SocialTagDetail; SocialTermDetail; SocialUrlDetail; TermDetail
WebSvcUserProfileChangeService Provides a user profile interface for remote clients to read and create user profiles. /_vti_bin/UserProfileChangeService.asmx Link… ProfileBaseChangeQuery; UserProfileChangeData; UserProfileChangeDataContainer; UserProfileChangeQuery; UserProfileChangeService; userProfileChangeToken
WebSvcUserProfileService Provides a user profile interface for remote clients to read and create user profiles. /_vti_bin/UserProfileService.asmx Link… ContactData; GetUserProfileByIndexResult; InCommonData; MemberGroupData; MembershipData; OrganizationProfileData; PinnedLinkData; PropertyData; PropertyInfo; QuickLinkData; SPTimeZone; UserProfileService; ValueData
         
         
Reference; MSDN http://msdn.microsoft.com/en-us/library/ee705814.aspx
June 06
Increase your resource usage quota in Office365

The default resource usage quota in Office365 is set to “0″. Which is not very useful when deploying solutions and trying to activate them. Today I wanted to test some solutions on the Office365 platform and hit this wall.
Usually you would access the farm configuration and increase/change the resource usage quota. But how do you access this option in Office365?
First add “-admin” to your username of the web app url. The default URL is “https://[username].sharepoint.com”. Now change the URL to “https://[username]-admin.sharepoint.com/” to access the sort-of farm configuration screen called Administration Center;



Choose the “Manage site collections” option to configure the different Office365 site collections.


Select the site collection you want to increase the resource usage quota for and click on the corresponding icon.
 

 
Enter the new quota and click save.
 

Now you’ll be able to activate your solution. Enj0y!
(Still don’t have an office365 account? Visit office365.com to join the beta)

 

May 10
Getting the DisplayName for a SharePoint Site Feature

To roll out a complete site structure (5 site colls + 30 sites) fast and identically onto 2 servers, I created a Powershell script (New-SPSite & New-SPWeb). No problems here. But we would also need the site feature SharePoint Server Publishing Infrastructure to be enabled. Which isn't a problem with Enable-SPFeature when you know the DisplayName. Which I didn't :(

How to get the displayname?

Well you could use the Get-SPFeature command, but that just generates a complete list (check below) of all features by DisplayName and ID. This doesn't help, because I don't know what the displayname is, I only know the site feature name used in the Site Collection Features screen within Site Settings.

screen1.jpg 

 

I was trying to figure out how to get the DisplayName for the site feature. I tried Google several times; "DisplayName SharePoint Server Publishing Infrastructure" & "enable-spfeature -identify SharePoint Server Publishing Infrastructure" & "get displayname for site collection features"... It got me nowhere. 

Then my awesome collegue Mark van Lunenburg told me I should use SharePoint Manager 2010 [codeplex]. And he was right! This was precisely what I was looking for.

1. Start up SharePoint Manager 2010

2. Navigate; Content Service > Web Applications > {Server} > Site Collection > {Server url} > Site Features

3. Click on the Site Feature by SharePoint Site Settings title

4. Check out the DisplayName in the Properties window on the right (see also picture below)

So never again am I searching for a site feature displayname. 

 

screen2.jpg



April 22
Choose your Office365 wisely

There are three versions for Office365; Small Business, Enterprise and Education. I'm leaving out Office365 for Education, for it's a version for Education only. 
The Enterprise edition comes in 4 flavors (E1 - E4), while there's only 1 Small Business plan (P1). However both versions are very similar, there are some differences, which can have a huge impact.

Why two versions?
Simply said, there's one version for small businessess (<25 employees and no IT dept.) and one for big(ger) companies. Hence the original names; Small Business and Enterprise.
The small business version is the "cheap" version. This "lite" version is a stripped down Office365 with most functionality and the benefit of being much cheaper. Below I've summed up most differences between the small business and enterprise edition.

Active Directory
The Small Business version will not support Active Directory Sync. If you need this functionality, you will have to choose one of the 4 Enterprise flavors.

BES support
The small business edition doesn't feature BES (Blackberry Enterprise Server).

Users
The small business version has a maximum number of users of 50. Need more? Please upgrade to the Enterprise edition.

Microsoft Office
Both versions will have the Office WebApps included. But only the Enterprise edition will also feature Office Professional Plus.

Advanced archiving
If your company needs advanced archiving features, like e-mail archiving for legal compliance, you are in need of the Enterprise edition.

Support
The small business version features full community support. If you're in need of full 24/7 phone support, you will have to get the Enterprise edition.

Indiana Jones
Yes, be like Indie and choose wisely. Ask yourself the next questions if you own a small business and want to move to the cloud. Can you really afford to lose full phone support, AD sync and advanced archiving? Or do I want to move everything to the cloud cheaply, get rid of on-premise servers and don't need Big Corp features. 
Sure it's no life or death decision, but it's nice to start of the right track instead of having to upgrade after 3 months.


April 21
Released; Office365 Beta Deployment guide for Enterprises

As you all may know, the Office365 Beta has gone public. Together with this release of the Beta, Microsoft has also released the deployment guide for Enterprises.

Read the blogpost below in which the guide was released, posted at the Office365 Community website;
"We are excited to announce that the “Microsoft Office 365 Beta Deployment Guide for Enterprises’ is now available on the Community Portal.
The Beta version of Office 365 for enterprises and this deployment guide are still in development and are subject to change during the beta period and at the time of general availability (GA). Please check back for updated versions as we incorporate feedback.
Please feel free to send feedback and suggestions to modgfdbk@microsoft.com.
About the document
This document presents the Office 365 Beta for enterprises deployment process in a manner that explains both important deployment concepts as well as detailed procedures. It is also intentionally organized into the sections that provide specific types of information to specific types of people in your organization. Here is a quick overview of what you will find:
  • Deployment Overview section. This material provides the high-level look at the deployment and organizational requirements to deploy Office 365 Beta for enterprises. It has valuable information for your IT decision-makers, program managers, and technical implementation leads.
  • Plan and Prepare sections. These sections describe the particular tasks and activities required to get ready and fully implement your Office 365 Beta for enterprises deployment. They are generally presented in the order in which you address them during your deployment. Topics discussed in the Plan section generally reappear in the Prepare section with instructions for carrying out the task. Within both sections is content that will concern specific subject matter experts in your organization.
  • Migrate section. This section describes the steps for moving your users’ mailboxes to Office 365 Beta for enterprises so you can begin using the Office 365 Beta services as part of your production environment.
This deployment guide does not address Office 365 Beta for enterprises sales activities that occur before deployment or operations activities that occur after deployment. In addition, the guide does not address solution alignment questions. It is assumed that your organization has already conducted a preliminary evaluation with Microsoft staff or partners to assess how well Office 365 Beta for enterprises aligns with your current and future business application requirements. Lastly, the guide does not provide guidance on moving an existing BPOS implementation to the Office 365 Beta for enterprises. Information about transitioning from BPOS to Office 365 is available at the Microsoft Office 365 transition center."
 
LINKS:
·          Released at the Office365 community site; http://community.office365.com/en-us/f/183/p/1541/5095.aspx
·          Sign-up for the Office365 Beta; http://office365.microsoft.com/office365-beta.aspx

 

 

 

 About this blog

 
About this blog
Welcome to the SharePoint blog of Mark Overdijk, Zevenseas sailor since 2011. I will be posting cool stuff about SharePoint and Office 365.
 

 Most Discussed

 
I'm a Speaker at SharePoint Connections Amsterdam 2011 2
 

 Most Recent

 
I'm a Speaker at SharePoint Connections Amsterdam 2011 571 Days Ago
 

 Information

 
 

 Tag Cloud