How to automate getting the .CSV file from IFS folder to local desktop

5 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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/

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • RVP400
    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
    270 pointsBadges:
    report
  • harish1990
    Hi RVP400..i was going through your comment. the explanation you have given is my requirement. can you please elaborate me with th escript to transfer the file from IFS to pc. i have used the cpytoimpf and stored the data in .csv format in ifs folder..after that can you share your idea!!!
    125 pointsBadges:
    report
  • philpl1jb

    you might want to look at commands

    CPYFRMIMPF QSYS Copy From Import File
    CPYFRMPCD QSYS Copy From PC Document

    53,910 pointsBadges:
    report
  • philpl1jb
    I'm sorry, that wasn't relevant, you want to send it from the ifs to a PC.
    53,910 pointsBadges:
    report
  • Splat
    Have you considered mapping a drive on the PC to the iSeries?
    9,635 pointsBadges:
    report
  • ToddN2000
    You might be able to grab it using FTP. Create a simple batch program to the i-series file even before it gets to the IFS. 
    49,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: