SharePoint Integration

Re: Overwriting infopath filename in SharePoint

shaun.nieves — Tue, 09 Oct 2007 20:36:46 GMT

No worries, it looks like I've stumped the great minds here yet again.

I got the code from Patricks book which I think is available somewhere on this site. It's called Developing Solutions with Infopath and is a great read.

Place this in an onload procedure (it's in VB)

If Not thisXDocument.IsNew Then
          Dim Submit As DAVAdapter
          Submit = thisXDocument.DataAdapters.Item("Main submit")
          If thisXDocument.URI.StartsWith(Submit.FolderURL) Then
          thisFilename = thisXDocument.URI.Substring(Submit.FolderURL.Length)
End If

In order for it to work you will need to declare thisFilename as a public variable

To call it onSubmit,

Dim Submit As DAVAdapter
            Submit = thisXDocument.DataAdapters.Item("Main submit")
            If thisFilename Is Nothing Then
                thisFilename = Submit.FileName
            End If

Submit.Submit()
e.ReturnStatus = True

For this portion to work your submit data connection must be named "Main submit" and it is case sensitive. Hope this helps!

Re: Overwriting infopath filename in SharePoint

grahamC — Thu, 04 Oct 2007 15:24:25 GMT

Sorry to take this thread slightly off topic, but you mention in your post "patricks excellent tip for captruing the filename on load". Would you mind sharing how to do this please or providing a link. Please PM if you dont want to post on here and take the thread too far off topic.

thanks

Overwriting infopath filename in SharePoint

shaun.nieves — Mon, 01 Oct 2007 23:25:49 GMT

I have an order tracking form. The form file name uses the customer name. If a user submits a form then comes back and changes the customer, a new file is created. I would like the existing file name to be updated if part of the file name is changed. Is this possible? I am currently using Patrick's excellent tip from his book on how to capture the file name on load and use it on submit but like I mentioned before, I need to be able to update the file name without creating a new record. Any help would be greatly appreciated. Thanks!