v1.5 user manual


 

Structure of the CSV file II

 prev    TOC    next
 

Row 1 (column >= 4) sets the type of the field (see section The Field Concept for the field related nomenclature). LL defines a local field (type 1), GL defines a global field (type 2), GG defines a global field with global entries (type 3). For a GG-field all entries of the column are put to a list that will be available as a popup list in the object form. Exeptions can be defined by marking an entry with an asterisk: such entries will not be added to the fields list (e.g. Helen Hunt in row 6). The asterisk must be the last character.

By default GL-columns don't build a list, however exeptions can be made here too: if there are entries marked with a star, they will be made available via a popup list. Example: the movie field is defined as GL in column 11 so by default the movie titles of column 2 are not put to a list. However the movies 'The Apartment' and 'Some Like it Hot' are treated differently, they will be made available via a list.

The first empty cell in row 1 (for column > 3) marks the last column of the spread sheet. This and all following columns are ignored by the converter independend of their content.

Row 2 (light blue face) is used to mark fields that share the same list. All entries of columns that have the same name in row 2 are put into the same list. Example: the fields 'Actor' and 'Director' use the same list of names (because a person can be both). This list consists of all name entries in the columns 4-6. The name of the list (here: 'Persons') is only used by the converter to distinguish between different lists, it does not appear in the databases.

Important: Each field of type GG or GL used as a key field in an object (first column) must have been defined before in row 3. This is the reason why the 'movie' field column 11 has been attached although it has no entries.