Content | Introduction | Getting started | Basics | Tutorial | Reference | Import/Export | Limits

Palm OS Freeware Projects

 v1.5 user manual

Structure of the CSV file I

The picture below shows a part of a spread sheet defining a small movie database (it is included in the db2go distribution as Excel and CSV file). This sample database will be used in the following to explain the structure of the CSV file passed to the converter. (note: the row and column numbers are not part of the CSV file)

Starting with row 4 each row represents a database object. The first column holds the name and the second column holds the item of the key field of the object (see section The Object Form for the object related nomenclature). The third column holds the text for the optional note field of the object.

The following columns (4, 5,...) define the remaining fields of the object. Only non-empty cells are considered.

The conversion process stops at the first completely empty row.

Row 3 (column >= 4, light red face) defines the names of the fields of an object (the left column in the object form).

Example: row 4 defines an object representing the movie 'Some Like it Hot' by director 'Billy Wilder' with actors Jack Lemmon and Marylin Monroe.