Guild Companies, Inc.  
 
Midrange Stuff - Hardware, Software & Services
OS/400 Edition
Volume 2, Number 3 -- January 22, 2002

KemeTECH Expands Excel Support

by Alex Woodie

KemeTECH Systems has announced its expanded support for multi-page Microsoft Excel spreadsheets and dBASE data in the latest release of its ConversionSuite, a collection of three OS/400 utilities for sharing data between PCs and AS/400s or iSeries servers.

With this new release, the Newark, New Jersey, company has shuffled some of the command functions available within two of the utilities and added entirely new functions as well. These changes reflect the growing need for expanded support of PC data--particularly Excel spreadsheets--among KemeTECH's customer base, the company said.

BCD
The first utility, called CVTDBF, or Convert Database File, now features two commands instead of just one. Previously, this utility was used to convert DB2/400 database files into Excel 2000 spreadsheets. KemeTECH has added a new command to this utility called CVTDBXLS, or Convert Database File to Excel, which provides support for multi-page Excel spreadsheets and for the use of formulas and expanded heading/column formats, among other functions. The second new command added to this utility, called CVTDBFDB, or Convert Database File to dBASE, allows users to convert DB2/400 database files into dBASE format. The CVTDBF utility includes both of these commands for $600.

The second utility, called CVTSMTF, or Convert Stream File, is the opposite of the first: It converts Excel and dBASE files back into DB2/400 files. Like the first utility, CVTSMTF previously included one command, which converted single-page Excel files to DB2/400. With this latest release, KemeTECH has added two new commands. The first command, CVTXLSDBF, or Convert Excel to Database File, provides support for the creation of DB2/400 files and data description specifications from multi-page Excel 95, 97, or 2000 files. The second command, CVTDBDBF, or Convert Dbase to Database File, supports the conversion of dBASE data into DB2/400 files. The CVTSMTF utility includes both of these commands for $850.

The third member of KemeTECH's ConversionSuite,CVTSPLF, or Convert Spooled File to Excel, allows users to convert OS/400 spool files to Excel. This utility costs $750 and will be updated soon, the company said.

As you might have already guessed from KemeTECH's choice of utility names, the ConversionSuite is not a GUI tool; it's an OS/400-centric way to control the integration of PC data with the iSeries' resident database, DB2/400. No PC hardware or software is required to use the ConversionSuite, and all commands work in either batch or interactive mode. OS/400 V3R2 or higher is required for all utilities.

For more information about KemeTECH or to try out its software, visit the company's Web site, at www.kemetech.com.

Sponsored By
BCD SOFTWARE INTERNATIONAL

See why WebSmart beat out 26 other vendors and was
Voted the BEST iSeries -- AS/400
e-Business / e-Commerce tool in the marketplace.

Free Download of the New Version. Build your own, or use / customize the 70+ Free templates and e-Commerce applications. Develop professional state-of-the-art applications in a day not months, all while using your existing skill set. Extend legacy applications.

Forget complex, expensive products that take months and months to learn, or bare bone products with minimal tools & features that make you do the work manually without HTML editing, restrict the look of your web apps, and restrict growth. Restrictions like no IFS, email or Graphics functions, session ids, persistent CGI handling and more.

WebSmart is a proven, state-of-the-art tool that is easy-to-use, requires little or no Web or iSeries400 programming, is packed with features to automate the work for you, and best of all it’s affordably priced.

Quickly deploy elegant, robust and secure B2B, B2C and browser based apps. Including: Inquiries, reporting, maintenance, wireless (XML, WML. . . ), ordering, product catalogs, shopping carts, EIS. . . .

State-of-the-art, portable PC-based design tool. Develop anywhere: Work, on the road & home and enjoy the freedom of choice.

Simply email objects to yourself or others. Unlimited end-users and unlimited developer seats. Automatically produces dynamic HTML CGI programs written in ILE/RPG. 128 bit AES encryption. Utilizes iSeries400 database and security features for scalability and reliability.

Ask for BCD’s 15-point opinion e-mail on why WebSmart is better than WebSphere TM, 1. Ability to run on smaller iSeries -- AS/400’s without having to upgrade hardware. 2. Significantly faster apps. . . .

WebSmart users include: Affinity Ins., Airways Freight, Arrow Environmental, Behr Process, Broward County Schools, Calvin Klein, D.J. Powers, Formica Corp., Goodyear, Hoshizaki America, Kauai Electric, Legacy Partners, Midwest Trophy, MSU, Oregon Dept., of Veterans Affairs, State of California, Testor Corp., Weigh-Tronix. . .

Also try CATAPULT, voted best e-mail / Automated Report Distribution Tool. FREE Downloads: WebSmart or CATAPULT

Visit http://www.BCDsoftware.com or call 630-986-0800, e-mail sales@bcdsoftware.com Trust BCD, Winner of 18 Industry Awards 20,000+ product installations - 9,000 World-wide customers.

THIS ISSUE
SPONSORED BY:
SoftLanding Systems
BCD Software Int'l
COMMON
Bits & Bytes
RJS Software Systems
Tramenco
BACK ISSUES
TABLE OF CONTENTS
Tree Top Harvests an iSeries Portal from Enfish
New iSeries Utility Addresses FTP Security
The iSeries Drives New ASP-based Business Intelligence Offerings
ASNA User Conference Big on Web Apps
BCC Adds LTO to iSeries Tape Offerings
SEAGULL Adds MQSeries Support to Transidiom
Kisco Adds Security Features to SafeNet/400
KemeTECH Expands Excel Support
News Briefs and Product Shorts
Corrections
  Newsletters | Subscribe | Advertise | About Us | Contact | Search | Home  
  Last Updated: 1/14/02
Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.