Qdabra qRules

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 17:29:49 GMT

When you say "update an existing record in the table", I think you mean update the XML with the latest from the SharePoint list. Is that correct?

If so, you can do this with the RefreshSharePointListItems command. Generally, I'd suggest setting this command on the finishedLoading node of the QdabraRules data source -- when finishedLoading is true for the condition. That way, when the user opens the XML, the list items get updated.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Thu, 10 Feb 2011 17:13:54 GMT

The submit attachment is working now. The problem was the XPath to your attachment field like you said. I think I was the one who was confused. :-) Thank you. As I read further in the document, it seems that if someone wants to update an existing record in the table, they would have to look up the ID number of the line, then return to the form and use another button to update it. Is that right?

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 17:09:39 GMT

I am utterly confused at this point.

I believe you are having issues with your SubmitToSharePointList command because you do not have the correct XPath to your attachment field. I do not understand what the owssvr.dll link for the Refresh command has to do with this issue. Perhaps you can tell me?

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Thu, 10 Feb 2011 16:58:39 GMT

Is this what you're looking for?

This is the location of the XML file from step 2 on page 11.
http://windows/kits/_vti_bin/owssvr.dll?CMD=Display&List={60A2F8ED-5B45-45D5-9120-37E1536D053C}&XMLDATA=TRUE&NOREDIRECT=TRUE

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 16:57:11 GMT

Okay, got your latest template. Your command should be:

SubmitToSharePointList /submit=ShPSubmit /mapping=mapping /id=my:ID /dsname=AddAttachment /xpath=my:Attachments /uniqueName=yes

The /xpath needs to be to your attachment field in your form. The name of the field is immaterial -- but the xpath needs to be correct, and if you are working with a repeating group, relative.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 16:46:27 GMT

What is the full XPath to the attachment field in your form?

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Thu, 10 Feb 2011 16:44:32 GMT

I changed the name of the field to match the existing field in SharePoint in the hopes that that would fix the problem

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 16:32:24 GMT

I'm looking at the copy of your template you sent me, and the /xpath to your attachment file looks incorrect in your command. Wouldn't it be: /xpath=my:EEAP_Attachment ?

EDIT: Sorry, I didn't really answer your question -- no, you don't need a separate button, the command you are using should submit to the list and save your attachment -- the issue is simply that your xpath is incorrect, I think.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Thu, 10 Feb 2011 16:14:22 GMT

Yes, I'm using one button to submit to list. I'm using the instructions in the document, "qRules and Sharepoint-related commands." I am up to step 16, but nothing is working yet. Here's what the button says:

SubmitToSharePointList /submit=ShPSubmit /mapping=mapping /id=my:ID /dsname=AddAttachment /xpath=my:attachments/my:attachmentFile /uniqueName=yes

Am I to understand that there needs to be a separate button to update the existing info in the list, and one to attach an attachmen to an existing list item?

Thanks!

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Thu, 10 Feb 2011 00:50:57 GMT

What is your full command? I'm thinking you are using the version where you include the attachment with your SubmitToSharePoint list command?

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Thu, 10 Feb 2011 00:47:00 GMT

I can't get the attachment part to work. There is no error message, it just doesn't attach.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Wed, 09 Feb 2011 22:29:07 GMT

You should also be able to change your SharePoint list columns back to True / False, and form data types -- you seem to completely understand the way they need to match. What was tripping you up was just that Attachment field.

It is true / false, and lets SharePoint know whether to display the little paperclip icon for the list item. The attachment itself has its own location. :-}

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Wed, 09 Feb 2011 22:20:13 GMT

Thank you Hilary! I'll read the document to get the attachment to work.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Hilary Stoupa — Wed, 09 Feb 2011 22:12:44 GMT

Just updating our thread here with the latest -- the attachments field should not be mapped. The attachments column in the list is actually a true / false value. With that column mapped to a field that had an attachment in it, you were submitting text to a true / false field (just like the error said).

Here's a link to a doc that has more info on how to include attachments with your list items.

Re: Errors occured submitting to list: Invalid Yes/No value A Yes/No field contains invalid data. It should be either 1 or 0. Please check the value and try again.

Carolyn2 — Wed, 09 Feb 2011 21:42:03 GMT

I'll email it to you privately.