SharePoint Integration

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Patrick Halstead — Tue, 19 Feb 2013 01:16:28 GMT

Hi again,

It's not just a boon for multiple forms. Whenever the form needs to change down the road and you add or update the data source, the qRules approach saves you time since you don't have to recompile your code - just go in and change the affecte rule commands.

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Patrick Halstead — Tue, 19 Feb 2013 01:08:49 GMT

We have a lot of documentation on how to update and delete list items from InfoPath forms

check out the links underneath SharePoint lists here: http://www.qdabra.com/en/products/docs/qRules.aspx

Also, check out videos here: http://www.qdabra.com/en/products/qRules_learn.aspx

specifically, check out the one about synchronizing forms with SharePoint lists

If you'd rather see a live demo, let us know. We're happy to arrange a quick 15 minute demo for you.

Best regards,

Patrick

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Mon, 18 Feb 2013 17:12:42 GMT

How can this be achieved using q-Rules?

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Mon, 18 Feb 2013 13:28:59 GMT

I partially agree. If I envision the need for qRules on many of our forms than that would be the way to go. I just dont see that. I only have one form that I see will require some extra coding. If I knew all of the libraries. this would be easy. All of our other forms can be done without code.

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Patrick Halstead — Sun, 17 Feb 2013 19:50:59 GMT

Once again, I just want to remind you that a common library is the way to go.

Hardcoding a form template with xpaths in compiled code will guarantee extra costs down the road.

That's why we developed qRules - to help people out with all of their forms. No developer needed.

It's xpath agnostic and it helps us support the forum.

Please consider trying qRules to help us keep putting hours into this forum.

Yours truly,

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Sat, 16 Feb 2013 16:42:56 GMT

Hillary,

I figured out the problem. Its in the iter.move code(XPathNodeIterator iter = root.Select("//my:myFields/my:group1", NamespaceManager);.

When I select more than one checkbox the loop concates the values together instead of using one value and looping through to the next value. I am still troubleshooting my error.

string siteUrl = "http://localhost/";

ClientContext clientContext = new ClientContext(siteUrl);

List oList = clientContext.Web.Lists.GetByTitle("Inventory");

while (iter.MoveNext())

{

string value = iter.Current.Value;

ListItem oListItem = oList.GetItemById(value);

oListItem["Title"] = "scuba";

oListItem.Update();

clientContext.ExecuteQuery();

}

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Thu, 14 Feb 2013 21:06:59 GMT

I tried without the execute but it does nothing I think its because i am using ClientContext class (Microsoft.SharePoint.Client)‎

I even tried this way but

using (SPSite site = new SPSite(http://sp-app))
{

using (SPWeb web = site.OpenWeb())
SPList list = web.GetList("/lists/item/%20inventory/");
list.GetItemById(id);
list.Update();

but i get this

The Web application at http://sp-app could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

when i use power shell Get-SPSite the url is in the list.

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Hilary Stoupa — Thu, 14 Feb 2013 20:04:57 GMT

Is this necessary?

clientContext.ExecuteQuery();

Isn't the items updated with oListItem.Update() ?

MSDN says that Update():

Updates the database with changes that are made to the list item.

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Thu, 14 Feb 2013 19:28:34 GMT

Thanks. I almost there. it works with one selection but when I select multiple items i get the following error.

SeverException was handeled by user code.
Item does not exist. It may have been deleted by another user.

Highlighted in green was clientContext.ExecuteQuery. I think it had to do with incorrect query with multiple values. I believe my code is formed wrong or wrong syntax.

here is my code.

//update list item

string siteUrl = http://sp-app/dev;
ClientContext clientContext = new ClientContext(siteUrl);

list oList = clientContext.Web.Lists.GetByTitle("Item Inventory");

PathNavigator root = MainDataSource.CreateNavigator();

XPathNodeIterator iter = root.Select("/my:myFields/my:group1", NamespaceManager);

while (iter.MoveNext())

{

string value = iter.Current.Value;

int id;

Int32.TryParse(value, out id);

ListItem oListItem = oList.GetItemById(id);

oListItem[

"Title"] = field1;

oListItem.Update();

clientContext.ExecuteQuery();

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Hilary Stoupa — Thu, 14 Feb 2013 16:11:00 GMT

After this line:

string value = iter.Current.Value;

You could do something like this:

int id;
Int32.TryParse(value, out id);

Then, when you add snippet 1, you'd use:

oList.GetItemById(id);

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Thu, 14 Feb 2013 16:03:47 GMT

I understand that much. I just wasn't sure what classes I use. I tried a caml string but it gives me cannot convert implicit string to call query error. I put the string variable where the 5 was. Can you give me an example with the correct syntax? Thanks

Re: Code help to update/delete SP List items where checkboxes are selected (ID) value

Hilary Stoupa — Thu, 14 Feb 2013 15:53:43 GMT

qRules can do this - and prevent you from having to write and maintain custom code.

That said, inside your loop where you are going through the checkboxes, you could just simply add snippet 1, replacing your hardcoded ID of 5 with your value variable converted to an int.

Code help to update/delete SP List items where checkboxes are selected (ID) value

cpluce — Thu, 14 Feb 2013 14:10:48 GMT

I have two code snippets working.

1. Update SP list item where ID = 5

  string siteUrl = "http://localhost/";
            ClientContext clientContext = new ClientContext(siteUrl);

            List oList = clientContext.Web.Lists.GetByTitle("Inventory");
            ListItem oListItem = oList.GetItemById(5);

            oListItem["Title"] = "Item999";
            oListItem.Update();
            clientContext.ExecuteQuery();
2. iterate through selected checkboxes in InfoPath and display in textbox
   // Write your code here.
            XPathNavigator root = MainDataSource.CreateNavigator();
            XPathNodeIterator iter = root.Select("//my:myFields/my:group1", NamespaceManager);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();

                    while (iter.MoveNext())
            {
                string value = iter.Current.Value;
                sb.Append(value);
                sb.Append(";");
            }

            root.SelectSingleNode("//my:myFields/my:field3", NamespaceManager).SetValue(sb.ToString());
I need help modifying/combining both of these to accomplish:
I want to update SPList item where selected checkboxes (ID value) is equal to the items in the list. I think I need to write a CAML and/or spquery but I couldnot get it to work. I think I need to iterate through selections(checkboxes) and create a dynamic CAML string through a loop and use this is my 
spquery. I just am having a hard time choosing the classes or methods that work.  I can also achieve this through web services and a batch file but I still need a dynamic CAML query to use through that else well. 
ANy assistance either approach would work , is greatly appreciated. Thanks