Newbie Questions

Re: Copy Secondary Data source to Main

Hilary Stoupa — Thu, 26 Jun 2008 21:38:40 GMT

Well, the type mismatch is because your second line is selecting a node, and then you are trying to set a text field to a node... thus, they are not the same type. I am pretty much stumped at this point -- I had thought your problem would be due to the xpath ("EmployeeName_Full") being incorrect, but really, since your first block of code works fine for all the fields except "EmployeeName_Full" and you aren't using the attribute symbol ("@") in any of the rest of them, I am afraid I am out of ideas.

Re: Copy Secondary Data source to Main

mmarvi — Thu, 26 Jun 2008 20:31:36 GMT

I used this

nSharedItem.selectSingleNode("@EmployeeName_Full").text

And still got the error.

I tried this, on a wild hunch

nSharedItem.selectSingleNode("@EmployeeName_Full")

And got type mismatch?

Any Ideas?

Re: Copy Secondary Data source to Main

Hilary Stoupa — Thu, 26 Jun 2008 20:12:22 GMT

Okay, they are attributes. Try this "@EmployeeName_Full"

Re: Copy Secondary Data source to Main

mmarvi — Thu, 26 Jun 2008 19:45:27 GMT

Sorry, IP 2003

Would it help to extract the files and review the xsd file?

<?xml version="1.0"?>
<xsd:schema elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution">
<xsd:element name="myFields">
  <xsd:complexType>
   <xsd:sequence>
    <xsd:element name="dataFields">
     <xsd:complexType>
      <xsd:sequence>
       <xsd:element name="Staff_Profiles" minOccurs="0" maxOccurs="unbounded">
        <xsd:complexType>
         <xsd:attribute name="EmployeeName_Full" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeName_SP" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeAddressLine1" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeAddressLine2" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeAddressCity" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeAddressState_Region" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeTitle" type="xsd:string"></xsd:attribute>
         <xsd:attribute name="EmployeeEmailAddress" type="xsd:string"></xsd:attribute>
        </xsd:complexType>
       </xsd:element>
      </xsd:sequence>
     </xsd:complexType>
    </xsd:element>
   </xsd:sequence>
  </xsd:complexType>
</xsd:element>
</xsd:schema>

Re: Copy Secondary Data source to Main

Hilary Stoupa — Thu, 26 Jun 2008 18:57:52 GMT

Are you using IP 2007? Could you rightclick EmployeeName_Full and copy the xpath?

Re: Copy Secondary Data source to Main

mmarvi — Thu, 26 Jun 2008 17:49:15 GMT

Re: Copy Secondary Data source to Main

Hilary Stoupa — Thu, 26 Jun 2008 17:19:59 GMT

Do you mind posting a screen shot that shows your secondary data source schema from the taskpane in InfoPath?

Re: Copy Secondary Data source to Main

mmarvi — Thu, 26 Jun 2008 16:44:02 GMT

This is wierd,

I added XDocument.UI.Alert(groupfield.hasChildNodes());

Just before if (groupfield.hasChildNodes()) , and get a string of falses!

Could this be because I am using a Secondary Data Source?

var oSharePointDom = XDocument.GetDOM("Staff Profiles");
oSharePointDom.setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"');
var group = oSharePointDom.selectNodes("/dfs:myFields/dfs:dataFields/dfs:Staff_Profiles");
    while( (groupfield = group.nextNode()) != null ){
  XDocument.UI.Alert(groupfield.hasChildNodes());
        if (groupfield.hasChildNodes()) {
            var i = 0
            for (var i = 0; i < groupfield.childNodes.length; i++){
                 XDocument.UI.Alert(groupfield.childNodes[i].nodeName);
            }
        }
    }

Re: Copy Secondary Data source to Main

Hilary Stoupa — Thu, 26 Jun 2008 16:20:00 GMT

Hi:

I did this to iterate and show values for fields under a group:

var group = XDocument.DOM.selectNodes("/my:myFields/my:group1/my:group2");
    while( (groupfield = group.nextNode()) != null ){
        if (groupfield.hasChildNodes()) {
            var i = 0
            for (var i = 0; i < groupfield.childNodes.length; i++){
                 XDocument.UI.Alert(groupfield.childNodes[i].nodeName);
            }
        }
    }

This also pops up #text for the text content, which you can ignore, but every other alert will show you a field name.

Re: Copy Secondary Data source to Main

mmarvi — Thu, 26 Jun 2008 13:19:14 GMT

Is there any way to loop through all the column names of nSharedItem?

That may help me with the syntax of whats between the ().

Re: Copy Secondary Data source to Main

