KeyesCalc Summary

KeyesCalc can be used to convert spooled files into CSV spreadsheet format.  The resulting CSV files can be used for any desired purpose, such as e-mailing, archiving, or posting on a website.

 

Spooled files must be standard *SCS printer files. We provide a mapping tool so that you can map each spooled file field to the desired spreadsheet columns.

 

For example: You can call our API to convert spooled files into CSV documents and have them placed directly into your IFS (Integrated File System).  This would make it available to everyone with access to the IFS directory.

 

KeyesCalc includes an automatic output queue processing program.  It will monitor an output queue called KCOUTQ. When any spooled file appears in this output queue, in a "RDY" status, it will be automatically converted to a CSV file and placed in your IFS.

 

KeyesCalc can be integrated with KeyesMail to allow you to email your spooled files converted into spreadsheets.

 

Details

  • Mapping Spooled Files to CSV

    Spooled files need a map member to define how they are converted to CSV spreadsheets.  The Edit Map Member screen (shown below) is used to create your map members.

     

    The Dft Data and Last Row parameters can include spreadsheet formulas.

     

    Example: =SUM(A#f:A#p) This sample formula would sum all of column A from the first detail row to the previous to last row.

     

    Special characters #c, #f, #p, can be used to specify the current row, first row, or previous to current row in the spreadsheet, respectively.

     

  • Application Program Interface (API's)

    We have included one API in the system and an output queue so that you can automatically create CSV spreadsheets out of your *SCS spooled files.

     

  • Output Queue Processing

    The output queue called KCOUTQ can be monitored for spooled files that you wish to convert.  As each spooled file becomes Ready in this output queue, it will be automatically processed into a CSV document.

     

    After processing a spooled file, it will be removed from the output queue unless you specify *YES on the Save spooled file attribute using an OVRPRTF command.

     

  • Simple Installation

    The software can be easily downloaded from the KeyesCalc Downloads section and installed on any IBM i (i5, iSeries, AS/400) computer in its own library.

     

  • System Requirements

    Hardware

    Any model IBM i (i5, iSeries, AS/400) Computer

     

    Software

    OS/400 Version 7 Rel 1 or higher

     

Pricing

All prices are per Logical Partition.

 

(All Models IBM i (i5, iSeries, AS/400)) - as of 1/01/23

 

$2750

 

Multicopy discounts

 Quantity   Discount

     2-4             10%

     5-9             15%

   10-19           20%

     20+             30%

 

Annual Maintenance

The first year of maintenance is free. Thereafter, an annual maintenance fee of 20% of the current price will keep your system current and bug free.

 

Downloads

KeyesCalc

Live Software:

Download to a PC and double click, then view the included Readme.txt.

File

kc01lib.exe

 

Manuals:

File

kc1man.pdf

 

Brochures:

File

kc1brch.pdf

 

 

 

Size

1584Kb

 

 

Size

304Kb

 

 

Size

174Kb

 

 

 

Description

Version 1 live software, V7R1M0 or higher

 

 

Description

Version 1 manual

 

 

Description

Version 1 brochure

 

 

 

Date Uploaded

07/06/2022

 

 

Date Uploaded

10/25/2021

 

 

Date Uploaded

11/08/2022

 

Free Trial / Activation Codes

  • KeyesCalc - Version 1 V7R1M0 or Higher

    To try KeyesCalc free for 30 days, use the link below to download the software to a PC and then double click to extract a Readme.txt with further instructions. Contact us or use the form below to have an activation code sent to your email.

     

    File

    kc01lib.exe

     

    Contact Form:

     

    Description

    Version 1 live software, V7R1M0 or higher

     

    Date Uploaded

    07/06/2022

     

    Size

    1584Kb

     

    Submitting Form...

    Incorrect Image Verification answer, or the server encountered an error.

    Form received.

    *If you do not know your Serial Number or Lpar Number, install KeyesCalc on your IBM i from the download link first, and then use the following commands to display your Serial Number and Lpar Number:

     

    chgcurlib kclib

    kclicense

     

Version Differences

  • KeyesCalc Version 1.0

    10/30/2020 - KeyesCalc Software (Spooled file to CSV Spreadsheet)

    KeyesCalc can be used to convert *SCS printer files to CSV spreadsheets.  KeyesCalc is a standalone package that can be integrated with KeyesMail for emailing spreadsheets or used by itself to create and save CSV documents to your network.