Newbie Questions

Re: Transferring data between two forms

gdgonzal — Mon, 19 Sep 2011 21:16:11 GMT

Hello Daniels,

I am experiencing the same issues defining dfs because of ambiguous xpath. I am also using Access 2003 as my main data source and when I look at the data field Details all I see is "Key_Field (Optional attribute field)" which is the unique indentifier field I am trying to pass from form 1 to form 2 when it's opened. There is no Namespace defined for this field that I can see. The only time I see a Namespace being defined is within myFields, not either queryFields or dataFields I am pulling from Access 2003.

I believe this is also addressed within this article when you suggest using a var to define this...the problem is you don't seem to mention where exactly in the code this should be defined.

Can anyone advise on how I should implement this within the code example you've provided?

var form1Field = XDocument.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetUserName");

var form2Field = objNewForm.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetName");

Then set the value of the form2 field using the following:

form2Field.text = form1Field.text;

Re: Transferring data between two forms

colecg — Tue, 02 Mar 2010 15:10:50 GMT

I hope this is what you are talking about. I just took out href="file:///C:" and <my:txtHyperLink>http://</my:txtHyperLink>

<?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution solutionVersion="1.0.0.820" productVersion="12.0.0" PIVersion="1.0.0.0" href="file:///C:" name="urn:schemas-microsoft-com:office:infopath:SIPA-1a:-myXSD-2010-01-11T12-50-42" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?><?mso-infoPath-file-attachment-present?><my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/" xmlns:s1="http://microsoft.com/wsdl/types/" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-01-11T12:50:42" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">

<my:group3>

<my:group4>

<my:txtCreatedBy>me</my:txtCreatedBy>

<my:Update></my:Update>

<my:attachmentBox xsi:nil="true"></my:attachmentBox>

<my:ddlStatus>Draft</my:ddlStatus>

<my:txtComment></my:txtComment>

<my:field1></my:field1>

<my:field2 xsi:nil="true"></my:field2>

<my:txtAtt xsi:nil="true"></my:txtAtt>

<my:txtMonthlySummary></my:txtMonthlySummary>

<my:txtAssessment></my:txtAssessment>

<my:ddlUpdateType>Update Report</my:ddlUpdateType>

<my:ddlMonthOfMonthlyUpdate>January 2010</my:ddlMonthOfMonthlyUpdate>

<my:dtDate></my:dtDate>

<my:txtTextBoxMonthlyUpdateTitle>January 2010</my:txtTextBoxMonthlyUpdateTitle>

<my:txtHyperLink>http://</my:txtHyperLink>

</my:group4>

</my:group3>

<my:listGUID>{EA770E3E-AF73-47F4-8A4B-EC1E565E8585}</my:listGUID>

<my:signatures1></my:signatures1>

</my:myFields>

Re: Transferring data between two forms

Jimmy — Tue, 02 Mar 2010 14:38:43 GMT

That certainly is puzzling. Would you mind putting up an example of one of these XML files on here so someone could look at it?

Re: Transferring data between two forms

colecg — Tue, 02 Mar 2010 14:15:13 GMT

Following error is displayed when I run source form, or the form from which I want to send/copy fields into the second form

Object reference not set to an instance of an object.
   at _c_Intelligence_Analysis.FormCode.CTRL120_5_Clicked(Object sender, ClickedEventArgs e)
   at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

when I run debug and look into watch of all objects, and get to number 9 from the above code

9. objNewForm.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text = objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

it says that for this object

objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

it states

Reference to undeclared namespace prefix: 'my'

Thank you for your time

Re: Transferring data between two forms

Jimmy — Tue, 02 Mar 2010 13:58:28 GMT

What's the exact error that you're getting?

Re: Transferring data between two forms

colecg — Tue, 02 Mar 2010 13:29:01 GMT

I have been following your example and trying to rewrite the same code in C#

here is my code

1. string strNewFormPath = @http://pathToForm;

2. MSXML2.IXMLDOMDocument3 objNewForm = new MSXML2.DOMDocument50Class();

3. objNewForm.load(strNewFormPath);

4. objNewForm.setProperty("SelectionNamespaces", "xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-01-11T12:50:42' xmlns:xd='http://schemas.microsoft.com/office/infopath/2003'");

5. MSXML2.IXMLDOMDocument3 objExternalData = new MSXML2.DOMDocument50Class();

