7.2 Edit Menu

Here you find the main tasks to configure the appearence and the characteristics of your personal logbook.

Create Baseteables

If you setup a new logbook first you have to define which elements the logbook should possibly contain. This is done by creating the basetables. LinlogBook contains a file BaseTables.sql that contains a set of usefull definitions. These definitions are made by sql statements and you can expand them by editing this file. For example you can add adif fields by adding values to the ADIF table.
You can also expand or reduce the list of bands and modes you are working by editing this file.
You can create these basetables only once

Define Database Fields

By defining the database fields you select those fields you will actually use in your logbook and you label the columns. You can change this selection up to the final creating of the qso table.

Create QSO Table

Creating the qso table means establishing the logbook. LinLogbook is ready for use. After this step you can’t change the defintion of this logbook anymore.

Update Basetables

Here you can execute sql statements stored in a file.
Two possible usecases are

• You want to expand the bands or modes that can be assigned in your logbook. Write the insert statements into a file and choose this file to update your basetables. In the file BaseTables.sql you see the syntax of the appropriate sql statements.
• If you want to expand the features of your logbook by inserting additional columns you did not use up to now, you have to recreate your logbook.
  First you have to save the database definitions and views to files and store the entered data into another file by exporting them as adif file.
  Then you can create a new database and load your previous definitions by updating the ( at this moment empty ) basetables by the stored database definitions.
  After this step the qso table is not defined yet, so you can expand your definition by new database fields. If the favoured fields are not in the adif field list, you have to update your ADIF table. For more infomations see section 5. If the definition fits your needs, create the qso table and create the views ( if necessary ) by updating the basetables by running the file you saved your views to.
  Now import your saved adif data and your redesigned logbook is ready for use.

QSL Card Setup

Here you define which fields of your logbook will be printed to your qsl card. Additionally you have to define the print position in mm and you can choose a font size between 8 and 12 points.
You are even able to print some text conditionally. I use this to mark either the TNX QSL or the PSE QSL text on my qsl card.
Here is my setup. Have a look at the two entries of QSL_RCVD.

Preferences

At least the database directory, the date format and the separator should be set. You have to set the port, if you want to be able to run the linlog server. The language selection will not be utilised at the moment and the other fields are for later use, too.