Focal Point
[SOLVED] ftp file from remote server

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/16010869

April 28, 2009, 07:58 PM
neerajk
[SOLVED] ftp file from remote server
I want to retreive a file from MVS and read content from downloaded file.
File has input paramters for further execution.
Any details on how to FTP in fex and then place it in IBI folder to read content will be useful .

Thanks..

This message has been edited. Last edited by: Kerry,
April 28, 2009, 10:58 PM
Waz
Assuming WebFOCUS has OS access, you can do a call to FTP.

The windows FTP command supports a script file containing FTP commands.

The call is FTP -s:scriptfile.

You will have to write out or have a script file available, then do the call.

DOS FTP -s:scriptfile
or
! FTP -s:scriptfile
or
WINNT FTP -s:scriptfile


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 28, 2009, 11:35 PM
neerajk
I do have access to MVS and with same FTP user i can distribute output to same MVS.

But now my reqt is to retreive file and read content.

Created ftpabc.txt in current working domain with details as -
-*ftpabc.txt
WEBFOCUS
WEBFOCUS
get abc.txt "\\ibisrv1\ibi\apps\holdtemp\abc01.txt"
quit

Then executed FTP call from fex.

-*test.fex
-********************************
-DOS ftp -s:app\ftpabc.txt FTPMVS
-********************************

Get Error opening script file app\ftpabc.txt
April 28, 2009, 11:42 PM
Waz
I think you may have to have an absolute path to the script file.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 29, 2009, 07:37 PM
neerajk
Thanks Waz...giving absolute path works.