• We've completed testing of iOS 14. Logbook Pro has no issues observed. APDL's only issue is the Weather Map is crashing. We are working on an update for the crash at this time.

Date format

tomljensen

New member
Joined
Oct 5, 2004
Messages
4
Support,
I have version 1.9.4 and my computer is running Windows 98. My company gives me my flight times electronically (tab delimited) so I can input them in a log book. So I save my company info (date, block times, routes, etc.) into an Excel Spreadsheet. It looks great, with all the correct columns. When I try to import my Excel spreadsheet into Logbook Pro, it asks me to choose a destination for each column. All of them work except for the date. The date format in my Excel spreadsheet is 01/01/04 and is exactly the format in my Logbook Pro spreadsheet. But when I try to select 'DATE' as my destination for my Excel date column, it gives me the error message: 'The target for the column selected is Date data type and the source does not validate as a date format.' But my Excel column IS formatted as that EXACT date format. What's up?
 

Neal Culiner

Founder, President
Staff member
Joined
Nov 14, 2001
Messages
12,644
Location
VA
Tom,

Have you checked the box at the top of step 2 that the first row contains column headings?

 

tomljensen

New member
Joined
Oct 5, 2004
Messages
4
Oops, yeah, you're right. It imports great now. But I ran into another problem. It won't Autofill anything for my imported aircraft. But Autofill works for any manually-typed 'brute force' data I put into my logbook. Any suggestions?
 

tomljensen

New member
Joined
Oct 5, 2004
Messages
4
thanks for your quick responses so far. But I don't see anywhere on the first Import screen where you can select or de-select the autofill function. Do you have a picture of this screen and where this check box is located? Also, your second point: the aircraft must already be in the database before you import. But another weird thing happens---after I import, a message box comes up that it is a new aircraft and the information (i.e. category, turbine/piston, etc.) needs to be updated. But I ALREADY did this before importing. The aircraft is an EM2.
Sincerely,
Confused
 
Top