Bulk upload files with metadata into SharePoint using PowerShell: UPDATE

This is an update to an article that I wrote back in July, which contained the first version of a PowerShell script to copy multiple documents from a file system into a SharePoint 2010 document library, automatically tagging them with column values (metadata) during upload. Back then, the script had very limited functionality, but I have now added some new features, converted the script to a function, and uploaded the PS1 script file with documentation to Codeplex for download.

In summary, the script now includes the following features:

- Upload multiple files from a local folder or network share into SharePoint 2010 document libraries
- Files can be uploaded from a single folder or an entire folder hierarchy
- Retain the folder hierarchy from the source path into the destination document library
- Choose the root or a specific destination folder in the document library to copy the files into
- Support for adding values to the following column types in the manifest file:
      - Single line of text
      - Multiple lines of text
      - Choice – Single value (drop-down/radio button)
      - Choice – Multiple value (checkboxes)
      - Currency
      - Number
      - Yes/No (checkbox)
      - Person or Group – Single value
      - Person or Group – Multiple value
      - Hyperlink or Picture
      - Managed Metadata – Single value
      - Managed Metadata – Multiple value
- Automatic file check in after upload, if required
- Automatic file approval after upload, if required
- Option to overwrite existing files in the destination document library
- Option to flatten the structure when copying from a multi-level folder hierarchy to a single folder in a document library (i.e., merging sub-folders to a single location)

You can download the script and user guide from Codeplex at http://spfileupload.codeplex.com. One of the advantages of using PowerShell for this tool rather than managed code, is the ability for you to customise the script should you wish to add any custom features as required. I intend to continue adding extra features in the future, but also welcome any ideas or contributions to the Codeplex site if you have them.