SharePoint 2010 Managed Metadata Import Error "Bulk load data conversion error (CustomSortOrder)"

What?

You receive the below error when you try to Export/Import Managed Metadata Service Application from one farm to another.

Import-SPMetadataWebServicePartitionData : Bulk load data conversion error (tru

ncation) for row 11, column 7 (CustomSortOrder).

One of the easiest ways to backup/restore Managed Metadata Service Application from one farm/environment to another is using import/export functionality.

I have explained this procedure a little while ago in this blog post

I have been successfully using the Import/Export method with no issues until I stumbled across this error today.

Why?

As the error hints, the error occurred due to specifying custom sort order in one of the term sets.

Speaking at Melbourne SharePoint User Group (MSPUG) on the 26th September 2012

What?

I am going to speak at Melbourne SharePoint User Group (MSPUG)  - http://mspuginfo.wordpress.com

When?

On Wednesday, September 26th 2012 5:30PM  (for 6pm start)

Where?

Microsoft Melbourne,
Level 5, 4 Freshwater Place,
SouthBank, Melbourne,
Australia

How to mix HTTP and HTTPS pages in a SharePoint 2010 site?

What?

How to have a combination of both HTTP and HTTPS pages in the same SharePoint 2010 site with configuration only without writing code?

Why?

It is a very common requirement to have a mix of HTTP and HTTPS pages in public facing SharePoint sites. Examples of such pages generally are login pages, contact forms, new testimonial form pages, new user review form pages  and any other pages that capture sensitive data from users. In these cases, only those specific pages must be loaded as HTTPS pages where as the rest of the pages in the site must be loaded as HTTP pages.