6. objExternalData.validateOnParse=false;

7. objExternalData.loadXML(objNewForm.xml);

8. objExternalData.setProperty("SelectionNamespaces", "xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-01-11T12:50:42' xmlns:xd='http://schemas.microsoft.com/office/infopath/2003' xmlns:dfs='http://schemas.microsoft.com/office/infopath/2003/dataFormSolution' xmlns:ns1='http://schemas.microsoft.com/sharepoint/soap/directory/' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'");

9. objNewForm.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text = objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

10. objNewForm.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text = objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

It is all good through step number 8. On step 9 it has a problem with namespace for right side of the assignment, where it claims that namespace for this object is null.

objNewForm.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text = objExternalData.selectSingleNode("/my:myFields/my:group3/my:group4/my:txtMonthlySummary").text;

I though I assigned a namespace for this object at step 8?

Any help is more than great.

Thank you in advance.

Re: Transferring data between two forms

RhysAZ — Tue, 01 Sep 2009 18:26:12 GMT

Thank you again Daniel. Great info!

Re: Transferring data between two forms

Daniels — Mon, 31 Aug 2009 23:34:21 GMT

See article Programattically Transfer Data Between InfoPath Forms for details and instructions on how to transfer data between two InfoPath forms programmatically using a JScript example similar to the above.

If using SharePoint you can submit the data to a SharePoint list from the first form eith using a CAML query and the SharePoint lists web service or the forms main submit data source, then load the data into the second form from the SharePoint list using a secondary data connection. If not using SharePoint, this can also be achieved by submitted to an external database (Access) or even an xml file (default) which can then be used as a secondary datasource in the second form to retrieve the data.

See InfoPath - Update Existing SharePoint List Item Programmatically Using CAML for details and instructions on how to Submit data to a SharePoint using a CAML Query and the SharePoint Lists web service.
See Using Secondary InfoPath Data Connections to retrieve data from a SharePoint List or Library for details and instructions on how to configure and use secondary data connections from an infoAPath from to retrieve data from a SharePoint list.
See Submit InfoPath form to SharePoint List or Library using Content Type for instructions on how to configure an InfoPath form's main submit data connection to submit to a SharePoint library by publishing the form template as a site content type and associating the content type with the form library being submitted to.

Re: Transferring data between two forms

RhysAZ — Wed, 19 Aug 2009 21:18:58 GMT

Hi Daniel- Are experimenting with the "var" lines of code, I got it to work!!!!!!!!!!!!!!!! The correct path names are:

var form1Field = XDocument.DOM.selectSingleNode("/dfs:myFields/my:SetUserName");

var form2Field = objNewForm.DOM.selectSingleNode("/dfs:myFields/my:SetName");

I needed to use "dfs" and drop the "/dataFields/" in the path name.

Thank you very much again for your help Daniel!!

RhysAZ

Re: Transferring data between two forms

Daniels — Tue, 18 Aug 2009 09:48:21 GMT

Hi RhysAZ,

RhysAZ:
Is there an easy way to determine if I have the correct XPaths to textbox1 and textbox2?

You can get the correct XPaths for the fields in each form by opening both in design mode, then right clicking on the field in the main data source and select "Copy XPath".

RhysAZ:
And, if you can tell me any else about the line 51 error, that would be great. Thanks.

It shouldn't matter if the value of the field in form1 or form2 are NULL, as long as they have been instantiated as an accessible object/XML Element. It is only when the form is being submitted or if validation has been configured for a field that setting a value as NULL might become a problem. The field from the main data source in form2 will be "not an object" if the XPath for the field is incorrect, as with the field in form1. If the name spaces are not correct, the field will also be inaccessible, which may also result in the "null or not an object" error.

It definitely seems that it is the field which is a null object, and not the value itself. Setting the initial value using rules may help, but setting the default value or a calculation should be enough to make sure the field is accessible.

You could also try adding text box controls for the fields to a view and manually enter a value in the form1 field before executing the code to load the second form, to ensure that the fields are initiated in the data source.

Check to make sure you are setting the namespace for both the form2 (objNewForm) object/variable and the data source object for form2 (objExternalData). The name space for the main data source in form1 should already have been set by InfopPath at the top of the code so you shouldn't have to worry about this. Check that the namespace information from the field's properties of the field in form2 mastches the selection name spaces being set in the code.

