views:

114

answers:

3

I have to upload some XML files to a SharePoint library. I have to do it from a computer that is not one of the SharePoint servers (so object model will not work). Also the library has a custom (integer) column and I have to set it's value for the uploaded file.

How do I upload the file and the the value by using the standard WebServices of SharePoint 2010?

+2  A: 

I haven't used it yet, but the Client Object Model may be a good choice for this.

Doug Stalter
You're right ... I will check for some tutorial, thanks ...
Hinek
+2  A: 

I now solved it by using the Client Object Model (as Doug suggested). Uploading a file using the COM is pretty simple:

public void UploadXmlFile(string xmlContent, int orderNumber)
{
    string filename = DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss") + "_" + orderNumber + ".xml";
    ClientContext context = new ClientContext(absoluteHostUrl + relativeWebUrl);
    using (MemoryStream stream = new MemoryStream())
    {
        // use a MemoryStream for the file contents
        StreamWriter writer = new StreamWriter(stream);
        writer.Write(xmlContent);
        writer.Flush();
        stream.Position = 0;
        // ... and upload it.
        Microsoft.SharePoint.Client.File.SaveBinaryDirect(
            context,
            "/" + relativeWebUrl + "Lists/" + libraryName + "/" + filename,
            stream,
            false);
    }
    // ...

... but after uploading the file is checked-out, and I still have to set my integer column:

    // ...
    // get the created entry
    Web web = context.Web;
    List list = web.Lists.GetByTitle(libraryName);
    ListItemCollection itemCol = list.GetItems(new CamlQuery() { ViewXml = "<View/>" });
    context.Load(itemCol,
        items => items
            .Include(i => i[COLUMN_IMPORTORDERNUMBER])
            .Where(i => (string)i[COLUMN_FILELEAFREF] == filename)
            .Take(1)
            );
    context.ExecuteQuery();
    // ... found it? ...
    if (itemCol != null && itemCol.Count > 0)
    {
        ListItem item = itemCol[0];
        // ... set the ImportOrderNumber
        item[COLUMN_IMPORTORDERNUMBER] = orderNumber;
        item.Update();
        // ... and check in
        item.File.CheckIn("Checked in by WebService", CheckinType.MajorCheckIn);
        context.ExecuteQuery();
    }
}
Hinek
A: 

Could you use something as simple as email to a list, and have the item created from that?

Kolten