InfoPath Dev

Let me know if you need more help. I think the blog posts I've done may actually be easier to understand than the videos (or, at least, for me blog posts are easier to understand): http://www.infopathdev.com/blogs/hilary/archive/2012/05/30/qrules-submittosharepointlist-command-changes-for-v4-2.aspx is the first in a series I wrote, you'll find links to the others there as well.

Hello again Hilary. Thanks for your help yesterday. I'll follow your recommendations on reading the blogs instead. However, I've still got a problem, even using the form that you so kindly adjusted. It won't update existing data, but only create new data. To test it properly, I created a new list with similar columns, tested that you can update the columns within SharePoint itself and then reset all of the mappings to the form. When I click on button with the rule when no fields, it adds a record. However, if I select a record that's already created, and using the ID as a reference field in the form, I get the following error message when I try and update a record Failed to submit to SharePoint. URL = 'http://portal.*******.local/_vti_bin/lists.asmx'. Exception: Exception from HRESULT: 0x8004304D. Full error node text: Cannot access a closed Stream. | Cannot access a closed Stream. Do you have a solution for this.

Can you try this:

Using your new form, take steps you've been using to successfully create a new record. Do you have a field in the form you are using for the /id parameter? Display that on the form, so you know it is getting populated.

Then, after creating the new record and making sure your /id field has been populated, make a change (in the same form, the one you just filled out) and run the command again. What happens? Does the list item get updated?

Hi Hilary. I've done all this. On new records, As soon as you hit the submit button i.e., you don't do anything to the form, it creates a new record, and then increments the ID field. Checking the SharePoint list shows a blank record with entitled "NEW", but no other records inserted accordingly. Running the form a second time and then selecting the newly created ID so as to update it with new or even blank records generates the error message: Failed to submit to SharePoint. URL = 'http://portal.********.local/_vti_bin/lists.asmx'. Exception: Exception from HRESULT: 0x8004304D. Full error node text: Cannot access a closed Stream. | Cannot access a closed Stream.

So, I don't understand this:

Checking the SharePoint list shows a blank record with entitled "NEW", but no other records inserted accordingly.

What does that mean? Are none of your form values getting submitted to the list?

As to this:

Running the form a second time and then selecting the newly created ID so as to update it with new or even blank records generates the error message

I must not have explained well what I would like you to do - I don't want you to run the form a second time. I want you to open the form one time. Submit your list item. Leave the form open. Make sure in the form, in the ShPId field (or whatever you've used for your /id param) gets returned by the command - that is, make sure you have an ID number. Don't close the form. Change something in your form. Submit again and see if you have an error or an update.

However, it sounds as if you have another issue if you are just getting a blank record created - like your mapping may not be correct?

Hello Hillary. I've included screenshots of exactly what I've done including the resulting errors.

Hilary Stoupa:

Checking the SharePoint list shows a blank record with entitled "NEW", but no other records inserted accordingly.

This occurs if I just clicked on "Submit", with no added data. However, yes, If I create a record with data, the form does get submitted. But, the purpose of the form is to edit existing data in a SharePoint list i.e. change the conditions of existing data. Please have a look at my screenshots, in the following threads, it will explain them all

initial Config

Next Action

3rd Action

Final result after submission

What I am trying to do is find out whether the issue has something to do with the data you are submitting via your form drop downs (since we don't know what the actual values there are) or with the command, or with something else. I do understand the purpose of the form. Sometimes, to troubleshoot issues, we have to simplify. I am trying to help you simplify.

If it were my form, and I were trying to troubleshoot this, I would drag the main data source onto the form again so that I could enter data in any of the fields. I'd submit a new item. I'd make sure the SharePoint Id field in the form, as specified in the /id parameter is successfully populated. I'd change some information in the form by typing in the fields, not by using the drop down controls. I'd try to submit again and see if my item was updated.

I want to reply to this again - Some of your screenshots were caught in the moderation queue, so when I reveiwed your posts, some steps were not displayed.

I'm wondering if any part of the issue might be with the fact that the Title field is not being populated? Can you try adding that field to your form so that your created items have a title? The error you are getting - Cannot access a closed Stream - is not one I have seen before. Another thought - there is a field in the QdabraRules data source, in the Form node, called extendedErrorMessages - can you put that field on your form and set it to true and see if we can get more error info from the form?

Hello. Sorry for my delays in replying but I have a problem with InfoPath which is preventing me from accessing old forms that I've created. I was trying to enable VSTA. I'll recreate the form and then send it to you again to have a look. Thanks.

Hello again Hilary.

Many thanks for replying to all of my emails. I'm still not having much luck and I need to present Qdara to some colleagues of mine who do have an interest of purchasing. I thought I'd actually show you in detail what I have been trying to do with the exact steps after following all of the details on your blog here http://www.infopathdev.com/blogs/hilary/archive/2012/05/30/qrules-submittosharepointlist-walkthrough-for-v4-2.aspx.

I've followed the steps that you took, but I'd really appreciate it if you could help me go through my document as it would let one know exactly where the problem is. I can't attach word documents on the system here so I have placed it my Google Docs account here

https://docs.google.com/file/d/0BwU4lZpNNSL4OGNXUEhRZzNERXM/edit

Please help

Regards

Yemi

I appreciate you putting all your steps together like that - and starting with a new form. Here's what I'm not seeing - can you put the ShPId field on the form so you can verify it is being populated when you first submit? Between your first submit and your second submit are you leaving the form open? If not, when you set your other field values after the laptop has been selected, are you setting the ShPId field with the ID from the laptop list? The ID field from the list is the key to updating instead of creating new - we have an ID field indicated in the mapping, and then the field in the XML indicated by that XPath need to have the ID of the item you are trying to update.