Let me know if you have any luck with this.

Thanks

Daniel

Re: Transferring data between two forms

RhysAZ — Mon, 17 Aug 2009 21:05:52 GMT

Hi Daniel- Tried setting the default values on both forms. No good that way. I then added the two "var" lines and the set the value of form2 field lines of code. Got the following error:

The following error occurred:

'null' is null or not an object
File:script.js
Line:51

Line 51 is the set the value of form2 line of code (form2Field.text = form1Field.text;). When I took out that line of code, there was no more error. So, that is where the problem lies, in that line of code.

FYI- I am presently not setting the value of the SetName and SetUserName using a calculation of or fields or by rules (just using a default value in textbox1 on form1). However, I will want to do that in the near future. Ultimately, when I have verified my user on form1, I want to use the users name from textbox1 on form1 and put that in textbox2 on form2.

Is there an easy way to determine if I have the correct XPaths to textbox1 and textbox2? I have a feeling that this is my problem. And, if you can tell me any else about the line 51 error, that would be great. Thanks.

Re: Transferring data between two forms

Daniels — Sun, 16 Aug 2009 13:52:25 GMT

Hi RhysAZ,

As long as you have se the name spaces to the one stated in the properties of the "SetName" and "SetUserName" fields. I don't think it is the name spaces either.

Try setting a default value for the fields in both forms to ensure that they are selectable in the XML DOM when using the DOM.selectSingleNode() function.

You can also try assigning the fields in each form as variables separately, which will tell you which field there are issues with (see below). Before you do this, make sure you have the correct XPaths by copying from each field:

var form1Field = XDocument.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetUserName");

var form2Field = objNewForm.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetName");

Then set the value of the form2 field using the following:

form2Field.text = form1Field.text;

If you get an error at one of the first two lines then it was not able to find the required field. You will also know which form has the problem depending on if it is the first or second line.

Are you setting the value of the "SetName" and "SetUserName" fields using a calculation of other field values, or rules from other fields and controls? if so, you should check to make sure the correct value is in the field before it is being transferred to form2. If the "SetName" and "SetUserName" fields aren't bound to a control on the form's view, you should add them to each form so that it is clear what values are being copied.

Re: Transferring data between two forms

RhysAZ — Fri, 14 Aug 2009 21:25:33 GMT

Daniel- Hi again. Need your help again about this. I'm using our solution in a project I'm doing. I'm using a Access 2003 database as my Main source in both forms. I'm running into an error at the end of the code. it's not setting the value on "form2" textbox 2 with the value from "form1" textbox 1. I think it's the way I'm writing the paths to both text boxes is causing the error.

The following error occurred:

'DOM.selectSingleNode(...)' is null or not an object
File:script.js
Line:46

The first form (we'll call it form1) has queryFields and dataFields sections. In the dataFields section, there is a repeating table called d:qrytblUsers, with 8 fields in the table. There are no other repeating tables. I have added a textbox to the MyFields group, called SetUserName (it displays as my:SetUserName in the data source window).

In the second form (we'll call it form2) has queryFields and dataFields sections. In the dataFields section, there is a repeating table called d:tblMain, along with 8 other repeating tables connected to d:tblMain. I have added a textbox to the MyFields group, called SetName (it displays as my:SetName in the data source window).

The code I put in at the end of the code is this:

objNewForm.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetName").text = XDocument.DOM.selectSingleNode("/my:myFields/my:dataFields/my:SetUserName").text;

I have tried different variations of the code (using "dfs:" instead of "my:", putting in the table names (d:qrytblUsers and d:tblMain) after "/my:dataFields", but I still keep getting that same error code.

If you could please help me get the correct code for this I would appreciate it. BTW, the rest to the code works fine. I can open "form2" using the button, but it just errors out when trying to set the value of text box 2.

Thanks Daniel.

RhysAZ

Re: Transferring data between two forms

Daniels — Thu, 13 Aug 2009 09:03:44 GMT

Excellent, good to hear! I have found this to be very useful when applied in different scenarios and hope that you will too.

Glad that I was able to help.

Thanks

Daniel

Re: Transferring data between two forms

RhysAZ — Wed, 12 Aug 2009 17:27:52 GMT

Daniel- It worked!!!!!!!!!! I didn't have to adjust anything. I pasted in the path as you wrote it . I am very happy.

Thank you very much again for your help!

RhysAZ