MOSS 2007 Document Migration
So we've got about 150,000 legal documents to migrate into MOSS from a network file share. Of course, the customer wants the document library to look just like the file share so I think, great, I'll just drag and drop the folders into Explorer View.
Well, no such luck. First, Explorer View is a big fat Page Not Found error on my host. I started the web client like Joel said yesterday and everything but no explorer view.
So I just create a network place for the doc library and I go to copy folders and, of course, it barfs everytime there's a special character in the file or folder name.
So that's got me looking for a better way to get these document migrated, something that will move the files without blowing up every time it hits an ampersand.
Since I'm an old robot (me and HAL9000 were school buds) I recall the first pc command I ever learned, dir, and it does alot more than make text fly by your command prompt. In fact, if you assume the network file share is mapped to L: then this one might be handy here:
L:>dir /s /b /-n >c:Files.txt
This will provide an alpahbetical list of all files in all folders in the network share. Now, all that remains is copying the text into Excel and writing some string magic in excel to write a copy command that can get batched into 2500 MakeDir commands and 15,000 copy commands. The MakeDir will acually create the folders in the document library. The copy will copy the old file with the old file name to the new folder with a "URLHappy" file name, i.e. one with no characters that are prohibited in URLs.
Let's I bet this works. The only question I have is this…
Which is easier:
-
Writing an executable to do it.
-
Writing VBA in Excel to do it.
-
Just doing it in Excel?
-robot
Tags: