General

Re: Passing Data into a Form

davidair — Mon, 25 Jun 2007 18:39:29 GMT

Now that you know your script works, the next thing to do is to look at how you're invoking it. You're doing it like this:

ProcId = Shell("cscript \\franklin\c$\Inetpub\wwwroot\shared\Infopath\jscript.js 8275")

You can of course try to do it differently, maybe by doing Process.Start(), passing it the full path to cscript.exe and the rest of the command line as arguments.

However, I would still suspect you might be running into permission issues since you are doing this from an ASP.NET code which runs under lower priviledges. You might want to check the logs to see if any exceptions happened (not sure where to start looking, though, off the top of my head).

Re: Passing Data into a Form

TogasPoon — Mon, 25 Jun 2007 17:53:18 GMT

Not so random, updated to SP1 - the script now runs from the run command.

Now I just need to get the script to run from my asp page.

Thanks for all your patience.

Re: Passing Data into a Form

davidair — Mon, 25 Jun 2007 17:03:13 GMT

Here is a random thought: are you sure that your production machine has InfoPath 2003 SP1 or later?

I believe InfoPath 2003 RTM simply does not expose InfoPath.Application

If you're running the RTM version of InfoPath then this is your problem

Re: Passing Data into a Form

TogasPoon — Mon, 25 Jun 2007 16:56:21 GMT

It runs but fails on this line:
var oApp = new ActiveXObject("InfoPath.Application");

With this error:
Automation server can't create object

Re: Passing Data into a Form

davidair — Mon, 25 Jun 2007 16:45:26 GMT

Strange... maybe some .NET permissions problems that prevent you from executing scripts on the production machine? It's a wild guess, really. Normally you should get an exception if it doesn't like you.

Since you are doing a shell exec, try to do a start | run on your production machine and paste the command there - see what happens.

Re: Passing Data into a Form

TogasPoon — Mon, 25 Jun 2007 16:34:46 GMT

That helps.

It's not even running the script file on the production box.

I change the start of the jscript.js to this:

WScript.Echo("Start");
if(WScript.Arguments.count()==1)
{
var param1 = WScript.Arguments.Item(0);
}
...

and I never get the start message box (I do on my local machine).

If I put this string (\\franklin\c$\Inetpub\wwwroot\Shared\Infopath) into my Windows Explorer address bar on the web server it takes me to right folder.

Re: Passing Data into a Form

davidair — Mon, 25 Jun 2007 16:22:40 GMT

Well, it's pretty hard to debug pasted code especially when it is known to work on one environment but not the other, but maybe a couple of pointers:

- Make sure the InfoPath process get started when you execute the script

- Try and see if you can replace cscript with wscript. Then add WScript.Echo() lines throughout your javascript code. When executed with wscript, those should appear as mesageboxes. Now you can put those traces at different points of your code to see what is failing

Sorry that I don't have more suggestions for now...

Re: Passing Data into a Form

TogasPoon — Mon, 25 Jun 2007 16:13:18 GMT

Oops, that was a error when I copy/pasted, the code I'm testing isn't commented out.

I fixed the code above.

Re: Passing Data into a Form

davidair — Mon, 25 Jun 2007 16:08:09 GMT

Didn't you comment out the line that starts the script in your code? :)

Re: Passing Data into a Form

TogasPoon — Mon, 25 Jun 2007 14:33:01 GMT

OK,

I got it to work on my dev box using the following code but when I run it from our production server nothing happens. I don't really work with jscript so I'm not even sure where to begin debugging.

Here is the relevant code

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim ProcId As Integer
    Dim Proc As System.Diagnostics.Process
    ProcId = Shell("cscript \\franklin\c$\Inetpub\wwwroot\shared\Infopath\jscript.js 8275")
    Proc = System.Diagnostics.Process.GetProcessById(ProcId)
    Proc.WaitForExit(3000)
End Sub

And this is the js file called from above

if(WScript.Arguments.count()==1)
{
var param1 = WScript.Arguments.Item(0);
}

//Start the application
var oApp = new ActiveXObject("InfoPath.Application");
WScript.Echo("InfoPath Version: " + oApp.Version);

//Open an InfoPath document from the published template
var oXDocumentCollection = oApp.XDocuments;
var oXDocument = oXDocumentCollection.NewFromSolution("http://franklin/shared/infopath/Metro Sales MA.xsn");

// Get pointers to the target fields
var oID = oXDocument.DOM.selectSingleNode("//my:PlanId");

//Determine whether the xsi:nil attribute is set for this
//element. If so, remove the xsi:nil attributes so that
//the value can be set.
if (oID.getAttribute("xsi:nil"))
oID.removeAttribute("xsi:nil");

//Update the fields
oID.text = param1;

//Submit the Form
//oXDocument.Submit();

oXDocument.QueryAdapter.Command = 'SELECT * FROM vwMaPlanForReport WHERE PlanId = ' + param1;

//execute "dbo"."byroyalty" ' + percentageValue;
//Query the Data Source.
oXDocument.Query();

oXDocument.DataObjects["Detail"].QueryAdapter.Command = 'execute "dbo"."ps_Reports_MA_Detail_Summary" ' + param1;
//'SELECT * FROM vwMaPlanEquipmentDetail WHERE PlanId = '
oXDocument.DataObjects["Detail"].QueryAdapter.Query();

//Close up shop
oXDocumentCollection = null;
//oApp.Quit();
oApp = null;

Re: Passing Data into a Form

TogasPoon — Fri, 22 Jun 2007 13:17:50 GMT

That's what I was thinking but later in the blog article it talks about using the parameters in the IP2003 so I was holding out hope.

I'll look into the two links,

Thanks

Re: Passing Data into a Form

davidair — Fri, 22 Jun 2007 13:13:13 GMT

The last line of your post is unfortunately your problem. Command line arguments are only supported in InfoPath 2003.

See this forum post for some IP2003 workarounds:

http://www.infopathdev.com/forums/post/20383.aspx

Passing Data into a Form

TogasPoon — Fri, 22 Jun 2007 13:05:35 GMT

From this Blog:

http://blogs.msdn.com/infopath/archive/2007/02/26/passing-data-into-a-form-input-parameters.aspx

I should be able to run a command line like this:

infopath.exe “C:\foo\bar.xml” /InputParameters "baz=1&biz=2"

to pass in parameters to my form.

When I do I get the following error:

Microsoft Office InfoPath does not recognize some or all of the command line options. Exit and restart MS InfoParth with the correct command line options.

I'm using Infopath 2003 SP2