QRules - InfoPath to SP List, (no title) list items are getting created - InfoPath Dev
in

InfoPath Dev

QRules - InfoPath to SP List, (no title) list items are getting created

Last post 11-27-2012 03:02 PM by Hilary Stoupa. 9 replies.
Page 1 of 1 (10 items)
Sort Posts: Previous Next
  • 11-26-2012 08:55 AM

    QRules - InfoPath to SP List, (no title) list items are getting created

    After seeing this video (http://www.youtube.com/watch?v=mpueygXbV-A ) I decided to try QRules. I downloaded QRules to test using one form to send items to multiple lists. I've setup a CAML manually to do this but I need to be able to use Date Pickers and drop downs instead of just text, that this method allows: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx After mapping the fields, injecting the form, and setting up the submit button I only get list items that say (no title), and the other columns are blank. This is a standard custom list in SP 2010 Enterprise, with 4 fields, title, assigned To, date, and urgent. This is the mapping file: {3CB049AD-BD74-4994-8629-E4135B179AEF} true my:myFields/my:Tasks my:myFields/my:Tasks/my:Title Title my:myFields/my:Tasks/my:Assigned Assigned my:myFields/my:Tasks/my:AssignedDate AssignedDate my:myFields/my:Tasks/my:Urgent Urgent https://...../demo Is this happening because this is a trial copy, or because something else is wrong?
  • 11-26-2012 09:01 AM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    Hi - can you attach your form to a reply (under the Options tab) and I'd be happy to take a quick look....
    Hilary Stoupa

  • 11-26-2012 09:20 AM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    Sure, thank you. I've attached it.
  • 11-26-2012 09:35 AM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    So, you'll want to save the attached file locally, right click the saved file and select Design to open in design mode - from there you can preview, see the changes I made, etc.

    I noticed you had a second, disabled rule on your button - you were right to disable that, because qRules will also execute the submit data connection. I think that may be where your blank item was getting created. There was an issue with your mapping file -I'm not sure how it happened, but you had a repeating group indicated, yet the individual field mappings were not relative paths from that repeating group - they were full paths. So, I'm assuming that the batch wasn't being created properly. I've added the qRules Error node onto your form too, so you have that to return any errors when you try this new version.

    Give this copy a try & let me know what happens....

    Hilary Stoupa

  • 11-26-2012 09:55 AM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    Wow, that worked just as advertised. Yea, I decided to try the original way with the second rule to see if something was off there. Looks like this will do exactly what we need. Thank you very much!
  • 11-26-2012 09:59 AM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    You bet - it can be kind of confusing the first few times you set it up, but pretty handy to not have to write & maintain custom code every time you want to save some stuff to a list. :-)

    There are a ton of other useful commands - a sample form and a user guide are included when you install qRules to help you find & understand them, and we keep a pretty close eye on the forum for questions, so don't hesitate to post if you have trouble.

    Hilary Stoupa

  • 11-27-2012 01:10 PM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    I tried to set it up in our Dev environment on the more complex form to submit to multiple lists and now it won't even 'submit'. I don't get an error from the QRules Mapping and nothing at all hits the appropriate list, which is odd. I did have to use multiple mapping files though so I'm using the mapping command on the Submit button. The mapping files look good, as in they didn't have the same issue the first one I made did with the repeating groups. Any ideas? {C9D277A5-C47E-47F1-93C4-CA6E0DC649B9} true my:myFields/my:POS my:POS_Title Title my:POS_Type POS_x0020_Type my:POS_Notes POS_x0020_Notes my:POS_Quantity POS_x0020_Quantity my:POS_Due_Date POS_x0020_Due_x0020_Date my:POS_Cost POS_x0020_Cost my:POS_Assigned_To POS_x0020_Assigned_x0020_To my:POS_Image1 POS_x0020_Image1 my:POS_Image2 POS_x0020_Image2 my:POS_ShPID http://infuzion-sp01/
  • 11-27-2012 02:19 PM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    So, the very first thing I do when I hear something like this is see if qRules works at all in the form. When I went to preview your form, I got a warning about it not being able to find it's custom code - is there a chance you may have accidentally added code to your form? It is possible to use qRules with custom code, if that is what you want, and I'll get you a document link on that if so - but more often, people accidentally add it - InfoPath makes it very easy to do - and it disables qRules.

    To remove this, go under File > Form Options (IP 2010 - Tools / Form Options for IP 2007) and under Programming, click the Remove Code button. Save and close your template. Then re-inject your template with qRules again and see what happens....

    Hilary Stoupa

  • 11-27-2012 02:31 PM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    I feel a little dumb that I spun my wheels for so long this morning on it, especially since I didn't add any code intentionally. Thank you very much. It looks to be cranking along now.
  • 11-27-2012 03:02 PM In reply to

    Re: QRules - InfoPath to SP List, (no title) list items are getting created

    Don't feel dumb. The hint for me was that you weren't getting an error & nothing was being created. On your machine, it could find the code files, so it didn't give you any information about code having been added. What I do is put the command and result field on the form, then preview and type GenerateGuid in the command field - you should get a shiny new GUID in the result. If you don't - something has disabled qRules. :-)
    Hilary Stoupa

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