Browse Prior Art Database

Data Conversion Method between IBM Application System and Lotus 1-2-3

IP.com Disclosure Number: IPCOM000110034D
Original Publication Date: 1992-Oct-01
Included in the Prior Art Database: 2005-Mar-25
Document File: 2 page(s) / 67K

Publishing Venue

IBM

Related People

Hattori, R: AUTHOR

Abstract

Disclosed is a method for conversion between IBM Application System (AS) tables and Lotus 1-2-3* (L123) worksheets. This method consists of two parts, one is the conversion from AS to L123 and the other is from AS to L123. The advantages are as follows: (1) same appearance (column names are also displayed in L123), (2) the width of the cell is set according to column length, and (3) the conversion is done by single AS command execution.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 72% of the total text.

Data Conversion Method between IBM Application System and Lotus 1-2-3

       Disclosed is a method for conversion between IBM
Application System (AS) tables and Lotus 1-2-3* (L123) worksheets.
This method consists of two parts, one is the conversion from AS to
L123 and the other is from AS to L123.  The advantages are as
follows: (1) same appearance (column names are also displayed in
L123), (2) the width of the cell is set according to column length,
and (3) the conversion is done by single AS command execution.

      The figure shows the example of this method.  In Step 1, the AS
command procedure converts the AS table to two text files, i.e., the
data file and column definition file.  In Step 2, the program coded
by high level language converts two text files to a L123 worksheet.
The column definition file is converted to the first row of the
worksheet, and the data file is converted to the second row and
after.  The width of the cell is set by the value, i.e., column
length +1.  The L123 macro describing the series of operation for the
reconversion from L123 to AS is also generated in the worksheet.
Step 1 and Step 2 can be combined to single AS command procedure.  In
Step 3, the L123 macro generated in Step 2 creates the text file with
cell information from the 123 worksheet.  Step 4 is the reverse
process of Step 2.  The program coded by high level language converts
the text file with cell information to two text files.  Step 5 is the
reverse proces...