Technical Notes


Managing multiple logbooks

Diabetes Logbook X keeps all data in the preferences file that is stored in each user's Preferences folder, found with their Library folder.

Provided that each user has a separate account on your Mac, you can manage multiple logbooks, one logbook per account.

Exported data format

The export data file format is a comma delimited text file: the first line always lists the columns. Here is an example (the lines have been split to fit on the page). To support mobile databasing applications on Palm PDAs a modified import data structure is provide, click here for details.

Data column Can a different column name be used? Data content
Flag No This column must be called 'Flag'.
  • Empty = not flagged
  • F = flaged
Date Yes The date format can be day/month/year or month/day/year: this is a selectable option during data export/import.

The supported date formats are:

  • DD/MM/YYYY
  • MM/DD/YYYY
The date's year must be 4 digits long, for example 2007.
Time Yes The supported time formats is HH:MM

The 24hr time range is 00:00 to 23:59.
Period Yes The time periods are recalculated during import. English options are:
  • Before Breakfast
  • After Breakfast
  • Before Lunch
  • After Lunch
  • Before Dinner
  • After Dinner
  • Before Bedtime
  • Night
Glucose Yes Number.

See note 2.
GlucoseUnits Yes Must be either:
  • the text string: mmol/L
  • the text string: mg/dL
InsulinA Yes Number.

See note 2.
InsulinAName Yes List field: no {comma} characters.
Carbs Yes Number.

See note 2.
InsulinB Yes Number.

See note 2.
InsulinBName Yes List field: no {comma} characters.
Medicine Yes Number.

See note 2.
MedicineName Yes List field: no {comma} characters.
KetonesTested Yes Must be either:
  • Empty
  • the text string: -ve
  • the text string: +ve
KetonesValue Yes Number.

See note 2.
Weight No Number.

See note 2.
Height Yes Number.

See note 2.
HbA1c Yes Number.

See note 2.
EventName Yes List field.

The list has the following preset:

  • Clinic
  • Staring item
No {comma} characters.
Notes Yes Text field.

The Notes column uses '{lf}' to signify multiple lines in the notes text.

The Notes field can have {commas} in its text.

Notes:
  1. The header row must be present and as shown below.
  2. All number fields must use a floating point format with a period, ".", as the decimal mark. Examples of permitted values: 12.5 ; 0.5 ; 1.0 .

For version 1.3.0 and later:

First row, with column names:

Flag,Date,Time,Period,Glucose,GlucoseUnits,InsulinA,InsulinAName, Carbohydrates,InsulinB,InsulinBName,Medicine,MedicineName, KetonesTested,KetonesValue,Weight,Height,HbA1c,EventName,Notes

Subsequent event rows, with day/month/year date format:

F,27/07/2006,22:51,Before Bedtime,12.0,mmol/L,12.0,NovoRapid, 12.0,12.0,Levemir,12.0,GlucoGel,+ve,12.0,22.3,119.0,7.0,Clinic,
HbA1c = 7.0%{lf}Weight = 22.3kg{lf}Height = 119cm


For version 1.2.0 and earlier:

First row, with column names:

Flag,Date,Time,Period,Glucose,GlucoseUnits,InsulinA,InsulinAName, Carbohydrates,InsulinB,InsulinBName,Medicine,MedicineName, KetonesTested,KetonesValue,EventName,Notes

Subsequent event rows, with day/month/year date format:

F,27/07/2006,22:51,Before Bedtime,12.0,mmol/L,12.0,NovoRapid, 12.0,12.0,Levemir,12.0,GlucoGel,+ve,12.0,Clinic,
HbA1c = 7.0%{lf}Weight = 22.3kg{lf}Height = 119cm


How the data is stored


Data file and snapshots

The database is saved in the application's preferences file com.Nesfield.DiabetesLogbookX.plist in the user's Preferences folder of their Library .

There is also a folder com.Nesfield.DiabetesLogbookX Saved Prefs, within the Preferences folder, which is used to hold snapshots of the last 5 states of the preferences file. Along with the .plist version of the file there is also a text based .xml version.

Automatic backup

In addition to the snapshots, the application's preferences file com.Nesfield.DiabetesLogbookX.plist will be saved to a backup folder in the home folder's Documents/Diabetes Logbook X/Backup folder. The backup is saved every 24 hours (when the logbook data is being saved after an edit).

The reason for this backup is to have a daily snapshot of the data which is not in the Library folder. You can then manually copy the data file to another hard disk or volume; or you may automate this using a Folder Action.

Regular backing up of either the actual preferences file or the automated backup file is strongly recommended: preferably to a volume that is not the same as the one on which your account data is stored; suitable backup volumes would be iDisk, a networked folder, another computer, or to CD or DVD.


What to do if an error occurs


This has not happened but I'm including these instructions in the unlikely event that it does happen.
  • Quit the application using this method: control-click the icon in the Dock and select 'Quit'.

    Diabetes Logbook X maintains 5 snapshots of the database: a snapshot is taken whenever an event is add, deleted or edited and during import, export and quit actions. Quiting via the Dock icon does not create a snapshot during a quit action, and so prevents potentially bad data from being added to the database, and from losing the oldest snapshot.

  • Make a backup copy of
    1. Preferences file com.Nesfield.DiabetesLogbookX.plist
    2. Preferences folder com.Nesfield.DiabetesLogbookX Saved Prefs
  • You can now re-launch Diabetes Logbook X and review the events, if they are all right you can continue using it without any further action.
  • If there is a problem with the data, quit as before and copy the newest snapshot file com.Nesfield.DiabetesLogbookX.plist.sav1 up into the Preferences folder and rename it com.Nesfield.DiabetesLogbookX.plist.
  • Now re-launch the application and review the events. Continue doing this with the snapshots until the event data is restored.