Newbie Questions

Re: open infopath 2003 form from sharepoint 2007 document list and pre-populate a field

grahamC — Wed, 19 Sep 2007 10:57:39 GMT

I've got round this problem now. I think you need to reference a published template with a full http path. Also you need to put an extra "\" char in for every "\" that appears in the path. (due to c# escape characters).

So my javascript all works. Now i just need to wrap that up in a button that can be placed on a sharepoint page as a user control and possibly then have that control wrapped up in a web part.

That may be a little beyond the scope of this forum as i appreciate this is moving away from infopath functionality somewhat.... but if anyone has any ideas i'd be happy to hear them :-)

cheers,

graham

Re: open infopath 2003 form from sharepoint 2007 document list and pre-populate a field

grahamC — Tue, 18 Sep 2007 11:05:30 GMT

ok i've been trying to test this... i have created a little html page with some javascript as follows:

<head>

<title>Test bit of javascript page</title>

function myfunction()

{

var strHRef= window.location.href;

var subString = strHRef.substr(strHRef.indexOf("Proposal"));

var splitstring = subString.split("/");

var strReturn = splitstring[1];

return(strReturn);

}

</script>

</head>

<body>

function openInfoPathPopulated()

{

var ProjID = myfunction();

alert(ProjID);

//

var oApp = new ActiveXObject("InfoPath.Application");

var oXDocument = oApp.XDocuments.NewFromSolution("c:\infopathtemplate\fifth.xsn");

var targetField1 = oXDocument.DOM.selectSingleNode("//my:ID0");

targetField1 = ProjID;

}

</script>

<form>

</form>

<p>By pressing the button, a function will be called. The function will alert a message.</p>

</body>

</html>

but i'm getting a problem with the path of the file to be opened: "the path referred to by an object model must be absolute".

i'm pretty new to all this.............. any ideas ??? Hopefully im on the right track with this.

open infopath 2003 form from sharepoint 2007 document list and pre-populate a field

grahamC — Tue, 18 Sep 2007 08:51:55 GMT

hi,

I have looked around the forum and found bits of posts that may be helpful to what i want to do but i just want to confirm that i am correct that this can be done ??

I have a sharepoint site that produces a workflow for creating project proposals. The project proposal form is based on a published template in inofpath 2003.

Basically when a user clicks generate proposal webpart button in sharepoint database entries are created in sqlserver db and an ID is assigned and a subsite for that proposal site is created. In that newly created subsite we put the infopath form based on the published infopath template in the mainsite (we do not want to publish EVERY document that is created for all the subsites though....). What we really want is when the infopath doc is opened from the new project proposals subsite.. is to have the project ID displayed in the first field. The project ID can be taken from a part of the URL of the subsite by a bit of string manipulation.

I have two questions really:

1/ can this actually be done in infopath 2003 ?

2/ if so, is the following how to all i need ?? http://www.infopathdev.com/blogs/jim/archive/2005/09/14/Pass-Parameters-to-InfoPath.aspx

I think the how to will only work for a published document as you need to change the manifest etc...... We would ideally like all this fully automated for the user (as its a workflow) and not have to do any specific actions for each new document created in the subsites.

I hope i have been clear in my explanation !

Appreciate any help/advice/pointers to samples that do this.