[SOLVED] Importing Schedules

[longhorns19]

I tried creating schedules on Excel in a .csv format. I have done everything php has said but I still get this error..

Airline with code LBY 10007 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N796LB 38000 6:16 AM CDT 7:13 AM MDT Route may be incorrect. For the most updated route does not exist! Skipping...

Airline with code LBY 10008 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N108LB 38000 3:42 PM CDT 4:37 PM MDT Route may be incorrect. For the most updated route does not exist! Skipping...

Airline with code LBY 10009 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N113LB 38000 10:36 AM CDT 11:30 AM MDT Route may be incorrect. For the most updated route does not exist! Skipping...

Airline with code LBY 10010 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N796LB 37000 1:08 PM MDT 4:02 PM CDT Route may be incorrect. For the most updated route does not exist! Skipping...

Airline with code LBY 10011 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N108LB 37000 12:44 PM MDT 3:44 PM CDT Route may be incorrect. For the most updated route does not exist! Skipping...

Airline with code LBY 10012 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N113LB 37000 6:14 AM MDT 9:05 AM CDT Route may be incorrect. For the most updated route does not exist! Skipping...

The import process is complete, added 0 schedules, updated 0, for a total of 0

Can someone help me?

[flyalaska]

Airport or Plane doesn't exist. Make sure they have been added first.

[longhorns19]

They are added. I've used them for all the routes I manually added.

[jazz]

Let us see some lines so that we can see what is actually in the .csv file?

[longhorns19]

What do you mean by lines?

[jazz]

Your scedules.csv should consist of lines like:

PIO,1,EHAM,EBBR,"NV RR ONW",PH-PID,4000,85,"02:35 UTC","03:35 UTC","1","Cargo flight. Inspired by KLM 1957 freight services","1","C","0123456","1"

So, what is inside the actual .csv file, not the excel representation.

[longhorns19]

I copy and pasted the excel sheet below

[longhorns19]

code flightnum depicao arricao route aircraft flightlevel distance deptime arrtime flighttime notes price flighttype daysofweek enabled

LBY 10007 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N796LB 38000 6:16 AM CDT 7:13 AM MDT Route may be incorrect. For the most updated route 608 P 123456 1

LBY 10008 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N108LB 38000 3:42 PM CDT 4:37 PM MDT Route may be incorrect. For the most updated route 624 P 123456 1

LBY 10009 KIAH KDEN STYCK1 DOLEY FUZ SPS ZIGEE BOSSS1 N113LB 38000 10:36 AM CDT 11:30 AM MDT Route may be incorrect. For the most updated route 629 P 123456 1

LBY 10010 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N796LB 37000 1:08 PM MDT 4:02 PM CDT Route may be incorrect. For the most updated route 619 P 123456 1

LBY 10011 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N108LB 37000 12:44 PM MDT 3:44 PM CDT Route may be incorrect. For the most updated route 625 P 123456 1

LBY 10012 KDEN KIAH SPAZZ2 TBE PNH MQP DRLLR2 N113LB 37000 6:14 AM MDT 9:05 AM CDT Route may be incorrect. For the most updated route 631 P 123456 1

[jazz]

For starters you miss the distance and the flight time.

Second: the copy - paste is still the excel representation of the .csv file. It would really help if you just open that file with a text editor and copy paste from that or just pm the .csv.

[longhorns19]

It says the distance and flight time can be blank

[longhorns19]

How do I send files on here?

[jazz]

Good question. OK mail the file to ceo[at]pioneerva.nl and I will take a look at it.