InfoPath Dev

 

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.

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

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);

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();

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.

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.  

 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();

 

}

 

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,

P

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.

How can this be achieved using q-Rules?

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

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.