File upload with metadata using SharePoint Web Services

Question

I trying to upload a file with metadata using SharePoint Web Services. The first approach I took is to use the WebRequest/WebResponse objects and then update the metadata using the Lists.asmx - UpdateListItems method. This works just fine but it creates two versions of the file. The second approach I took was to use the Copy.asmx web service and use the CopyIntoItems method which copies the file data along with the metadata. This works fine and creates v 1.0 but when I try to upload the same file with some changes in the metadata (using the Copy.asmx) it does not do update anything. Does anybody came across the same issue or has some other ideas to implement the required functionality.

Thanks, Kiran

Are you using SharePoint 2007 or 2010?

CBono
– CBono

2011-06-16 22:37:04 +00:00
Commented Jun 16, 2011 at 22:37 — CBono
– CBono, Commented Jun 16, 2011 at 22:37
We are using SharePoint 2010.

user802355
– user802355

2011-06-16 23:15:35 +00:00
Commented Jun 16, 2011 at 23:15 — user802355
– user802355, Commented Jun 16, 2011 at 23:15

Eric Herlitz · Accepted Answer · 2011-06-17 09:31:04Z

1

This might be a bit of topic (sorry) but I'd like to advice you to a real timesaving shortcut when working with SharePoint remotely, http://www.bendsoft.com/net-sharepoint-connector/

It enables you to work with SharePoint lists and document libraries with SQL and stored procedures.

Uploading a file as a byte array

...
string sql = "CALL UPLOAD('Shared Documents', 'Images/Logos/mylogo.png', @doc)";

byte[] data = System.IO.File.ReadAllBytes("C:\\mylogo.png");
SharePointCommand cmd = new SharePointCommand(sql, myOpenConnection);
cmd.Parameters.Add("@doc", data);

cmd.ExecuteNonQuery();
...

Upload stream input

using (fs == System.IO.File.OpenRead("c:\\150Mb.bin")) {
    string sql = "CALL UPLOAD('Shared Documents', '150Mb.bin', @doc)";
    SharePointCommand cmd = new SharePointCommand(sql, myOpenConnection);
    cmd.Parameters.Add("@doc", fs);
    cmd.ExecuteNonQuery();
}

There are quite a few methods to simplify remote document management

UPLOAD(lisname, filename, data)
DOWNLOAD(listname, filename)
MOVE(listname1, filename1, listname2, filename2)
COPY(listname1, filename1, listname2, filename2)
RENAME(listname, filename1, filename2)
DELETE(listname, filename)
CREATEFOLDER(listname, foldername)
CHECKOUT(list, file, offline, lastmodified)
CHECKIN(list, file, comment, type)
UNDOCHECKOUT(list, file)

Cheers

answered Jun 17, 2011 at 9:31

Eric Herlitz

26.4k28 gold badges117 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

barrypicker Over a year ago

I don't really want to spend money on the tool you are describing, but I gotta say - I really like alternative approaches to solving the problem. This tool totally side-steps all the web services authentication stuff (assuming using SP Web Services)...

Collectives™ on Stack Overflow

File upload with metadata using SharePoint Web Services

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related