Home > IT Answers > AS/400 > How to automate getting the .CSV file from IFS folder to local desktop
Richapd
5 pts.
 How to automate getting the .CSV file from IFS folder to local desktop
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE
I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV files stored in IFS folder?

Software/Hardware used:
ASKED: April 8, 2009  6:15 AM
UPDATED: April 14, 2009  4:26 PM
RELATED QUESTIONS
Answer Wiki:
I'm not sure I understand what you are asking. Are you asking how to open the file or how to get the file to the local PC? You can open the file on the IFS with Note pad, Word pad or Excel. If you are looking for how to get the file from the IFS to the local PC, you might want to start with Scott Klement’s tutorial "Working with the IFS in RPG IV" which you can find at http://www.scottklement.com/rpg/ifs_ebook/
Last Wiki Answer Submitted:  April 13, 2009  2:55 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Richapd,

One way to automate the transfer is using a FTP script to transfer the file from the IFS to a PC. You can have the script on the ISeries and run it directly from your program or have it on the PC and use the STRPCCMD to invoke the script.

If this is what you need, let me now – I can provide extra details on how to do it.

RVP400

RVP400
 270 pts.