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.