Pull file from FTP site with process flow

You can use SysCommand to call a script. I tried using WebRun with ftp:// but was unsuccessful.

Shane,
We are a hospital system and do a lot of interfaces of different types of protocols to different partners. Lawson processflow is not meant to be used for doing ftp to the outside world. A simple ftp script might do but when you are dealing with encryption/decryption or secured layers which requires certificates then this can get real ugly. What we did was to use a product that can handle all kinds of integration with our third party partners, clinical systems and financial system(Lawson). We bought a product called AXWAY as our single point of integration tool (not cheap). We are happy with it (no more scripts) and even our EDI interfaces are done by this tool. This tool can also be used as a scheduler and also act like scanfileclient as well as does notifications.

When you deal interfaces with any banks, they usually use AS2 protocols and this is where the real challenges are.

Hi Shane -

Check out CoreFTP - it is an FTP server which supports SSH/SFTP and you can call it from an FTP script - thereby using PFI to FTP Securely from command line script.

I've also seen it integrated into DTS packages on SQL Server to handle secure FTP for a large retail client ($1B+ Restaurant Chain).

I believe you will find it way cheaper than an Axway solution (which is coincedentally used primarily with Movex (Lawson M3) EDI).

HTH,
Rob.

Thanks all ----   I really need an inexpensive solution that will be easy to maintain.   The DTS package sounds like an interesting concept.   As for using ProcessFlow - at the last CUE Lawson indicated that they were looking to include a full encryption tool into the system in a future release.   Since it is a payroll and benefit system it seems like clients would like to have a single solution for integrations with security.   There is a great article from Lawson about using Process Flow for integrations but they are currently missing a solution for FTP and Security of the files.  

I really thought I could do the FTP with the Web Run as well...   I just keep thinking I am missing something simple to make it work.

Thanks
Shane

You can run a batch job in a SysCommand node. The bacth job then invokes custom written FTP / Encryption / Decryption programs. In the process flows we developed, we run FTP, SSIS package, file archive, file formation, etc.