SharePoint Integration

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

Matt Faus — Thu, 14 Jun 2007 22:46:31 GMT

Hi Jack,

Did the error give a line number? I don't really have time to debug your code. My guess is that it's an XPath error. In general, you should check to see if the selectSingleNode() returns null or not before accessing the .text attribute. We use a helper function to do this and it returns "" if the node is null.

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

jeagly — Thu, 14 Jun 2007 21:59:15 GMT

Okay Matt,

I got this usefull error, "InfoPath cannot complete this action because of an error in the form's code." Let me know if anything jumps out at you!

function Submit::OnClick(eventObj)

{
var root = XDocument.DOM;
// Retrieve the values for the calendar item
var PPCEID = root.selectSingleNode("my:myFields/my:PPCEID").text;
var PPCENumber = root.selectSingleNode("my:myFields/my:PPCENumber").text;
var Description = root.selectSingleNode("my:myFields/my:Description").text;
var AssignedTo0 = root.selectSingleNode("my:myFields/my:AssignedTo").text;
var Status0 = root.selectSingleNode("my:myFields/my:Status").text;
var DueDate = root.selectSingleNode("my:myFields/my:DueDate").text;
var batch = XDocument.DataObjects["EventsCAML"].DOM; //

Set the location batch.selectSingleNode("/Batch/Method/Field[@Name='PPCEID']").text = PPCEID;
// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='PPCENumber']").text = PPCENumber;
// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='Description']").text = Description;
// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='AssignedTo0']").text = AssignedTo;
// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='Status0']").text = Status;
// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='DueDate']").text = DueDate + "T";
// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Submit"].Submit();
}

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

jeagly — Thu, 14 Jun 2007 21:20:31 GMT

Hi Matt,

I don't have permissions to upload. You might be interested in a post that I submited to a similur forum, http://www.infopathdev.com/forums/thread/20220.aspx 20691. This might help explain what I am working torwards.

I was successfully able to complete the tutorial at; http://enterprise-solutions.swits.net/infopath2003/article.php?t=programmatically-add-item-sharepoint-2003-calendar-infopath-2003-script&c=infopath2003

it is sort of what I am trying to do only I want to submit to an issues list not an event to a calendar. But when I modified it to fit my design the button did not submit nor did I get an error that something was wrong.

My source:

var root = XDocument.DOM;

// Retrieve the values for the Action Item
var PPCEID = root.selectSingleNode("my:myFields/my:PPCEID").text;
var PPCENumber = root.selectSingleNode("my:myFields/my:PPCENumber").text;
var Description = root.selectSingleNode("my:myFields/my:Description").text;
var AssignedTo0 = root.selectSingleNode("my:myFields/my:AssignedTo0").text;
var Status0 = root.selectSingleNode("my:myFields/my:Status0").text;
var DueDate = root.selectSingleNode("my:myFields/my:DueDate").text;
var batch = XDocument.DataObjects["assToCAML"].DOM;

// Set PPCEID batch.selectSingleNode("/Batch/Method/Field[@Name='PPCEID']").text = PPCEID;
// Set PPCENumber batch.selectSingleNode("/Batch/Method/Field[@Name='PPCENumber']").text = PPCENumber;
// Set Description batch.selectSingleNode("/Batch/Method/Field[@Name='Description']").text = Description;
// Set AssignedTo batch.selectSingleNode("/Batch/Method/Field[@Name='AssignedTo0']").text = AssignedTo0;
// Set Status batch.selectSingleNode("/Batch/Method/Field[@Name='Status0']").text = Status0;
// Set DueDate batch.selectSingleNode("/Batch/Method/Field[@Name='DueDate']").text = DueDate;
// Submit the item details to the web service to update AI List

XDocument.DataAdapters["Submit"].Submit();

Sorry for the confusion. Thanks for you patience.

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

Matt Faus — Thu, 14 Jun 2007 18:59:57 GMT

Hi Jack,

You can't submit Lookup types to SharePoint. I still don't think I understand your problem - can you attach an XSN so I can take a quick look? I haven't worked with SharePoint CAML too much, so I'm not sure how much help I will be, but I can try.

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

jeagly — Thu, 14 Jun 2007 16:39:28 GMT

Hi Matt,

I created an Issues list in SharePoint to track Action Items, assignees and status etc. I want to update the list via InfoPath. I used the CAML method to UpdateListItems. In SharePoint there are several DDLs identified as choice types, Status being one of them. I want to update the choice type via DDLs from InfoPath. How do I do that? I've searched the forum. I am begining to wonder if I need to use the UdateList method rather than the UdateListItems.

I am slowly learning XML: I
want Status field in InfoPath to share the choice column in SharePoint. I have found some posts on what I thought would create the FieldName as Type Lookup, but on preview, all that displays in the DDL is Lookup.

<?xml version="1.0" encoding="UTF-8" ?>

- <Batch OnError="Continue">

- <Method ID="1" Cmd="New">

- <Fields>

</Fields>

</Method>

</Batch>

Thanks!

<?xml version="1.0" encoding="UTF-8" ?>

- <Batch OnError="Continue">

- <Method ID="1" Cmd="New">

- <Fields>

</Fields>

</Method>

</Batch>

Thanks!

Re: Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

Matt Faus — Thu, 14 Jun 2007 08:41:40 GMT

Hi Jack,

I don't think I fully understand your question. You can submit to a SharePoint list from InfoPath, and we have several very long threads as well as a blog post on how to do this. It's a little complicated, but it can be done.

The only data type issue I've heard about submitting to SharePoint is with RichText columns, and possibly dates.

Is it possible to submit from InfoPath to a List in SharePoint that contains a column type (choice)?

jeagly — Mon, 11 Jun 2007 17:50:15 GMT

I am trying to submit a from InfoPath to a list in SharePoint. Can I create a connection between the drop down list box in InfoPath and the choice box in SharePoint? It appears that the only way to submit to SharePoint is if all column types are single line of text. Is that correct?