SharePoint admins occasionally have write PowerShell scripts to regularly extract some type of summary data from the SharePoint farm and then write that out to a file, usually in CSV format since PowerShell handles those so well. This is great for admins because we can just log onto the box and open the file to read the data, but what about the rest of the SharePoint team that also needs that data?
The obvious and “SharePointy” solution is to upload the CSV files to a SharePoint document library so that others on the team can easily access the data whenever they want and then use Excel to slice it to their heart’s content. However, there is a problem: PowerShell has no way of uploading those files into SharePoint! Even if it did, SharePoint document libraries have so many configuration possibilities that it could get hairy quickly.
I wrote the script below to get around that. It can be called from other scripts and allows for:
- Major and Minor Versioning
- Check Out (if required)
- Check In with comment
- Approval with comment (if required)
- Usage of the original file’s timestamps for SharePoint’s Created/Modified fields
Check In and Approval updates the Modified date so that the file date will not be reflected in those cases
The script is still a little rough but seems to work for most cases.