Importing a CSV into a Physical File

Based upon the guide from racingmars / Mainframes & More with Matthew: https://www.youtube.com/watch?v=8kAEcep1AdA

Let's say you uploaded WRDL/400 to your AS/400 and want to use the master wordlist CSV supplied. How do you import this file other than typing out the words one by one with DFU? Utilizing the Installable Filesystem (IFS) present in V3R1 and newer, it's easy. Make sure you have TCP/IP and the FTP server running on your AS/400 host, then follow these commands.

This guide uses the built-in Windows FTP command-line client and assumes WRDL.CSV is relative to the directory you started FTP from.

open <your AS/400's hostname or IP address>

Log in with the appropriate username and password.

quote site namefmt 1

This tells the FTP server to use the unix-style directory and pathing system instead of the OS/400 native one.

mkdir tmp

put wrdl.csv /tmp/wrdl.csv

You must specify a leading slash on the destination parameter, otherwise the OS/400 FTP server will not know where to put your file. When the upload completes, you are done with the FTP side of things.

CRTSRCPF WORDLE/ERROR

Creates an error log file that our next command will use to log lines that did not import. Failure to create this file will cause our next command to fail.