Suggestions for distribution of database files to folders (Can I FTP From shared folder?)
Posted on 2006-11-22
I am trying to work out an efficient method of distributing 60 or so files to a variety of folders every monthend. The database files are the output of RPG programs and have unique names for company and report and unique run id
e.g. R01F10456 = R - Results, 01 Head office , F - Finished goods report , 10456 - Unique run id.
R04O10457 = R(Results) , 04 (France), O (Obsolete stock report) , 10457
R18B10458 = R(Results),18 (Wales office) , B (Bought stock report), 10458 - unique run ID.
The files need to be copied to various folders on the network depending on the Company id (see above)
e.g. \Finance\Reports\01 - All reports for head office
\Finance\Reports\04 - All reports for French office
I am considering using the CPYTOIMPF command to copy the AS/400 file to a .csv file to be loaded into Excel and then ftp to the various folders.
The client is running V5R3 with a mixture of Client Access, Acess for iseries etc.
I have managed (at last thanks to other contributions on this site) to map a drive to the QDLS\A folder (where the result .csv files are copied).
Only thing is I can't seem to get any FTP access to the \QDLS\A folder.
I want to schedule all of this so it happens automatically
1) Given the scenario , what would you suggest to achieve it?
2) Can I get FTP access to the \QDLS\A - a shared folder on the AS/400 ?