"A MUST Have Tool For AS/400-iSeries PC Data Integration"

 

 

 

What would you like to do?

     Convert PC files to AS/400-iSeries database files

     Access PC data with RPG, COBOL or other HLL via API(To Be Announced)

     Convert AS/400-iSeries database files to PC files

     Convert AS/400-iSeries reports to PC files

      View product documentation

 

      View product pricing

      Request an evaluation copy

      Purchase our products

 

 

 

 

Convert AS/400-iSeries Database Files to PC Files

"Create pre-formatted application ready files from your AS/400-iSeries data."

 

Overview

CVTDBF(XLS/DB) is a collection of software utilities that convert AS/400-iSeries database files to  Microsoft Excel spreadsheets and Dbase database files and places the resulting PC files in the Integrated File System.   Supports packed and binary AS/400-iSeries data with automatic translation from EBCDIC to ASCII.

 

 

Features (CVTDBFXLS)

  • Titles - Create up to three(3) lines of title information with the ability to specify the starting column.  Create custom titles or dynamically create them using a variety of keywords.
  • Row & Column Formulas - Create Excel spreadsheets with 'live' formulas using the @SUM, @COUNT, @MIN, @MAX, and @AVG functions
  • Multiple Sheet Spreadsheets - Generate multiple sheet Excel spreadsheets based on member name or field value. Assign custom descriptions or dynamically created descriptions using a variety of keywords. 
  • Keywords - Choose from a variety of keywords to dynamically create titles, sheet descriptions and  printer header/footer information.  Keywords cover the source database file, source file text, multi-sheet field, source file library, source member, source member text, system date, system time. Also, a special *EDIT keyword can be used to produce additional date formats. For example: *EDIT(*DATE,"DDDD, MMMM DD, YYYY") will display the system date of 12/05/2003 as Friday, December 05, 2003
  • Column Headings - Create headings consisting of data description specifications(DDS) field names, *ALIAS data, DDS column headings or custom entries consisting of multiple lines.
  • Field Overrides - Specify *ALL fields and then enter individual field entries to override database defaults.
  • Print Header/Footer - Create up to three(3) lines of printer header and footer information with the ability to specify left, center or right alignment.  Create a custom printer header/footer or dynamically create them using a variety of keywords.
  • Excel Date & Time Support - Translates AS/400-iSeries date and time formatted data to Excel date and time formats
  • Accurate Column Widths - Column widths generated directly from the data description specifications
  • Fixed Columns/Rows - Specify the Fixed Columns/Fixed Rows option to freeze rows and  columns in place for better visibility while scrolling
  • Field Selection - Specify up to 256 fields from the AS/400-iSeries database file or select all fields
  • Host Based - No PC hardware or software required

 

 

Sample CVTDBFXLS Command

