mccPILOTLOG can import data from more than 40 other logbook applications


Export your data from the other application and submit the file through our website for conversion.


If you have a self-made Excel sheet, you can submit the file through the same web-page.  Select V01 - Generic CSV and we will convert the file into a compatible CSV file.  Should you prefer doing the conversion yourself, follow the guidelines listed further down in this article.



  Video Tutorial  


The following Video Tutorial demonstrates the different options how to insert your previous flying experience in mccPILOTLOG :




  1. How to import records from another electronic logbook 
  2. How to import historical flight data from the airline's Crew Web Portal 
  3. How to manually insert total time per aircraft model








Convert your self-made Excel logbook

 


Save the file as CSV file and continue as follows :

 

 

Step 1- Modify the column headers

 

Open the data file with a text editor (like notepad) or with some spreadsheet software, like Excel or Calc.Caution when using Microsoft Excel :MS Excel has a bad habit to auto-modify the contents of the fields.A flight time of 1.4 hours can be modified to Jan 1st or April 4th. If you notice this kind of data modification, then use another software to edit the CSV file.

 

The following 120 headers are recognized by the mccPILOTLOG import wizard. Mandatory headers are listed red bold (4 columns).

 

Each header can only be used once. Columns (headers) can be used in any order. The header name is not case sensitive.

 

Each column must have one of the following headers. If you cannot find a suitable header, then use "X" as header ;these columns are then ignored by the import wizard.

 


 

 
MCC_DATE
Date of flight
The column header is set to mcc_Date in order to confirm the file has been modified to meet mccPILOTLOG import requirements.
 
The wizard can process about any kind of date formatting, like Day first, or Month first or Year first (YYYYMMDD) and with any kind of separator (slash, hyphen, space, point, none), with or without leading zero ( 9-3-2010 or 09-03.2010)
FLIGHTNUMBER
Flight Number
May be numeric (345) or alphanumeric (34K).May include airline company (AF204).
PAIRING
Pairing Number
The pairing number is an in-house reference to the flight route, often spanning multiple days. Pairing can be numeric (610) or alphanumeric (P7108_B). 

AF_DEP

Airfield Departure
 
Column must list the unique ICAO or IATA (or FAA) airfield identifier in 3 or 4 characters. Flights with invalid airfields are refused by the wizard !
If your data file does not have unique ICAO codes, but the long airfield names (e.g. John F. Kennedy International instead of JFK), the Airfield Lookup wizard will assist you in searching the codes and converting the file.
 
Required for flights only, not for simulator training.
AF_ARR
Airfield Arrival
ROUTE
Flight Route
The Route is imported as free text in the Flight Log Report.mccPILOTLOG does not interpret the airfields !Read above the note Logging per Flight Route.
TIME_DEP
Departure Off-Block Time
Can be LOCAL or UTC time, according to your settings on the Settings page.Format can be with semi-colon (12:00) or in four digits (1200) or with your regional language settings (12h00).Reads AM – PM and accepts with or without leading zero (8:30 or 08:30)
TIME_DEPSCH
Scheduled Departure Time
TIME_ARR
Arrival On-Block Time
TIME_ARRSCH
Scheduled Arrival Time
TIME_TO
Takeoff time
TIME_LDG
Landing time
TIME_AIR
Airborne time (optional)
Airborne time will be calculated from Takeoff time to Landing time, and is not stored by itself
TIME_MODE
Time Mode for the Departure and Arrival times

Can be UTC, LOC (Local time airfield of departure and local time arrival of arrival) or BASE (Local time at the Home Base – the Home Base must be set on the Settings page)

TIME_TOTAL

Total Duration of Flight

Can be formatted with semi-colon (3:30) or in decimal hours (3.5 or 3,5) or in minutes (210)

TIME_TOTALSIM

Total Duration of Simulator

Simulator sessions must be logged as separate records (rows) in the CSV file.The TIME_TOTALSIM column is not mandatory.You can also use the TIME_TOTAL column in combination with the AC_ISSIM column.
TIME_SOLO
Solo time
Times can be formatted with semi-colon (3:30) or in decimal hours (3.5 or 3,5) or in minutes (210)
 
