User Guide : Map Connectors : Source and Target Map Connectors : Lotus 123
 
Share this page                  
Lotus 123
Lotus 123 is a spreadsheet application. With the Lotus 123 connector, you can read and write Lotus 123 DOS and the following Windows releases:
r1A
r2.01
r2.2
r3
r4
It is important to remember that the integration platform transforms field and record (column and row) oriented data. Title sections, formulas, macros, and display formatting are not transformed. Column headings in a single row can be transformed as field names.
This connector sets field width in bytes. What actually varies is the number of characters that fit into a given field. For example, if a field width is 10 bytes and the encoding is Shift-JIS, the field can hold a minimum of 5 characters and a maximum of 10. This means that if you try to write eight Japanese characters, data is truncated (the Kanji characters all take 2 bytes).
Connector-Specific Notes
Some basic limitations exist when transforming data to a spreadsheet.
Field Length
Lotus 123 has a limitation of 255 characters in a single cell. If you try to transform data to Lotus 123 containing more than 255 characters in any field, that data is truncated at the 255th character.
The integration platform does not automatically truncate data in a field to 255 characters when transforming to a spreadsheet. You may either change the field length to 255 in the target schema grid or you may leave it at the default value. If you set it to greater than 255 characters, when you open the spreadsheet in Lotus 123, the data is truncated.
Field length in Lotus 123 is actually a measure of the column width of a cell and not a measure of character length. When you view the length that is read in the the integration platform, you are seeing the column width set in the Lotus 123 application rounded to the nearest whole number. If you have truncated data, set the length to a higher value in the schema.
Number of Fields
Lotus 123 has a limitation of 254 fields. If you try to transform data to Lotus 123 that has more than 254 fields, the data is truncated at the 254th field.
Number of Records
Lotus 123 has a limitation of 8192 records. If you try to transform data to Lotus 123 that has more than 8192 records, the data is truncated at the 8192nd record.
Property Options
These are properties that you may need to specify for your source or target data.
Property
Use
Auto Type Text Fields
Automatic styling changes the way Lotus 123 data is read or written. For example, when Delimited ASCII is the source connector, all data is "Text" (except when you change the Delimited ASCII Source Property AutomaticStyling to true, or when you change the "Type" from Text to a numeric data type in the Delimited ASCII source schema grid. For details on these options, see the ASCII Delimited section.) When that data is transformed to a spreadsheet, the user may need the fields that contain numbers to be formatted as Numeric (to perform calculations in the spreadsheet).
The default for this option is true. To transform the number fields as Text in the Target Lotus 123 file, change the setting to false.
Header Record Row
For Lotus 123 source files, this is the row number of any column headings. For Lotus 123 target files, this sets the row number where the integration platform writes column headings.
If there are no column headings involved in the data you access multiple tables in the same transformation, each time that transformation runs, the value should be left to the default setting of 0. If the column heading is the first record (row 1), change the value to 1.
Worksheet
For versions of Lotus 123 that support multiple worksheets within one file (often referred to as 3D spreadsheets), this option allows you to specify which of those worksheets that the integration platform uses for the transformation. If you want the integration platform to read the first worksheet, leave the default value of "0". To read the second sheet, change the setting to "1"; for the third sheet, change the setting to "2" and so on.
CodePage
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Data Types
All data is transformed to Text in a spreadsheet, unless the user has selected true for the Auto Type Text Fields option in Target Properties.
Length
These are field lengths in your data. If you need to change field lengths, reset them in the schema.
Caution!
A field size shorter than the default may truncate data.
The integration platform does not automatically truncate data in a field to 255 characters when transforming to a spreadsheet. You may either change the field length to 255 in the schema or you may leave it at the default value. If you set it to greater than 255 characters, when you open the spreadsheet in Lotus 123, the data is truncated.