Logbook import / export format guide
The logbook import routine uses CSV (comma separated values) data. This is list of flights, with one on each line. Each line contains some data about the flight -- commander, registration, date, etc. -- and, in case you hadn't guessed, these items are separated by a comma.
Here's an example of some CSV data:
If you want include an actual comma within your data, you must surround the data with speech marks, like this:
1,Cameron,David,"Conservative,Lib Dem alliance"
The speech marks indicate that everything inside is to be treated as one item.
Sometimes CSV files have a header line, like this:
The format for the input data is the same as the UKGA logbook backup file... so the easiest way to get started is to do a backup of your logbook and then continue to add data in the same format.
If you don't have any flights yet, you can still export the file, but it will only have a header line. It's easier if you add a sample flight, then export the file, as this will give you an example in the exported data. You can delete the flight afterwards.
Creating CSV files
You can create a CSV file by hand, using Notepad or similar, but it's usually easier to use a spreadsheet, such as OpenOffice Calc, or Microsoft Excel, as these support exporting their rows and columns to CSV files.
Import the downloaded backup file into your spreadsheet, add extra rows (one per flight) and the save the file in CSV format when you're finished. The spreadsheet software should take care of everything for you.
UKGA import CSV data field formats
Each line of the UKGA logbook import CSV data should contain 27 elements. These are as follows:
Type: Either L (for logbook entry) or B (for balancing entry)
Date: Date in the format dd/mm/yyyy, e.g. 31/12/1999
AircraftType: This field is ignored during import.
Registration: Aircraft, e.g. G-BOAC
Commander: Commander's surname, e.g. "Smith" or "Self"
HoldersOperatingCapacity: Capacity of logbook holder during flight. This must be one of: P1,P1 U/S,P2,SPO,P U/T,N1,N2,E1,E2,R1,R2,T1,T2
FromAerodrome: Name of the departure airfield. The system will attempt to match this during import.
DepartureTime: 24-hour time in the format hh:mm, e.g 23:59 or 00:01
ToAerodrome: Name of the arrival airfield. The system will attempt to match this during import.
ArrivalDate: Date in the format dd/mm/yyyy, e.g. 31/12/1999
ArrivalTime: 24-hour time in the format hh:mm, e.g 23:59 or 00:01
The next 12 fields show the number of minute spent in various activities:
DayP1, DayP2, DayDual, NightP1, NightP2, NightDual, InstrumentP1, InstrumentP2, InstrumentDual, OtherCapacity, OtherFlying, StallingFlying, TwinFlying
Each of those fields should container a number of minutes, e.g. 10, 54, or 244
Remarks: Any notes or remarks relating to the flight. Note that if you want to put a comma in this field, you will need to surround it in speech marks, like this: "Ex. 4(1), Ex. 4(2)".
Takeoffs: The number of takeoffs made (0 is acceptable).
Landings: The number of landings made (0 is acceptable).
Here is an example line: