Date: Wed, 21 Dec 2011 13:03:33 -0800
Reply-To: "Pirritano, Matthew" <MPirritano@ochca.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Pirritano, Matthew" <MPirritano@ochca.com>
Subject: Re: FTP Data Extraction and Automation via Syntax + Finding SPSS
Help Manuals Online.
1. It looks like all the manuals are posted on the ibm site here:
2. What ftp client are you using? Chances are there is a way to
automate the uploads. I use ws_ftp and have a simple batch statement
that uploads the file. I then have windows scheduler run this batch
statement regularly. I have it set to run at 6am every day. This is what
my batch file looks like with generic filenames. The last line renames
the file with the current date. 'h' is just what the network (local)
drive was labeled in this case:
wsftppro.exe -s ftpConnectionName:\remote folder path\remote filename
-d "local:h:/local path/local filename"
cd /d h:\go to directory where file you just loaded lives
ren filename filename_%date:~10,4%%date:~4,2%%date:~7,2%.xls
3. I've also scheduled syntax to run in a python wrapper using the
windows scheduler. So you could schedule the ftp inload, allow for
sufficient time for the file to be loaded, and then schedule the python
file with the spss syntax to run. I would imagine that you can run any
ftp client like this.
Matthew Pirritano, Ph.D.
Research Analyst IV
Medical Services Initiative (MSI)
Orange County Health Care Agency
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
J. R. Carroll
Sent: Wednesday, December 21, 2011 12:30 PM
Subject: FTP Data Extraction and Automation via Syntax + Finding SPSS
Help Manuals Online.
Tried searching the web but my searches turned up nothing relevant. I
am trying to find a way to automate some monthly analyses without having
to go through some intermediate steps.
Question 1: Currently, my team has to log into an FTP site, manually
select and download a specific file on the server and download it to
their own HDD, then run the SPSS script necessary to analyze the data.
We are looking into ways that we might just link directly to the FTP
file via syntax (e.g. some sort of "open" syntax command that allows
FTP). Does SPSS syntax support this? If not, are there alternatives
like if I wrap the syntax into a python layer (using a module like
sockets or twister for packet management or some other FTP module -
haven't really looked into this yet)? The file is either a flat/text
file or a CSV and prepared by a client, so we do not have an ODBC
Question 2: I couldn't "easily" find the SPSS help manuals online (I
found some old archived SPSS help manuals on a few personal sites). I
also checked the SPSS/IBM wiki but nothing jumped out at me.
Specifically I was looking for the PDF's that come packaged with SPSS
(syntax ref, programming ref/python, etc); the PC I am on doesn't have
SPSS installed on it right now. Am I blind and just totally glazed over
it? Or is not available for d/w? Whatever the case, can someone
suggest a solution to getting access to the manuals while I am away from
a PC that has SPSS?
I've already tried: google, IBM/SPSS Forums, old syntax ref manuals,
and a few other odds and ends for both questions.
J. R. Carroll
Researcher for Hurtz Labs
Instructor at California State University, Sacramento
Research Methods, Test Development, and Statistics
Cell: (916) 628-4204