Lotus WK4 (Release 4) Files

The Visual Integrator module can directly import Lotus Release 4 files. The spreadsheet must be saved as a .WK4 file type (Lotus 1-2-3, Release 4). Because most spreadsheet products can save data in a Lotus 1-2-3 compatible format, this feature allows you to import information from virtually any spreadsheet product.

Information stored in the spreadsheet must be organized in a row format; all related information for a single record (for example, account, customer, or item) must appear on the same row. If the information is organized in a column format (related data items appear in the same column), you must change the orientation. For more information, refer to the user manual provided with your spreadsheet program.

Each data field in a Lotus 1-2-3 file is identified by a column number. The first field in a record is in column 1, the second field is in column 2, etc. This information is assigned to the Column field for each data item using the Import Field Properties feature (accessed from the Import Job Maintenance Data page). Because each field is stored in a separate column, you do not need to specify the length of each field when importing from a Lotus 1-2-3 file. Each line of the spreadsheet is considered to be a separate record.

For more information, see Import File Types.