Import Flight Records from another Logbook or my Excel sheet

Modified on Wed, 17 Jul at 9:04 AM


CrewLounge PILOTLOG imports flight records from more than 50 other logbook apps, such as LogTen Pro, RosterBuster, Safelog, NC Software, Wingman,... 


If you have been using a self-made excel datasheet, that can be imported too!



How to import flight records?



The process takes 3 steps:


  1. Export the data from the other logbook software
  2. Convert the Data File into a Compatible File
  3. Import the compatible file via the PILOTLOG Import Wizard (PIW) Queue


You can download the template refer below: 



Step 1+2: Export and Convert the data into a compatible File




If you have created your own Excel sheet you should to do the conversion yourself, follow the guidelines in this article.


Continue here for the export instructions (Step 1) and file conversion (Step 2).






Step 3: Import the File



Upload the Compatible File into your personal Queue. Login to 

My CrewLounge > Apps > PILOTLOG > Import records from another Logbook.  Click here to go directly to that page. 


The PILOTLOG Import Wizard (PIW) verifies the quality of the records and will report any errors or issues. Issues are recommendations that can be fixed at a later time, after the import.  However, errors must be fixed right away, before you can submit your file to your PILOTLOG Cloud Database!

 

Once you submit the records to your PILOTLOG Cloud Database, all flight data will automatically sync to all devices on which you run the PILOTLOG logbook application.





Doing the conversion yourself


 

Step 2.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 PILOTLOG import wizard. There are 6 mandatory headers, listed below in red bold color.

 

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.

 


 

 

PILOTLOG_DATE
Date of flight
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. PILOTLOG does not interpret the airfields!
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_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)

PILOTLOG 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.

PILOTLOG 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 PILOTLOG, 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 PILOTLOG, 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 PILOTLOG, 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 crew member on board 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
PILOTLOG 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, PIC, CAPT, Captain

Time is imported as PIC time


CDR

For military pilots that operate as Aircraft Commander. Type of Operations is set to "CDR". Time is imported as PIC time, unless other function time is logged.


P2, SIC, COP, Co-Pilot, CoPilot, FO, F/O, First Officer, SFO, Safety

Time is imported as SIC time


P2X

Time is imported as SIC time, and Type of Operations is set to "P2X"


P3, SNY, Extra

Time is imported as RELIEF time (*)


PIC/us, P/us, PICUS

Time is imported as PICUS time


CH, Line Check, EXAM, Examiner

Time is imported as Examiner (Check-Pilot) time


INS, Instructor

Time is imported as Instructor (Instruction Given) time


Dual 

Time is imported as DUAL time


DH, Deadhead, PAX, OBS, Observer

These records are imported, but with no function time. Type of Operations is set to "DH"



(*) 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.
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 PILOTLOG, 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
RWY_DEP
Runway Departure Airfield
Runway designator, such as 09, 12L, 25R
RWY_ARRRunway Arrival Airfield
Runway designator, such as 01, 12R, 25L
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.

In the event that you did 3 times the same approach, you would have to store that in the 3 columns, e.g. APP_1=ILS, APP_2=ILS, APP_3=ILS
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

PILOTLOG 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.
SOLOOperation TypeSOLO time is PIC time
CREWLISTMore Crew NamesUsually cabin crews/attendants


 

 

The following Types Of Approach, Landing and Takeoff are recognized by the import wizard. Use any of the keywords from the right column in your data sheet, e.g.  APP_1 = LLZ


 

TypeKeywords
Airborne Radar Approaches ARA
Area Navigation (Global Positioning System) / LNAV minimumsRNAVGPS, RNAVLNAV
Localizer Directional AidsLDA
Lateral NavigationLNAV
LocalizerLOC, LOCALIZER, LLZ
Localizer Back CourseLOCBC, BACK, BACKCOURSE
Non Directional BeaconNDB
Area NavigationRNAV
Required Navigation PerformanceRNAV, RNP
Simplified Directional FacilitySDF
Surveillance Radar ApproachSRA
UHF Tactical Air Navigation AidTACAN
VHF Omni Directional Radio RangeVOR
VHF Omni Directional Radio Range (Distance Measuring Equipment)VORDME, DME
Non Directional Beacon (2 stations)NDB2, 2NDB
Circling ApproachCIRCLING, CIRC
NPA     (Non-Precision Approach) (general)NONPRECISION, NONPREC
Localizer (Distance Measuring Equipment)LOCDME, LLZDME
Non Directional Beacon (Distance Measuring Equipment)NDBDME
Lateral Navigation and Vertical NavigationLNAVVNAV, VNAVLNAV
Localizer Performance with Vertical GuidanceLPV
Area Navigation (using VOR and DME)RNAVVORDME, RNAVVOR
Area Navigation (using two different DME)RNAVDMEDME, RNAVDME
Area Navigation (Global Positioning System) / LPV minimumsRNAVGPSLPV, GPSLPV, LPV
Global Positioning SystemGPS
Area Navigation (Global Positioning System) / LP minimumsRNAVGPSLP, GPSLP, LP
Vertical NavigationVNAV
Vertical SpeedVS
Landing OutsideOUTSIDE
Landing on MountainMOUNTAIN, HILL
Landing on HospitalHOSPITAL, MEDICALCENTER
Landing on Building RoofROOF
Landing on GlacierGLACIER
Landing on ShipSHIP, CARRIER, USS, SHIPDECK
Landing on Oil RigOILRIG, OIL, RIG
Landing on Helicopter Deck or Aircraft Carrier DeckHELIDECK, DECK, CARRIER
Visual ApproachVIS, VISUAL, VISUALAPP
Contact ApproachCONTACT
Instrument Landing SystemILS
Ground Controlled ApproachGCA
Area Navigation (Global Positioning System) / VNAV minimumsRNAVGPSVNAV, GPSVNAV
Joint PA     (Precision Approach) and Landing SystemJPALS
Local Area Augmentation System LAAS
Microwave Landing SystemMLS
PA     (Precision Approach) RadarPAR
Instrument Landing System - Category IICAT2, CATII, ILSCAT2, ILSCATII
Instrument Landing System - Category IIICAT3, CATIII, ILSCAT3, ILSCATIII, CAT3A, CATIIIA, ILSCAT3A, ILSCATIIIA
Instrument Landing System - Category III-BCAT3B, CATIIIB, ILSCAT3B, ILSCATIIIB
Instrument Landing System - Category III-CCAT3C, CATIIIC, ILSCAT3C, ILSCATIIIC
PA     (Precision Approach) (general)PREC, PRECISION, PRECAPP, PRECISIONAPPROACH
ILS (with glide slope more than 4.5°)ILSSTEEP, STEEP, STEEPAPPROACH, STEEPANGLE
ILS (Instrument Guidance System)ILSIGS, IGS
Area Navigation (Global Navigation Satellite System) RNAVGNSS, GNSS
GBAS (Ground Based Augmentation System) Landing SystemGLS
Global Orbiting Navigation Satellite SystemGLONASS
ILS - Category I (Lower Than Standard)CAT1LTS, CATILTS, LTS, ILSCAT1LTS
ILS - Category II (Other Than Standard)CAT2OTS, CATIIOTS, OTS, ILSCAT2OTS
Monitored ApproachMP, MONITORED, MONITOREDAPP
AutolandAL, AUTOLAND, AUTO
Low Visibility TakeoffLVTO, LOWVISTO, LOWVIS
Head-Up Display TakeoffHUD, HUDTO
RNAV Visual ApproachRNAVVIS, RNAVVISUAL
Go-AroundGA, GOAROUND, TOGA
HUD (Enhanced Vision System)HUD, EVS, EFVS, HUDEVS, HUDEFVS
Enhanced Flight Vision SystemEVS, EFVS
ILS (Precision Runway Monitor)ILS, PRM, ILSPRM, PARALLEL, PARALLELRUNWAY
Pilot Monitored ApproachPMA, MONITORED
Night Vision Imaging SystemNVIS, NVG
Night Vision Imaging System (Confined Area Landing)NVIS, NVG, CAL
Night Vision Imaging System (Unlit Area Landing)NVIS, NVG, UL
Required Navigation Performance (Authorization Required)RNAV, RNP, RNPAR, AR
Required Navigation Performance / LPV minimumsRNAV, RNP, LPV
Required Navigation Performance / LP minimumsRNAV, RNP, LP
Required Navigation Performance / LNAV minimumsRNAV, RNP, LNAV
Required Navigation Performance / VNAV minimumsRNAV, RNP, VNAV
Takeoff from Helicopter Deck or Aircraft Carrier DeckHELIDECK, DECK, CARRIER
Advanced RNPA-RNP, ARNP, RNP
Integrated Approach NavigationIAN, INTEGRATED
Catapult TakeoffCATAPULT
Touch & GoTOUCH, TOUCH&GO, T&GO, T&G
Instrument ApproachIAPP
Field Carrier Landing PracticeFCLP
Arrestor Gear LandingARRGR, ARRESTOR, HOOK
Bolter Aircraft Carrier LandingBOL, BOLTER

                                                    


Step 2.2 - Save file as CSV or XLS

 

The following formats are accepted: CSV, TXT, XLS and XLSX  

Continue with Step 3 above, to import the file through the PILOTLOG Import Wizard (PIW). 

 

 

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, or save the file as XLS.



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:35 If 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)



 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article