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. Restore 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 i denotes an operation performed on your System i. Enter represents the enter key.

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

1. i Sign on to your System i as the security officer (QSECOFR).
2. i 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.

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

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

   STRTCPSVR SERVER(*FTP)Enter

2. PC If you haven't already unzipped the download do so now by double clicking it, or by choosing Start > Run and specifying xl1.
3. 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

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

   FTP system_nameEnter

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

   binaryEnter

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

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

8. PC Transfer the product save file by running:

   put xl1.svf qgpl/xl1savfEnter

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

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

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

   DSPDTAARA DTAARA(QGPL/QSS1MRI)Enter

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

2. i 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. i 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. i 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. i Delete the save file which is no longer needed:

   DLTF FILE(QGPL/XL1SAVF)Enter

6. i Type GO XLERATOR/XLERATOREnter to display the product's main menu.
7. i 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.

1. For additional information see IBM's^® Install, upgrade, or delete IBM^® i and related software SC41-5120.