I’ve spent a little time recently developing a Windows Form utility that allows you to update SharePoint 2003 user profiles (in a profile database) from values in a CSV file. The tool allows you to map up to 12 profile properties to colums in a CSV file. You can pick any SharePoint property to update, including custom ones. I’ve posted it up on GotDotNet, at this location: http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=BCEDDB1C-D210-42D4-91C1-20DF50F19738
This tool addresses scenarios where:
- You do not want to rely on users editing their own profiles
- Your Active Directory does not have user profile information in it
- You want to maintain corporate profile information which the users cannot update
- You are doing user migrations and want the profile information there from day 1
I am aware of a great set of utilities called ‘SharePoint Utility Suite’ (http://www.microsoft.com/sharepoint/downloads/components/detail.asp?a1=724). My tool is similar to the SPUserUtil/SPSPropConfig tools apart from mine is a Windows form and allows you to update any SharePoint user profile property, including custom ones. I’m under no illusion though that mine is any better, I know the guys that build the ‘SharePoint Utility Suite’ put a lot of time and effort into it and I’m sure their tools are much better tested and developed than this one is – you should check them out also.
If you are going to use my tool, you simply need to run the .exe from a SharePoint 2003 server. It does not actually need to be installed, just place the .exe on the file system and remove it when you are done.
Feel free to have a play, it was really done for my own experience more than anything. Comments and feedback are welcome, just comment on this blog (please no “it is the same as the utility suite” comments).
Regards – Martin