InfoPath Dev

Jimmy:

kelogs1347:

swathip:

Hi,

Before getting the value of a node, verify that node is existing or not. Check rows.Current.SelectSingleNode( "@Person_Responsible", NamespaceManager) is null or not. If it is not null then go for rows.Current.SelectSingleNode( _
                "@Person_Responsible", NamespaceManager).Value.

Do the same thing for other fields also.

 How do you check if it's null or not? Sorry I'm really new to this. Thanks. 

 It would be something like this:

Dim tempNode As XPathNavigator = rows.Current.SelectSingleNode("@Person_Responsible", NamespaceManager)
Dim owner As String
If tempNode Is Nothing Then owner = "" Else owner = tempNode.Value

Of course, if @Person_Responsible is always supposed to have a value it would be best to figure out what's going wrong.

Thanks for all the help. It finally works. I used your way of checking. And it worked. Apparently it doesn't want the HasAttributes way of checking. Thanks for all the help. I totally appreciate it. :D 

I'm trying to follow the example from http://www.bizsupportonline.net/infopath2007/copy-rows-from-sharepoint-list-to-main-data-source.htm as well.  I'm using C# for my code.

 I'm running in to the same issue in regards to blank fields.  Some of the fields in my Sharepoint list are blank and it stops when it hits the first blank field.  My sharepoint list has 4 columns (Title, Owner, Notes, Meeting Date).  I want my IP form to pull those columns into a repeating table, if one of those fields is blank i want it to continue onto the next item without an error.

How can i initialize these fields as empty or have it ignoe empty fields?  I ran into a similar issue before and someone helped me with it, but i applied the bit of code that helped me in that situation and it did not help this time.

 The error i get is:

System.NullReferenceException
Object reference not set to an instance of an object.
   at MatrixAdmin_MeetingMinutes.FormCode.FormEvents_Loading(Object sender, LoadingEventArgs e)
   at Microsoft.Office.InfoPath.Internal.FormEventsHost.OnLoad(DocReturnEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._XDocumentEventSink2_SinkHelper.OnLoad(DocReturnEvent pEvent)

My code snippet is as follows:

using Microsoft.Office.InfoPath;

using System;

using System.Xml;

using System.Xml.XPath;

public partial class FormCode

// Member variables are not supported in browser-enabled forms.

// Instead, write and read these values from the FormState

// dictionary using code such as the following:

//

// private object _memberVariable

// {

// get

// {

// return FormState["_memberVariable"];

// }

// set

// {

// FormState["_memberVariable"] = value;

// }

// }

// NOTE: The following procedure is required by Microsoft Office InfoPath.

// It can be modified using Microsoft Office InfoPath.

// Retrieve the rows of the secondary data source

// Loop through the rows of the secondary data source and fill the repeating table

"@Title", NamespaceManager).Value;

"@Owner", NamespaceManager).Value;

"@Notes", NamespaceManager).Value;

// Increment the counter

// Add the item to the repeating table

// Remove the first empty item from the repeating table

