How to automatically update documents generated by another system as new versions?

Question

We want to share documents in a SharePoint Document Library (SP 2013) which are automatically generated each week by another software system.

These documents are in PDF and RTF format (maybe also html).

I would like to upload the documents once first "by hand" and then let the other software system overwrite the documents and check-in a new version.

How can this be done programmatically (the easiest possible way)?

Answer 1

I would either built a small console app using CSOM or use PowerShell and CSOM together.

I haven't checked if this code works, but it probably look something like this:

using (var context = TokenHelper.GetClientContextWithAccessToken(uri.ToString(), token))
            {
                var web = context.Web;
                using (var fs = new FileStream(sourceFilePath, FileMode.Open))
                {
                    FileInfo fi = new FileInfo(sourceFilePath);

                    FileCreationInformation flciNewFile = new FileCreationInformation();

                    flciNewFile.ContentStream = fs;
                    flciNewFile.Url = System.IO.Path.GetFileName(sourceFilePath);
                    flciNewFile.Overwrite = overWriteIfExists;

                    List docs = web.Lists.GetByTitle(listName);
                    Microsoft.SharePoint.Client.File uploadFile = docs.RootFolder.Files.Add(flciNewFile);

                    context.Load(uploadFile);
                    context.ExecuteQuery();

                    fs.Close();

                    //publish the file
                    uploadFile.Publish("comment");
                    context.ExecuteQuery();
                }
            }
        }