CVTDBFXLS FRMFILE(QIWS/QCUSTCDT) STMF('/qdls/csuite/Example1.xls') TTL('File:*FILETXT Date:*EDIT(*DATE,"DDDD, MMMM DD, YYYY")'/'A' 'File:*FILE'/ 'A' 'Member:*MBR'/'A') SHT(*FILETXT/*NONE) FLD(*ALL '"Customer" "Number"'/*DDS/CUSNUM *SUM/'"Credit" "Limit"'/*CURR/CDTLMT *NO/*SUM/'"Balance" "Due"'/*CURR/BALDUE '"Credit" "Due"'/*CURR/CDTDUE)

 

 

From This

 

 

To This

 

 

 

 

[TOP]

 

Features (CVTDBFDB)

  • Familiar Field Names - Dbase field  names generated from data description specifications field names
  • Dbase Date Support - Translates AS/400-iSeries date formatted data to Dbase date format
  • Field Selection - Specify up to 256 fields from the AS/400-iSeries database file or select all fields
  • Host Based - No PC hardware or software required

 

[TOP]

 

Convert AS/400-iSeries Reports to PC Files

"Convert production reports to popular PC files."

 

 Overview

CVTSPLF is a software utility that converts AS/400-iSeries reports to Microsoft Excel spreadsheets and places the resulting PC files in the Integrated File System. Unlike CSV(comma separated value) files the report formatting is maintained and there isn't a need to adjust column widths.

 

 

Features (CVTSPLF)

  • Fixed Headings/Columns (V2.5) - Specify the Fixed Headings/Columns option to 'freeze' columns and report headings in place for better visibility while scrolling
  • Detail Line Selection - Ability to select specific report lines to provide concise detailed information
  • Single Instance of Report Headings - Automatically ignores subsequent report headings through out the report
  • Multiple Sheet Support (v2.5) - Burst reports into multiple sheet spreadsheets based on report content
  • Accurate Column Widths - Column widths generated directly from operator specified length entries to insure data visibility
  • Retain Report Look & Feel - Report formatting remains intact.  AS/400-iSeries numeric, date and time formats are converted to the resulting spreadsheet
  • Row & Column Formulas(V2.5)   - Create Excel spreadsheets with 'live' formulas using the @SUM, @COUNT, @MIN, @MAX, and @AVG functions
  • Host Based - No PC hardware or software required

 

CVTSPLF Sample Command

CVTSPLF FILE(QPRTOBJD) TOFILE(*FLDR) PATH('/QDLS/DOWNLOAD/') PCFILE(OBJLIST.XLS)
HDGLNS(3) COL01FMT(15/1/*SAME/*CHAR) COL02FMT(25/16/*SAME/*CHAR)
COL03FMT(31/26/*SAME/*CHAR) COL04FMT(51/32/*SAME/*CHAR) COL05FMT(100/52/*SAME/*CHAR)

From This

To This

[TOP]

 

Convert PC Files to AS/400-iSeries Database Files

"Easily integrate PC information into your AS/400-iSeries server environment."

 

 Overview

CVT(XLS/DB)DBF is a collection of software utilities that convert  Microsoft Excel 95, 97, 2000 & 2003 spreadsheets and Dbase database files stored in the Integrated File System to AS/400-iSeries database files.

 

 

Features (CVTXLSDBF)

  • DDS Generation - Full data description specifications created automatically in an operator specified source member
  • Member Support - Upload individual Excel sheets to specific members
  • Full Cell Access - Specify row-column start/end coordinate pairs, an Excel Range name or Sheet name to indicate the Excel data to convert
  • Excel Date & Time Support - Translate Excel date & time values to AS/400 -iSeries date and time formats
  • Host Based - No PC hardware or software required.

 

 

CVTXLSDBF Sample Command

CVTXLSDBF STMF('/qdls/expense.xls') TOFILE(QGPL/Expense) 
MBROPT(*ADD) FLDROW(*YES) 
COLINFO(0/8/N/*N 0/22/A/*N 0/7/N/*N 0/7/N/*N 0/7/N/*N)
CRTFILE(*YES) SRCFILE(QGPL/QDDSSRC) DDSOPT(*ADD) RANGE(QTR1)
NBRFMT(*SIGNED)

From This

 

 

 

To This

 

 

 

 

 

CVTDBDBF (Convert Dbase to Database File) Feature Summary:

  • DDS Generation - Full data description specifications created automatically in an operator specified source member
  • Member Support - Upload Dbase files to specific members
  • Dbase Date Support - Translate Dbase date values to AS/400-iSeries date format
  • Host Based - No PC hardware or software required

 

[TOP]

Access PC data with RPG, COBOL or other HLL via API(To Be Announced)

"Effortlessly utilize Excel & Dbase information, no Java required."

 

 Overview

The ConversionSuite Application Program Interface(API) is a programmer productivity tool that enables programs written in RPG, Cobol and other iSeries high level languages to read Microsoft Excel spreadsheets and Dbase database files stored in the iSeries integrated file system (IFS).

By utilizing ConverisionSuite API functions, iSeries programmers gain access to Excel 95, 97, 2000 & 2003 spreadsheet cell contents and Dbase III, IV and V field information. Additional API functions permit retrieval of Excel metadata (title, author, creation date, file size, modification date, custom properties and more) and Dbase metadata (number of records, file size, last update, record size and field information). Example programs with source code and demonstration Excel spreadsheets & Dbase files are also included.

Excel Functions

         OpenXLS - Open Excel spreadsheet

         GetXLSInfo - Retrieve Excel spreadsheet information: title, author, creation date, file size, modification date, custom properties and more

         GetCell - Retrieve Excel spreadsheet cell data: data, data type & decimal places

         CloseXLS - Close Excel spreadsheet

Dbase Functions

         OpenDBF - Open Dbase file

         GetDBFInfo - Retrieve Dbase file information: number of records, file size, last update, record size and field information

         GetStruct - Retrieve Dbase file field structure information: field name, length, type, decimal places

         GetField - Retreive Dbase file field data

         CloseDBF - Close Dbase file

 

[TOP]

 

Documentation

 

The KemeTECH ConversionSuite documentation is available in Adobe Acrobat format.

 

ConversionSuite Programmer's Guide & Reference Manual - Convert Database File Version 2.6 CSUITE.PDF (1,165KB)

CVTDBF - Convert Database File To PC File (Excel, Dbase) Programmer's Reference Manual CVTDBF.PDF (1,174KB)

CVTSPLF - Convert Spooled File Programmer's Reference Manual CVTSPLF.PDF (29KB)

CVTSTMF - Convert Stream File (Excel, Dbase) to Database File Programmer's Reference Manual CVTSTMF.PDF (658KB)

 

[TOP]

 

Pricing

Product

Function

Price*

Annual Maintenance

CVTDBFXLS CVTDBFDB

Convert AS/400-iSeries database files to Excel and Dbase PC files

$650

$100

CVTSPLF

Convert AS/400-iSeries Spooled Files to Excel

$750

$115

CVTXLSDBF CVTDBDBF

Convert Excel & Dbase files to AS/400-iSeries database files

$850

$130

CSAPI

ConversionSuite API

$950

$145

Effective January 1, 2010. Prices subject to change without notice.

* Price is per iSeries serial number

 

[TOP]