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

help with import!

airplanedriver75

New member
Joined
Apr 29, 2005
Messages
4
I keep getting this error mesage even though I make sure and edit it into date format every way I know how. its also doing this on numerical columns like flt time. what up wit dat?

Error:
The target for the column selected is a DATE data type and the source does not validae a Date format. The import selection is not valid, please check your selection.
 

Neal Culiner

Founder, President
Staff member
Joined
Nov 14, 2001
Messages
12,644
Location
VA
The common causes are:

1) In the second import wizard dialog the checkbox that the first row contains column headers was not clicked
2) Attempting to import data in either the Date, OUT/IN, or Takeoff/Landing columns are not conformant to the proper date format (M/d/yyyy) that Logbook Pro requires

 

airplanedriver75

New member
Joined
Apr 29, 2005
Messages
4
hopefully this uploads, but could you take a look at my .csv file and see if you see the prob. I'm still not exactly sure whats going on. ps i didn't mention it earlier but the file is being exported by captains log 2000... are there compatibility issues, shouldnt those be nullified if converting to a common format? .....
 

Neal Culiner

Founder, President
Staff member
Joined
Nov 14, 2001
Messages
12,644
Location
VA
I changed the format of the Date to M/d/yyyy, see if that works. I also saved this as a TAB delimited text file as with a comma delimited import you're going to have problems. I saw the use of commas in the remarks and that will cause troubles. Always use TAB delimiters if possible.

 

airplanedriver75

New member
Joined
Apr 29, 2005
Messages
4
still getting the same errors, also getting this for duration, night, inst, and every numerical column.

Should I remove all commas, is that what your saying...?

Thanks a million for the help btw
 

airplanedriver75

New member
Joined
Apr 29, 2005
Messages
4
WOW I'm a moron! when all else fails read...or watch the instructions :p

Problem came from not telling it that 1st row was titles!

Thanx anyway
 
Top