Importing your Data to LogTen Pro
*The import process has also been shown in one of our YouTube instructional videos. You can check it out here!
If your current data exists in an Excel file or another digital logbook program, you can transition to LogTen Pro with confidence that all of your data can be imported seamlessly. If you are using Logbook Pro, FlightLevel, Skylog Pro or Pilots Pal, please refer to this article for specific instructions.
If you use LogTen Pro for iOS our support team can import your data for you. Follow the instructions below and send the file with your logbook data to firstname.lastname@example.org – we've transferred thousands of logbooks over to LogTen Pro and would be very happy to help you!
If you use LogTen Pro for Mac, then you'll be able to follow the instructions in this article to import your data yourself (or feel free to contact us for help if you need it – email@example.com.)
- While LogTen Pro for Mac is currently the only version that supports direct data import, we're happy to help import data for iOS-only users import their flight history. This article includes preparation and submission instructions.
- Some digital logbooks don't offer a direct export to Excel/CSV/TXT, but we may still be able to convert your data for you. You can find more information about which programs we can work with, as well as what we need from you, here: Logbook Conversions.
Tip: Get to know LogTen Pro a bit first! There are a wide variety of data fields to accommodate any need, so it helps to know what's available. Here is a link to a few Video Tutorials that will give you a good overview of LogTen Pro. Then explore it yourself!
1. Export your Data
If your data is already in an Excel, CSV, or tab-delimited TXT file, then proceed to Step 2.
If your data is currently stored in another logbook program, export the data to Excel, CSV, or tab-delimited TXT file.
- Export options are typically found under the File or Tools menu, but this will vary depending on the individual program. If necessary, please consult the program's manual or support team for further assistance.
2. Prepare the File for Import
Following these guidelines will ensure that your data is imported into LogTen Pro smoothly. You're free to use just about any spreadsheet program you'd like to prepare the file (e.g. Numbers; Excel; LibreOffice; OpenOffice; etc.)
- Your file should have no blank rows or total (summary) lines between your entries.
- XLS files with data on multiple sheets (e.g. a different sheet for each month) should be consolidated to a single sheet to allow for all data to be imported in a single action.
- Make sure that your formatting is consistent throughout the file; e.g. your dates and times are formatted the same for each flight; your times are all either UTC or local; etc.
- There should only be one column per data type in your file.
- An example of this would be separate columns for Aircraft Types and Simulator Types; in preparing your file, you'll want to combine these into a single Types column that lists both actual aircraft and simulators.
- Another example is to have separate columns for the date and times. Instead of having a single Date/Start/Out column like "09/01/10 12:56", separate the Date from the Out time into two columns (there is often a function in the spreadsheet editor for this).
3. Save your File as a CSV
Once your data is ready for import, convert the file to a CSV (comma-separated value) file. Most spreadsheet programs either have an option for direct export of your data to a new CSV file.
- When saving to CSV, you may be prompted to select a character set; make sure that Unicode UTF-8 is selected before saving.
NOTE: If using LogTen Pro for iOS, you can send your import file to our support team with the following information:
- If your times are UTC or Local
- If you’ve already entered flights into LogTen Pro, please send us your logbook file by tapping More > Help and Email support and we’ll import your the missing data directly into it.
If using LogTen Pro for Mac, proceed with the following steps to import your data.
1. Check LogTen Pro's Settings
Open the Preferences > General menu and check to make sure that the app is set to your desired preferences:
- If the file to be imported contains times and dates in Local time, then be sure to uncheck the "Dates and Times are UTC" option, or vice versa.
- If your file contains airport names (instead of ICAO/IATA codes) or crew ID numbers (instead of names), then set the "Preferred Identifier" for each appropriately.
2. Select your Data File
Open LogTen Pro and go to File >> Import from File… >> Flights. A standard Open dialogue displays; from here, browse to your CSV file, select it, and click Open.
3. Tell LogTen Pro where to Import your Data
The Import screen is where you'll set and double-check that your data is being imported to the correct fields in LogTen Pro.
- The left column displays the first entry in each column of your file (usually your column titles, or headers)
- The center column (“LogTen Pro Field”) displays the field that each column’s data is currently set to be imported into.
- The right column (“Import Category”) displays the category for the current selection in the LogTen Pro Field column.
LogTen Pro will try to select the best match for each of your file’s columns based on your headers; however, some fields may have been misidentified so it’s important to make sure that each is mapped to the right field.
The Import screen also includes the following options:
- My Dates Look Like: Use this drop-down to tell LogTen Pro how dates are formatted in your data file. It's important that the dates in your file match one of the format options here, or else some of your dates may not be imported correctly.
- Ignore first row: Selecting this option will ensure that LogTen Pro doesn’t import your first row of column headers as flight data.
- Flight times are in minutes: This should only be selected if your file contains times in pure minutes; e.g. “72” instead of “1:12” or “1.2”.
- Populate Auto Enter Times: Auto-Enter times are an easy way to have LogTen Pro fill out times for you; e.g. a First Officer will usually log SIC and XC time for each flight, so these would be good options to Auto-Enter. The Auto-Enter options can be accessed from the LogTen Pro menu >> Preferences >> Time. Each time field has an additional checkbox below it to "auto fill total time".
Additional Tips for Successful Imports:
- IMPORTANT! Double-Check your Data: If you need to check the data, you'll find two arrow buttons near the bottom right of the import window. These allow you to go to the next row of your data file, and the data of that row will be displayed on the left side.
- Field Names: Some fields in LogTen Pro may have similar names, but track completely different types of data; e.g. the PIC/P1 Crew field tracks your PIC’s name, while the PIC/P1 field is for indicating PIC duty and the PIC (P1 in some countries) field is to track your time as Pilot In Command. It’s always a good idea to double-check that each of your file’s columns are set to import to the right category for the data type.
- Aircraft ID / Tail Number / Registration Number: Whatever identifies the individual aircraft in your CSV file should be imported to Aircraft >> Aircraft ID.
- Type / Model / Variant: Whatever identifies your different Aircraft Types of your entries should be imported into Aircraft Type >> Type. Your CSV file may contain other information such as Engine Type or Class data for Aircraft Types. These are best to configure afterwards, so they can be set to Do Not Import to skip them. You can find more information about this process here: Managing your Aircraft Types.
- Places: LogTen Pro uses three data fields to track airports / places logged on a flight -- From, Route (for waypoints), and To. It is not usually necessary to adjust your CSV file to this format though. If your CSV file contains a single column detailing the route of each flight, just import this to Flight >> Route. LogTen Pro will adjust this appropriately during the import! Note: If you have any places that are more than one word, please connect them by an underscore like so: Johns_Landing_Strip.
- Times (Such as Departure and Arrival Times): Make sure that your clock times, such as departure (Out) / Arrival (In) or Take-off (Off) / Landing (On), are formatted to match your Mac's System Preferences (e.g. typically "2359" or "23:59"). If your data file uses a different format, then you'll need to either reformat those columns in your spreadsheet program to use your system's time format before importing. Alternatively, you could modify your system's time format to match your data file in System Preferences > Language & Region > Formats.
Approaches: LogTen Pro stores your number of approaches, approach type, runway number, and place in a single table. To properly import your data using LogTen Pro's template, your approach data should be all contained in a single cell, separated by semicolons; e.g. 1;VOR;10L;KPDX.
If you only have one or a couple of the different approach data types logged, you can use the same format, leaving the cell blank for any data you don't have; e.g. ;VOR;;KPDX.
3. Click Import!
When you've got everything identified correctly, click Import, and LogTen Pro will import all your data. It will also create the entries for any People, Places, Aircraft, and Aircraft Types, and create the necessary relationships between them.
All of your data is now in LogTen Pro! It’s important to double-check certain aspects of your data to ensure that LogTen Pro will work as you want it to:
- Flight Data: Ensure that everything is where you intended it to be, and everything you wanted to import did. If you need to display or hide any of the columns in the Logbook section, they are all accessible in the app's Preferences. On your menu bar, go to LogTen Pro >> Preferences (or [command+comma] is a shortcut). The Preferences dialog is broken down into categories with a General settings section, and another tab for each type of data field (e.g. Flight, Time, Crew, etc). Simply select the box next to each field to make it appear in your file, or deselect to hide it (note: even if data is not displayed, it is still saved). On LogTen Pro's Logbook tab, each column can be rearranged and resized by clicking and dragging its column header; this will also automatically re-order your fields in your Flight Details section to the right of the table.
- Places: It's also a good idea to check the list of Places that were created during the import. If your file contained ICAO codes of locations, most should have mapped perfectly. If your file contained IATA codes or Names of airports, these are not always unique, so they may have mapped manually. However, these are easily fixed: the easiest solution is to enter the ICAO code of the airport, and our database will populate it with the correct information. (Since all the information is dynamically connected, all of your flights will automatically be updated to reflect this correction too!)
- Aircraft Types: Remember to use ICAO Type Identifiers to automatically populate all the associated data with an aircraft type; e.g "C172" instead of "C-172". Similarly, aircraft types should be checked to ensure they were not mapped incorrectly, and should be configured to take full advantage of LogTen Pro's automatic time tracking. Refer to Managing your Aircraft Types for a complete description.
Don't worry, if you get stuck, we're happy to help! We understand that the process of migrating your data from one format to another can be a challenge, and we want to be sure you get everything working perfectly in LogTen Pro.