Flight Import Problem - 1.1.458

[davehardy]

Has the format been changed?

Attached the csv template i use, it wont import even though it says it has.

I have added all the airports prior to importing.

Book1.zip

[BBuchanan]

try putting something in all the fields. Example would be:

EZE  123 1 EGNR EGTG NOKIN N862 ERNOK L9 ALVIN JS41 99nm 07:45:00 AM 08:30:00 AM Shunt N/A

This would fill in:

Code Flightnm Leg Dept Arriv Route Aircraft Distance Dept time arrive time Flight time Notes

I used FSBuild to get my Route between the airports, plus it also gave me a distance. A free program similar would be Super Flight Planner.

I also converted my flight times to decimal, meaning a 1 hour 30 minute flight would be 1.50. You can google a time to decimal converter and just copy/paste that decimal over.

[Nabeel]

Also you need commas between the fields (CSV = comma separated values), though excel will insert those if you export.

Match up the columns as well. Distance, etc are optional, though they will come in handy in the future for financials and reports.

Also make sure you're using the registration number for the aircraft.

I know times in decimal format are a little unnatural, but its easier to handle it in mysql.

[BBuchanan]

I would suggest getting and using OpenOffice.org which just happens to be the website.

Inside of this office program, I use the Calc, which is actually the spreadsheet. Just import it and tell it that its comma seperated. And it can save in the same format that you opened it.

[davehardy]

Ive got MS Office 2007 and it keeps bitching about saving in CSV

Do i have to set all my times in decimal now? My import list is huge and i dont want to spend a day editing each time the format changes!

At this rate it willbe quicker for me to add the schedule by hand, i now have to go and make new routes for all my flights and get the distance too which i can do but its going to take hours.

[Nabeel]

You don't have to add distance or routes; and leave the times as is, as long as the time format you use is consistent it doesn't matter.

Office ******* about CSV, but just ignore it.

[BBuchanan]

Ive got MS Office 2007 and it keeps bitching about saving in CSV

Open Office only asks if I wish to continue to save as the current format or save as openoffice format.