XmlNode group = doc.CreateElement("group2",

XmlNode field = doc.CreateElement("Title",

field = doc.CreateElement("Owner",

XPathNavigator itemNav = domNav.SelectSingleNode(

}

Just like in the post directly above yours, you have to check that the values are not blank before you try to access them.  Please add the following method to your code:

/// <summary>
/// Returns the value of the specified node, or an empty string if the object is null
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public static string GetValueOrEmptyString(XPathNavigator node)
{
     return node == null ? string.Empty : node.Value;
}

And then change these lines:

string title = rows.Current.SelectSingleNode( "@Title", NamespaceManager).Value;
string owner = rows.Current.SelectSingleNode( "@Owner", NamespaceManager).Value;
string notes = rows.Current.SelectSingleNode( "@Notes", NamespaceManager).Value;

to this:

string title = GetValueOrEmptyString(rows.Current.SelectSingleNode( "@Title", NamespaceManager));
string owner = GetValueOrEmptyStringrows.Current.SelectSingleNode( "@Owner", NamespaceManager));
string notes = GetValueOrEmptyString(rows.Current.SelectSingleNode( "@Notes", NamespaceManager));

Thank You, that worked perfectly.  One of these days i'll get my brain wrapped around this whole programming thing.

Thanks Again!!!!

Well that worked out great, but now there's one more snag.  The code works flawlessly except for the fact that it pulls in every List item from the Sharepoint List.  I would like to filter it and only pull in the List items where the "Status" field is set to "Pending Discussion" or "Follow-Up".  I know it needs some sort of If-Else statement, but i can't seem to get the syntax right.  I thought if i just changed my data source to use a particular view of the sharepoint list it would work, but it still pulls all list items.

Here's the code snippet as it exists now, if you could help me figure out how to tell this to only display or retrieve list items with those two statues I would be oh so greatful.

// Retrieve the rows of the secondary data source

// Loop through the rows of the secondary data source and fill the repeating table

string owner = GetValueOrEmptyString(rows.Current.SelectSingleNode( "@Owner", NamespaceManager));

// Increment the counter

// Add the item to the repeating table

// Remove the first empty item from the repeating table

Hi:

Add a filter to the XPath in this line:

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:Agenda_Items", NamespaceManager);

So it only selects the Agenda Items that match your criteria. Since I'm not sure of your data structure, you'll have to modify the XPath, but something like this:

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:Agenda_Items[@Status = 'Pending Discussion' or @Status = 'Follow-Up'", NamespaceManager);

Hi Hilary,

Thanks for that bit of help, i didnt know you could add a filter in at that point.  I put those changes into my code, but now when i preview the form i get an error which i can't seem to decipher.

Error:

 System.Xml.XPath.XPathException
'/dfs:myFields/dfs:dataFields/dfs:Agenda_Items[@Status = 'Pending Discussion'' has an invalid token.
   at MS.Internal.Xml.XPath.XPathParser.CheckToken(LexKind t)
   at MS.Internal.Xml.XPath.XPathParser.ParsePredicate(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseStep(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseLocationPath(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParsePathExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseUnionExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseUnaryExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseMultiplicativeExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseAdditiveExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseRelationalExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseEqualityExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseAndExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseOrExpr(AstNode qyInput)
   at MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion(String xpathExpresion)
   at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean allowVar, Boolean allowKey)
   at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean& needContext)
   at System.Xml.XPath.XPathExpression.Compile(String xpath, IXmlNamespaceResolver nsResolver)
   at System.Xml.XPath.XPathNavigator.Select(String xpath, IXmlNamespaceResolver resolver)
   at MatrixAdmin_MeetingMinutes.FormCode.FormEvents_Loading(Object sender, LoadingEventArgs e)
   at Microsoft.Office.InfoPath.Internal.FormEventsHost.OnLoad(DocReturnEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._XDocumentEventSink2_SinkHelper.OnLoad(DocReturnEvent pEvent)

When I run a Debug from VSTA I see:

// Retrieve the rows of the secondary data source

//XPathNodeIterator rows = secDSNav.Select(

//"/dfs:myFields/dfs:dataFields/dfs:Agenda_Items",

//NamespaceManager);

// Loop through the rows of the secondary data source and fill the repeating table

//string meetingdate = GetValueOrEmptyString(rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Agenda_Items/@Meeting_Date", NamespaceManager));

string owner = GetValueOrEmptyString(rows.Current.SelectSingleNode( "@Owner", NamespaceManager));

string status = GetValueOrEmptyString(rows.Current.SelectSingleNode( "@Status", NamespaceManager));

// Increment the counter

// Add the item to the repeating table

// Remove the first empty item from the repeating table

 I realize this is an old post, but for those finding it as I did... the reason for the invalid token error is because the filter is in the wrong format. The entire filter statement must be enclosed in brackets, not just the field name. Also, I'm not sure if the operator "or" is valid in this context.