PeopleSoft Corner

CB Login

Recommended Products

I use and recommend the following products:

UltraEdit

UltraCompare

BeyondCompare

SQL Developer

del.icio.us addon for Firefox

 

How do you move your files? Print
Friday, 16 June 2006
Every Financials and HRMS implementation I've seen involves moving flat files between internal and external systems.

I recently worked with a client that had an automated system called "File Mover". The original version was created years ago by a Unix expert who decided that it would be nice to have generic scripts to look for files on regular intervals and FTP them when they were created. Smaller "setup" scripts specified the filename to watch for, the system it needs to be FTP'd to, the userid and password on the remote server, and what to name the file once the FTP was complete.

Over the years File Mover was modified to encrypt files with PGP, get inbound files, support secure FTP, verify the file has quit growing before moving it, avoid overlaying a remote file, check process scheduler for a Success code, append to files, send e-mail notifications, hide authentication information, etc.

It's actually quite sophisticated, but the biggest problem is with the learning curve when bringing in new people. To support it, you have to be pretty good with Unix and able to figure things out with little documentation.

Having a tool like File Mover was quite opposite of another client who had one or two FTE's on staff to manually move files.

Another client was somewhere in between - most files were moved via individual scripts that were either scheduled or called from Process Scheduler.

So I was wondering -- how do you move files in and out of your ERP system? Do you have a better way?
Comments (1)add feed
Comment from Imtiaz : Imtiaz
You might try to look at the tool Connect Direct (NDM).

http://www.sterlingcommerce.com/Products/AllProducts/Connect/direct.htm



It is a licenced tool but offers a lot of features.
December 28, 2006
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley
Smiley


Write the displayed characters


busy
Last Updated ( Friday, 16 June 2006 )
 
< Prev