B PC Download for Lotus and Excel

This appendix contains the topic:

B.1 About the Download Process

  1. Run the FASTR version with the following information specified in the corresponding fields on the Override Default Information form:

    Field Information
    PC Download File Y
    Member Name (your name, initials, or version name)
    Library Name (a valid library name). If left blank, the system will create a file in QGPL

  2. When the version finishes running, resubmit it by entering an 8.

  3. Press Enter.

    This reformats the version that you created in step 1 ,and saved to disk file F8309, into an EBCDIC format.

  4. (Optional) You should have a file prepared to be converted to ASCII. You can view this file by entering the following commands:

    Prompt Value
    Command entry DSPPFM
    File FASTR form ID (e.g. GENERAL)
    Library QGPL (or whatever library was specified in the library field)
    Member Version identifier (e.g. XJDE0001)

  5. Press F4.

    If the file is there and resembles the version that you submitted, proceed to step 6; otherwise, return to step 1.

  6. You are ready to use the PC support product to create the transfer.

Transferring the Data via your PC Support Product

  1. Access your PC support product. The following instructions are for IBM Client Access on a Windows NT 4.0 platform.

  2. Double click on the selection Data Transfer from AS/400.

  3. AS/400 System Name: Type your system name (e.g., JDEG1)

  4. File Name: Click on Browse and select -

  5. Library/Form Name/(Version Name) (e.g., QGPL/TEACHER(XJDE0001)

  6. PC Output Device: File

  7. Select the subdirectory and file name with a .prn extension where you want this file to reside on your PC.

  8. Click Transfer Data From AS/400.

  9. A window appears with the message: Receive completed successfully.

Lotus Instructions

  1. Once in Lotus, press F9 to retrieve options. Choose the following:

    • F - File

    • I - Import (Do not use R - retrieve)

    • N - Numbers (Do not use T - text)

  2. Follow the standard procedures for creating a Lotus spreadsheet.

Excel Instructions

  1. Once in Excel, click the File/Open button.

  2. Find your file with the .prn extension in the subdirectory and open it.

  3. In the text Import Wizard Step 1 of 3 window, select the following settings:

    • Delimited

    • File Origin = DOS or OS/2 (PC-8)

  4. Click Next.

  5. In the text Import Wizard Step 2 of 3 window, select the following options:

    • For Delimiters, select comma only

    • Text Qualifier: '"

  6. Click Next

  7. In the Text import Wizard step 3 of 3 window, select the following options:

    • Column Data Format: General

  8. Click Finish.

  9. Organize the data as needed.