Code

Re: UpdateListItems + CAML + File Attachment

Hilary Stoupa — Tue, 24 Aug 2010 22:01:38 GMT

No, qRules doesn't generate CAML files -- it actually handles the entire submit process. You simply add some data connections and provide a mapping and the tool does the rest.

Re: UpdateListItems + CAML + File Attachment

rZ3A8zj8neCW3K — Tue, 24 Aug 2010 14:16:41 GMT

Will the qRules generate CAML files for me? I'm looking on this page http://www.qdabra.com/en/products/qRules.aspx but it is not clear, I think if the page was revised to have more detailed information it might be more effective.

Re: UpdateListItems + CAML + File Attachment

Patrick Halstead — Tue, 24 Aug 2010 06:41:48 GMT

I responded to the other post. Please read that and download the free qRules v2.3 trial and you'll have this working without code in 30 minutes. If you want to continue down the BizSupportOnline.net path, go for it, but we don't support that. Sorry, but we have to pay for this forum in some way and qRules is that way. It will save you money and help support the forum. You can get a discount off of the already cheap price of $199 by providing a testimonial.

Re: UpdateListItems + CAML + File Attachment

rZ3A8zj8neCW3K — Mon, 23 Aug 2010 19:37:45 GMT

looks like someone else has this same exact issue

http://www.infopathdev.com/forums/p/10870/38710.aspx#38710

UpdateListItems + CAML + File Attachment

rZ3A8zj8neCW3K — Mon, 23 Aug 2010 14:08:07 GMT

Hello!

I am trying to include an attachment in some already working code that creates a new item in a SharePoint list. I have read that you can do this by including the attachment as a field in your CAML document. The field will hold an encoded string that represents the file. I want to do this using the CAML document.

Here is an example of the type of CAML document I am using already:
<?xml version="1.0" encoding="UTF-8" ?>
<Batch OnError="Continue">
<Method ID="1" Cmd="New">
<Field Name="Title" />
</Method>
</Batch>

Here is an example of how I would encode the XML infopath form file when I attach the file to the CAML (if possible, as an encoded string):
http://www.bizsupportonline.net/blog/2009/01/submit-infopath-form-sharepoint-list-attachment/
string formXml = MainDataSource.CreateNavigator().OuterXml;
byte[] attachment = Sytem.Text.Encoding.UTF8.GetBytes(formXml);
item.Attachments.Add("InfoPathForm.xml", attachment);

Here is an example of what I mean, a typical SharePoint list that can have attachments on each item.

I'm having trouble finding any sources that explain how to set up the CAML document properly. I believe I will be able to encode the file and insert it into the CAML without issue, but I'm not sure what the CAML needs to look like so that SharePoint will accept the field as an attachment.

Edit: I have seen this http://www.bizsupportonline.net/browserforms/how-to-use-sharepoint-object-model-submit-data-infopath-browser-form-sharepoint-list.htm
but for some reason I am unable to complete steps 5 and 6:

In the Project Explorer window in Microsoft Visual Studio Tools for Applications, right-click the node for the project name, and select Add Reference from the context menu.
On the Add Reference dialog box, select Windows® SharePoint® Services from the list of components on the .NET tab, and click OK.