Climb! is capable of importing logbook data from a CSV (Comma Separated Value) text file. Fields must be separated by commas. Enclosing quotes are optional, but fields containing commas must be enclosed by quotes. Records (flights, in this case) must be separated by carriage returns. Many logbook, database, and spreadsheet programs are capable of exporting data in this format.

To begin the import process, select "Import Flights…" from the File Menu. The Import Window will be presented. There are two distinct types of imports that can be performed, Keyword and Discrete. A Discrete import places the time information directly into the appropriate column. A Keyword import uses the "AC CAT CLASS", "FLYING", and "FLT CON" field entries to place the block time in the appropriate column or columns during the import process. Select which type of import to perform by clicking the associated radio button.

Select the fields to be imported by checking each in turn. Reorder the fields to match the CSV file by drag and drop. Click OK and select the CSV text file containing the information to be imported. Any errors encountered will be reported following the import process.

• Valid date formats are determined by your System Preferences International settings. Two digit years assume the current century.
• Time fields can be formatted with or without leading zeroes and colons. Decimal times must include a decimal point even if there is no decimal portion ("5." will be interpreted as five hours, but "5" will be interpreted as five minutes).
• Remarks: Remarks and other text fields should not contain carriage returns or quotes (neither single nor double).

Click here to download a sample "keyword" CSV file (with headers).
Click here to download a sample "discrete" CSV file (with headers).

Versions 2.3 and later handle date formatting in a different way than earlier versions: The displayed date format now corresponds with the OS X System Preferences International settings formats. Please be aware of the following:

• Dates typed in the Edit Panel date field must adhere to the System formats.
• Imported text file date formats must match one of the System formats.

Advantages:

• It is now possible to change the date presentation throughout Climb! using the System Preferences.
• Any import or export file date format can be supported by changing the System Preferences.
• Climb!'s date display will now be consistent with the other applications on the host computer.

Want to change the date format?

1. Quit Climb!
2. Open the System Preferences and click "International"
3. Click the "Formats" tab and the Dates Customize button
4. Select "Medium" to customize the date string in the Log View Table or "Short" to customize the date string in the Edit Panel date field or date control
5. Customize the date string and Press OK to confirm
6. Relaunch Climb!