• NC Software is proud to announce the release of APDL version 9.3 now on the Apple App Store. Click here to review what's new and download the latest version. New users enjoy the first 90 DAYS FREE.

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,632
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,632
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