Pilot Magazine UKGA

About You

Log In Register UKGA membership

Flight planning

Flight planning New flightplan NOTAM map LARS map & NOTAMs Danger area, mil. & TRA activations Weather map GPS route download Find waypoints Your waypoints New waypoint

Forums

Forums Currently discussing "England light aircraft aircraft fly to Wales and Scotland?"

History

Logbook import / export format guide

Other items

Articles Events Links News Surveys Tips Other users Feedback UKGA membership About UKGA

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.  

CSV data

Here's an example of some CSV data: 

1,Cameron,David,Conservative
2,Brown,Gordon,Labour
3,Blair,Tony,Labour

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"
2,Brown,Gordon,Labour
3,Blair,Tony,Labour

The speech marks indicate that everything inside is to be treated as one item.

Sometimes CSV files have a header line, like this:

Order,Surname,Forename,Party
1,Cameron,David,Conservative
2,Brown,Gordon,Labour
3,Blair,Tony,Labour

Import format

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:

"L","31/12/1999",,"G-ABCD","Smith","P1","Heathrow","12:35","Geneva","31/12/1999","13:40",60,0,0,0,0,0,0,0,0,0,0,0,0,,1,1

About You

Log In Register UKGA membership

Airfields

Interactive airfield map Search by name Search by postcode Search by location Fuel prices Pilot reviews Latest
(No favourites selected)

Flight planning

Flight planning New flightplan NOTAM map LARS map & NOTAMs Danger area, mil. & TRA activations Weather map GPS route download Find waypoints Your waypoints New waypoint

Forums

Forums Currently discussing "England light aircraft aircraft fly to Wales and Scotland?"

History

Logbook import / export format guide

Other items

Articles Events Links News Surveys Tips Other users Feedback UKGA membership About UKGA