Hilary Stoupa — Wed, 25 Jun 2008 23:34:47 GMT

You have the object in the first bit:

clone.selectSingleNode("my:EmployeeName_Full").text

But I mean this line isn't returning an object:

nSharedItem.selectSingleNode("EmployeeName_Full").text

exactly for the reason you state, that you can enter text instead of the line above and not get an error. That's why I was wondering about it being the xpath in nSharedItem.selectSingleNode("EmployeeName_Full").text. Have you tried popping up an alert box to show the value of that node, or debugging? And I agree -- it is always hard when you are really close to getting something and one last thing isn't behaving.

Re: Copy Secondary Data source to Main

mmarvi — Wed, 25 Jun 2008 23:14:50 GMT

It's just a regular text field.

I have the object, because, if I comment out the offending lines, and set the clone to add straight text (""PP") I end up with a string of records with "PP".

This is depressing.

Re: Copy Secondary Data source to Main

Hilary Stoupa — Wed, 25 Jun 2008 22:35:24 GMT

Hi:

Your object required error (and your test where you replace the problematic line) indicates that nSharedItem.selectSingleNode("EmployeeName_Full").text is returning null, hence there is no object. Usually when I have that issue it is because I have a mistake in my xpath pointing to the node I want -- incorrect spelling or capitalization or something. I'm sure you have checked that already. Is there anything special about that field in your list? Is it just a regular text field?

Copy Secondary Data source to Main

mmarvi — Wed, 25 Jun 2008 19:30:48 GMT

I've found code to do the captioned job, but I have some kind of problem.

Here is my code

// Get a copy of the main DOM node.
var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:Table_StaffProfiles").cloneNode(true);

// Clear the main DOM nodes.
XDocument.DOM.selectNodes("/my:myFields/my:Table_StaffProfiles").removeAll();

clone.selectSingleNode("my:EmployeeName_Full").text = "x";
clone.selectSingleNode("my:EmployeeName_SP").text = "";
clone.selectSingleNode("my:EmployeeAddressLine1").text = "";
clone.selectSingleNode("my:EmployeeAddressLine2").text = "";
clone.selectSingleNode("my:EmployeeAddressCity").text = "";
clone.selectSingleNode("my:EmployeeAddressState_Region").text = "";
clone.selectSingleNode("my:EmployeeTitle").text = "";
clone.selectSingleNode("my:EmployeeEmailAddress").text = "";
XDocument.DOM.selectSingleNode("my:myFields").appendChild(clone.cloneNode(true));

// Get the SharePointList DOM
var oSharePointDom = XDocument.GetDOM("Staff Profiles");
// Setup the Namespaces
oSharePointDom.setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"');
// Loop through all of the items in the SharePoint List
var nlSharedItems = oSharePointDom.selectNodes("/dfs:myFields/dfs:dataFields/dfs:Staff_Profiles");

while( (nSharedItem = nlSharedItems.nextNode() ) != null )
{
// Create a new row from the sample

var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:Table_StaffProfiles").cloneNode(true);
clone.selectSingleNode("my:EmployeeName_Full").text = nSharedItem.selectSingleNode("EmployeeName_Full").text;
clone.selectSingleNode("my:EmployeeName_SP").text = nSharedItem.selectSingleNode("EmployeeName_SP").text;
clone.selectSingleNode("my:EmployeeAddressLine1").text = nSharedItem.selectSingleNode("EmployeeAddressLine1").text;
clone.selectSingleNode("my:EmployeeAddressLine2").text = nSharedItem.selectSingleNode("EmployeeAddressLine2").text;
clone.selectSingleNode("my:EmployeeAddressCity").text = nSharedItem.selectSingleNode("EmployeeAddressCity").text;
clone.selectSingleNode("my:EmployeeAddressState_Region").text = nSharedItem.selectSingleNode("mployeeAddressState_Region").text;
clone.selectSingleNode("my:EmployeeTitle").text = nSharedItem.selectSingleNode("EmployeeTitle").text;
clone.selectSingleNode("my:EmployeeEmailAddress").text = nSharedItem.selectSingleNode("EmployeeEmailAddress").text;
XDocument.DOM.selectSingleNode("my:myFields").appendChild(clone.cloneNode(true));
}

I get an Error on the Italic Lines. It seems to be nSharedItem.selectSingleNode("EmployeeName_Full").text causing the problem.

The error is

The following error occurred:

Object required
File:script.js
Line:186 is the first italic line. If I replace the nSharedItem.selectSingleNode("EmployeeName_Full").text with plain text, I get no problem, and it iterates through the whole data set.

What am I doing wrong?