Thank you for downloading Excel-erator, the software utility that transforms IBM i database files into Excel spreadsheets.
There are 4 steps to installing Excel-erator on your system. They are:
xl1.svffrom your PC to the save file using FTP.
Procedures for each of these steps are detailed below. In these procedures PC denotes an operation performed on your PC while i denotes an IBM i operation performed on your system. Enter represents the enter key.
To create a save file on your system perform the following:
CRTSAVF FILE(QGPL/XL1SAVF) AUT(*ALL)Enter
You are now ready to transfer
xl1.svf to your system, go to Step 2 Transfer Procedure - FTP.
xl1.svf to your system using FTP,
perform the following:
quote site namefmt 0Enter
put xl1.svf xl1savf.fileEnter
You are now ready to restore Excel-erator from the save file, go to Step 3 Restore Procedure.
To restore Excel-erator to IBM i perform the following:
Note: If you are running an IBM i release earlier than V7R2M0, release V2R2M0 of Excel-erator cannot be installed on your system. Download and install an earlier release.
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.
Note: If individual libraries are listed, the library QTEMP must be included in the list.
Take option 5 to display the value. If the value is 3 or higher, use option 2 to temporarily change the value to 1.
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 or four times.
Note: When the RSTLICPGM command completes, library XLERATOR and directory '/Gumbo/ProdData/2A55XL1' contain the new software.
Temporary authorization of the software is automatic upon first use.