Data Connections

Re: Submit Infopath form to a specific folder of Sharepoint library

ramyasha20 — Fri, 18 Feb 2011 19:00:57 GMT

I'm not comfortable with any of this, I'm an Infrastructure/Security guy but I've got to learn for Organizational needs. Yes, what I'm trying to do exactly is if I submit a Leave Request and I'm in the NOC department, I'd like the form to create the Department folder and then the individual user folder if they don't exist, then place the form there. This looks like it'll be a huge help, I'm reading as much as I can and I really appreciate all the help

Re: Submit Infopath form to a specific folder of Sharepoint library

Hilary Stoupa — Fri, 18 Feb 2011 18:55:21 GMT

To create a new folder using the DWS web service, first create a data connection that receives data from a web service. The URL looks like this:

http://<yourShPServer>/_vti_bin/DWS.asmx

Replace <yourShPServer> with your actual server URL.

When you click next, there will be some methods you can choose from. Select CreateFolder.

In your form, when you want to create the folder, set the url query field of the new data connection to the folder you want in a rule:

Shared Documents/DepartmentX/SomeotherThing

You can use a concat formula:

concat("Shared Documents/", my:DepartmentField, "/", my:SomeOtherField)

Then for the next rule, query using a data connection -- this will be the data connection you just created and set the URL for. This will create the folder if it does not already exist.

However, I think what you are then wanting to do is submit your form to that new folder. This thread has a code sample you can use, if you are comfortable with code. qRules has a command you can use (ChangeSubmitUrl) which may be a better way to go, depending on your coding skill level.

EDIT: I was mistaked about this web service -- while it will create a folder in a document library, it apparently will NOT in a form library. It looks like the UpdateListItems method of the Lists web service may work, but I've not tried that.

Re: Submit Infopath form to a specific folder of Sharepoint library

ramyasha20 — Fri, 18 Feb 2011 18:42:47 GMT

Hey Hilary thanks so much! I'm rather a novice, could you assist by defining the steps? I'd ever be so grateful

Re: Submit Infopath form to a specific folder of Sharepoint library

Hilary Stoupa — Fri, 18 Feb 2011 18:29:43 GMT

You don't have to use code to create a folder. You can use the CreateFolder method of the dws web service. Create a data connection in your form to the web service. Set the url query param to the site specific folder name you wish to create (you could use a concat formula here, if you want to use form field values for the folder name) and query the data connection to create the folder.

Re: Submit Infopath form to a specific folder of Sharepoint library

ramyasha20 — Fri, 18 Feb 2011 11:51:27 GMT

Is there a way to have code auto-create those folders based on Department/User? For example:

If User A, from Department IT submits a form, to have InfoPath form auto-create the destination if it doesn't exist to where it would be Leave Forms(Root) --> IT Department --> User A

Thanks in advance!

Re: Submit Infopath form to a specific folder of Sharepoint library

phunghuutu — Tue, 28 Dec 2010 10:09:45 GMT

Hi swathip ! I was a little known code, in the code above I can not find DAVAdapter library. Please, help me! My computer use Sharepoint 2007 and Info Path 2007.

Re: Submit Infopath form to a specific folder of Sharepoint library

bashkov — Tue, 07 Apr 2009 10:37:40 GMT

Thanks a lot!

Re: Submit Infopath form to a specific folder of Sharepoint library

swathip — Tue, 07 Apr 2009 10:28:38 GMT

Hi,

You can do this using code below. Use this code in the submit button on click event.

try

{

DAVAdapter oSharePoint = (DAVAdapter)thisXDocument.DataAdapters["Adapter name"];

oSharePoint.FileName = "give the form name";

oSharePoint.FolderURL = "http://../DocLib/" + thisXDocument.DOM.selectSingleNode("XPath of your field").text;

oSharePoint.Submit();

}

catch(Exception ex)

{

String str = ex.Message;

}

Submit Infopath form to a specific folder of Sharepoint library

bashkov — Tue, 07 Apr 2009 07:29:22 GMT

How can I submit form to a specific folder (depends of the value of field) of Sharepoint library?

For example:

The value of the field = "Nosov", then the form should be submitted to: http://.../DocLib/Nosov/

The value of the field = "Zobov", then the form should be submitted to: http://.../DocLib/Zobov/

Best regards