Importing a CSV into a Physical File - Revision history

Snow at 00:13, 16 June 2025

2025-06-16T00:13:31Z

← Older revision		Revision as of 00:13, 16 June 2025
Line 30:		Line 30:

	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.		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.

			<pre>
			CPYFRMIMPF

			From Stream File: '/tmp/wrdl.csv'
			To data base file:
			File: WRDLWORDS
			Library: WORDLE
			Member: *FIRST
			Record delimiter: *CRLF
			Error record file:
			File: ERROR
			Library: WORDLE
			Member: ERROR
			</pre>

			This will copy the Wordle CSV into the WRDLWORDS file automatically. Any errors will be populated into the ERROR file.

			Launch the program that needs this data and should be populated.

	[[Category:Guides]]		[[Category:Guides]]

Snow at 23:19, 15 June 2025

2025-06-15T23:19:19Z

← Older revision		Revision as of 23:19, 15 June 2025
Line 25:		Line 25:
	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.		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.

			<pre>
			CRTSRCPF WORDLE/ERROR
			</pre>

			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.

	[[Category:Guides]]		[[Category:Guides]]

Snow: Created page with "Based upon the guide from racingmars / Mainframes & More with Matthew: https://www.youtube.com/watch?v=8kAEcep1AdA Let's say you uploaded [https://github.com/LBBNetwork/WRDL400 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 you..."

2025-06-15T22:39:41Z

Created page with "Based upon the guide from racingmars / Mainframes & More with Matthew: https://www.youtube.com/watch?v=8kAEcep1AdA Let's say you uploaded [https://github.com/LBBNetwork/WRDL400 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 you..."

New page

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

Let's say you uploaded [https://github.com/LBBNetwork/WRDL400 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.

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

Log in with the appropriate username and password.

<pre>
quote site namefmt 1
</pre>

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

<pre>
mkdir tmp

put wrdl.csv /tmp/wrdl.csv
</pre>

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.

[[Category:Guides]]