RE: [sqr-users] Using Call System to FTP on file on WINNT-and PeopleSoft

["Knapp, Richard" <KnappR@umsystem.edu>]

Peoplesoft is running on a different machine than your desktop, no?  So how can 
you expect that commands that work on your desktop machine will work on the PS 
server?

Make a command that uses the server OS and file paths for when it runs on the 
server.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of bmrazek@sympatico.ca
Sent: Tuesday, January 20, 2004 2:11 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Using Call System to FTP on file on WINNT-and
PeopleSoft


Hi Everyone,

I have read a few postings on this issue, and have tried recommended changes, 
but nothing seems to be working for me.  I an running an SQR under PeopleSoft 
PIA (Web) that is using call system to ftp a file from NT to the FTP site.  The 
code works fine if I run it through SQRW, but when running it through a 
PeopleSoft page, nothing happens.  I don't believe I am getting a valid status 
code either, as it is always 0, though from what I read in the SQR manuals, for 
NT, anything less than 32 is an error.

Though my code is built dynamically in the SQR, ultimately, when call system is 
executed, it looks like this:

C:\WINNT\system32\cmd.exe /c ftp -n 
-s:\\scanty\psoftfm\\FMDEV\user\upload\fms_ftpout.bat

As stated, this works fine from the "run" command in windows, and also running 
through SQRW, but running it from within peoplesoft results in no results :-)

Any suggestions would be greatly appreciated.

Barb


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users