mccPILOTLOG prefers a single column for function time (e.g. TIME_PIC) and a separate TIME_NIGHT column. There is no need for a Day – Night split. However, if your data file has Day – Night split, you can use these column headers.
 
Another technique to import function time is the combination of TIME_TOTAL with the pilot CAPACITY column, where it says P1, P2, P/US, etc.
 
The sum of the function times (PIC + PICus + CoPilot + Dual + Relief) should be equal to Total Time.The wizard will notify you if that is not the case.
 
mccPILOTLOG does not have a separate column for Solo time.TIME_SOLO is imported as PIC time and a text comment is added to the Instruction field.Read more about SOLO on the FAQ Help page.
 
Dual Received and Dual Given are stored in the same column.When Instructor time is logged for the same flight, Dual time is considered to be Given.When no instructor time is logged, Dual is considered as Received.
TIME_PIC
Pilot In Command time
TIME_PICDAY
Pilot In Command time Day
TIME_PICNIGHT
Pilot In Command time Night
TIME_SIC
Co-Pilot time
TIME_SICDAY
Co-Pilot time Day
TIME_SICNIGHT
Co-Pilot time Night
TIME_DUAL
Dual Received / Given time
TIME_DUALDAY
Dual Received / Given time Day
TIME_DUALNIGHT
Dual Received / Given time Night
TIME_PICUS
PIC Under Supervision time
TIME_PICUSDAY
PIC Under Supervision time Day
TIME_PICUSNIGHT
PIC Under Supervision time Night
TIME_INSTRUCTOR
Instructor Time
Time as instructor on a real aircraft or in the simulator
TIME_EXAMINER
Examiner Time
Time as check pilot on a real aircraft or in the simulator
TIME_NIGHT
Night Time
Total night time on the flight. If different functions are logged on the flight (like 3 hours PICUS and 2 hours Co-Pilot), night time is automatically distributed on those functions in hierarchical order, starting with PIC, PICus, Co-Pilot and finally Dual.
 
Night time is not mandatory for import.Once the records have been imported in mccPILOTLOG, you can use the Multiselect function on the Flights page to mass edit all records with a single click and have the software recalculate night time for all selected flights.The software is using airfield coordinates + flight date (summer, winter, DST rules) + Block Hours for this.
TIME_XC
Cross-Country Time
XC time is not mandatory for import.Once the records have been imported in mccPILOTLOG, you can use the Multiselect function on the Flights page to mass edit all records with a single click and have the software recalculate cross country time for all selected flights.The software is using airfield coordinates to calculate distance.All flights above 50 NM will then be logged XC.
TIME_IFR
IFR Time
Instrument Flight Rules, which is different from Actual Instrument time ! During a visual approach under clear weather you still fly IFR regulations.
VFR time is not logged in mccPILOTLOG, but is automatically obtained (any flight time not logged as IFR is VFR).
TIME_HOOD
Simulated Instrument time
Simulated Instrument time, also called Hood time. Can be logged on real flights and on simulator sessions.
TIME_ACTUAL
Actual Instrument time
Actual Instrument time, not to be confused with IFR time. Can be logged on real flights and on simulator sessions, however the latter is not recommended.
TIME_RELIEF
Pilot Relief time
Time as pilot crewmember onboard the aircraft where you are not sitting in the front seats. Can also be used as Observer, but is not recommended.
 
The sum of the function times (PIC + PICus + CoPilot + Dual + Relief) should be equal to Total Time.The wizard will notify you if that is not the case.
There is an option on the Settings page allowing you to have Relief time included or subtracted from your Total Time.This option can be selected or not selected at any time.However, for the CSV import file, Relief time must be included in Total Time.
 
e.g. Flight from LHR to JFK
Off-Block12:00
On-Block19:00
 Total Time must be logged as 7:00 hours
 
For this flight you can log something like 4 hours of Co-Pilot time and 3 hours as Relief Time. Your logbook will then show Total Time 7 hours or Total Time 4 hours, depending on your settings, which can be changed at any time later.
TIME_USER1
User Time field 1
You can import up to 4 user defined time fields. You must first setup the user time field(s) on the Settings – Flight Logging page prior to running the import wizard.
 
Times can be formatted with semi-colon (3:30) or in decimal hours (3.5 or 3,5) or in minutes (210)
 
Times in these user fields may not exceed Total Time.
 
Beside time fields, you can also setup 3 other fields – see further
TIME_USER2
User Time field 2
TIME_USER3
User Time field 3
TIME_USER4
User Time field 4
CAPACITY
Holder’s Capacity
mccPILOTLOG does not store Pilot Capacity in its database. During import, this column will be used to store pilot function time in the correct column.
 
So, your CSV will either have a column TIME_TOTAL and other columns like TIME_PIC and TIME_SIC showing the time for each function, or it will have the TIME_TOTAL column in combination with the CAPACITY column.
 
The following values are recognized : P1, P2, P3, PIC, PIC/us, P/us, COP, Co-Pilot, FO, SNY, CH (check pilot), Captain, Co-Pilot, Instructor, DUAL and DH (deadheading).
 
Notice that P3, SNY and CH hours are imported in the Relief Time field.According to your selections on the Settings page Relief function time is or is not included in your total flying experience.This setting can be changed any time later.
 
In all columns are present in the CSV file, the import wizard will verify the record for any conflicts (e.g. you log P1 as capacity while Co-Pilots time is logged for the same flight).
OPERATOR
Name of Airline or Company
Used for Aircraft and Pilots
PILOT1_ID
Pilot 1 Employee ID
Pilot 1 is usually the captain or the commander. 
 
Pilot 2 is usually the co-pilot or the instructor in the right-hand seat. 
 
Pilot 3 is usually the examiner on the jump seat, the instructor on the back seat in the simulator or the relief pilot for augmented flight crews.
 
Pilot 4 is an additional crew member, such as on some long intercontinental flights.
 
The Employee ID for each pilot must be unique.This ID can be numeric or alphanumeric, such as a 3-letter code.Maximum length 10 characters.
 
The Pilot Name can be up to 50 characters long.If your data file contains 3-letter codes instead of pilot names, it is recommended to use the PILOT_ID column header, since these codes are actually the Employee ID and not the real name.
 
The phone number can be numeric or alphanumeric, like
+32 (0) 477 – 11.22.33
PILOT1_NAME
Pilot 1 Name
PILOT1_PHONE
Pilot 1 Phone Number
PILOT1_EMAIL
Pilot 1 E-Mail address
PILOT2_ID
Pilot 2 Employee ID
PILOT2_NAME
Pilot 2 Name
PILOT2_PHONE
Pilot 2 Phone Number
PILOT2_EMAIL
Pilot 2 E-Mail address
PILOT3_ID
Pilot 3 Employee ID
PILOT3_NAME
Pilot 3 Name
PILOT3_PHONE
Pilot 3 Phone Number
PILOT3_EMAIL
Pilot 3 E-Mail address
PILOT4_ID
Pilot 4 Employee ID
PILOT4_NAME
Pilot 4 Name
PILOT4_PHONE
Pilot 4 Phone Number
PILOT4_EMAIL
Pilot 4 E-Mail address
TO_DAY
Number of Takeoff Day
Number of takeoffs and number of landings during day and during night time.
 
Not mandatory for import.Once the records have been imported in mccPILOTLOG, you can use the Multiselect function on the Flights page to mass edit all records with a single click and have the software recalculate takeoff (day/night) and landing (day/night) for all selected flights.The software is using airfield coordinates + flight date (summer, winter, DST rules) + Block Hours for this.
TO_NIGHT
Number of Takeoff Night
LDG_DAY
Number of Landing Day
LDG_NIGHT
Number of Landing Night
LIFT
Number of Lifts
Can be Sling & Winch lifts, parachute dropping lifts, or similar
PF
Task PF – PM/PNF
Pilot Flying or Pilot Monitoring (Non-Flying)
 
Column can contain ‘PF’ and ‘PM’ or ‘PNF’ value, or any other boolean value, like Yes / No, True / False or 1 / 0
HOLDING
Number of Holdings
Numeric value
APP_1
Type of Approach 1
You can log up to 3 different approaches per flight.
 
See table below for different types of approaches that are recognized by the import wizard.
 
mccPILOTLOG does not log the number of approaches. However, you can setup a User Numeric field for that.
APP_2
Type of Approach 2
APP_3
Type of Approach 3
APP_PRECISION
Precision Approach
Column can contain ‘PREC’ and ‘NON-PREC’ flags, or any other boolean value, like Yes / No, True / False or 1 / 0
APP_NONPRECISION
Non-Precision Approach
Column can contain ‘PREC’ and ‘NON-PREC’ flags, or any other boolean value, like Yes / No, True / False or 1 / 0
APP_VISUAL
Visual Approach
Column can contain ‘Visual’ flag, or any other boolean value, like Yes / No, True / False or 1 / 0
GLIDERLAUNCH
Type of Glider Launch
The import wizard recognizes the following types of glider launch :
aerotow, bungee, car tow, self launch, winch
 
mccPILOTLOG does not log the number of launches, only 1 type for 1 flight
INSTRUCTION
or
TRAINING
Training Info
Kind of training that was received or given. Logged as free text
(maximum 30 characters).Is printed or not printed in the Remarks column of the logbook (user selectable during print job)
REMARKS
Remarks
Free text comments on the flight, which are printed in the Remarks column of the paper logbook(maximum 50 characters)
FLIGHTLOG
Flight Log Report
Free text comments on the flight, such as detailed report or name of cabin crew members.Is never printed in the paper logbook(maximum 250 characters)
AUTOLAND
Number of Autoland
Number of automatic landings.No direct link to CAT 2 or 3 approach.Approach must be logged separately as APP.
PAX
Number of Passengers
Number of passengers carried on the flight. Should not exceed 6% of maximum aircraft seating capacity.
FUEL
Total Ramp Fuel
Ramp Fuel – must be numeric value. Units can then be selected on the Settings – Other Settings page (can still be selected or changed after import)
 
Fuel used during this flight. While the software itself allow you to enter Remaining Fuel (by putting a negative number in the Fuel Used field), the import wizard only accepts Fuel Used (positive numbers)
 
Both can be logged independently, so you can import only Ramp Fuel or only Fuel Used, however the combination of both will return the best reporting.
FUELUSED
Fuel Used
DELAY
Delay Code
Delay code according to the official IATA code list, e.g. 75 for delay due to aircraft de-icing.
 
The complete list is available on the following website : 
IATA delay codes
DEICE
Aircraft De-Icing
Boolean field indicating whether or not the aircraft has been de-iced. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
Type Of Fluid, the number of litres and/or the timing can be logged as free text in the Flight Log Report field.
USER_NUMERIC
 
User Numeric field
 
Besides 4 user time fields, you can import another 3 user defined fields. You must first setup the user field(s) on the Settings – Other Settings page prior to running the import wizard.
 
- USER_NUMERIC must be a numeric field and can be used to log the number of approach, cargo freight weights, etc
 
- USER_TEXT is a free text field (max 50 characters) and can be used to log cabin crew names, gate number, or special events – the contents of this field are not printed in the paper logbook, unless you setup a user column
 
- USER_YESNO must be a Yes-No field or similar boolean values, like True / False or 1 / 0 and can be used to log any kind of additional information.
USER_TEXT
 
 
User Text field
 
 
USER_YESNO
User Boolean field
AC_ISSIM
Aircraft is a simulator
Boolean field indicating whether or not the flight is performed with a real aircraft or a simulator. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
 
This field is not mandatory, you can also use the column TIME_TOTALSIM instead.
AC_MAKE
Aircraft Make
Name of the aircraft manufacturer, like Boeing, Airbus, Cessna
AC_MODEL
Aircraft Model
Aircraft type (short), like B737, A320, PA28, C172
AC_VARIANT
Aircraft Variant
Aircraft sub model, like the B737-800. You would then log 800 in this column, or 100 for a A320-100, or RG for a C172-RG (retractable gear)
AC_REG
Aircraft Registration
Aircraft unique tail registration, like OO-TUC or N2406K.May contain hyphen or not.If aircraft tail is missing, the import wizard will create a dummy tail number for this aircraft model.
AC_FIN
Aircraft Fin
Aircraft fin – usually the short registration, like UC for OO-TUC or 406 for N2406K
AC_RATING
Aircraft Rating
Free text indicating the aircraft rating, like “B777-787” for the Boeing 777 and “A320 family” for A318 through A321 models
AC_SP
Single Pilot
Time field – any time logged in this field considers the aircraft as Single Pilot type. Accepts also Boolean values, like True / False and Yes / No.
AC_MP
Multi Pilot
Time field – any time logged in this field considers the aircraft as Multi Pilot type. Accepts also Boolean values, like True / False and Yes / No.
AC_ME
Multi Engine
Time field – any time logged in this field considers the aircraft as Multi Engine. Accepts also Boolean values, like True / False and Yes / No.
AC_SPSE
Single Pilot – Single Engine
Time field – any time logged in this field considers the aircraft as Single Pilot + Single Engine type. Accepts also Boolean values, like True / False and Yes / No.
AC_SPME
Single Pilot – Multi Engine
Time field – any time logged in this field considers the aircraft as Single Pilot + Multi Engine type. Accepts also Boolean values, like True / False and Yes / No.
AC_CLASS
Aircraft Class
Class : glider, balloon (lighter-than-air), rotorcraft (helicopter), microlight (ULM) or aircraft
AC_GLIDER
Aircraft is a Glider
Boolean field indicating whether or not the aircraft is a Glider. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
This column overrides the AC_CLASS column. There is an additional column for TMG.
AC_ULTRALIGHT
Aircraft is a Microlight
Boolean field indicating whether or not the aircraft is a Microlight. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
This column overrides the AC_CLASS column. 
AC_SEA
Aircraft is a Sea Plane
Boolean field indicating whether or not the aircraft is a Sea plane or not (land plane). Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
AC_ENGINES
Number of Engines
Indicates the number of engines. Reads also “single”, “multi” or “none” values.
AC_ENGTYPE
Type of Engines
Indicates the type of engines, like piston, turboprop, turboshaft, jet engine, etc
AC_TAILWHEEL
Aircraft has Tailwheel
Boolean field indicating whether or not the aircraft has a tailwheel.Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.Reads also “tail” and “retractable landing gear”.Does not read “fixed landing gear”, because this can still be a tail dragger.
AC_COMPLEX
Aircraft is Complex
Boolean field indicating whether or not the aircraft is Complex. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
AC_TMG
Glider is TMG
Boolean field indicating whether or not the aircraft is a Touring Motor Glider. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
This column overrides the AC_CLASS column. 
AC_HEAVY
Aircraft is Heavy
Boolean field indicating whether or not the aircraft is Heavy (above 5700 KG or 12500 LBS). Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
AC_HIGHPERF
Aircraft is High Performance
Boolean field indicating whether or not the aircraft is a High Performance. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
AC_AEROBATIC
Aircraft is Aerobatic
Boolean field indicating whether or not the aircraft is Aerobatic. Accepts any kind of boolean values, like Yes / No, True / False or 1 / 0.
Notice that Aerobatic time can also be logged as User Time field. Read more about this on the FAQ Help page.
AC_SEATS
Aircraft Seats
Aircraft maximum seat capacity for passenger load
IS_PREVEXP
Previous Experience
Boolean field indicating whether or not the record is logged as previous experience. That would be that you have logged a single line to cover many flights, e.g. 250 hours on Cessna 172.
Previous Experience records must be placed at the bottom of the data file.

 

 

 

 

 

The following Types Of Approach are text-recognized :

 

 

