SharePoint Integration

Re: Populating a repeating table from a Sharepoint List

Potemkine — Thu, 14 Oct 2010 18:16:25 GMT

Hi, just a comment on that:

string selected = rows.Current.SelectSingleNode("xSelected", NamespaceManager).ValueAsBoolean.ToString();

you can just do :

string selected = rows.Current.SelectSingleNode("xSelected", NamespaceManager).Value;

it's the same and simpler.

For your current problem, You probably need to remove the xsi:nil attribute. Here a sample of code to remove it:

IXMLDOMNode FullBooleanNode = thisXDocument.DOM.selectSingleNode("//my:Node");
removeNil(FullBooleanNode ).text = "true";

public IXMLDOMNode removeNil(IXMLDOMNode node)
{
if (node.selectSingleNode( "@xsi:nil" ) != null)
node.selectSingleNode( "@xsi:nil" ).text = "false";

return node;
}

you can make a search on google for more detail.

Re: Populating a repeating table from a Sharepoint List

jkuni — Thu, 14 Oct 2010 13:07:57 GMT

Since I got that working, I am trying to do the same process for an entire form. The overall goal is to have users create a new form, have everything autopopulate, then have the user able to check the rows that are needed, so that we can then use the xml to pull out only those rows to make a presentation view. I've got a basic structure as follows Selected, Category Type Requirement Requestor Value Date being the columns, and category, type, requirement being strings, value a drop down between H,M,L, requester a person and date date. Selected is the actual boolean check list. Now my problem is I get a null error when I use, even though selected shows the value of false. string selected = rows.Current.SelectSingleNode("xSelected", NamespaceManager).ValueAsBoolean.ToString(); So my first question would be how to solve this, and secondly is what I am trying to do even possible? I don't want the data to be uplaoded to a sharepoint list, rather be able to create a view in sharepoint to pull out only the selected fields from the xml. Sorry, basically new to Infopath and Sharepoint. Thanks for any help.

Re: Populating a repeating table from a Sharepoint List

Potemkine — Wed, 13 Oct 2010 13:45:19 GMT

Your welcome !

Re: Populating a repeating table from a Sharepoint List

jkuni — Wed, 13 Oct 2010 13:38:49 GMT

Yeah that worked. I figured it would be something very small. Thank you.

Re: Populating a repeating table from a Sharepoint List

Potemkine — Wed, 13 Oct 2010 13:24:42 GMT

Hi, I think you have a problem with your Xpath. You don't paste you "rows" line so I can be sure but I suppose you have to change all your "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:FirstName" by just "d:FirstName", "d:Email","d:LastName"

Populating a repeating table from a Sharepoint List

jkuni — Wed, 13 Oct 2010 13:09:22 GMT

I found a few tutorials online regarding this and am having trouble getting it working 100%.

I have 7 rows in a list of emails, MyContacts. The repeating table will fill 7 rows, but each row is filled with the information from the first row, say first name - John last name- Doe email- johndoe@.com.

I know that row is actually progressing and holding the values of the next row in the list, and when i do row.Current.Value it actually spits out the entire next row correctly.

code :

DataSource ds = DataSources["MyContacts"];

XPathNavigator domNav = ds.CreateNavigator();

XPathNavigator listNav = ds.CreateNavigator();XPathNodeIterator rows = listNav.Select("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW", NamespaceManager);

while (rows.MoveNext())

{

string lastName = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:LastName", NamespaceManager).Value.ToString();

string firstName = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:FirstName", NamespaceManager).Value.ToString();string email = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Email", NamespaceManager).Value.ToString();

AddItem(lastName, firstName, email);

I assume something is going wrong with the SelectSingleNode, and the xpath attribute to pull from. Any help would be much appreciated.