RE: Win2K Pro FTP server recommendations

Im all for making things as simple and trouble free as possible.
Thats one of the reasons im looking at FTP in the 1st place.

The PC application needs a CSV formated file.

Im assuming what your saying is to use the FTP server on the AS400,
and the FTP client from the Win2K box. Pull rather than Push.

I guess the reason i was looking at Push was i know i can control the
entire process from CL, and have it all done on the one machine.

I cant expect the user to learn FTP cmds, and i dont know off-hand how to write
an FTP script that can run on a Win2K Pro box. Or can that be done in some
of the FTP clients like WS-FTP?

Also, currently the PC code would like to do a RMTCMD to do at least a
CLRPFM, an my preference is to do all of that natively. The more done on a
single box the better to my mind.


Still,

Pulling the data could still be a viable solution - either way someone has to
manually initiate the process - the same person that starts off the following
PC application.

Something to think about.
Interesting how you often tend to focus on the solution you 1st think of.

"If all you have is a hammer, everything looks like a nail"


Thks for the suggestion.

Regards

Ian.



-----Original Message-----
From:   Paul Raulerson [SMTP:praulerson@hot.rr.com]
Sent:   Monday, 16 December 2002 2:08
To:     midrange-l@midrange.com
Subject:        Re: Win2K Pro FTP  server recommendations

I'll show my ignorance;

   Why don't you just have the W2K machine FTP the file down as a flatfile, or 
as a comma separate file
if that is what you really need?  I do this on a pretty regular basis here. It 
sounds like you are making a pretty simple task much
more difficult that it really has to be...

-Paul


----- Original Message -----
From: "Ian Scotson" <iscotson@bigpond.com>
To: <midrange-l@midrange.com>
Sent: Sunday, December 15, 2002 12:31 AM
Subject: Win2K Pro FTP server recommendations


>
> Hi guys,
>
> I'm looking at a job that needs to transfer a CSV file from
> a DB400 file to a Win2K pro PC for eventual sending to
> a number of Retail stores via s/ware on the Win2K Pro PC.
>
> It has been currently done via ODBC into access, then moved
> via a Mapped drive method - very messy to me and damn
> slow  - mainly im told because a RMTCMD wouldnt work
> because of Conflicting OCX type problems?
>
> Anyway, my feeling is that doing all conversion work to CSV on the
> AS400 (V5R1) via CPYTOIMPF with maybe a little help from
> a bit of freeware (CRTCSVDTA) courtesy of Martin Rowe, and then
> FTP'g it to the PC would be the better/cleaner/quicker/etc way to
> go.
>
> Having said that, what FTP server on the Win2K should i use??
> I believe Win2K Pro has it own FTP server - would that work OK?
> If so, is it easy to setup and get working?Reliable?
> Or maybe some other freeware/shareware product?
> Probably cant justify a full blown commercial product ( other than pretty 
>cheap one..)
>
> Any recommendations that work well with the AS400 would be most welcome.
>
> Regards
>
>
> Ian Scotson.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.