I have to run an update each month that will send over 1,000 files to specific folders presently via script. I wish to upload these files as individual file names and append metadata to them. So, today a directory called
2013/01/ExecReports/ where 2013 is a folder as is 01 and ExecReports
will contain files called PDFFile1Report.pdf and PDFCallList.pdf (better named than this...) and 100 others. Repeat this for:
EmployeeReports Folder GeneralReports Folder etc. many more folders
I'd rather upload the files either to their respective directory or preferably as file name: PDFFile1Report_2013_01.pdf and while uploading, it should add the metadata of Month = 01 and the Year = 2013 so I can create specific views for Dept, Month and Year.
First, can I run scripts from my desktop or does it have to be on the server? This guy seems to have the right idea, but it isn't working for me. http://www.sharepointdiary.com/2012/10/bulk-upload-files-to-sharepoint-using.html