Monday, October 1, 2007

Moving Lists from WSS 2.0 to WSS 3.0

Just started on this project. Ain't sure if there's an easier way; but considering that we are hosting on a shared server farm and I aint nothing more than an mear admin for the website; with no access to the box or the server howsoever; this is what i figure out so far.
1. Export 2.0 list to excel; then make this change to your local machine:
2. Open the Excel Add-In EXPTOOWS.XLA locate in C:\Program Files\Microsoft Office\Office12\1033 by default. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL). Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub

3. On 3.0 site go to Create -> Import Spreadsheet -> Locate the path and click import.
4. Done!

Enjoy! more stuff coming on as i move forward.

No comments: