Overview

Thank you for your interest in Excel-erator, the software utility that transforms System i database files into Excel spreadsheets.

There are 3 steps to installing Excel-erator on your System i. They are:

  1. Create a save file on your System i.
  2. Transfer the contents of file xl1.svf from your PC to the save file using FTP.
  3. Restoring Excel-erator from the save file.

Procedures for each of these steps are detailed below. In these procedures PC denotes an operation performed on your PC while i5 denotes an operation performed on your System i. Enter represents the enter key.

But before you start, If you haven't already unzipped the download do so now by double clicking it, or by choosing Start > Run and specifying “xl1”.

Step 1. Save File Creation Procedure

To create a save file on your System i perform the following:

  1. i5 Sign on to your System i as the security officer (QSECOFR).
  2. i5 Create a save file by running the command:

    CRTSAVF FILE(QGPL/XL1SAVF) AUT(*ALL)Enter

You are now ready to transfer xl1.svf to your System i.

Step 2. Transfer Procedure - FTP

To transfer xl1.svf to your System i using FTP, perform the following:

  1. i5 Insure the FTP server is active by running command:

    STRTCPSVR SERVER(*FTP)Enter

  2. PC Choose Start > Programs > Accessories > Command Prompt. Change to the directory where you unzipped the downloaded file. This is usually:

    cd \Gumbo\ProdData\XL1\InstallEnter

  3. PC Open an FTP connection to the System i by running (substitute your system's name or IP address):

    FTP system_nameEnter

  4. PC Enter a user name and password when prompted.
  5. PC Change to binary (image) mode by running:

    binaryEnter

  6. PC Change to library/file/member mode by running:

    cd /qsys.lib/qgpl.libEnter
    quote site namefmt 0Enter

  7. PC Transfer the product save file by running:

    put xl1.svf qgpl/xl1savfEnter

  8. PC End FTP and the command prompt by running:

    quitEnter
    exitEnter

You are now ready to restore Excel-erator from the save file, go to Step 3 Restore Procedure.

Step 3. Restore Procedure

To restore Excel-erator to your System i perform the following:

  1. i5 Verify that your System i is running IBM® i release V5R4M0 or a later release by running:

    DSPDTAARA DTAARA(QGPL/QSS1MRI)Enter

    Note: If you are running a version of IBM® i earlier than V5R4M0, release V1R7M0 of Excel-erator can not be installed on your System i. Download and install an earlier release.

  2. i5 Verify that user domain objects are allowed in the product's library XLERATOR and in library QSRV by running:

    WRKSYSVAL SYSVAL(QALWUSRDMN)Enter

    Take option 5 to display the value. If the value is not *ALL, use option 2 to add libraries XLERATOR and QSRV to the list of libraries where user domain objects are allowed. QSRV is required to correctly process PTFs when they are loaded and applied.

  3. i5 Insure that IBM® i will be able to verify the signatures that we apply to our product's objects by installing our Signing Certificate and Root CA Certificate in the system's *SIGNATUREVERIFICATION certificate store using Digital Certificate Manager. Alternately, insure that signature verification will not prevent the restore operation by running:

    WRKSYSVAL SYSVAL(QVFYOBJRST)Enter

    Take option 5 to display the value. If the value is 3 or higher, use option 2 to temporarily change the value to 1.

  4. i5 Restore the product by running (you may wish to submit this command to batch):

    RSTLICPGM LICPGM(2A55XL1) DEV(*SAVF) SAVF(QGPL/XL1SAVF) LNG(2924)Enter

    Note: During the restore operation the system operator message queue may receive inquiry message CPA3DE4 "Directory not registered. (C G)". Unless you are using a directory naming convention similar to ours (that is the directory specified in the CPA3DE4's second level text is unrelated to our software), You can safely respond with a "G" to reestablish the relationship between the directory and the product. Typically the message will occur three times.

  5. i5 Delete the save file which is no longer needed:

    DLTF FILE(QGPL/XL1SAVF)Enter

  6. i5 Type GO XLERATOR/XLERATOREnter to display the product's main menu.
  7. i5 Select option 1 to display the on-line manual which contains additional instructions.
  8. PC To purchase a license to this software, see files prices.htm, order.htm and license.htm on your PC.

Additional Information

  1. For additional information see IBM's® Install, upgrade, or delete IBM® i and related software SC41-5120.
  2. If you are restoring to V6R1M0 or later, program conversion is preformed the first time the software is used. The conversion will take some time. For more information see Memo to Users V6R1