Thursday, February 02, 2006 10:03 PM
eforce
What are the various ways of bulk uploading files to WSS?
There are six main methods
1. Using the WSS user Interface
I.e. Upload Document; Upload Multiple Document and select the files to upload.
Note that Upload Multiple Document is only visible when the Client has Office 2003 (any version) installed.
2. Using Explorer View
Open the Document Library and select the Explorer View.
Copy/Paste (or drag and drop if it works) the files from Windows Explorer to it.
3. Using "My Network Places"
Define the document library in "My Network Places" and Copy/Paste (or drag and drop if it works) the files from Windows Explorer to it.
4. Using a Local Drive
Use Net use to define a local drive for the document library.
This probably requires Office 2003 installed on the client and has the following format
(It is wise to only use names in the path that contain no blanks or strange (or foreign) characters as otherwise the net use statement often seems to have problems.)
Following the specification of local drive X:, files can be copied to the document library it represents by Copy/Paste (or drag and drop if it works) from Windows Explorer.
Note: Sergio notes that provided you are running Windows XP or Windows 2003 mapped drives will work - if they don't make sure the "WebClient" service is enabled and started (Start Menu; Run; services.msc). Thanks, Sergio!
Warning: don't be tempted to go to this local drive and edit your document there. As "mda1125" reported, when you save it, you then lose the document (it's deleted).
5. Using Web Services
The following code was described as a generic way to upload a file into any web folder (doesn't have to be WSS) using ADODB. It can presumably be amended for a batch of files.
Set objRecord = New ADODB.Record
Set objStream = New ADODB.Stream
objRecord.Open strFile, "URL=" + strUrl,
ADODB.ConnectModeEnum.adModeReadWrite,
ADODB.RecordCreateOptionsEnum.adCreateOverwrite,
ADODB.RecordOpenOptionsEnum.adDelayFetchStream, Sharepoint2003USerName,
Sharepoint2003Password
objStream.Type = ADODB.StreamTypeEnum.adTypeBinary
objStream.Open objRecord, ADODB.ConnectModeEnum.adModeWrite,
ADODB.StreamOpenOptionsEnum.adOpenStreamFromRecord
objStream.LoadFromFile (FileName)
objStream.Flush
objStream.Close
objRecord.Close
6. Using WebDav
If you want to use a tool for this, a couple of suggestions are
(The ADODB code was originally posted by Joachim Hoffmann, thanks to him!)
(The addition of WebDav to the list was suggested by Maurice Prather, thanks to him too!)
Note that if you are looking for a way to automate bulk transfers, Derek Fakehany used to suggest Karen's Replicator
He says it's a "very clean tool, free, and pretty easy to configure. Plus lots more settings for copying to/from Sharepoint."
Thanks (again), Derek!
