How to upload document and update properties in one go using C# in SharePoint

Question

I am using following code to upload a file in library and setting column values. This library has Major versioning enabled. Problem I am facing is on each file upload, it creates two versions, first version is for file upload and second version is for updating column values. Can we do it in one go i.e. upload and setting column values only create one version?

I tried spfile.ListItemAllFields.SystemUpdate(); instead of spfile.ListItemAllFields.Update(); but then it didn't update the Editor field and saved it as System Account

SPSecurity.RunWithElevatedPrivileges(delegate()
{
   using (SPSite site = new SPSite(siteURL))
   {
      using (SPWeb web = site.OpenWeb(mySubSite))
      {
         Byte[] bytes = Convert.FromBase64String(Attachment);
         SPFolder myLibrary = web.Folders[myLibrary];
         web.AllowUnsafeUpdates = true;
         SPFile spfile = myLibrary.Files.Add(FileName, bytes, true);
         spfile.ListItemAllFields["Editor"] = web.EnsureUser(UploadedBy).ID;
         spfile.ListItemAllFields["Product"] = Product;
         spfile.ListItemAllFields.Update();
         web.AllowUnsafeUpdates = false;
         myLibrary.Update();
      }
   }
});

Accepted Answer

Yesterday, I answered the same question in StackExchange:

How to upload document and update properties in one go using C#

Actually, this is by design.

Using Update() method, Version1 is to create the uploaded file item and Version 2 is to update the metadata column.

Using SystemUpdate() method, it won't update Editor field and generate the new version history, it will set the Editor field with Current Logged User.

A workaround is to open the SPSite with a UserToken which is the same as the value which needs to be set with Editor like this:

SPSecurity.RunWithElevatedPrivileges(delegate()
{
SPUserToken token;
using (SPSite site = new SPSite("http://sp/sites/dev/"))
{
token = site.RootWeb.EnsureUser(@"i:0#.w|contoso\jerry").UserToken;
}
using (SPSite site = new SPSite("http://sp/sites/dev/", token))
{
using (SPWeb web = site.OpenWeb())
{
Byte[] bytes = File.ReadAllBytes(@"C:\passwords.txt");
SPFolder myLibrary = web.Folders["DocVersion"];
web.AllowUnsafeUpdates = true;
SPFile spfile = myLibrary.Files.Add("pwd.txt", bytes, true);
spfile.ListItemAllFields["Title"] = "TestTitle";
spfile.ListItemAllFields.SystemUpdate();
web.AllowUnsafeUpdates = false;
}
}
});

Then it will only generate one version like this:

This workaround needs to make sure the User in UserToken have enough permission for the site and library.

Reference:

Update vs. SystemUpdate for SharePoint List Item

Answer

FYI
https://video2.skills-academy.com/en-us/previous-versions/office/sharepoint-server/ms479448(v=office.15)

The SystemUpdate method has a bool param which you can set to false that will not affect the modified by.

Share via

How to upload document and update properties in one go using C# in SharePoint

1 additional answer