SubmitToSharePointList - Delete not working on v6.1 - InfoPath Dev
in

InfoPath Dev

SubmitToSharePointList - Delete not working on v6.1

Last post 10-02-2015 09:15 AM by Hilary Stoupa. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-01-2015 11:48 PM

    • berchtm1
    • Not Ranked
    • Joined on 10-02-2015
    • Penzberg
    • Posts 3

    SubmitToSharePointList - Delete not working on v6.1

    Hi, I have a huge InfoPath form with 12 tables connected to 12 different SharePoint lists. I'm encountering issues with the combination of RefreshSharePointListItems and SubmitToSharePointList for the delete operation. Create and Edit works fine. But when I delete multiple rows in InfoPath at once, the items in SharePoint are deleted sometimes, but not always. I'm deleting rows with the Delete qRule. Here is my set up: I followed this tutorial: http://www.infopathdev.com/blogs/hilary/archive/2012/07/05/qrules-refreshsharepointlistitems-walkthrough-for-v4-2.aspx It's v4.2 but I didn't find a newer one. - qRules Version: 6.1 (I have an earlier version of my form working on 5.2. All works perfectly fine here!) - I have that owssvr data connection 'owssvr_Refresh' - I have one mapping data connection serving all the 12 tables - I also have that web service connection to UpdateListItem. I left all parameters blank ignoring the warning. - on finishedLoading = true --> RefreshSharePointListItems /dsname=owssvr_Refresh /mode=Update - I have a 'Save and Continue' button which triggers the SubmitToSharePointList rule: SubmitToSharePointList /submit=EditListItem - I have a SP_ID field in each table which stores the SharePoint ID. Each of these fields has an attribute qRulesLastModified. As opposed to your tutorials, the SharePoint ID is NOT written to the XML fields automatically. Instead I needed to load them by default value. If I delete multiple rows at once and hit 'Save&Continue', the items are NOT deleted in SharePoint. When I delete one item and hit the 'Save&Continue' button right after that, it seems to work better. But still not reliable. Is this is a v6.1 bug or am I doing something wrong? Thank you for your support.
    Filed under:
  • 10-02-2015 12:03 AM In reply to

    • berchtm1
    • Not Ranked
    • Joined on 10-02-2015
    • Penzberg
    • Posts 3

    Re: SubmitToSharePointList - Delete not working on v6.1

    Update: Here is an error message that I could capture: Action: SubmitToSharePointList. Arguments: submit: EditListItem . Details: Enumeration already finished.. Stack: at System.SZArrayHelper.SZGenericArrayEnumerator`1.get_Current() at Qdabra.Tools.RulesLibrary.SharePointListSubmitterWebService.PopulateIdsAndLastModified(XPathNavigator outputNav, Mapping mapping, IEnumerable`1 nodes, String idXpath) at Qdabra.Tools.RulesLibrary.SharePointListSubmitterWebService.UploadListData(Mapping mapping, SubmitToListSettings settings, IEnumerable`1 nodes, String listNameOrGuid, String idXPath, XmlElement batch) at Qdabra.Tools.RulesLibrary.SharePointListSubmitter.PerformSubmit(Mapping mapping, SubmitToListSettings settings, IEnumerable`1 baseNodes) at Qdabra.Tools.RulesLibrary.SubmitToSharePointList.PerformSubmitToList(SubmitToListSettings settings) at Qdabra.Tools.RulesLibrary.SubmitToSharePointList.<>c__DisplayClass3.b__2() at Qdabra.Tools.RulesLibrary.SubmitToSharePointList.Execute() at Qdabra.Tools.RulesLibrary.CommandStarter.Run() at Qdabra.Tools.RulesLibrary.Commands.RunCommand(Commands command) at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand() This error message was captured when I deleted two items from table 1 and two items from table 2 at once and then submitted to SharePoint. The SharePoint items in table 1 were successfully deleted. The items in SharePoint table 2 not.
  • 10-02-2015 07:33 AM In reply to

    Re: SubmitToSharePointList - Delete not working on v6.1

    Yup, I think we had a bug at one point in 6.1. Send me an email via the forum and I can get you a later build where this was fixed, okay?
    Hilary Stoupa

  • 10-02-2015 09:02 AM In reply to

    • berchtm1
    • Not Ranked
    • Joined on 10-02-2015
    • Penzberg
    • Posts 3

    Re: SubmitToSharePointList - Delete not working on v6.1

    Hi Hilary, thank's a lot for your help. V7.2 resolves the issue. I wished I had asked earlier. That was a lot of time wasted searching for the issue in my form. Regards
  • 10-02-2015 09:15 AM In reply to

    Re: SubmitToSharePointList - Delete not working on v6.1

    Wonderful, thanks for the update!
    Hilary Stoupa

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.