InfoPath Dev

Only just started dabbling with InfoPath. I am currently designing a form that needs to be saved to a specific location with a specific reference id as the file name which is to be taken from a field within the form. But alas, as you might have guessed, it does not work for me.

I have followed steps outlined in the article Extending the Save Functionality in InfoPath 2003

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_ta/html/odc_InfoPath_extending_save.asp

This document describes how to add script through Tools - Form Options > Open And Save > Save Behaviour > Save using custom code

The code I have used is as follows:

Sub XDocument_OnSaveRequest(eventObj)

' Write the code to be run before saving here.

Dim GMSRef
GMSRef = thisXDocument.DOM.selectSingleNode("//my:myfields/my:field5").text
If thisXDocument.IsNew = True or eventObj.IsSaveAs = False then
	If eventObj.IsSaveAs = True then
		thisXDocument.UI.SetSaveAsDialogLocation("f:\Windows Infrastructure\Inspection Form")
		thisXDocument.UI.SetSaveAsDialogFileName(GMSRef)
	End If
	eventObj.IsCancelled = eventObj.PerformSaveOperation()
	eventObj.ReturnStatus = true
Else
		thisXDocument.UI.Alert("The 'Save As' functionality is disabled for forms that are not new.")
End If

End Sub

The error message is as follows:

quote:

---

InfoPath cannot save the form.
The OnSaveRequest function returned a value indicating that the save failed.
The following error occurred.

Object required: 'thisXDocument'
File:script.vbs
Line 24

---

Line 24 is highlighted red and bold.

Any help would be gratefully recieved. I know I am doing something daft and it is most likely to do with the way I am using vb.

Thanks

Hi.

I believe the error is being caused due to your XPath command.
The // will selects nodes in the document from the current node that match the selection no matter where they are.
In addition you are fully qualifying the node you want.
Therefore the node is not being located and thus calling the .text method raises an exception.

Could you try changing your line 24 to;
GMSRef = thisXDocument.DOM.selectSingleNode("my:myfields/my:field5").text
Basically remove the //

cheers. Scott.

Thanks for the response but it didn't make any difference. Any other ideas?

Hi.

Just as a sanity check does my:myfields/my:field5 exist? or is it myFields or Field5. XPath is case sensitive.

cheers. Scott.

One other thing is does field5 node contain a value? Please makie sure that it does contain that. Also i would suggest setting some hardcoded value such as abc.xml to GMSRef and verify that the file does get saved.

This will let us know for sure that its because the value of GMSRef is incorrect that the file is not getting saved. It could be either that it is null or it contains a character that is not suitable for a file name.

Hope this helps!

Shanthi
InfoPathDev India

Hello

The field does exist and hopefully I am referencing it correctly. In looking at the datasource (main) I have a folder myfields, within it I have the field called field5 which is expecting a string - it has validation ensuring that the field is not left blank.

I simply added a series of text boxes etc and accepted the default names.

I can also confirm that myfields and field5 is all lowercase.

Thanks

I changed the value of GMSref to abc.xml

GMSRef = abc.xml
'GMSRef = thisXDocument.DOM.selectSingleNode("my:myfields/my:field5").text

The error message changed, only now instead of saying object required is 'ThisXDocument' it was now requiring object "abc.xml"

Hi. Again just a sanity check. Your code is - DIM GMSRef as string = "abc.xml" Cheers. Scott.

Well actually the code I am using is:

Dim GMSRef
GMSRef = "abc.xml"

which produces the original error about thisXDocument

If I use

Dim GMSRef As String
GMSRef = "abc.xml"

or

Dim GMSRef As String = "abc.xml" 

it fails to even open the form:

quote:

---

InfoPath cannot open new blank form.
InfoPath cannot open the selected form because of an error in the form's code.
The following error occurred:

Expected end of statement
File:script.vbs
Line:25
DIM GMSRef as string = "abc.xml"
or
DIM GMSRef as string

---

Sorry my apologies. I see you are using script and not managed code. I have not used InfoPath scripting. Initial questions that spring to mind are;
* is the thisXDocument object definatly set?
* does the eventObj parameter provide the XDocument?

Sorry i cant be of much more use. Cheers. Scott.

I am simply looking to have a form filed with the unique reference id as entered into the form as the filename and to specify exactly where it is saved to.

The first obvious choice was as per the link in my first post. If this is not the best way to go can you identify another method. The script is provided by infopath with the sub name etc declared. Evidently the script is not getting details of what thisxdocument is.

I am really stuck with this and if there is an alternative way to do it then I'll use it.

Many thanks

Paul

Hi Paul.

Sorry for the delay, i have been out of the office for a few days.

Here you go http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkIntroducingInfoPathDevelopment_HV01073333.asp

thisXDocument is not the object in script. Use XDocument;
GMSRef = XDocument.DOM.selectSingleNode("my:myFields/my:field1").text

this works for me :)

Cheers. Scott.

Hi,

The problem I have is not the same but it is regarding the same function.

The form contents is saved using eventObj.PerformSaveOperation(); method.
As the user can modify the file name, I would like to save this new file name (a default one is set when the dialog box is opened) in the XDocument.
I use eventObj.XDocument.URI; to get the new file name but saved XML document is not updated (I agree with that).

How can I do that ?
I tried a XDocument.Save(); but it doesn't work (error message).
If I use again eventObj.PerformSaveOperation(), a new dialog box is opened. Unfortunately the IsSaveAs property is read-only.

Thanks for your help.

Save requires higher security. Why do you need to store the value in the XDocument DOM when you can always query the URI when you open the file?

Patrick Halstead [InfoPath MVP]
InfoPathDev