Import/Export Field Layout

NOTE: All fields must be included in each record line (signified by the delimiter) or AirLog will read it as an invalid record.

Examples

Flight Records

12/13/2003,N1520J,VJI-MKJ-MOR-HLX,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,PIC,This is the comment

10/4/2000,N1520J,HEF-VJI,3.2,0,0,0,3.2,0,0,0,0,0,0,1,0,0,0,0,0,0,0,PIC-SOLO,

Airport Records

VJI,Virginia Highlands,0,Uncontrolled

CVYK,Canadian Airport,-1,Class C

Aircraft Records

N1120J,0,0,0,-1,0,0,Piper,140,Airplane,Single-Engine Land,Acrobatic,Piston Aircraft,VJI,

N1230D,0,0,0,-1,0,0,Piper,140,Airplane,Single-Engine Land,Acrobatic,Piston Aircraft,CVYK,My Type Rating

Flight Record Fields

#	Name	Format	Description
1	flight_date	mm/dd/yyyy	Flight Date - Any valid date
2	aircraft_ident	Text	Aircraft Identification
3	route	Apt1-Apt2-Apt3-etc.	Valid airports separated by -
4	total_time	Decimal (00.0)	Total Time
5	night_time	Decimal (00.0)	Night Time
6	act_inst	Decimal (00.0)	Actual Instrument Time
7	sim_inst	Decimal (00.0)	Simulated Instrument Time
8	xcountryday	Decimal (00.0)	Cross Country Day Time
9	xcountrynight	Decimal (00.0)	Cross Country Night Time
10	user_time1	Decimal (00.0)	User Defined Time
11	user_time2	Decimal (00.0)	User Defined Time
12	user_time3	Decimal (00.0)	User Defined Time
13	user_time4	Decimal (00.0)	User Defined Time
14	user_time5	Decimal (00.0)	User Defined Time
15	day_fullstops	Number	Day Full Stops (No Decimal)
16	day_touchngos	Number	Day Touch & Go's (No Decimal)
17	day_goarounds	Number	Day Go Arounds (No Decimal)
18	day_instappchs	Number	Day Inst. Approaches (No Decimal)
19	night_fullstops	Number	Night Full Stops (No Decimal)
20	night_touchngos	Number	Night Touch & Go's (No Decimal)
21	night_goarounds	Number	Night Go Arounds (No Decimal)
22	night_instappchs	Number	Night Inst. Approaches (No Decimal)
23	Logged As	PIC-SOLO-DUAL-SIC-ASINSTR	Any combination with more than 1 separated by -
24	Comments	Text	Flight Comments