iSeries Data Transfer

Executing File Transfers

iSeries (AS/400) Data Transfer

BlueZone Secure FTP has the ability to perform iSeries data transfers via FTP and automatically place the data into a Microsoft Excel Spreadsheet, comma delimited file or tab delimited file. The resulting spreadsheet or file can be edited and transferred back to the iSeries host.

This procedure assumes that you already have BlueZone Secure FTP running and connected to an iSeries host. It also assumes that you have an existing physical data file (must be a type *FILE with attribute PF) located on the iSeries host that you wish to download and view as a data file.

NOTE Since iSeries directories can be very large, and can take a long time to display, you may want enable the "Disable automatic LIST after connect and uploads" feature. To enable this feature, edit the connection and go to the Miscellaneous tab, and check the checkbox.

To receive a data file from the host system:

Highlight the data file located on the iSeries host (right hand window) you want to download and right click. The Receive File pop-up menu will display.

Select iSeries File Transfer from the pop-up menu. The iSeries File Transfer menu will display.

Or, from the BlueZone Secure FTP MenuBar, choose Transfer:Receive iSeries File Transfer. The iSeries File Transfer menu will display.

Enter the name of the Library you wish to send the file from if you are not in the correct Library now.
Enter the name of the iSeries file you wish to receive if the correct file is not being displayed now.
Enter the name of the Library where the File Field Description (FFD) file is located if you are not in the correct Library now.
Enter the name of the File Field Description (FFD) file to be generated on the iSeries host. This file has specific data about the types of fields in the file.
Enter the PC Filename of the file you wish to receive if the correct file is not being displayed now.
Select the PC File Type you wish to receive it as:

Excel Spreadsheet (.XLS)
Comma Delimited (.CSV)
Tab Delimited (.TXT)

Check whether or not you want to delete the FFD after the transfer completes.
Click the OK button.

BlueZone Secure FTP will display a transfer status dialog showing the file transfer progress. To cancel a file transfer in progress, click the Cancel button.

After the file download is complete, the appropriate application will automatically launch and display the data.

To send a data file to the host system:

Highlight the desired data file in the left hand, client side window and right click. The Send File pop-up menu will display.
Select iSeries File Transfer from the pop-up menu.

Or, from the BlueZone Secure FTP MenuBar, choose Transfer:Send iSeries File Transfer. The iSeries File Transfer menu will display.

Enter the name of the Library you wish to send the file to if you are not in the correct Library now.
Enter the name of the iSeries file you wish to send if the correct file is not being displayed now.
Enter the name of the File Field Description (FFD) library you wish to use if it is not being displayed now.
Enter the name of the File Field Description (FFD) file you wish to use if it is not being displayed now.
Enter the PC Filename of the file you wish to send if it is not being displayed now.
Click the OK button.

The PC File and the will be parsed, the new data file will be created and uploaded to the iSeries host.