ILS
CAT-3C
LOC
CIRCLING
VISUAL
GPS
GCA
CAT-2
RNAV
LOC-NC
CIRC
VIS
GPS-NP
MLS
CAT2/3
BRNAV
VOR
NPREC
PREC
SRA
SDF
CAT-3
RNP
VOR-DME
NON-PRECISION
PRECISION
ARA
NDB
CAT-3B
PRNAV
LNAV
JPALS
ILS (Steep)
TACAN
NDB2
NONE
N/A
PAR
LDA
LAAS


 

 

 

Step 2- Save file as CSV

 

Export the XLS / XLSX / ODS file into a CSV or TXT file. By preference, use semi-colon or TAB separator

 

 

Step 3- Import file

 

On the Tools - Import Old Flight Data page of mccPILOTLOG, select "V01 - Generic CSV" from the dropdown list, and continue with the wizard.

 

 

 

 

Additional guidelines :



If you get an error ‘columns too many [X]’ for all record lines, there can be two reasons :


1- the CSV delimiter and the windows decimal delimiter are both set to comma ;


e.g.2010-10-26,EMB145,SIM,,26 oct 10 18:30,26 oct 10 22:30,4,0,,,,,,4,0,,,,,,


The duration of this simulator session is 4.0 hours.However, the duration was exported as 4,0 which is interpreted as 2 columns...


The solution here is to ;

   - choose another delimiter when you create the CSV file

   - if that is not possible, temporarily change your windows regional settings from comma to point for the decimal limiter, just for the time to create that CSV file



2- one or more header captions are missing in the first row.


e.g. if the ‘Remarks’ column header is missing, you need to manually add this header at the end of the first row in the CSV file.


(e.g. ,'Instructor Flying','Any Other Flying'becomes,'Instructor Flying','Any Other Flying',’Remarks’,’unknown’)


Make sure to use the correct delimiter, especially when the delimiter is a TAB :a TAB looks like a space, but a space is never used as delimiter !


If you don’t know what data is stored in that column, just enter a fictive header, such as ‘unknown’. Data from this field will not be imported with this kind of header.



If you get an error ‘columns too many [X]’ for only a few record lines, this can either be an error in the file structure or the CSV delimiter being used inside a data field :


Typical examples are :


- using a comma inside pilot name or remarks field :


…,3:00, , 1:45, “Beck, Jan”, , 1:45 (remove the comma in the name)

…,’3:00’,‘‘,’1:45’, ‘Special Flight, Hotel Sun’ (remove the comma in the remarks field)


- using a single quotation mark in the pilot name :


…,3:00, , 1:45, ‘O’Neill Jeff’, , 1:45 (remove the single quotation mark in the name)


- the record line has an additional delimiter at the end :


e.g. all records end by …;3:00;1:45;and this records ends like…;3:00;1:45;; (remove the semi-colon)


- the CSV delimiter is the same as the windows decimal symbol (you log flight hours in decimal format)


…,3,0,1,75,should have been stored like …,3.0,1.75,or…;3,0;1,75;



If you get an error ‘columns missing’, the wizard considers the line broken.The wizard will add empty fields at the end of the record line and try to import the record line.Even if you do not get any subsequent error for this record, you still need to verify the flight details, since time fields may have shifted, should the missing column be in the middle of the record and not at the end !


Dates can be saved in any numeric format, such as 1999-12-6, 8/31/2009,01.05.2010 and others.You can use any of the following date separator symbols : hyphen, slash, point and space.Alphanumeric dates, such as 1-jan-2010 or Dec 8, 1996 are refused, due to language differences.Find-Replace all months by their numeric value.


Flight Times must be formatted according to your Windows regional settings, e.g. 1:35If times are logged decimal, such as 1,6 or 1.6 make sure not to use the CSV delimiter.Decimal hours must

always have a tenth digit (e.g. 2 must be logged as 2.0 or 2,0)


If you have been using the Remarks column to store the name of the PIC or Co-Pilot, you are allowed to replace the Remarks caption by NamePIC or NameCOP.However, keep in mind that all data in this column will be considered as a pilot name.


Same logic applies for Flight Number (change Remarks into Flight Number) and Training Instruction (change Remarks into Instruction) should your have used the Remarks field for that purpose before.