Hi all,
I'm fairly new to PHP and SPSS and have the following query.
I have some data in a MYSQL database which I can read into an SPSS .sav datafile using an SPSS syntax file test.SPS defined as:
GET DATA /TYPE = ODBC /CONNECT='dsn=MHC' /SQL='select mycol from hc_lookup_table'
.
SAVE OUTFILE='C:\hc_lookup.sav'
.
I can run this from the command line by creating a SPSS Job and calling it from the command line as "spssprod.exe c:\SPSSJob1.spp -s -r" which opens the SPSS production facility runs the syntax file test.SPS and successfully creates the output file.
I want to call this command line string automatically from PHP. i've tried using the PHP system, passthru and exec commands and I see the spssprod.exe and spsswin.exe files in task manager under SYSTEM user (not my user) . then spsswin.exe vanishes and spssprod.exe is left with no output file produced.
Does anyone have a solution / tips for this?
tia
Jase
