SharePoint Profile Data Export Import is a simple command line utility to export the data associated with profiles in SharePoint.

Why

During a farm upgrade I needed a a way to bring across all the profiles from the old SSP to the new SSP. Some of the data in the profiles was original content and was not in any of the profile source systems e.g. Skills etc.

Usage

To export all the profiles use spprofiledump.exe --url http://example.sharepoint.com --file dump.xml --export. This will create an XML file with all the profiles contained in the SSP.
To import data into an SSP use spprofiledump.exe --url http://example.sharepoint.com --file dump.xml --import.

The XML File

The file is reasonably straight forward. A sample entry is probably the simplest way to explain it:
<ProfileDump>
  <User AccountName="DOMAIN\USER">
    <Property Name="Title" Type="string">Mr</Property>
    <Property Name="FirstName" Type="string">Geoff</Property>
    <Property Name="LastName" Type="string">Ford</Property>
    <Property Name="SPS-HireDate" Type="date">10/06/2003 12:00:00 AM</Property>
    <Property Name="SPS-Skills" Type="List">
        <Entry>SharePoint Development</Entry>
    <Property>
    ...
  </User>
<ProfileDump>


As you can see, dates and multi-valued properties are handled correctly.

Last edited Aug 2, 2010 at 2:54 AM by alephnullplex, version 1

Comments

No comments yet.